XNATGR01_1.6.1
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
Geographic region of student nationality | XNATGR01 | 1.6.1 | 4 | Char |
Valid entries
Dependent fields
- None
Depend upon fields
- NATION
Additional information
This field groups student nationality information (Student.NATION) into geographic regions. The regions are similar to those in the equivalent derived field for EntryProfile.DOMICILE, XDOMGR01.
For HESA analysis purposes the Channel Island Bailiwicks of Guernsey and Jersey, and the Isle of Man, are grouped into the UK geographic region. (Officially, these Crown Dependencies are not part of the UK or the EU).
The codes are derived from an overseas look-up table, provided by Data Management, which groups domiciles into regions. Nationalities which are not included in the domicile overseas look-up table, or require a different specification grouping, are dealt with first in the technical specification.
The former European countries of XM Czechoslovakia not otherwise specified, QN Serbia and Montenegro not otherwise specified, XN Union of Soviet Socialist Republics not otherwise specified and XO Yugoslavia not otherwise specified are valid codes for nationality, and have been assigned to GROE Geographic region - Other Europe. IO British Indian Ocean Territory is a valid code for nationality, and has been assigned to GRAU Geographic region - Australasia, consistent with the mapping of other countries within this geographical region, as informed by the National Statistics Country Classification (NSCC) 2006 (http://www.ons.gov.uk/ons/guide-method/classifications/current-standard-classifications/national-statistics- country-classification/index.html).
Technical Specification
The specification is hierarchical. Initially assign a region to codes that have a different grouping requirement than those mapped by the overseas lookup table, or which do not exist in the table, and then use the table to assign regions.
XNATGR01 may output a null value. This is an error, highlighting that a value in the collection's NATION field is not contained in the T_OVERSEAS_LOOKUP_V9 lookup table's F_DOMICILE_ISO column. This is designed so the derived function does not fail. Nulls are to be identified at impossible values testing to flag the issue to HESA's Data Management team.
Student.NATION | XNATGR01 |
---|---|
GB, GG, JE, XL, IM | GRGB |
XM, QN, XN, XO | GROE |
IO | GRAU |
AA, ZZ, null | GRZZ |
Found in T_OVERSEAS_LOOKUP_V9.F_DOMICILE_ISO | T_OVERSEAS_LOOKUP_V9.F_REGION |
Not found in T_OVERSEAS_LOOKUP_V9.F_DOMICILE_ISO | Null |
Revision history
Contact Liaison by email or on +44 (0)1242 388 531.