Versions Compared

Version Old Version 50 New Version 51
Changes made by

Jordan Lamb

Jordan Lamb

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt
nameSSN

Social Security numbers are issued by the Social Security Administration to U.S. citizens and other residents.

Code Block
SPBPERS_SSN
Info

This field is allowed to be null.

Note

This is PII:

Insert excerpt
Common Definitions
Common Definitions
namePII
nopaneltrue

...

Excerpt
nameRACE_ETHN_CDE

Intended to locally replicate the Race/Ethnicity groups shown on the CCCCO Data Mart system.

Info

IS_HEADER on https://sequoias.atlassian.net/wiki/spaces/BANNER/pages/1173946389/COS+GEN.CODATAMART+RACE+ETHN+CROSSWALK+table table is an additional column to tell if GORPRAC race code is a header value. On CCCApply, a header value checkbox must be selected to be able to select values underneath that header.

  1. If a student has selected SPBPERS_ETHN_CDE = ‘2’ OR has select a number of races that equates ETHN_CODE to include ‘H’, then that student will be listed as Hispanic.

  2. If a student has selected a number of races WHERE SPBPERS_ETHN_CDE <> ‘2’ AND ETHN_CODE equates to 1 – 2 codes including ‘F’ and potentially ‘A’, AND the races that equate to ETHN_CODE = ‘A’ have IS_HEADER = ‘Y’, the student will be returned Filipino. 

  3. If a student has selected a number of races WHERE SPBPERS_ETHN_CDE <> ‘2’ AND ETHN_CODE equates to 1 -2 codes including ‘A’ and potentially ‘F’, AND the races that equate to ETHN_CODE = ‘A’ have IS_HEADER <> ‘Y’, the student will be returned Multi-Ethnic.

  4. If a student has selected a number of races that equate to TWO or MORE unique ETHN_CODE values that DOES NOT include ‘H’ OR SPBPERS_ETHN_CODE <> ‘2’, the student will be returned as Multi-Ethnic.

  5. If a student has selected a number of races that equate to ONE ETHN_CODE AND SPBPERS_ETHN_CDE <> ‘2’, the student will be returned as derived ETHN_CODE

  6. Else Unknown

This is distinct from IPEDS. There is no CCCCO Data Mart methodology documented.

See

Jira Legacy
serverSystem JIRAcolumnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId8b861ae3-ff87-316b-a17e-97c61a7e2fb4
keyAP-231
for the work history.

...