A person's ethnicity is on table U_CC_PDATA_TBL,
field U_CC_ETHNIC_REPORT. This field is a number code (which is required for
some reporting needs). To translate the code to a value, edit the field (on the
query Fields tab) and select the long translate value. Click Okay to return.
If your query has a Union, editing the field output to translate the value will
result in an error message. You must manually translate the field. Edit the
field and set translate to "none". Join to table XLATTABLE_VW. Enter the
following two criteria:
(1) Set FIELDNAME = "U_CC_ETHNIC_REPORT" (field equal to constant)
(2) Set FIELDVALUE = U_CC_ETHNIC_REPORT (field equal to field)
For output, select field XLATLONGNAME.
Ethnicity Reporting Values
|
Code 1 2 3 4 5 6 7 8 9 |
Value Hispanic of Any Race American Indian/Alaska Native Asian Black or African American Native Hawaii/Othr PacIslander White Two or More Races Race & Ethnicity Unknown Non-Resident Alien (Any Race) |
Persons with USA Citizenship Status of Non-resident Treaty or Non-resident No Treaty are always reported as "Non-Resident Alien", regardless of ethnic group selections.
If Hispanic is selected, regardless of any additional selections, that person is reported as "Hispanic of Any Race".
Persons selecting more than one ethnic group (as long as one of them is not Hispanic) are reported as "Two or More Races".
Reconciling Reports
The recommendation is that all ethnicity reports be reformatted to conform to the new reporting standard. Do not attempt to take new ethnicity values and align them with old ethnicity values. If at all possible reproduce older reports to the new values, for comparison purposes.
The only historical impact will be for students who have selected ethnic group OTHER (explained below).
Changes and History
There is no "history" for a person's ethnicity. The reporting value found within field U_CC_ETHNIC_REPORT is the value to use. The only difference between the previous and new ethnicity values are international and those who select multiple ethnicities.
Non-resident aliens will have an ethnicity of "Non-Resident Alien (any race)". Their actual ethnic group will typically be NSPEC (not specified).
Persons may now select more than one race/ethnicity. They are reported as "Two or More Races".
Students will not be resurveyed, except for those with ethnic group OTHER. Current and previous students (matriculation prior to Summer 2010) will have the same ethnic groups, and so the same reporting values, they have always had (if you previously did not change NSPEC to International, then those may appear to be different, but in fact were international all along).
Current students who previously selected OTHER will be resurveyed (by Fall 2010 census date). OTHER is no longer a valid value for ethnicity. The assumption is that students with multiple ethnicities selected OTHER, and now they can select multiple values and be reported as "Two or More Races". Some may have selected OTHER because they disagreed with the available options. This is not a valid reason. The federal definition for ethnic groups covers all options, whether a person agrees with them or not.
There is no history for Ethnic Group selections. If your reporting needs require the knowledge of who used to be OTHER, then you must capture this data and save it off.
Ethnic Group Codes
Actual Ethnic Group selections are saved on table DIVERS_ETHNIC. If you join to this table be aware that persons may have more than one row of data. There is no "primary" ethnic group. Persons who are non-resident will not be identified as such. The recommendation is to avoid using DIVERS_ETHNIC.
The custom field U_CC_ETHNIC_REPORT has been created according to federal reporting guidelines to allow the reporting of one ethnicity value per person.
