Skip to main content

XPROVCAT_1.1.1

Back to C20054

Field description Field abbreviation Field version Field length Field type
HESA Provider Category XPROVCAT 1.1.1 2 Char

Valid entries

Code Label
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)
09 Optional Subscriber
10 Designation for Teach Out
11 Limited Designation

Dependent fields

  • None

Depend upon fields

  • UKPRN

Additional information

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

Technical Specification

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.

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 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

Revision history

Date Version Notes
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.