Skip to main content

Student Alternative record 2019/20

Back to C19054

File structures for downloadable files - Data supply

Version 1.0 Produced 2020-06-26

Five data tables are supplied in CSV and XML format. The CORE table contains the majority of fields. Separately provided are the SUBJECT table, an INSTANCE PERIOD table, and a COURSE table.

Also provided is a QUALIFICATIONS ON ENTRY Register which details the qualifications on entry data returned for each instance.

The tables contain the following types of field:

  • Instance.InstanceKEY which is a unique key within the database and is used to link records across tables
  • Base fields from the C19054 submission prefixed with the appropriate entity
  • EP_USE fields are the entry profile fields collected for new entrants and which may be updated in subsequent years, if data submitted originally is found to be incorrect.
  • Derived fields, prefixed with an X or Z, are standard ways of grouping data. View details of the derived field specifications.
  • QOE fields are the Qualification On Entry Register fields collected for new entrants, and which may be updated in subsequent years if the data submitted originally is found to be incorrect.

The field names for each table are given in the first line of each downloadable file ready for use in creating pivot tables. The HESA website provides guidance on creating and using pivot tables.

CORE table

Field name Description Element name in XML output Field length
Instance.InstanceKEYUnique key for every student instanceInstanceKEY13
Provider.UKPRNUK Provider Reference NumberUKPRN8
Student.HUSIDHESA unique student identifierHUSID13
Instance.NUMHUSStudent instance identifierNUMHUS20
Student.OWNSTUInstitution's own identifier for studentOWNSTU20
Instance.OWNINSTInstitution's own instance identifierOWNINST30
Course.COURSEIDCourse identifier (from latest InstancePeriod)COURSEID30
Course.OWNCOURSEIDOwn course identifier (from latest InstancePeriod)OWNCOURSEID50
Course.COURSEAIMGeneral qualification aim of course (from latest InstancePeriod)COURSEAIM3
Course.TTCIDTeacher training course (from latest InstancePeriod)TTCID1
Student.BIRTHDTEDate of birthBIRTHDTE10
Student.SURNAMEFamily nameSURNAME100
Student.FNAMESForenamesFNAMES100
Student.SSNStudent support numberSSN13
Student.ULNUnique Learner NumberULN10
StudentEquality.DISABLEDisabilityDISABLE2
StudentEquality.ETHNICEthnicityETHNIC2
StudentEquality.GENDERIDGender identityGENDERID2
StudentEquality.NATIONNationalityNATION2
StudentEquality.RELBLFReligion or beliefRELBLF2
StudentEquality.SEXIDSex identifierSEXID1
StudentEquality.SEXORTSexual orientationSEXORT2
EP_USE.DOMICILEDomicileDOMICILE2
EP_USE.POSTCODEPostcodePOSTCODE8
EP_USE.PREVINSTLast institution attendedPREVINST8
EP_USE.QUALENT3Highest qualification on entryQUALENT33
Instance.COMDATEStart date of instanceCOMDATE10
Instance.ENDDATEEnd date of instanceENDDATE10
Instance.FUNDCODEFundability codeFUNDCODE1
Instance.FUNDCOMPCompletion of year of instanceFUNDCOMP1
Instance.FUNDLEVLevel applicable to funding council HESESFUNDCOMP2
Instance.GROSSFEEGross feeGROSSFEE6
Instance.INTENTLEVStudy intentions of students on MPhil/PhD programmesINTENTLEV2
Instance.NETFEENet feeNETFEE6
Instance.RSNENDReason for ending instanceRSNEND2
Instance.SPLENGTHExpected length of studySPLENGTH2
Instance.UNITLGTHUnits of lengthUNITLGTH1
InstancePeriod.InstancePeriodKEYUnique key for every student instance periodInstancePeriodKEY13
Latest InstancePeriod.CAMPIDCampus identifierCAMPID1
Latest InstancePeriod.DISALLDisabled Student AllowanceDISALL1
Latest InstancePeriod.EXCHINDExchange programmesEXCHIND1
Latest InstancePeriod.INITIATIVES01InitiativesINITIATIVES012
Latest InstancePeriod.INITIATIVES02InitiativesINITIATIVES022
Latest InstancePeriod.INITIATIVES03InitiativesINITIATIVES032
Latest InstancePeriod.LOCATION01Location identifierLOCATION0115
Latest InstancePeriod.LOCATION02Location identifierLOCATION0215
Latest InstancePeriod.LOCATION03Location identifierLOCATION0315
Latest InstancePeriod.LOCATION04Location identifierLOCATION0415
Latest InstancePeriod.LOCATION05Location identifierLOCATION0515
Latest InstancePeriod.LOCATION06Location identifierLOCATION0615
Latest InstancePeriod.LOCATION07Location identifierLOCATION0715
Latest InstancePeriod.LOCATION08Location identifierLOCATION0815
Latest InstancePeriod.LOCATION09Location identifierLOCATION0915
Latest InstancePeriod.LOCATION10Location identifierLOCATION1015
Latest InstancePeriod.LOCSDYLocation of studyLOCSDY1
Latest InstancePeriod.MODEMode of studyMODE2
Latest InstancePeriod.MSTUFEEMajor source of tuition feesMSTUFEE2
Latest InstancePeriod.NOTACTSuspension of active studiesNOTACT1
Latest InstancePeriod.PERIODENDInstance period end datePERIODEND10
Latest InstancePeriod.PERIODSTARTInstance period start datePERIODSTART10
Latest InstancePeriod.PRIPROVPrimary provider of teachingPRIPROV8
Latest InstancePeriod.YEARPRGYear of courseYEARPRG2
Latest InstancePeriod.YEARSTUYear of student on this instanceYEARSTU2
XAGEA01Age at 31 August in reporting yearXAGEA012
XAGEJ01Age at 31 July in reporting yearXAGEJ012
XAGRP601Age grouping at 31 August in reporting year - 6 way splitXAGRP6011
XAGRPA01Age grouping at 31 August in reporting yearXAGRPA011
XAGRPJ01Age grouping at 31 July in reporting yearXAGRPJ011
XCLASS01Classification of qualificationXCLASS011
XCLASSF01Classification of qualificationXCLASSF012
XDESIG02Designation marker - instance period level (from latest InstancePeriod)XDESIG021
XDESIG03Designation marker - instance levelXDESIG031
XGLEV301Level of qualification in Graduate Outcomes - 3 way splitXGLEV3011
XGLEV501Level of qualification in Graduate Outcomes - 5 way splitXGLEV5011
XDOM01Domicile in Cyy051 coding frameXDOM012
XDOMGR01Government Office Region of student DomicileXDOMGR014
XDOMGR401Region of student domicile - 4 way groupingXDOMGR4011
XDOMHM01Domicile (participation by nation)XDOMHM011
XDOMREG01Analytical protocol domicile regionXDOMREG014
XDOMUC01Domicile (country/unitary authority level)XDOMUC014
XELSP01Expected length of study programmeXELSP011
XEPYEAR01Last year in which an Entry Profile for a HIN was supplied to HESAXEPYEAR014
XETHNIC01Analytical protocol ethnicityXETHNIC012
XETHNIC02Analytical protocol ethnicity 2XETHNIC022
XFYEAR01First year identifier (to be used with XPDEC01 only)XFYEAR011
XFYRSR01First year identifier (to be used with XPSR01 only)XFYRSR011
XHOOS01Home/overseas studentXHOOS011
XINACT01Inactive for entire reporting yearXINACT011
XINSTC01Country of institutionXINSTC011
XINSTG01Government Office Region of institution locationXINSTG011
XINSTID01Derived HESA institution identifierXINSTID014
XLEV301Level of study - 3 way splitXLEV3011
XLEV501Level of study - 5 way splitXLEV5011
XLEV601Level of study - 6 way splitXLEV6011
XMODE02Mode of studyXMODE021
XMODE301Mode of study - three way groupingXMODE3011
XMSTUFEE01Analytical protocol major source of tuition feesXMSTUFEE012
XNATGR01Geographic region of student nationalityXNATGR014
XOBTNG01Graduate Outcomes highest qualification obtainedXOBTNG013
XPDEC01Population at 1 DecemberXPDEC011
XPGO01Graduate Outcomes population for expanded coverageXPGO011
XPQUAL01Qualifications obtained populationXPQUAL011
XPSES01Session populationXPSES011
XPSR01Standard registration populationXPSR011
XQLEV1003Level of qualification - 10 way splitXQLEV10032
XQLEV301Level of qualification - 3 way splitXQLEV3011
XQLEV501Level of qualification - 5 way splitXQLEV5011
XQLEV601Level of qualification - 6 way splitXQLEV6011
XQLEV701Level of qualification - 7 way splitXQLEV7011
XQMODE01Qualification obtained mode of studyXQMODE011
XQOBTN01Highest qualification obtainedXQOBTN013
XQUALENT01Highest qualification on entryXQUALENT011
XSTUDIS01Student disabilityXSTUDIS011
XSTULOAD01Sum of student instance FTE for reporting periodXSTULOAD015
XTPOINTSUCAS Tariff for general purposesXTPOINTS4
XTPOINTSGP01Tariff analysis groupingsXTPOINTSGP012
XUHN01UKPRN-HUSID-NUMHUS combinationXUHN0141
ZFUNDCODE01FUNDCODE aggregationZFUNDCODE011
ZSTARTMONTH01Start month of instanceZSTARTMONTH012
ZNOTEND01Withdrawn or suspendedZNOTEND011

SUBJECT table

Field name Description Element name in XML output Field length
Provider.UKPRNUK Provider Reference NumberUKPRN8
Course.COURSEIDCourse identifierCOURSEID30
Course.OWNCOURSEIDOwn course identifierOWNCOURSEID50
XCAH01Common Aggregation Hierarchy, first level groupingXCAH015
XCAH02Common Aggregation Hierarchy, second level groupingXCAH028
XCAH03Common Aggregation Hierarchy, third level groupingXCAH0311
XFPE01HECOS subject by full person equivalentXFPE017
XHECOSHECOS subject by full person equivalentXHECOS6

INSTANCE PERIOD table

Field name Description Element name in XML output Field length
Instance.InstanceKEYUnique key for every student instanceInstanceKEY13
Latest InstancePeriod.InstancePeriodKEYUnique key for every student instance periodInstancePeriodKEY13
Provider.UKPRNUK Provider Reference NumberUKPRN8
Student.HUSIDHESA unique student identifierHUSID13
Instance.NUMHUSStudent instance identifierNUMHUS20
Student.OWNSTUInstitution's own identifier for studentOWNSTU20
Instance.OWNINSTInstitution's own instance identifierOWNINST30
Course.COURSEIDCourse identifierCOURSEID30
Course.OWNCOURSEIDOwn course identifierOWNCOURSEID50
InstancePeriod.CAMPIDCampus identifierCAMPID1
InstancePeriod.DISALLDisabled Student AllowanceDISALL1
InstancePeriod.EXCHINDExchange programmesEXCHIND1
InstancePeriod.INITIATIVES01InitiativesINITIATIVES012
InstancePeriod.INITIATIVES02InitiativesINITIATIVES022
InstancePeriod.INITIATIVES03InitiativesINITIATIVES032
InstancePeriod.LOCATION01Location identifierLOCATION0115
InstancePeriod.LOCATION02Location identifierLOCATION0215
InstancePeriod.LOCATION03Location identifierLOCATION0315
InstancePeriod.LOCATION04Location identifierLOCATION0415
InstancePeriod.LOCATION05Location identifierLOCATION0515
InstancePeriod.LOCATION06Location identifierLOCATION0615
InstancePeriod.LOCATION07Location identifierLOCATION0715
InstancePeriod.LOCATION08Location identifierLOCATION0815
InstancePeriod.LOCATION09Location identifierLOCATION0915
InstancePeriod.LOCATION10Location identifierLOCATION1015
InstancePeriod.LOCSDYLocation of studyLOCSDY1
InstancePeriod.MODEMode of studyMODE2
InstancePeriod.MSTUFEEMajor source of tuition feesMSTUFEE2
InstancePeriod.NOTACTSuspension of active studiesNOTACT1
InstancePeriod.PERIODENDInstance period end datePERIODEND10
InstancePeriod.PERIODSTARTInstance period start datePERIODSTART10
InstancePeriod.PRIPROVPrimary provider of teachingPRIPROV8
InstancePeriod.STULOADStudent instance FTESTULOAD5
InstancePeriod.YEARPRGYear of courseYEARPRG2
InstancePeriod.YEARSTUYear of student on this instanceYEARSTU2
XDESIG02Designation marker - instance period levelXDESIG021

QUALIFICATIONS ON ENTRY register

Field name Description Element name in XML output Field length
QOE.HUSIDHESA unique student identifierHUSID13
QOE.UKPRNUK Provider Reference NumberUKPRN8
QOE.NUMHUSStudent instance identifierNUMHUS20
Student.OWNSTUInstitution's own identifier for studentOWNSTU20
Instance.OWNINSTInstitution's own instance identifierOWNINST30
QualificationsOnEntry.OWNQUALProvider's own internal identifier for the qualificationOWNQUAL20
QOE.QUALGRADEQualification gradeQUALGRADE11
QOE.QUALSBJQualification subjectQUALSBJ3
QOE.QUALSITQualification sittingQUALSIT1
QOE.QUALTYPEQualification typeQUALTYPE2
QOE.QUALYEARQualification yearQUALYEAR4
XQEYEAR01Year QualificationsOnEntry last updatedXQEYEAR014

COURSE table

Field name Description Element name in XML output Field length
Provider.UKPRNUK Provider Reference NumberUKPRN8
Course.COURSEIDCourse identifierCOURSEID30
Course.OWNCOURSEIDOwn course identifierOWNCOURSEID50
Course.AWARDBOD01Awarding bodyAWARDBOD018
Course.AWARDBOD02Awarding bodyAWARDBOD028
Course.AWARDBOD03Awarding bodyAWARDBOD038
Course.AWARDBOD04Awarding bodyAWARDBOD048
Course.AWARDBOD05Awarding bodyAWARDBOD058
Course.AWARDBOD06Awarding bodyAWARDBOD068
Course.AWARDBOD07Awarding bodyAWARDBOD078
Course.AWARDBOD08Awarding bodyAWARDBOD088
Course.COURSEAIMGeneral qualification aim of courseCOURSEAIM3
Course.CTITLECourse titleCTITLE255
Course.REGBODY01Regulatory body for health and social care studentsREGBODY012
Course.REGBODY02Regulatory body for health and social care studentsREGBODY022
Course.TTCIDTeacher training courseTTCID1

Need help?

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