XSTULOCGR_3.1.1
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
Region of study | XSTULOCGR | 3.1.1 | 4 | Char |
Valid entries
Dependent fields
- XSTULOCN
Depend upon fields
- STUCOUNTRY
- UCNAME
- D_Country.CountryCode
- Reference.T000_INSTHQPC.F_XSTULOCGR
Additional information
This algorithm uses look-up tables provided from data initially supplied by the Office for National Statistics (ONS). Postcodes (full, outward and area) are mapped to UK government office regions for UK domiciled students where possible.
Country codes are returned for other UK and mapped to geographic regions for non-UK domiciled students.
Valid entry Z (Guernsey, Jersey and the Isle of Man) is derived from country entries GG (Guernsey), JE (Jersey), IM (Isle of Man) and XL (Channel Islands not otherwise specified). The smaller Channel Islands of Alderney and Sark are included under the Bailiwick of Guernsey. Officially, the Crown Dependencies of Guernsey, Jersey and the Isle of Man are not part of the UK or the EU. However, for HESA analysis purposes they are often grouped with and generally assumed to be part of the United Kingdom.
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.
The definition of the European Union is as at 1 December in the academic year to which the data relates.
Valid entry NOTK (Not known) includes those for whom location of self-employment / own business cannot be determined from the information returned and those for whom location information was not provided.
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.
Where a graduate studied at The Open University (UKPRN = 10007773), the location of study is set to UK to reflect the distance learning nature of the courses which could take place from any location.
Where a graduate studied at University of London Institute in Paris (UKPRN = 10007812), the location of study is set to ‘Geographic region - Other European’ (GREU).
Valid entry NOTK (Not known) includes those for whom location of study cannot be determined from the information returned and those for whom no location information was provided.
Technical Specification
The algorithm uses the HESA Data Management table D_country which is created from an overseas lookup and restricted to the November YYYY update (country mapping is valid at this date), where YYYY represents the year following the academic year of collection. For example, for graduate outcomes 2017/18, the November 2019 ONSPD data is used. The table includes the following fields: Country Code (CountryCode, VARCHAR(2)) and Region Code (GeographicGroupCode, NVARCHAR(4)).
Where UCNAME is not 'OTHER' the UKPRN is mapped using Reference.T000_INSTHQPC to government office region level using the November YYYY lookup.
STUCOUNTRY (CHAR 2) | UCNAME (CHAR 8) | XSTULOCGR (CHAR 4) |
---|---|---|
If STUCOUNTRY is GG, JE, XL or IM | Z | |
If STUCOUNTRY found in D_Country.CountryCode and STUCOUNTRY not XF, XI, XH or XG | D_Country.GeographicGroupCode | |
If STUCOUNTRY found in D_Country.GeographicGroupCode and STUCOUNTRY not XF, XI, XH or XG | D_Country.GeographicGroupCode | |
Else | 10007773 | XK |
10007812 | GREU | |
If UCNAME not equal to 'OTHER' | T000_INSTHQPC.F_XSTULOCGR Where F_UKPRN = UCNAME | |
4002 | OS | |
Else | NOTK |
Revision history
Contact Liaison by email or on +44 (0)1242 388 531.