XINSTG01_3.17.1
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
Region of higher education provider | XINSTG01 | 3.17.1 | 1 | Char |
Valid entries
Dependent fields
- None
Depend upon fields
- UKPRN
Additional information
This field presents a region of location using the postcode (unit level) of the higher education provider's (HEP) administrative centre. Region in this context are the nine England regions (formerly Government Office Region) and codes for Wales, Scotland and Northern Ireland. Lookup tables derive region using Office for National Statistics (ONS) data.
The allocation of a HEP to a geographical region relates only to its administrative centre. There may be students registered at a HEP who are studying in regions other than that of the administrative centre.
This field derives the Open University to South East. Although the Open University teaches throughout the UK, their administrative centre is located in South East England. In HESA analyses the Open University is often displayed separately.
The HESA Data Management STATIC_DATA.INSTHQPC_LOOKUP lookup table is updated with the Office for National Statistics Postcode Directory (ONSPD) in November, May and August each reporting year. However, HESA would not expect the Region allocated to a particular HEP to be reported differently within a HESA reporting year. Consequently this specification is updated only once per reporting year to coincide with the August ONSPD, with the suffix '_(Y2)AUG'.
Analysis of Region for Graduate Outcomes is carried out by linking to XINSTG01 in the Student record (Cyy051) or Student Alternative record (Cyy054) as appropriate.
The August ONSPD update is used to ensure that all postcodes valid in a reporting period can be validated during submission. The static data postcode lookup tables provided by Data Management are updated with the August ONSPD when it becomes available, in addition to the November and May postcodes used for the early and full systems.
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 HESA Data Management STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG table is created as part of the processing of the ONS postcode data loaded into Oracle. For providers in England the postcode is taken from the OfS Register, for other nations the primary contact address postcode from the UKRLP is used.
All valid UKPRNs (UK Provider Reference Numbers) must be added to the HESA Data Management STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table in Oracle.
1. Where the UKPRN is found in the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG F_UKPRN column, then STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG F_GOR is returned as XINSTG01.
2. Where the UKPRN is not found in STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG F_UKPRN column, then return Null as XINSTG01. This is an error, highlighting that a value in the collection's UKPRN field is not contained in the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table's F_UKPRN 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.
Column | Description |
---|---|
F_HHESA | HESA higher education provider identifier |
F_OPOSTCODE | Full postcode of higher education provider HQ |
F_XDOMUC01 | County/unitary authority of higher education provider |
F_GOR | Region of higher education provider |
F_CTRY | Country of higher education provider |
F_CTRY_ISO | Country of higher education provider (2-letter ISO-3166-1 format) |
F_UKPRN | UK Provider Reference Number |
F_XPROVCAT | Flag to identify the category the provider is subscribed under e.g England Approved, England Approved Fee Cap |
UKPRN (as submitted in each collection) | XINSTG01 |
---|---|
1. Found in STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG.F_UKPRN | STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG. F_GOR |
2. Not found in STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG.F_UKPRN | Null |
Revision history
Contact Liaison by email or on +44 (0)1242 388 531.