Online DLHE File layout

Version 1.2 Produced 2012-10-01

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 Institution's own student identifier 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 ALLACT4 1
Q1 Student.ALLACT2 3 All activities ALLACT4 1
Q1 Student.ALLACT3 3 All activities ALLACT4 1
Q1 Student.ALLACT4 3 All activities ALLACT4 1
Q1 Student.ALLACT5 3 All activities ALLACT4 1
Q1 Student.ALLACT6 3 All activities ALLACT4 1
Q1 Student.ALLACT7 3 All activities ALLACT4 1
Q1 Student.ALLACT8 3 All activities ALLACT4 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.SALARY Salary SALARY 7
Q6 Employment.EMPUNPAID Unpaid work EMPUNPAID 1
Q7 Employment.PTHOURS Part-Time hours per week PTHOURS 5
Q8 Employment.ESTEARN Total estimated earnings for a year ESTEARN 7
Q9 Employment.EMPNAME Employer name EMPNAME 60
Q10 Employment.MAKEDO Nature of employer's business MAKEDO 60
Q11 Employment.EMPPLACE Place of employment EMPPLACE 200
Q11 Employment.EMPPCODE UK Postcode for place of employment EMPPCODE 8
Q11 Employment.EMPCOUNTRY Country of employment EMPCOUNTRY 2
Q12 Employment.QUALREQ Qualification required for job QUALREQ 2
Q13 Employment.EMPIMP Importance to employer EMPIMP 1
Q14 Employment.JOBRSNALL13 All reasons for taking the job JOBRSNALL4 2
Q14 Employment.JOBRSNALL2 3 All reasons for taking the job JOBRSNALL4 2
Q14 Employment.JOBRSNALL3 3 All reasons for taking the job JOBRSNALL4 2
Q14 Employment.JOBRSNALL4 3 All reasons for taking the job JOBRSNALL4 2
Q14 Employment.JOBRSNALL5 3 All reasons for taking the job JOBRSNALL4 2
Q14 Employment.JOBRSNALL6 3 All reasons for taking the job JOBRSNALL4 2
Q14 Employment.JOBRSNALL7 3 All reasons for taking the job JOBRSNALL4 2
Q14 Employment.JOBRSNALL8 3 All reasons for taking the job JOBRSNALL4 2
Q14 Employment.JOBRSNALL9 3 All reasons for taking the job JOBRSNALL4 2
Q14 Employment.JOBRSNMAIN Main reason for taking the job JOBRSNMAIN 2
Q15 Employment.JOBFOUND How found job JOBFOUND 2
Q16 Employment.PREVEMP Previous employed PREVEMP 1
Q17 Employment.PREVWORK1 3 Category of previous employment PREVWORK4 2
Q17 Employment.PREVWORK2 3 Category of previous employment PREVWORK4 2
Q17 Employment.PREVWORK3 3 Category of previous employment PREVWORK4 2
Q17 Employment.PREVWORK4 3 Category of previous employment PREVWORK4 2
Q17 Employment.PREVWORK5 3 Category of previous employment PREVWORK4 2
Q17 Employment.PREVWORK6 3 Category of previous employment PREVWORK4 2
Q17 Employment.PREVWORK7 3 Category of previous employment PREVWORK4 2
Q18 Teaching.EMPLDTEACH Employed as a teacher EMPLDTEACH 1
Q19 Teaching.GTCSTIS GTC Scotland Teacher Induction Scheme GTCSTIS 1
Q20 Teaching.TEACHFUND Teaching funded TEACHFUND 1
Q21 Teaching.TEACHPHS Teaching phase TEACHPHS 1
Q22 Teaching.SEEKTEACH Seeking a teaching post SEEKTEACH 1
Q23 Study.COURSENO Number of courses COURSENO 1
Q24 Study.TYPEQUAL Type of qualification TYPEQUAL 2
Q25 Study.COURSENAME Course name COURSENAME 200
Q26 Study.SUBJECT Subject of study SUBJECT 200
Q27 Study.UCNAME Name of university or college UCNAME 50
Q28 Study.STUDYFUND How funding further study STUDYFUND 2
Q29 Student.HEWORKEXP Higher education experience for work HEWORKEXP 1
Q30 Student.HESTUDYEXP Higher education experience for study HESTUDYEXP 1
Q31 Student.HEBUSNEXP Higher education experience for business HEBUSNEXP 1
n/a
 FOLLOWUP Include in follow-up survey? (1=No, 0=Yes) FOLLOWUP 1

1 Where survey is complete STATUS=04, where survey is incomplete STATUS=XX

2 The INCOMPLETE_SURVEY field shows which section the 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 field will be left blank e.g. where the leaver completes up to question 4 of the survey INCOMPLETE_SURVEY = B will be output.

3 Where fields 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 manual for that question e.g. ALLACT3 would have a value of 3 to indicate 'Unemployed and looking for work' was ticked. If an answer was not ticked, it will be left blank in the CSV and fixed length files.

4 Where fields have multiple occurrences in the XML download because more than one option can be selected from a list, the field 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 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 29 to 31, fields 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 fields will be coded 6 (unable to code) where the question is not answered.

To assist with XML familiarisation and validation, the XML schema and sample Online DLHE data can be downloaded below: