XDESIG02_2.1.1

Back to C19054

Field description	Field abbreviation	Field version	Field length	Field type
Student Alternative provider marker - instance period level	XDESIG02	2.1.1	2	Char

Valid entries

Code	Label
01	Instance period is associated with a course at a provider which is registered as ‘Approved (Fee Cap)’ during the reporting period.
02	Instance period is associated with a course at a provider which is registered as ‘Approved’ during the reporting period.
03	Instance period is associated with a course at a provider which is categorised as ‘Optional Subscriber’ during the reporting period.
04	Instance period is associated with a course which is ‘Limited Designation’ or ‘Teach Out Designation’ during the reporting period
05	Instance period is associated with a course that is 'Not designated'during the reporting period
00	The provider cannot be assigned to a Registration or a Designation category

Dependent fields

None

Depend upon fields

LOCATION
COURSEID
UKPRN

Additional information

For the Student Alternative record there is a requirement to identify constituent providers by Registration Category and course-level Designation Status. This is to enable appropriate validation and reporting to be run against the category of provider.

The Registration Categories for the Student Alternative record’s constituent providers are Approved (Fee Cap), Approved, and Optional Subscriber. The identification of Registration Categories are obtained from Data Management’s static data table INSTHQPC_LOOKUP XPROVCAT values (also created as the derived field XPROVCAT).

For the purposes of course-level designation, a course is uniquely identified by the combination of a UKPRN, COURSEID and a LOCATION, which will be submitted to OfS as part of the designation process. From C19054 only two Designation categories are applied Limited Designation and Teach Out.

A designated course may have multiple approved locations. Providers are required to submit every location associated with the relevant instance period - thus there may be several unique combinations of COURSEID and LOCATION per instance period. An instance period is only considered to be associated with a designated course if all associated locations are designated.

The XDESIG02 field assigns a value to each instance period in the record with reference to this information, allowing easy identification of instance periods which are associated with Registered providers or designated courses.

This derived field operates top-down, looking for the occurrence of the submitted provider’s UKPRN against the Registration Category in the first instance, then against the Designation Status.

Technical Specification

XPROVCAT is derived from HESA’s Data Management static data table INSTHQPC_LOOKUP(Y2)AUG.

OfS supply HESA with a designation file in XML format, containing the following structure:

Each 'Provider' entity contains:
UKPRN	UK provider reference number

	'CourseDesignation' entities (1 or more) containing:
	COURSEID	Course identifier

	'Location' sub-entities (1 or more) containing:
	LOCID	Location identifier
	DESIGNATIONSTATUS	Designation status

Calculate top down:

Provider. UKPRN	XPROVCAT	InstancePeriod. COURSEID	InstancePeriod. LOCATION (up to 10 per Instance Period)	Designation file DESIGNATION STATUS	XDESIG02
Match on XPROVCAT F_UKPRN	01				01
	02				02
	09				03
Match on OfS Designation file for the Provider.UKPRN		Match on OfS Designation file for the Provider.UKPRN on Provider, CourseDesignation.COURSEID	All values submitted match on CourseDesignation, Location.LOCID in OfS Designation file for the Provider.UKRPN and InstancePeriod.COURSEID combination	All associated values are 'Limited Designation' Or ‘Teach Out’	04
Match on OfS Designation file for the Provider.UKPRN			Otherwise		05
Otherwise					00

Note: Valid entry 00 should not occur and would result only if a provider is in constituency but has not been added into INSTHQPC_LOOKUP by HESA or the designation.xml by OfS. Its occurrence should be picked up by Impossible values testing.

Revision history

Date	Version	Notes
2020-03-26	2.1.1	All details within the derived field have been replaced to include all categories of providers e.g Approved (fee-cap), Approved etc
2017-09-05	1.3.1	Technical specification updated to include which locations are designated for which levels of study (Undergraduate or Postgraduate
2016-11-01	1.2.1	Technical specification updated to reflect the deletion of Course.TTCID valid entry G
2016-04-12	1.1.1	Created to replace XDESIG01 at instance period level

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