Alternative provider student record 2014/15
File structures for downloadable files - DLHE survey population file
Version 1.0 Produced 2015-09-02
Files are produced in XML and CSV (comma separated value) format.
Derived fields, prefixed with an X or Z, are standard ways of grouping data. The specifications for these fields are made available under the 'Submission process and quality assurance' section of the manual when finalised.
Field name | Description | Element name in XML output | Field length |
Student.HUSID | HESA unique student identifier | HUSID | 13 |
Student.SURNAME | Family name | SURNAME | 100 |
Student.FNAMES | Forenames | FNAMES | 100 |
Student.OWNSTU | Provider's own identifier for student | OWNSTU | 20 |
Course.CTITLE | Course title | CTITLE | 255 |
Course.COURSEID | Course identifier | COURSEID | 30 |
Course.OWNCOURSEID | Own course identifier | OWNCOURSEID | 50 |
XQMODE01 | Qualification mode of study | XQMODE01 | 1 |
QualificationsAwarded.QUAL1 | Qualification awarded | QUAL1 | 3 |
QualificationsAwarded.QUAL2 | Qualification awarded 2 | QUAL2 | 3 |
XOBTND01 | DLHE Highest qualification obtained: the highest entry where more than one occurrence is returned of QualificationsAwarded.QUAL | XOBTND01 | 3 |
XDLEV301 | Level of qualification in DLHE - 3 way split | XDLEV301 | 1 |
HOMEEUOS | Home/Other EU/Other Overseas flag 1 | HOMEEUOS | 1 |
Course.TTCID | Teacher training course | TTCID | 1 |
Instance.NUMHUS | Student instance identifier | NUMHUS | 20 |
CENSUS | Census1 | CENSUS | 3 |
Instance.OWNINST | Provider's own instance identifier | OWNINST | 30 |
DORMANT | Dormant flag1 | DORMANT | 1 |
XDLEV501 | Level of qualification in DLHE - 5 way split | XDLEV501 | 1 |
XJACSLEV101_1 | Analytical protocol JACS - level 1 grouping3 | XJACSLEV101_1 | 1 |
XJACSLEV101_2 | Analytical protocol JACS - level 1 grouping3 | XJACSLEV101_2 | 1 |
XJACSLEV101_3 | Analytical protocol JACS - level 1 grouping3 | XJACSLEV101_3 | 1 |
XJACSLEV201_1 | Analytical protocol JACS - level 2 grouping3 | XJACSLEV201_1 | 2 |
XJACSLEV201_2 | Analytical protocol JACS - level 2 grouping3 | XJACSLEV201_2 | 2 |
XJACSLEV201_3 | Analytical protocol JACS - level 2 grouping3 | XJACSLEV201_3 | 2 |
XJACSLEV301_1 | Analytical protocol JACS - level 3 grouping3 | XJACSLEV301_1 | 3 |
XJACSLEV301_2 | Analytical protocol JACS - level 3 grouping3 | XJACSLEV301_2 | 3 |
XJACSLEV301_3 | Analytical protocol JACS - level 3 grouping3 | XJACSLEV301_3 | 3 |
Notes
1 Field attributes:
Field name | Code | Derived from |
HOMEEUOS | 1 (Home) | XDOMHM01 = 1, 2, 3, 4 or 5 |
2 (EU) | XDOMHM01 = 6 | |
3 (Overseas) | XDOMHM01 = 7 | |
4 (Not known) | XDOMHM01 = 8 | |
DORMANT | 1 (Dormant) | XINACT01 = 1 |
0 (Not Dormant) | XINACT01 = 0 | |
CENSUS | APR (April Census) | Instance.ENDDATE > 31-JUL-Y1 and Instance.ENDDATE < 01-JAN-Y2 |
JAN (January Census) | Instance.ENDDATE > 31-DEC-Y1 and Instance.ENDDATE < 01-AUG-Y2 |
2 Multiple InstancePeriod entities can be returned within an Instance and each InstancePeriod can have up to two QualificationsAwarded entities associated with it.
- If more than one InstancePeriod exists for the Instance use the latest one returned (the one with the latest PERIODSTART date. Uniqueness of InstancePeriod.PERIODSTART within Instance is enforced by schema).
- If only one QualificationsAwarded.QUAL exists for the InstancePeriod, it is recorded in the QUAL1 field and the second qualification field (QUAL2) will be blank.
3 The XJACSLEV101, XJACSLEV201 and XJACSLEV301 fields are derived from the CourseSubject entity which, for DLHE, will always have at least one occurrence and may have up to 3 (this is enforced in the Cyy054 schema). The derived fields are held in the Cyy051_SJ table and each Instance.InstanceKEY will link to the table between 1 and 3 times. Consequently, XJACSLEV101_1, XJACSLEV201_1 and XJACSLEV301_1 will always be populated but XJACSLEV101_2, XJACSLEV201_2, XJACSLEV301_2, XJACSLEV101_3, XJACSLEV201_3 and XJACSLEV301_3 may not be.
Need help?
Contact Liaison by email or on +44 (0)1242 388 531.