Skip to main content

HESA Graduate Outcome record 2018/19

Back to C18072

File structures for downloadable files - Survey results

Version 1.2 Produced 2021-04-22

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
GRADUATEKEYGraduate key10
INSTANCEKEYInstance key13
ILRKEYILR key25
ZEMPSICSOCKEYKey for the employment activity to enable linking to the SIC / SOC table10
ZBUSSICSOCKEYKey for the business employment activity to enable linking to the SIC / SOC table10
RECIDRecord type indicator5
HUSIDHESA unique student identifier13
UKPRNUK Provider reference number8
NUMHUSStudent instance identifier20
CENSUSCensus3
FEPUSIDFE Unique student identifier12
ACTCHECKActivity check2
ALLACT01Activity - Paid work for an employer1
ALLACT02Activity - Self-employment/freelancing1
ALLACT03Activity - Running my own business1
ALLACT04Activity - Developing a creative, artistic or professional portfolio1
ALLACT05Activity - Voluntary/unpaid work for an employer1
ALLACT06Activity - Engaged in a course of study, training or research1
ALLACT07Activity - Taking time out to travel - this does not include short-term holidays1
ALLACT08Activity - Caring for someone (unpaid)1
ALLACT09Activity - Retired1
ALLACT10Activity - Unemployed and looking for work1
ALLACT11Activity - Doing something else1
CONSTART01Contract start - Contracted to start a job in the next month1
CONSTART02Contract start - Due to start studying in the next month1
CONSTART03Contract start - No1
HEPCONProvider contact2
HOMECOUNTRYHome country5
HOMECOUNTRY_OTHERHome country other250
MIMPACTMain activity2
EMPBASISEmployment basis2
EMPCITYEmployer city500
EMPCOUNTRYEmployer country5
EMPCOUNTRY_OTHEREmployer country other250
EMPCURRENCYSalary currency3
EMPCURRENCY_OTHERSalary currency other100
EMPDUTIESEmployer duties8000
EMPINTENSITYEmployment intensity2
EMPMONTHMonths worked2
EMPNAMEEmployer name1000
EMPPCODEEmployer postcode100
EMPPCODE_UNKNOWNEmployer postcode unknown1
EMPPLOCEmployer location2
EMPYEAREmployment length2
FIRSTJOBFirst job since graduating2
JOBDUTIESJob duties8000
JOBRSNALL1Reason for taking the job - It fitted into my career plan/it was exactly the type of work I wanted1
JOBRSNALL2Reason for taking the job - It was the best job offer I received1
JOBRSNALL3Reason for taking the job - It was an opportunity to progress in the organisation1
JOBRSNALL4Reason for taking the job - To see if I would like the type of work it involved1
JOBRSNALL5Reason for taking the job - To gain and broaden my experience in order to get the type of job I really want1
JOBRSNALL6Reason for taking the job - It was the right location1
JOBRSNALL7Reason for taking the job - The job was well paid1
JOBRSNALL8Reason for taking the job - In order to earn a living1
JOBRSNALL9Reason for taking the job - In order to pay off debts1
JOBRSNALL10Reason for taking the job - To work in my family business1
JOBRSNMAINMain reason for taking the job2
JOBTITLEJob title4000
MULTIJOBMultiple jobs2
NHSORGNHS organisation2
QUALREQQualification required for the job2
SALARYSalary annually20
SUPERVISESupervising responsibility2
YEARWORKYears worked2
BUSCOMPFUND1Business, self-employment or portfolio company funding - Self/family1
BUSCOMPFUND2Business, self-employment or portfolio company funding - Crowdfunding1
BUSCOMPFUND3Business, self-employment or portfolio company funding - Loan1
BUSCOMPFUND4Business, self-employment or portfolio company funding - Venture Capital1
BUSCOMPFUND5Business, self-employment or portfolio company funding - University business incubation1
BUSCOMPFUND6Business, self-employment or portfolio company funding - Other1
BUSEMPCITYBusiness, self-employment or portfolio employer city500
BUSEMPCOUNTRYBusiness, self-employment or portfolio employer country5
BUSEMPCOUNTRY_OTHERBusiness, self-employment or portfolio employer country other250
BUSEMPDUTIESBusiness, self-employment or portfolio employer duties4000
BUSEMPINTENSITYBusiness, self-employment or portfolio intensity2
BUSEMPNAMEBusiness, self-employment or portfolio employer name1000
BUSEMPPCODEBusiness, self-employment or portfolio employer postcode100
BUSEMPPCODE_UNKNOWNBusiness, self-employment or portfolio employer postcode unknown1
BUSEMPPLOCBusiness, self-employment or portfolio employer location2
BUSJOBDUTIESBusiness, self-employment or portfolio job duties4000
BUSJOBRSNALL1Business, self-employment or portfolio reason for taking the job - It fitted into my career plan/it was exactly the type of work I wanted1
BUSJOBRSNALL2Business, self-employment or portfolio reason for taking the job - It was the best job offer I received1
BUSJOBRSNALL3Business, self-employment or portfolio reason for taking the job - It was an opportunity to progress in the organisation1
BUSJOBRSNALL4Business, self-employment or portfolio reason for taking the job - To see if I would like the type of work it involved1
BUSJOBRSNALL5Business, self-employment or portfolio reason for taking the job - To gain and broaden my experience in order to get the type of job I really want1
BUSJOBRSNALL6Business, self-employment or portfolio reason for taking the job - It was the right location1
BUSJOBRSNALL7Business, self-employment or portfolio reason for taking the job - The job was well paid1
BUSJOBRSNALL8Business, self-employment or portfolio reason for taking the job - In order to earn a living1
BUSJOBRSNALL9Business, self-employment or portfolio reason for taking the job - In order to pay off debts1
BUSJOBRSNALL10Business, self-employment or portfolio reason for taking the job - To work in my family business1
BUSJOBRSNMAINBusiness, self-employment or portfolio main reason for taking the job2
BUSJOBTITLEBusiness, self-employment or portfolio job title1000
BUSOWNEMPBusiness, self-employment or portfolio employees2
BUSSUPERVISEBusiness, self-employment or portfolio supervising responsibility2
STUCOUNTRYStudy country5
STUCOUNTRY_OTHERStudy country other500
STUINTENSITYStudy intensity2
TYPEQUALType of qualification2
UCNAMEUniversity or college UKPRN8
UCNAME_OTHERUniversity or college name other500
FTPREVEMPFull-time or part-time previous employment2
PREVJOBNUMPrevious number of jobs3
FURSTUFurther study since graduating2
PREVCOURSENUMPrevious number of courses3
PREVINTENSITY1Previous course intensity 12
PREVINTENSITY2Previous course intensity 22
PREVINTENSITY3Previous course intensity 32
PREVTYPEQUAL1Previous type of qualification 12
PREVTYPEQUAL2Previous type of qualification 22
PREVTYPEQUAL3Previous type of qualification 32
PREVUCNAME1Previous university or college UKPRN 18
PREVUCNAME2Previous university or college UKPRN 28
PREVUCNAME3Previous university or college UKPRN 38
PREVUCNAME_OTHER1Previous university or college name other 1500
PREVUCNAME_OTHER2Previous university or college name other 2500
PREVUCNAME_OTHER3Previous university or college name other 3500
ACTMEANActivity meaningful2
ACTONTRACKActivity on-track2
ACTSKILLSActivity skills2
STUMEANStudy meaningful2
STUONTRACKStudy on-track2
STUSKILLSStudy skills2
WRKMEANWork meaningful2
WRKONTRACKWork on-track2
WRKSKILLSWork skills2
XACTIVITYGraduate Outcomes activity2
XWEIGHT01Weighting15
XACTMEANActivity is meaningful2
XACTONTRACKActivity is on track2
XACTSKILLSActivity utilises skills2
XBUS2007SICSelf-employment - Standard Industrial Classification 20074
XBUS2007SIC1Self-employment - Standard Industrial Classification 2007 1 digit1
XBUS2007SIC2Self-employment - Standard Industrial Classification 2007 2 digit2
XBUS2020SOCSelf-employment - Standard Occupational Classification 20204
XBUS2020SOC1Self-employment - Standard Occupational Classification 2020 major grouping1
XBUS2020SOC3Self-employment - Standard Occupational Classification 2020 minor grouping3
XBUSCOMPFUNDBusiness funded2
XBUSLOCGRLocation of Self-employment (region)4
XBUSLOCNLocation of Self-employment (basic level)2
XBUSLOCUCLocation of Self-employment (county/unitary authority level)4
XBUSMARKERSelf-employment marker2
XCURRLOCLocation based on currency returned1
XEMP2007SICEmployment - Standard Industrial Classification 20074
XEMP2007SIC1Employment - Standard Industrial Classification 2007 1 digit1
XEMP2007SIC2Employment - Standard Industrial Classification 2007 2 digit2
XEMP2020SOCEmployment - Standard Occupational Classification 20204
XEMP2020SOC1Employment - Standard Occupational Classification 2020 major grouping1
XEMP2020SOC3Employment - Standard Occupational Classification 2020 minor grouping3
XEMPLOCGRLocation of employment (region)4
XEMPLOCNLocation of employment (basic level)2
XEMPLOCUCLocation of employment (county/unitary authority level)4
XHOMELOCGRRegion of residence4
XHOMELOCNLocation of residence (basic level)2
XHOMELOCUCCountry of residence4
XINTSTUDYInterim study2
XSTULOCGRRegion of study4
XSTULOCNLocation of study (basic level)2
XSTULOCUCCountry of study4
XWRK2007SICWork - Standard Industrial Classification 20074
XWRK2007SIC1Work - Standard Industrial Classification 2007 1 digit1
XWRK2007SIC2Work - Standard Industrial Classification 2007 2 digit2
XWRK2020SOCWork - Standard Occupational Classification 20204
XWRK2020SOC1Work - Standard Occupational Classification 2020 major grouping1
XWRK2020SOC3Work - Standard Occupational Classification 2020 minor grouping3
XWRKHSKILLHighly skilled work marker2
XWRKINTENSITYWork mode2
XWRKJOBRSNMain reason for taking job2
XWRKLOCGRLocation of work (region)4
XWRKLOCNLocation of work (basic level)2
XWRKLOCUCLocation of work (country/unitary authority)4
ZBUSAREAArea of self-employment / own business4
ZBUSCOUNTRYCountry of self-employment / own business4
ZBUSPCODEPostcode of self-employment / own business8
ZCURRENCYSalary currency3
ZEMPAREAArea of employment4
ZEMPCOUNTRYCountry of employment4
ZEMPPCODEPostcode of employment8
ZHOMECOUNTRYHome country4
ZRESPSTATUSResponse status2
ZSTUCOUNTRYCountry of Provider of further study4
ZSTUPROVUKPRN of Provider of further study8
ADDITIONALINFORMATIONAdditional information about the survey250
CHECKSUMThe 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

OPTIN QUESTIONS table

Field name Description Field length
GRADUATEKEYGraduate key10
CAREERSERVCareer support2
COLLOUTCollaborating with others outside HE research1
COLLSUBDIFFCollaborating with others in different subject1
COLLSUBSAMECollaborating with others in same subject1
COMPDIFFCompletely different course1
CONDRSCHConduct research1
DIFFPROVDifferent provider1
DIFFQUALDifferent qualification1
DIFFSUBDifferent subject1
DISKNOWGeneral disciplinary knowledge1
EMPLDTEACHEmployed as a teacher2
GENSKILDEVGeneral skills developed1
GTCSTISGTC Scotland teacher induction scheme2
INTLMOBInternational mobility1
JOBFOUND1Finding the job - Your university/college Careers service1
JOBFOUND2Finding the job - Employer's website1
JOBFOUND3Finding the job - Other university/college source (e.g. lecturer, website)1
JOBFOUND4Finding the job - Recruitment agency/website1
JOBFOUND5Finding the job - Media (e.g. newspaper/magazine advertisement)1
JOBFOUND6Finding the job - Speculative application1
JOBFOUND7Finding the job - Network, including family and friends1
JOBFOUND8Finding the job - Already worked there (including on an internship/placement/apprenticeship)1
JOBFOUND9Finding the job - Social media/professional networking sites1
JOBFOUND10Finding the job - Online job site1
JOBFOUND11Finding the job - Other1
KNOWBASEKnowledge on which research degree based1
KNOWSKILDEVDevelopment of knowledge and skills1
MRSCHDEGMain reason for research degree2
OTHRRSCHDEG1Other reasons for research degree - Interested in subject1
OTHRRSCHDEG2Other reasons for research degree - Interested in research1
OTHRRSCHDEG3Other reasons for research degree - Wanted to continue being a student/postpone job hunting1
OTHRRSCHDEG4Other reasons for research degree - Awarded funded studentship1
OTHRRSCHDEG5Other reasons for research degree - Encouraged or required to do so by my employer1
OTHRRSCHDEG6Other reasons for research degree - Wanted an academic career1
OTHRRSCHDEG7Other reasons for research degree - It would improve my career prospects1
OTHRRSCHDEG8Other reasons for research degree - Essential to get into area of employment I wanted1
OTHRRSCHDEG9Other reasons for research degree - I wanted to change career1
OTHRRSCHDEG10Other reasons for research degree - Encouraged to do so by university (including lecturer, tutor)1
OTHRRSCHDEG11Other reasons for research degree - Other1
PLCINTSHPWork placement(s) or internship(s)1
PROVSCOREProvider score8000
RECPROVRecommend the provider2
RSCHFINDResearch findings1
RSCHSKILDEVResearch skills developed1
SEEKTEACHSeeking a teaching post2
TEACHFUNDState-funded or non-state-funded school or college2
TEACHPHSTeaching phase2
WRKAUTOWork autonomously1
WRKOWNWorking on your own1
WRKPARTWork as part of a team1
WRKSUPERWork under supervision1
CHECKSUMThe 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
SICSOCKEYKey for the employment, business employment, or main activity to enable linking to the core table10
ZSUPEMPNAMESupplemental employer name80
ZSUPPCODESupplemental postcode8
ZCHREGNOCompanies House registration number8
ZSIC2007Standard industrial classification 20075
ZSOC2020Standard occupational classification 20204
ZNOEMPBANDNumber of employees banding1
CHECKSUMThe 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
UKPRNProvider8
XANXYESTGRPAnxious yesterday1
XHAPYESTGRPHappy yesterday1
XLIFEWORTHGRPLife worthwhile1
XSATLIFEGRPLife satisfaction1
TOTALNumber of graduates10
CHECKSUMThe 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.