Skip to main content

XINSTG01_3.16.1

Back to C19052

Field description Field abbreviation Field version Field length Field type
Region of higher education provider XINSTG01 3.16.1 1 Char

Valid entries

Code Label
A North East
B North West
D Yorkshire and The Humber
E East Midlands
F West Midlands
G East of England
H London
J South East
K South West
W Wales
X Scotland
Y Northern Ireland

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. It uses the value for main campus postcode from the HESA Contacts database.

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.

STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table consists of 9 columns:
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

Date Version Notes
2020-03-26 3.16.1 Technical specification updated to describe the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table correctly due to further changes made to the contents. The F_XPROVTYPE01 and F_XPARTCAT01 fields has been replaced with F_XPROVCAT. These fields are not used in the derivation of XINSTG01. Copyright information has also been added to the additional information section
2015-02-12 3.15.3 Technical specification updated to describe the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table correctly due to further changes made to the contents. The 'F_PROVIDER' field has been replaced with F_XPROVTYPE01 and F_XPARTCAT01. These fields are not used in the derivation of XINSTG01
2014-10-16 3.15.2 Additional information section amended to allow for the use of this field in the Cyy054 AP student record. Technical specification updated to describe the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table correctly in light of changes made to the contents
2014-08-27 3.15.1 Higher education provider (HEP) name change applied to field. Subsequent long name change
2013-09-30 3.14.2 Table suffixes changed to be non-year specific, with explanatory sentence added
2013-02-06 3.14.1 Updated for new version of lookup 13AUG. Reference to XUKPRN01 in yy025 changed to UKRPN, as this field is now collected rather than derived. Second row added to Technical specification: Where the UKPRN value is not found in INSTHQPC_LOOKUP_yyAUG F_UKPRN column, return Null as XINSTG01 as an error - rather than allowing the function to fail
2012-04-12 3.13.2 Field description changed to 'Region of institution location' and reference to 'Government Office Region' changed to 'Region' following ONS policy change. No change to function or valid entries
2012-02-09 3.13.1 Updated for new version of lookup table 12AUG. Reference to NSPD updated to ONSPD
2011-04-13 3.12.2 Updated to clarify UKRPN for Cyy031
2011-04-13 3.12.1 Updated for new lookup table 11AUG
2011-01-31 3.11.1 Updated for new lookup table 11MAY
2010-10-01 3.10.2 yy042 added to technical specification header. No change to function
2010-06-23 3.10.1 Error handling clarified for circumstances where value not found in lookup table. Change to function required to handle
2010-05-07 3.9.2 Typo corrections to Technical specification (XINSTC01 column corrected to XINSTG01 and F_CTRY to F_GOR) - No change required to function
2010-04-12 3.9.1 Using new lookup table - 10MAY
2009-10-01 3.8.1 Technical specification amended to reflect that Cyy031 uses UKPRN from 2008/09
2009-07-16 3.7.2 Removed yy018 from XUKPRN01 list as XINSTG01 not created for DLHE. Note added to Additional information for analysis of GOR from DLHE record
2009-06-10 3.7.1 Valid entry label D changed to Yorkshire and The Humber, G to East of England to match ONS description
2009-03-11 3.6.1 Using new lookup table - 09MAY. More comprehensive explanation of specification provided for return to institutions. Field type added
2008-10-15 3.5.3 Remove superfluous semicolons from valid entry list
2008-10-14 3.5.2 Clarification of reporting period updates – once per reporting year using yyMAY
2006-02-21 3.3.1 Using new lookup table - May 2006. Table INSTHQPC_LOOKUP_06MAY not yet created as at 21 February 2006
2005-01-06 3.1.1 Using new lookup table source and different valid entry codes
2004-03-01 2.2.1 Code modified to use updated lookup table (R36); 2004-02-25
2003-02-11 2.1.1 Code modified to use updated lookup table (R34). Code 4 not used
2002-05-13 1.2.2 Specification change – new column added to lookup table
2001-09-20 1.2.1 Code modified to use updated lookup table (R32
2000-03-16 1.1.1 Created
1994-01-01 3.5.1 Using new lookup table - May 2008. Clarified source of lookup
1994-01-01 3.4.1 Using new lookup table - May 2007
1994-01-01 3.2.1 Using new lookup table - May 2005

Contact Liaison by email or on 01242 211144.