|Field description||Field abbreviation||Field version||Field length||Field type|
|HESA Provider Category||XPROVCAT||1.1.1||2||Char|
|01||England - Approved (Fee Cap)|
|02||England - Approved|
|03||England Further Education College (EFEC)|
|04||Northern Ireland HE Provider|
|05||Scotland HE Provider|
|06||Wales HE Provider|
|07||Northern Ireland Further Education College (NIFEC)|
|08||Wales Further Education College (WFEC)|
|10||Designation for Teach Out|
Depend upon fields
This derived field adds a HESA Provider Category flag to relevant datasets for each Higher Education Provider (HEP). HESA provider category refers to a HEP's funding categorisation.
Where HESA analysts have identified a need for this field for a collection it will be created against all HEPs within that collection.
The mapping to HESA provider type is carried out through the use of a static data lookup table (see technical specification, below), supplied by HESA Data Management.
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
Please note: in the following specification, the table suffix '_(Y2)AUG' referes to a year-specific reference derived from the reporting year. For 2014/15, Y1 is 14 and Y2 is 15. Thus for 2014/15 the table suffix would be 15AUG, and for 2015/16 the suffix would be 16AUG, and so on.
Each HEP in the collection will submit a UK Provider Reference Number (UKPRN). Each UKPRN in the HESA constituency is mapped using the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG table, to a HESA provider type value and returned in XPROVCAT. 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.
|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||HESA Provider Category|
Where this derived specification exists for a collection, this field is created against each provider. If no match is made between the collection's UKPRN and a UKPRN held in STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG table, the function will output an invalid null value.
1. Where the UKPRN value is found in the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG table F_UKPRN, return F_XPROVCAT as XPROVCAT.
2. Where the UKPRN value is not found in the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG table F_UKPRN, return Null as XPROVCAT. This is an error, highlighting that a value in the collection's UKPRN field is not contained in the static_data lookup table 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.
|UKPRN (as submitted in each collection)||XPROVCAT (CHAR 2)|
|1. Found in STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG. F_UKPRN||STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG.F_XPROVCAT|
|2. Not found in STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG.F_UKPRN||Null|
|2020-03-03||1.1.1||Created and copyright information has also been added to the additional information section|
Contact Liaison by email or on +44 (0)1242 388 531.