Skip to main content

Alternative provider student record 2015/16

Back to C15054

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 title4 CTITLE 255
Course.COURSEID Course identifier4 COURSEID 30
Course.OWNCOURSEID Own course identifier4 OWNCOURSEID 50
XQMODE01 Qualification mode of study XQMODE01 1
QualificationsAwarded.QUAL1 Qualification awarded QUAL1 3
QualificationsAwarded.QUAL2 Qualification awarded2 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 course4 TTCID 1
Instance.NUMHUS Student instance identifier NUMHUS 20
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


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 InstancePeriod.PERIODSTART date. Uniqueness of 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 will always have at least one occurrence and may have up to 3 (this is enforced in Cyy054 schema). The derived fields are held in the Cyy054_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 and XJACSLEV101_3, XJACSLEV201_3, XJACSLEV301_3 may not be.

4 The latest InstancePeriod (that is the one in the Instance with the latest InstancePeriod.PERIODSTART date) contains InstancePeriod.COURSEID. This should be used to link to the Course entity to obtain the Course fields.

Download: XML Schema for DLHE survey population file.

Need help?

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