XDESIG03_2.1.1
| Field description | Field abbreviation | Field version | Field length | Field type |
|---|---|---|---|---|
| Student Alternative provider marker - instance level | XDESIG03 | 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 XDESIG03 field assigns a value to each instance in the record with reference to this information, allowing easy identification of instances which are associated with Registered providers, or designated courses with reference to the designation status of the latest instance period submitted. XDESIG03 uses the designation status at the end of the reporting period. The XDESIG02 field (‘Student Alternative provider marker – Instance period level’) uses the designation status of the course that was current during each instance, which may potentially result in different values between the fields if the designation status has changed one or more times during the reporting period. The fields will, however, align for the latest instance period submitted.
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 | |
| LATESTSTATUS | Latest designation status | |
Calculate top down:
| Provider. UKPRN | XPROVCAT | Latest InstancePeriod. COURSEID | Latest InstancePeriod. LOCATION (up to 10 per Instance Period) | Designation file LATEST STATUS | XDESIG03 |
|---|---|---|---|---|---|
| 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 | 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.