Skip to main content

Destinations of Leavers from Higher Education record 2016/17

Back to C16018

Data supply

Version 1.0 Produced 2018-02-01

The data supply table is supplied in CSV and XML formats. The table contains the majority of DLHE fields.

The tables contain the following types of field:

  • Cyy051/Cyy054.InstanceKEY and Student.StudentKEY are unique keys within the database used to link records across tables.
  • Base fields from the C16018 submission prefixed with the appropriate entity; Student, Employment, Study or Teaching.
  • The DLHE data supply requires fields from the corresponding Student record to enable recreation of Credibility report figures. Where a field is from the Student record it will be prefixed with Cyy051, and where a field is from AP Student record it will be prefixed with Cyy054.
  • Derived fields, prefixed with an X, are standard ways of grouping data. View details of the derived field specifications.

Core table

Field name Description Element name in XML output Field length
Unique key for every student instance INSTANCEKEY 13
Student.STUDENTKEY Unique key for every DLHE instance STUDENTKEY 13
Institution.RECID HESA record type indicator RECID 5
Institution.UKPRN UK Provider Reference Number UKPRN 8
Student.HUSID HESA unique student identifier HUSID 13
Provider's own identifier for student OWNSTU 20
Student instance identifier NUMHUS 20
Provider's own instance identifier OWNINST 30
Cyy054.ULN Unique Learner Number ULN 10
Course identifier COURSEID 30
Own course identifier OWNCOURSEID 50
Cyy051.INSTCAMP Provider's own campus identifier INSTCAMP 8
Qualification obtained mode of study XQMODE01 1
Mode of study MODE 2
Level of qualification in DLHE - three way split XDLEV301 1
Level of qualification in DLHE - five way split XDLEV501 1
Cyy051.RCSTDNT Research Council student RCSTDNT 2
End date of instance ENDDATE 10
Teacher training course TTCID 1
XPDLHE02 DLHE population for expanded coverage XPDLHE02 1
Student.STATUS Method of the response STATUS 2
XACTIV02 Employment activity XACTIV02 2
Student.ALLACT1 All activities - one ALLACT 1
Student.ALLACT2 All activities - two ALLACT 1
Student.ALLACT3 All activities - three ALLACT 1
Student.ALLACT4 All activities - four ALLACT 1
Student.ALLACT5 All activities - five ALLACT 1
Student.ALLACT6 All activities - six ALLACT 1
Student.ALLACT7 All activities - seven ALLACT 1
Student.ALLACT8 All activities - eight ALLACT 1
Student.APRJAN April or January survey APRJAN 1
Student.HEBUSNEXP Higher Education experience for business HEBUSNEXP 1
Student.HESTUDYEXP Higher Education experience for study HESTUDYEXP 1
Student.HEWORKEXP Higher Education experience for work HEWORKEXP 1
Student.MIMPACT Most important activity MIMPACT 1
Student.OPTOUT Opt out from communications OPTOUT 1
Employment.EMPBASIS Employment basis EMPBASIS 2
Employment.EMPCOUNTRY Country of employment EMPCOUNTRY 2
Employment.EMPCURRENCY Currency of pay EMPCURRENCY 1
Employment.EMPHOURS Hours worked per week EMHOURS 5
Employment.EMPIMP Importance to employer EMPIMP 1
Employment.EMPNAME Employer name EMPNAME 60
Employment.EMPPAY Pay EMPPAY 20
Employment.EMPPAYPERIOD Payment period EMPPAYPERIOD 1
Employment.EMPPCODE UK Postcode for place of employment EMPPCODE 8
Employment.EMPPLACE Place of employment EMPPLACE 200
Employment.EMPUNPAID Unpaid Work EMPUNPAID 1
Employment.ESTEARN Total estimated earnings for a year ESTEARN 7
Employment.JOBDUTIES Job duties JOBDUTIES 200
Employment.JOBFOUND How found job JOBFOUND 2
Employment.JOBRSNALL1 All reasons for taking the job - one JOBRSNALL 2
Employment.JOBRSNALL2 All reasons for taking the job - two JOBRSNALL 2
Employment.JOBRSNALL3 All reasons for taking the job - three JOBRSNALL 2
Employment.JOBRSNALL4 All reasons for taking the job - four JOBRSNALL 2
Employment.JOBRSNALL5 All reasons for taking the job - five JOBRSNALL 2
Employment.JOBRSNALL6 All reasons for taking the job - six JOBRSNALL 2
Employment.JOBRSNALL7 All reasons for taking the job - seven JOBRSNALL 2
Employment.JOBRSNALL8 All reasons for taking the job - eight JOBRSNALL 2
Employment.JOBRSNALL9 All reasons for taking the job - nine JOBRSNALL 2
Employment.JOBRSNMAIN Main reason for taking the job JOBRSNMAIN 2
Employment.JOBSNO Number of jobs JOBSNO 1
Employment.JOBTITLE Job title JOBTITLE 60
Employment.MAKEDO Nature of employer's business MAKEDO 60
Employment.NHSORG NHS organisation NHSORG 1
Employment.POSTDOC Postdoctoral research contract POSTDOC 1
Employment.PREVEM Previously employed PREVEM 1
Employment.PREVWORK1 Category of previous employment - one PREVWORK 2
Employment.PREVWORK2 Category of previous employment - two PREVWORK 2
Employment.PREVWORK3 Category of previous employment - three PREVWORK 2
Employment.PREVWORK4 Category of previous employment - four PREVWORK 2
Employment.PREVWORK5 Category of previous employment - five PREVWORK 2
Employment.PREVWORK6 Category of previous employment - six PREVWORK 2
Employment.PREVWORK7 Category of previous employment - seven PREVWORK 2
Employment.QUALREQ Qualification required for job QUALREQ 2
Employment.SOCDLHE2010 Standard Occupational Classification 2010 SOCDLHE2010 5
Study.JACS1 JACS 3.0 subject of study JACS 4
Study.JACS2 JACS 3.0 subject of study JACS 4
Study.JACS3 JACS 3.0 subject of study JACS 4
Study.STUDYFUND How funding further study STUDYFUND 2
Study.SUBJECT Subject of study, training, or research SUBJECT 200
Study.TYPEQUAL Type of qualification TYPEQUAL 2
Study.UCNAME Name of university or college UCNAME 50
Study.UCPROV University or college providing study UCPROV 1
Teaching.EMPLDTEACH Employed as teacher EMPLDTEACH 1
Teaching.GTCSTIS GTC Scotland Teacher Induction scheme GTCSTIS 1
Teaching.SEEKTEACH Seeking a teaching post SEEKTEACH 1
Teaching.TEACHFUND Teaching funded TEACHFUND 1
Teaching.TEACHPHS Teaching phase TEACHPHS 1
XANNPAY01 Annual pay equivalent (DLHE) XANNPAY01 10
XEARND01 Total annual earnings XEARND01 7
XINSTID01 HESA institution identifier XINSTID01 4
XLOCGR01 Location of employment (region) XLOCGR01 4
XLOCN01 Location of employment (basic level) XLOCN01 1
XLOCUC01 Location of employment (country/unitary authority level) XLOCUC01 4
XPAIDEMP01 Paid employment marker XPAIDEMP01 1
XPROFEMP01 Professional/Non-professional employment marker XPROFEMP01 1
XPUBPOPD01 Publication population marker (DLHE) XPUBPOPD01 1
XSALMKR01 Publication salary marker (DLHE) XSALMKR01 1
XSOCD02 Standard Occupational Classification 2010 major grouping XSOCD02 1
XSOCD302 Standard Occupational Classification 2010 minor grouping XSOCD302 3
Age grouping at 31 July in reporting year XAGRPJ01 1
Domicile in Cyy051/Cyy054 coding frame (processing) XDOM01 2
Region of student domicile XDOMGR01 4
Region of student domicile - 4 way grouping XDOMGR401 1
Domicile (participation by nation) XDOMHM01 1
Analytical protocol JACS - level two XJACSLEV201_1 2
Analytical protocol JACS - level two XJACSLEV201_2 2
Analytical protocol JACS - level two XJACSLEV201_3 2
Level of study - 5 way split XLEV501 1
DLHE highest qualification obtained XOBTND01 3

Download: XML Schema for the CORE table file.

Note that the Cyy051/Cyy054.XJACSLEV201 derived field is from the Cyy051_SJ/Cyy054_SJ table. There will always be at least one entry per instance in the SJ table, but there can be up to 3. Hence the three occurrences of the field in this file.

1 These fields will only be populated where the course subject links to multiple JACS level subjects.

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