Skip to main content

Destinations of Leavers from Higher Education record 2015/16

Back to C15018

SIC data supply


Version 1.0 Produced 2017-03-02

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 C15018 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
Cyy051.NUMHUS
Cyy054.NUMHUS
Student instance identifier NUMHUS 20
Student.APRJAN April or January survey APRJAN 1
Cyy051.INSTANCEKEY
Cyy054.INSTANCEKEY
Unique key for every student instance INSTANCEKEY 13
Cyy051.OWNSTU
Cyy054.OWNSTU
Provider's own identifier for student OWNSTU 20
Cyy051.OWNINST
Cyy054.OWNINST
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
ZCHARFLAG Charity flag ZCHARFLAG 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 01242 211144.