Destinations of Leavers from Higher Education record 2016/17
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 |
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 +44 (0)1242 388 531.