| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | PA0616 | HR Master Record: Infotype 0616 | 37 | ETHNIC | HESA: Ethnicitiy code | nvarchar | 2 | 0 | | |
| 2 | PAPBSGBH_13_P | HESA: Person table (2012/13 onwards) | 27 | ETHNIC | HESA: Ethnicitiy code | nvarchar | 2 | 0 | | |
| 3 | PAPBSGB_HESA_P | HESA: Archive table for NISR Person table | 13 | ETHNIC | HESA: Ethnicitiy code | nvarchar | 2 | 0 | | |
| 4 | T5GPBSH_ETC | HESA: Ethnicity codes | 2 | ETHNIC | HESA: Ethnicitiy code | nvarchar | 2 | 0 | | |
| 5 | T5GPBSH_ETCT | HESA: Ethnicity code text | 3 | ETHNIC | HESA: Ethnicitiy code | nvarchar | 2 | 0 | | |
| 6 | T5GPBSH_ETH | HESA: Mapping of ethnicitiy code | 3 | ETHNIC | HESA: Ethnicitiy code | nvarchar | 2 | 0 | | |
| 7 | T5GPBSH_ETH2 | HESA: Mapping of ethnicitiy code | 5 | ETHNIC | HESA: Ethnicitiy code | nvarchar | 2 | 0 | | |
| 8 | HRP1704 | DB Table for Infotype 1704 | 23 | ETHNIC | Ethnic Origin | nvarchar | 4 | 0 | | |
| 9 | T7PIQETHNIC | Ethnic Origins | 2 | ETHNIC | Ethnic Origin | nvarchar | 4 | 0 | | |
| 10 | T7PIQETHNICT | Text Table for Ethnic Origins | 3 | ETHNIC | Ethnic Origin | nvarchar | 4 | 0 | | |
| 11 | T7PIQ_US_ETHNIC | Define IPEDS Ethnic Groups | 2 | ETHNIC | IPEDS US Ethnic Group Classification | nvarchar | 2 | 0 | | |
| 12 | T7PIQ_US_ETHNIT | US IPEDS: Customizing table for Ethnic group Text | 3 | ETHNIC | IPEDS US Ethnic Group Classification | nvarchar | 2 | 0 | | |
