Skip to main content

XINSTCOU01_1.1.3

Back to C19051

Field description Field abbreviation Field version Field length Field type
Country of higher education provider - Open University split by national centres XINSTCOU01 1.1.3 1 Char

Valid entries

Code Label
E England
S Scotland
W Wales
N Northern Ireland

Dependent fields

  • None

Depend upon fields

  • CAMPID
  • UKPRN

Additional information

This field presents a country of location using the postcode (unit level) of the higher education provider's (HEP) administrative centre for all HEPs, with the exception of the Open University. Lookup tables derive country using Office for National Statistics (ONS) data.

Although the Open University's administrative centre is located in England, it teaches throughout the UK, and has national centres in Wales, Scotland and Northern Ireland. This field derives students at the Open University to either England, Wales, Scotland or Northern Ireland, using the CAMPID field returned in the Student record. (Please note that all non-UK domicile students, plus those who study at postgraduate research level (PGR) with the Open University are registered to the administrative centre in England).

There may be students registered at HEPs who are studying in countries other than that of the administrative centre.

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 country of higher education provider to change within a HESA reporting year. Consequently this specification is updated only to coincide with the August ONSPD, with the suffix '_(Y2)AUG', with no subsequent updates for collections within the same reporting year.

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 loaded earlier in the reporting year.

If the analysis of Country of Higher Education Provider for Graduate Outcomes requires the Open University to be split by national centres link to this Student derived field. If an Open University split by national centres is not required link to the Student/Student Alternative derived field XINSTC01.

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.

Where the UKPRN submitted is that of the Open University, the CAMPUS field is used to derive a country of location for XINSTCOU01.

Where the UKPRN is not that of the Open University, but is found in the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG F_UKPRN column, then STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG F_CTRY is returned as XINSTCOU01.

Where the UKPRN is not that of the Open University, and is not found in STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG F_UKPRN column, then Null is returned as XINSTCOU01. 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 table consists of 8 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_XPROVTYPE01 Flag to identify the the type of provider e.g HEI or AP
F_XPARTCAT01 Flag to identify the groups of collections to which a provider submits data
Institution.UKPRN Instance.CAMPID XINSTCOU01 (CHAR 1)
10007773 A E
W W
S S
N N
Otherwise (including Null) E
Not 10007773 and found in STATIC_DATA. INSTHQPC_LOOKUP_(Y2)AUG.F_UKPRN STATIC_DATA. INSTHQPC_LOOKUP_(Y2)AUG.F_CTRY
Not 10007773 and not found in STATIC_DATA. INSTHQPC_LOOKUP_(Y2)AUG.F_UKPRN Null

Revision history

Date Version Notes
2020-03-26 1.1.3 Copyright information added
2015-04-01 1.1.2 Minor error correction to bottom row of Technical Specification table, correcting the cited UKPRN of '10007774' to '10007773'
2014-12-09 1.1.1 Created

Contact Liaison by email or on +44 (0)1242 388 531.