Destinations of Leavers from Higher Education record 2014/15
Online DLHE file layout
Version 1.0 Produced 2015-03-26
The Online DLHE survey data can be downloaded from the Aardvark data collection system in fixed length, csv (comma separated) or XML format. In fixed length format, each field is left justified and padded out with spaces where necessary to the specified length.
| Question | Field name | Description | Element name in XML output | Field length |
| N/A | TIMESTMP | Timestamp (YYYY-MM-DD hh:mm:ss) | TIMESTMP | 19 |
| N/A | Student.RECID | Record type indicator | RECID | 5 |
| N/A | Student.UKPRN | UK Provider Reference Number | UKPRN | 8 |
| N/A | PIN | PIN number 5 | PIN | 10 |
| N/A | OWNSTU | Provider's own identifier for student 6 | OWNSTU | 20 |
| N/A | Student.STATUS | Status of data collection 1 | STATUS | 2 |
| N/A | INCOMPLETE_SURVEY | Incomplete survey flag (A, B, C, D, E or F) 2 | INCOMPLETE_SURVEY | 1 |
| N/A | FNAMES | Forenames 5 | FNAMES | 100 |
| N/A | SURNAME | Surname 5 | SURNAME | 100 |
| N/A | ADDRESS1 | Address Line 1 5 | ADDRESS1 | 50 |
| N/A | ADDRESS2 | Address Line 2 5 | ADDRESS2 | 50 |
| N/A | ADDRESS3 | Address Line 3 5 | ADDRESS3 | 50 |
| N/A | TOWNCITY | Town or City 5 | TOWNCITY | 50 |
| N/A | COUNTY | County, Region or State 5 | COUNTY | 50 |
| N/A | POSTCODE | Postal or Zip Code 5 | POSTCODE | 8 |
| N/A | COUNTRY | Country 5 | COUNTRY | 50 |
| N/A | TELEPHONE | Telephone 5 | TELEPHONE | 30 |
| N/A | EMAIL_ID | Email address 5 | EMAIL_ID | 80 |
| N/A | COURSE_STUDIED | Title of course studied 5 | COURSE_STUDIED | 255 |
| Q1 | Student.ALLACT1 3 | All activities | ALLACT 4 | 1 |
| Q1 | Student.ALLACT2 3 | All activities | ALLACT 4 | 1 |
| Q1 | Student.ALLACT4 3 | All activities | ALLACT 4 | 1 |
| Q1 | Student.ALLACT5 3 | All activities | ALLACT 4 | 1 |
| Q1 | Student.ALLACT6 3 | All activities | ALLACT 4 | 1 |
| Q1 | Student.ALLACT7 3 | All activities | ALLACT 4 | 1 |
| Q1 | Student.ALLACT8 3 | All activities | ALLACT 4 | 1 |
| Q1 | Student.ALLACT9 3 | All activities | ALLACT 4 | 1 |
| Q1 | Student.MIMPACT | Most important activity | MIMPACT | 1 |
| Q2 | Employment.JOBSNO | Number of jobs | JOBSNO | 1 |
| Q3 | Employment.JOBTITLE | Job title | JOBTITLE | 60 |
| Q4 | Employment.JOBDUTIES | Job duties | JOBDUTIES | 200 |
| Q5 | Employment.EMPBASIS | Employment basis | EMPBASIS | 2 |
| Q6 | Employment.EMPPAY | Pay | EMPPAY | 10 |
| Q6 | Employment.EMPUNPAID | Unpaid work | EMPUNPAID | 1 |
| Q7 | Employment.EMPPAYPERIOD | Payment period | EMPPAYPERIOD | 1 |
| Q8 | Employment.EMPCURRENCY | Currency of pay | EMPCURRENCY | 1 |
| Q9 | Employment.EMPHOURS | Hours worked per week | EMPHOURS | 5 |
| Q10 | Employment.ESTEARN | Total estimated earnings for a year | ESTEARN | 7 |
| Q11 | Employment.EMPNAME | Employer name | EMPNAME | 60 |
| Q12 | Employment.MAKEDO | Nature of employer's business | MAKEDO | 60 |
| Q13 | Employment.EMPPLACE | Place of employment | EMPPLACE | 200 |
| Q13 | Employment.EMPPCODE | UK Postcode for place of employment | EMPPCODE | 8 |
| Q13 | Employment.EMPCOUNTRY | Country of employment | EMPCOUNTRY | 2 |
| Q14 | Employment.QUALREQ | Qualification required for job | QUALREQ | 2 |
| Q15 | Employment.EMPIMP | Importance to employer | EMPIMP | 1 |
| Q16 | Employment.JOBRSNALL1 3 | All reasons for taking the job | JOBRSNALL 4 | 2 |
| Q16 | Employment.JOBRSNALL2 3 | All reasons for taking the job | JOBRSNALL 4 | 2 |
| Q16 | Employment.JOBRSNALL3 3 | All reasons for taking the job | JOBRSNALL 4 | 2 |
| Q16 | Employment.JOBRSNALL4 3 | All reasons for taking the job | JOBRSNALL 4 | 2 |
| Q16 | Employment.JOBRSNALL5 3 | All reasons for taking the job | JOBRSNALL 4 | 2 |
| Q16 | Employment.JOBRSNALL6 3 | All reasons for taking the job | JOBRSNALL 4 | 2 |
| Q16 | Employment.JOBRSNALL7 3 | All reasons for taking the job | JOBRSNALL 4 | 2 |
| Q16 | Employment.JOBRSNALL8 3 | All reasons for taking the job | JOBRSNALL 4 | 2 |
| Q16 | Employment.JOBRSNALL9 3 | All reasons for taking the job | JOBRSNALL 4 | 2 |
| Q16 | Employment.JOBRSNMAIN | Main reason for taking the job | JOBRSNMAIN | 2 |
| Q17 | Employment.JOBFOUND | How found job | JOBFOUND | 2 |
| Q18 | Employment.PREVEM | Previous employed | PREVEM | 1 |
| Q19 | Employment.PREVWORK1 3 | Category of previous employment | PREVWORK 4 | 2 |
| Q19 | Employment.PREVWORK2 3 | Category of previous employment | PREVWORK 4 | 2 |
| Q19 | Employment.PREVWORK3 3 | Category of previous employment | PREVWORK 4 | 2 |
| Q19 | Employment.PREVWORK4 3 | Category of previous employment | PREVWORK 4 | 2 |
| Q19 | Employment.PREVWORK5 3 | Category of previous employment | PREVWORK 4 | 2 |
| Q19 | Employment.PREVWORK6 3 | Category of previous employment | PREVWORK 4 | 2 |
| Q19 | Employment.PREVWORK7 3 | Category of previous employment | PREVWORK 4 | 2 |
| N/A | NONQTS | No Newly Qualified Teacher Status | NONQTS 7 | 1 |
| Q20 | Teaching.EMPLDTEACH | Employed as a teacher | EMPLDTEACH | 1 |
| Q21 | Teaching.GTCSTIS | GTC Scotland Teacher Induction Scheme | GTCSTIS | 1 |
| Q22 | Teaching.TEACHFUND | Teaching funded | TEACHFUND | 1 |
| Q23 | Teaching.TEACHPHS | Teaching phase | TEACHPHS | 1 |
| Q24 | Teaching.SEEKTEACH | Seeking a teaching post | SEEKTEACH | 1 |
| Q25 | Study.TYPEQUAL | Type of qualification | TYPEQUAL | 2 |
| Q26 | Study.COURSENAME | Course name | COURSENAME | 200 |
| Q27 | Study.SUBJECT | Subject of study | SUBJECT | 200 |
| Q28 | Study.UCNAME | Name of university or college | UCNAME | 50 |
| Q29 | Study.STUDYFUND | How funding further study | STUDYFUND | 2 |
| Q30 | Student.HEWORKEXP | Higher education experience for work | HEWORKEXP | 1 |
| Q31 | Student.HESTUDYEXP | Higher education experience for study | HESTUDYEXP | 1 |
| Q32 | Student.HEBUSNEXP | Higher education experience for business | HEBUSNEXP | 1 |
| N/A | Student.OPTOUT | Opt out from communications (1=Opted out) | OPTOUT | 1 |
| N/A | Student.APRJAN | April or January survey (1=April, 2=January) | APRJAN | 1 |
1 Where the survey is complete STATUS=04, where the survey is incomplete STATUS=XX.
2 The INCOMPLETE_SURVEY data item shows which section the HE leaver was working on when they decided not to proceed with the rest of the survey (and where STATUS=XX). If they complete the survey (STATUS=04), this data item will be left blank e.g. where the HE leaver completes up to question 4 of the survey INCOMPLETE_SURVEY = B will be output.
3 Where data items have multiple occurrences in the CSV and fixed-length download files because more than one option can be selected from a list, the number at the end of the field name relates to the position of the option in the questionnaire. If the question has been answered, the value populated for each occurrence will be the option selected as defined in the coding manual for that question e.g. ALLACT9 would have a value of 9 to indicate 'Unemployed' was ticked. If an answer was not ticked, it will be left blank in the CSV and fixed length files.
4 Where data items have multiple occurrences in the XML download because more than one option can be selected from a list, the data item will be repeated depending on the number of options selected. The value in each occurrence of the field will be for the option selected for that question as defined in the manual. If the question has not been answered, the element will not be present in the XML file.
5 If the HE leaver's own student identifier has been included in the URL for the survey then they will skip straight to Section A so this field will not exist in the XML output and will be left blank in CSV and fixed length files.
6 OWNSTU will be populated automatically in all downloads for leavers where their own student identifier has been included in the URL for the survey.
Note: With the exception of questions 30 to 32, data items with no answer will be left blank in the CSV and fixed-length files but will not exist in the XML download. For the higher education experience questions the data items will be coded 6 (unable to code) where the question is not answered.
7 For the higher education providers (HEPs) information NONQTS will record the outcome of the checkbox at the beginning of section C.
The XML schema for the Online DLHE data can be downloaded below:
- Schema for the XML format of the Online DLHE data file.
Need help?
Contact Liaison by email or on +44 (0)1242 388 531.