Ethnicity (ETHNICS)

Return: ITT

Entity: Student

Pages Used:

Page	Page Element
Person HESA Data	ETHNICS
Ethnicity (Campus Community , and then Personal Information (Student), and then Biographical (Student), and then Personal Attributes, and then Ethnicity)	Regulatory Region, Ethnic Group
Ethnicity (Records and Enrollment, and then HESA Reporting, and then Codes and Mappings, and then Code Mappings, and then Ethnicity)	HESA Ethnicity

Field Derivation Rule: Include for all entities.

Derivation Steps:

1. Derive from the Person HESA Data page.

2. Select Person Ethnicity records as follows:

   • If a single record exists, use that record.

   • If multiple records exist and one is marked as Primary on the Campus Community Ethnicity page, use that record.

   • If multiple records exist and none are marked as Primary, select the record with the highest Percentage defined in the Ethnicity Detail page.

   • If multiple records are indistinguishable, select the lowest alphabetic Ethnic Group code.

   For the selected record, use the HESA Ethnic code from the mapping between the Ethnic Group, Regulatory Region, and the HESA Ethnic code. If no mapping exists, log an error message and skip to next step.

3. Use default.

4. Derive as null.