Often populated off CCCApply Application or manual entry by Student Services (or Human Resources for employees).

CCCApply nulls can equal Non-binary, Decline to state, No selection

IS_HEADER on https://sequoias.atlassian.net/wiki/spaces/BANNER/pages/1173946389/COS+GEN.CODATAMART+RACE+ETHN+CROSSWALK+tabletable 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. Values underneath headers do not have to be selected.

1. If a student has selected SPBPERS_ETHN_CDE = ‘2’ OR has select a number of races that equates CODATAMART_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  AND CODATAMART_ETHN_CODE CODE equates to 1 – 2 codes including ‘F’ and  and potentially ‘A’, AND the races that equate to CODATAMART_ETHN_CODE 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 CODATAMART_ETHN_CODE CODE equates to 1 -2 codes including ‘A’ and potentially ‘F’, AND the races that equate to CODATAMART_ETHN_CODE CODE = ‘A’ have IS_HEADER <> ‘Y’, the student will be returned Multi-Ethnic Asian.

4. If a student has selected a number of races that equate to TWO or MORE unique CODATAMART_ETHN_CODECODE 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 CODATAMART_ETHN_CODECODE AND SPBPERS_ETHN_CDE <> ‘2’, the student will be returned as derived ETHN_CODE

6. Else Unknown