Skip to main content

Destinations of Leavers from Higher Education record 2016/17

Back to C16018

SIC data supply

Version 1.0 Produced 2018-02-01

The Data supply - SIC table is supplied in CSV and XML formats.

The tables contain the following types of field:

  • Cyy051/Cyy054.InstanceKEY is a unique key for every student instance within the database used to link records across tables.
  • Base fields from the C16018 submission prefixed with the appropriate entity; Student or Employment.
  • Where a field is from the Student or AP record it will be prefixed with Cyy051/Cyy054 accordingly.
  • Derived fields, prefixed with an X, are standard ways of grouping data. View details of the derived field specifications.
  • Third party supplied fields are denoted by the prefix 'Z'. Specification for these fields can be download from the derived field specifications page under the SIC coding section.

File structure of the report

Field name Description Element name in XML output Field length
Student.HUSID HESA unique student identifier HUSID 13
Student instance identifier NUMHUS 20
Student.APRJAN April or January survey APRJAN 1
Unique key for every student instance INSTANCEKEY 13
Provider's own identifier for student OWNSTU 20
Provider's own instance identifier OWNINST 30
XPDLHE02 DLHE population for expanded coverage XPDLHE02 1
Employment.EMPCOUNTRY Country of employment EMPCOUNTRY 2
Employment.EMPPLACE Place of employment EMPPLACE 200
Employment.EMPPCODE UK Postcode for place of employment EMPPCODE 8
Employment.EMPNAME Employer name EMPNAME 60
Employment.MAKEDO Nature of employer's business MAKEDO 60
ZORGTYPE Organisation type ZORGTYPE 2
ZNOEMPBAND Number of employees banding ZNOEMPBAND 2
XSICD02 Standard Industrial Classification (SIC 2007) grouping XSICD02 1
XSIC202 Standard Industrial Classification (SIC 2007) code (first two characters) XSIC202 2
ZSIC2007 Oblong supplied Standard Industrial Classification (SIC 2007) code ZSIC2007 4
SIC2007 Code Label Description of supplied Standard Industrial Classification (SIC 2007) code ZSIC2007_DESCRIPTION 150

Download: XML Schema for the SIC table file.

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