XPARTCAT01_2.2.1
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
HESA participation category | XPARTCAT01 | 2.2.1 | 2 | Char |
Valid entries
Dependent fields
- None
Depend upon fields
- UKPRN
Additional information
This derived field adds a HESA participation category to the relevant datasets for each higher education provider (HEP).
The HESA participation categories align with the contractual subscription agreements between HESA and HEPs.
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 participation category is carried out through the use of a static data lookup table (see technical specification, below), supplied by HESA Data Management.
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 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 participation category value and returned in XPARTCAT01. 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.
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 | HESA provider type |
f_xpartcat01 | HESA participation category |
Where this derived specification exists for a collection, this field is created against each HEP. If no match is made between the collection's UKPRN and a UKPRN held 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_XPARTCAT01 as F_XPARTCAT01.
2. Where the UKPRN value is not found in the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG table F_UKPRN, return Null as F_XPARTCAT01. 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) | XPARTCAT01 (CHAR 2) |
---|---|
1. Found in STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG. F_UKPRN | STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG. F_XPARTCAT01 |
2. Not found in STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG.F_UKPRN | Null |
Revision history
Contact Liaison by email or on +44 (0)1242 388 531.