XDESIG02_2.1.1
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
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 | |
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
Contact Liaison by email or on +44 (0)1242 388 531.