HESA Student record 2015/16
File structures for downloadable files - DLHE survey population file
Version 1.0 Produced 2016-03-03
Files are produced in XML and CSV (comma separated value) format.
Derived fields, prefixed with an X, 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.RCSTDNT | Research Council student | RCSTDNT | 2 |
Instance.NUMHUS | Student instance identifier | NUMHUS | 20 |
CENSUS | Census1 | CENSUS | 3 |
Instance.OWNINST | Institution'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) | Instance.MODE = 63 or 64 |
0 (Not Dormant) | Instance.MODE not in (63 or 64) | |
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 If only one qualification exists the second qualification field 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 business rule QR.Cyy051.Course.CourseSubject.2 as the level is HE). 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.
Download: XML Schema for DLHE survey population file.
Need help?
Contact Liaison by email or on +44 (0)1242 388 531.