Skip to main content

Destinations of Leavers from Higher Education record 2011/12

Back to C11018

SIC data supply

Version 1.1 Produced 2013-06-06

The SIC data supply table is supplied in CVS and XML formats.

The tables contain the following types of field:

  • Cyy051.INSTANCEKEY which is a unique key within the database used to link records across tables.
  • Base fields from the C11018 submission prefixed with the appropriate entity; Student or Employment.
  • Where a field is from the Student record it will be prefixed with Cyy051.
  • 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'.

Jump directly to the valid entries and labels of third party supplied fields:

File structure of the report

Field name Description Element name in XML output Field length
Student.HUSID HESA unique student identifier HUSID 13
Cyy051.Instance.NUMHUS Student instance identifier NUMHUS 20
Student.APRJAN April or January survey APRJAN 1
Cyy051.INSTANCEKEY Unique key for every student instance INSTANCEKEY 13
Cyy051.Student.OWNSTU Institution's own identifier for student OWNSTU 20
Cyy051.Instance.OWNINST Institution'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
SIC2007 Oblong supplied Standard Industrial Classification (SIC 2007) code ZSIC2007 5
SIC2007 Code Label Description of supplied Standard Industrial Classification (SIC 2007) code SIC2007_DESCRIPTION 150

Download: XML Schema for SIC table file. Sample XML for SIC table file.

Third party supplied fields - valid entries and labels

ZORGTYPE valid entries and labels

01 Public sector organisation
02 Private sector organisation
03 Charity

ZNOEMPBAND valid entries and labels

A 1 to 5
B 6 to 10
C 11 to 25
D 26 to 50
E 51 to 100
F 101 to 200
G 201 to 500
H Over 500

SIC2007 valid entries and labels

The SIC 2007 valid entries and labels are based on the UK Standard Industrial Classification 2007 (UK SIC 2007) four digit class and five digit subclass levels as identified in the Office for National Statistics (ONS) UK Standard Industrial Classification 2007 web page 'Main volume' (PDF).

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