XPARTCAT01_2.2.1

Back to C18054

Field description	Field abbreviation	Field version	Field length	Field type
HESA participation category	XPARTCAT01	2.2.1	2	Char

Valid entries

Code	Label
01	Full subscriber
02	Designated and Unistats subscriber
05	KIS (course) only participation
06	FE subscriber submitting HE data

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.

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

Date	Version	Notes
2016-11-01	2.2.1	Valid entry 05 reinstated and 06 added to reflect the change in contractual arrangements between HESA and providers for 2016/17
2016-02-11	2.1.1	Valid entries 04 and 05 removed to reflect the change in contractual arrangements between HESA and providers. The Additional Information content which dealt with these entries has also been removed
2015-01-21	1.1.1	Created

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