XREGAG01_3.1.1
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
Aggregate Offshore region of provision | XREGAG01 | 3.1.1 | 4 | Char |
Valid entries
Dependent fields
- None
Depend upon fields
- None
Additional information
This field groups the country of provision entries from the Aggregate Offshore collection (Cyy052) to regions in a manner consistent with the Student collection's domicile derived fields.
The valid entries for this field are created from an overseas lookup table, provided by Data Management, which includes all the valid country entries in the column F_DOMICILE_ISO. (The Aggregate Offshore collection country entries are a subset of the Student collection DOMICILE entries.)
Entry XL is the National Statistics County Classification (NSCC) code for Channel Islands not otherwise specified, but is used in this field to label Guernsey and Jersey. Guernsey and Jersey in this context refer to the Bailiwicks of Guernsey and Jersey, which includes their smaller islands. Guernsey and Jersey includes Channel Islands not otherwise specified.
Technical Specification
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.
Where the COUNTRY value is found in the F_DOMICILE_ISO column of T_OVERSEAS_LOOKUP_V9, then return F_REGION as XREGAG01.
Where the COUNTRY is not found in the F_DOMICILE_ISO column of T_OVERSEAS_LOOKUP_V9, then return Null as XREGAG01, which will be reproduced in XREGAG01. This is an error, highlighting that a value in the collection's COUNTRY field is not contained in the F_DOMICILE_ISO column of T_OVERSEAS_LOOKUP_V9. (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.)
Cyy052 Provision.COUNTRY (2 CHAR) | XREGAG01 |
---|---|
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.