XDOMGR01_5.2.2
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
Region of student domicile | XDOMGR01 | 5.2.2 | 4 | Char |
Valid entries
Dependent fields
- XDOMGR401
- XDOMHM01
- XDOMREG01
Depend upon fields
- DOMICILE
- POSTCODE
Additional information
The single character England region codes are as described in Region (Office for National Statistics) in the ONS Postcode Directory (ONSPD). The remaining UK codes are mapped by HESA from pseudo ONS region codes. Where a postcode is provided and this matches on the ONSPD to a Region, then this region is output. Where a valid postcode is provided (valid postcodes include terminated postcodes), but it does not match the ONSPD, then UK region unknown is output (this would only occur as the result of a validation switch for a postcode introduced after the release of the ONSPD version in use by HESA).
Code XF is the National Statistics Country Classification (NSCC) code for England, but is used in this field as England region unknown, when data cannot be assigned to one of the nine England region codes.
Non-UK codes are derived from an overseas look-up table, provided by HESA Data Management, which includes all domicile codes except ZZ. Where no postcode is provided, and the country reported in domicile can be matched to region in the overseas lookup table then this region is output.
The August ONSPD update is used to ensure that all postcodes valid in a reporting period can be validated during submission.
Contains OS data © Crown copyright and database right 2020
Contains Royal Mail data © Royal Mail copyright and database right 2020
Source: Office for National Statistics licensed under the Open Government Licence v.3.0
Geographical mappings for Northern Ireland are based upon Crown Copyright and are reproduced with the permission of Land & Property Services under delegated authority from the Keeper of Public Records, © Crown copyright and database right 2020. NIMA MOU577.4
Technical Specification
Please note: in the following specification, the table suffix '_(Y2)AUG' refers to a year-specific reference derived from the reporting year. For 2013/14, Y1 is 13 and Y2 is 14, thus for 2013/14 the table suffix would be 14AUG, and for 2014/15 the suffix would be 15AUG, and so on.
The table FULLPC_LOOKUP_(Y2)AUG consists of 6 columns:
Full Postcode (F_FULLPC, VARCHAR2, 8); X coordinate (F_OSEAST1M, NUMBER); Y coordinate (F_OSNRTH1M, NUMBER); Region (F_GOR, CHAR, 2); Country (F_CTRY, VARCHAR2, 2) and County/Unitary Authority code (F_XDOMUC01, VARCHAR2, 4).
This table has been supplied in an Oracle table provided by Data Management.
The table OUTPC_LOOKUP_(Y2)AUG consists of 7 columns:
Outward Postcode (F_OUTPC, VARCHAR2, 4); Full Postcode (F_FULLPC, VARCHAR2, 8); X coordinate (F_OSEAST1M, NUMBER); Y coordinate (F_OSNRTH1M, NUMBER); Region (F_GOR, CHAR, 2); Country (F_CTRY, VARCHAR2, 2) and County/Unitary Authority code (F_XDOMUC01, VARCHAR2, 4).
This table has been supplied in an Oracle table provided by Data Management.
The table T_OVERSEAS_LOOKUP_V9 consists of 3 columns:
Country of domicile (F_DOMICILE, VARCHAR2, 4); Region of domicile (F_REGION, VARCHAR2, 4) and ISO Country of domicile (F_DOMICILE_ISO, VARCHAR2, 2).
This table has been supplied in an Oracle table provided by Data Management.
If a valid DOMICILE code has been supplied (in 2-char ISO format), but is not found in T_OVERSEAS_LOOKUP_V9, then the function will output NULL, which is to be identified during impossible values testing.
see following page
Note to developers:Convert incoming POSTCODE data to uppercase in Software Development function, before carrying out lookup.
POSTCODE (CHAR 8) | DOMICILE (CHAR 2) | XDOMGR01 (CHAR 4) |
---|---|---|
Null | ZZ, Null | NOTK |
GG, JE, XL or IM | Z | |
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 | |
Found in FULLPC_LOOKUP_(Y2)AUG .F_FULLPC and FULLPC_LOOKUP_(Y2)AUG .F_GOR not blank (If F_GOR is blank match on OUTPC) | FULLPC_LOOKUP_(Y2)AUG .F_GOR | |
Set of characters (max. of 4) up to first space, if there is one, found in OUTPC_LOOKUP_(Y2)AUG .F_OUTPC and OUTPC_LOOKUP_(Y2)AUG .F_GOR not blank (If F_GOR is blank then Otherwise) | OUTPC_LOOKUP_(Y2)AUG .F_GOR | |
Otherwise | XK |
XDOMGR01 may output a null value. This is an error, highlighting that a value in the collection's DOMICILE 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.
Revision history
Contact Liaison by email or on +44 (0)1242 388 531.