HESA Graduate Outcome record 2021/22
File structures for downloadable files - Survey results
Version 1.0 Produced 2023-08-09
The tables contain the following types of field:
- INSTANCEKEY, GRADUATEKEY and ILRKEY are unique keys within the database and are used to link records across tables
- Derived fields, prefixed with an X or Z, are standard ways of grouping data. View details of the derived field specifications.
- The ADDITIONALINFORMATION field may be used to capture row level supporting information to aid data users.
CORE table
Field name | Description | Field length |
GRADUATEKEY | Graduate key | 10 |
INSTANCEKEY | Instance key | 13 |
ILRKEY | ILR key | 25 |
ZEMPSICSOCKEY | Key for the employment activity to enable linking to the SIC / SOC table | 10 |
ZBUSSICSOCKEY | Key for the business employment activity to enable linking to the SIC / SOC table | 10 |
RECID | Record type indicator | 5 |
SID | Student identifier | 17 |
UKPRN | UK Provider reference number | 8 |
NUMHUS | Student instance identifier | 20 |
CENSUS | Census | 3 |
FEPUSID | FE Unique student identifier | 12 |
ACTCHECK | Activity check | 2 |
ALLACT01 | Activity - Paid work for an employer | 1 |
ALLACT02 | Activity - Self-employment/freelancing | 1 |
ALLACT03 | Activity - Running my own business | 1 |
ALLACT04 | Activity - Developing a creative, artistic or professional portfolio | 1 |
ALLACT05 | Activity - Voluntary/unpaid work for an employer | 1 |
ALLACT06 | Activity - Engaged in a course of study, training or research | 1 |
ALLACT07 | Activity - Taking time out to travel - this does not include short-term holidays | 1 |
ALLACT08 | Activity - Caring for someone (unpaid) | 1 |
ALLACT09 | Activity - Retired | 1 |
ALLACT10 | Activity - Unemployed and looking for work | 1 |
ALLACT11 | Activity - Doing something else | 1 |
HEPCON | Provider contact | 2 |
HOMECOUNTRY | Home country | 5 |
MIMPACT | Main activity | 2 |
EMPBASIS | Employment basis | 2 |
EMPCITY | Employer city | 100 |
EMPCOUNTRY | Employer country | 5 |
EMPCURRENCY | Salary currency | 3 |
EMPDUTIES | Employer duties | 750 |
EMPINTENSITY | Employment intensity | 2 |
EMPNAME | Employer name | 100 |
EMPPCODE | Employer postcode | 100 |
EMPPCODE_UNKNOWN | Employer postcode unknown | 1 |
EMPPLOC | Employer location | 2 |
EMPYEAR | Employment length | 4 |
JOBDUTIES | Job duties | 750 |
JOBRSNMAIN | Main reason for taking the job | 2 |
JOBTITLE | Job title | 100 |
MULTIJOB | Multiple jobs | 2 |
NHSORG | NHS organisation | 2 |
QUALREQ | Qualification required for the job | 2 |
SALARY | Salary annually | 10 |
BUSEMPCITY | Business, self-employment or portfolio employer city | 100 |
BUSEMPCOUNTRY | Business, self-employment or portfolio employer country | 5 |
BUSEMPDUTIES | Business, self-employment or portfolio employer duties | 750 |
BUSEMPINTENSITY | Business, self-employment or portfolio intensity | 2 |
BUSEMPNAME | Business, self-employment or portfolio employer name | 100 |
BUSEMPPCODE | Business, self-employment or portfolio employer postcode | 100 |
BUSEMPPCODE_UNKNOWN | Business, self-employment or portfolio employer postcode unknown | 1 |
BUSEMPPLOC | Business, self-employment or portfolio employer location | 2 |
BUSJOBDUTIES | Business, self-employment or portfolio job duties | 750 |
BUSJOBRSNMAIN | Business, self-employment or portfolio main reason for taking the job | 2 |
BUSJOBTITLE | Business, self-employment or portfolio job title | 100 |
STUCOUNTRY | Study country | 5 |
STUINTENSITY | Study intensity | 2 |
TYPEQUAL | Type of qualification | 2 |
UCNAME | University or college UKPRN | 8 |
FURSTU | Further study since graduating | 2 |
PREVCOURSENUM | Previous number of courses | 2 |
PREVINTENSITY1 | Previous course intensity 1 | 2 |
PREVINTENSITY2 | Previous course intensity 2 | 2 |
PREVINTENSITY3 | Previous course intensity 3 | 2 |
PREVTYPEQUAL1 | Previous type of qualification 1 | 2 |
PREVTYPEQUAL2 | Previous type of qualification 2 | 2 |
PREVTYPEQUAL3 | Previous type of qualification 3 | 2 |
PREVUCNAME1 | Previous university or college UKPRN 1 | 8 |
PREVUCNAME2 | Previous university or college UKPRN 2 | 8 |
PREVUCNAME3 | Previous university or college UKPRN 3 | 8 |
ACTMEAN | Activity meaningful | 2 |
ACTONTRACK | Activity on-track | 2 |
ACTSKILLS | Activity skills | 2 |
STUMEAN | Study meaningful | 2 |
STUONTRACK | Study on-track | 2 |
STUSKILLS | Study skills | 2 |
WRKMEAN | Work meaningful | 2 |
WRKONTRACK | Work on-track | 2 |
WRKSKILLS | Work skills | 2 |
XACTIVITY | Graduate Outcomes activity | 2 |
XWEIGHT01 | Weighting | 15 |
XACTMEAN | Activity is meaningful | 2 |
XACTONTRACK | Activity is on track | 2 |
XACTSKILLS | Activity utilises skills | 2 |
XBUS2007SIC | Self-employment - Standard Industrial Classification 2007 | 4 |
XBUS2007SIC1 | Self-employment - Standard Industrial Classification 2007 1 digit | 1 |
XBUS2007SIC2 | Self-employment - Standard Industrial Classification 2007 2 digit | 2 |
XBUS2020SOC | Self-employment - Standard Occupational Classification 2020 | 4 |
XBUS2020SOC1 | Self-employment - Standard Occupational Classification 2020 major grouping | 1 |
XBUS2020SOC3 | Self-employment - Standard Occupational Classification 2020 minor grouping | 3 |
XBUSCOMPFUND | Business funded | 2 |
XBUSLOCGR | Location of Self-employment (region) | 4 |
XBUSLOCN | Location of Self-employment (basic level) | 2 |
XBUSLOCUC | Location of Self-employment (county/unitary authority level) | 4 |
XBUSMARKER | Self-employment marker | 2 |
XEMP2007SIC | Employment - Standard Industrial Classification 2007 | 4 |
XEMP2007SIC1 | Employment - Standard Industrial Classification 2007 1 digit | 1 |
XEMP2007SIC2 | Employment - Standard Industrial Classification 2007 2 digit | 2 |
XEMP2020SOC | Employment - Standard Occupational Classification 2020 | 4 |
XEMP2020SOC1 | Employment - Standard Occupational Classification 2020 major grouping | 1 |
XEMP2020SOC3 | Employment - Standard Occupational Classification 2020 minor grouping | 3 |
XEMPLOCGR | Location of employment (region) | 4 |
XEMPLOCN | Location of employment (basic level) | 2 |
XEMPLOCUC | Location of employment (county/unitary authority level) | 4 |
XHOMELOCGR | Region of residence | 4 |
XHOMELOCN | Location of residence (basic level) | 2 |
XHOMELOCUC | Country of residence | 4 |
XINTSTUDY | Interim study | 2 |
XSTULOCGR | Region of study | 4 |
XSTULOCN | Location of study (basic level) | 2 |
XSTULOCUC | Country of study | 4 |
XWRK2007SIC | Employment - Standard Industrial Classification 2007 | 4 |
XWRK2007SIC1 | Employment - Standard Industrial Classification 2007 1 digit | 1 |
XWRK2007SIC2 | Employment - Standard Industrial Classification 2007 2 digit | 2 |
XWRK2020SOC | Employment - Standard Occupational Classification 2020 | 4 |
XWRK2020SOC1 | Employment - Standard Occupational Classification 2020 major grouping | 1 |
XWRK2020SOC3 | Employment - Standard Occupational Classification 2020 minor grouping | 3 |
XWRKHSKILL | Highly skilled work marker | 2 |
XWRKINTENSITY | Work mode | 2 |
XWRKJOBRSN | Main reason for taking job | 2 |
XWRKLOCGR | Location of work (region) | 4 |
XWRKLOCN | Location of work (basic level) | 2 |
XWRKLOCUC | Location of work (country/unitary authority) | 4 |
ZBUSAREA | Area of self-employment / own business | 4 |
ZBUSPCODE | Postcode of self-employment / own business | 8 |
ZEMPAREA | Area of employment | 4 |
ZEMPPCODE | Postcode of employment | 8 |
ZRESPSTATUS | Response status | 2 |
ADDITIONALINFORMATION | Additional information about the survey | 250 |
STARTMODE | Method by which survey was started | 1 |
COMPLETIONMODE | Method by which survey was completed | 1 |
CHECKSUM | The checksum is calculated by summing the ASCII values of all characters within the record that are within the ranges A-Z, a-z and 1-9. The field itself can be up to 6 digits in length. | 6 |
Note that STARTMODE / COMPLETEMODE will be populated with 'A' (Telephone contact) OR 'B' (Online)
OPTIN QUESTIONS table
Field name | Description | Field length |
GRADUATEKEY | Graduate key | 10 |
CAREERSERV | Career support | 2 |
COLLOUT | Collaborating with others outside HE research | 1 |
COLLSUBDIFF | Collaborating with others in different subject | 1 |
COMPDIFF | Completely different course | 1 |
CONDRSCH | Conduct research | 1 |
DIFFPROV | Different provider | 1 |
DIFFQUAL | Different qualification | 1 |
DIFFSUB | Different subject | 1 |
DISKNOW | General disciplinary knowledge | 1 |
EMPLDTEACH | Employed as a teacher | 2 |
GENSKILDEV | General skills developed | 1 |
GTCSTIS | GTC Scotland teacher induction scheme | 2 |
INTLMOB | International mobility | 1 |
JOBFOUND1 | Finding the job - Your university/college Careers service | 1 |
JOBFOUND2 | Finding the job - Employer's website | 1 |
JOBFOUND3 | Finding the job - Other university/college source (e.g. lecturer, website) | 1 |
JOBFOUND4 | Finding the job - Recruitment agency/website | 1 |
JOBFOUND5 | Finding the job - Media (e.g. newspaper/magazine advertisement) | 1 |
JOBFOUND6 | Finding the job - Speculative application | 1 |
JOBFOUND7 | Finding the job - Network, including family and friends | 1 |
JOBFOUND8 | Finding the job - Already worked there (including on an internship/placement/apprenticeship) | 1 |
JOBFOUND9 | Finding the job - Social media/professional networking sites | 1 |
JOBFOUND10 | Finding the job - Online job site | 1 |
JOBFOUND11 | Finding the job - Other | 1 |
KNOWBASE | Knowledge on which research degree based | 1 |
MRSCHDEG | Main reason for research degree | 2 |
OTHRRSCHDEG1 | Other reasons for research degree - Interested in subject | 1 |
OTHRRSCHDEG2 | Other reasons for research degree - Interested in research | 1 |
OTHRRSCHDEG3 | Other reasons for research degree - Wanted to continue being a student/postpone job hunting | 1 |
OTHRRSCHDEG4 | Other reasons for research degree - Awarded funded studentship | 1 |
OTHRRSCHDEG5 | Other reasons for research degree - Encouraged or required to do so by my employer | 1 |
OTHRRSCHDEG6 | Other reasons for research degree - Wanted an academic career | 1 |
OTHRRSCHDEG7 | Other reasons for research degree - It would improve my career prospects | 1 |
OTHRRSCHDEG8 | Other reasons for research degree - Essential to get into area of employment I wanted | 1 |
OTHRRSCHDEG9 | Other reasons for research degree - I wanted to change career | 1 |
OTHRRSCHDEG10 | Other reasons for research degree - Encouraged to do so by university (including lecturer, tutor) | 1 |
OTHRRSCHDEG11 | Other reasons for research degree - Other | 1 |
PLCINTSHP | Work placement(s) or internship(s) | 1 |
PROVSCORE | Provider score | 1000 |
RECPROV | Recommend the provider | 2 |
RSCHFIND | Research findings | 1 |
RSCHSKILDEV | Research skills developed | 1 |
SEEKTEACH | Seeking a teaching post | 2 |
TEACHFUND | State-funded or non-state-funded school or college | 2 |
TEACHPHS | Teaching phase | 2 |
WRKAUTO | Work autonomously | 1 |
WRKPART | Work as part of a team | 1 |
WRKSUPER | Work under supervision | 1 |
CHECKSUM | The checksum is calculated by summing the ASCII values of all characters within the record that are within the ranges A-Z, a-z and 1-9. The field itself can be up to 6 digits in length. | 6 |
SICSOC table
Field name | Description | Field length |
SICSOCKEY | Key for the employment, business employment, or main activity to enable linking to the core table | 10 |
ZSUPEMPNAME | Supplemental employer name | 80 |
ZSUPPCODE | Supplemental postcode | 8 |
ZCHREGNO | Companies House registration number | 8 |
ZSIC2007 | Standard industrial classification 2007 | 5 |
ZSOC2020 | Standard occupational classification 2020 | 4 |
ZNOEMPBAND | Number of employees banding | 1 |
CHECKSUM | The checksum is calculated by summing the ASCII values of all characters within the record that are within the ranges A-Z, a-z and 1-9. The field itself can be up to 6 digits in length. | 6 |
SUBJECTIVE WELLBEING AGGREGATE PROVIDER table
Field name | Description | Field length |
UKPRN | Provider | 8 |
XANXYESTGRP | Anxious yesterday | 1 |
XHAPYESTGRP | Happy yesterday | 1 |
XLIFEWORTHGRP | Life worthwhile | 1 |
XSATLIFEGRP | Life satisfaction | 1 |
TOTAL | Number of graduates | 10 |
CHECKSUM | The checksum is calculated by summing the ASCII values of all characters within the record that are within the ranges A-Z, a-z and 1-9. The field itself can be up to 6 digits in length. | 6 |
Data will be suppressed if fewer than 8 graduates have answered any one of the 4 questions.
Need help?
Contact Liaison by email or on +44 (0)1242 388 531.