Skip to main content

Student record 2013/14

Back to C13051

File structures for downloadable files

Version 1.2 Produced 2014-08-14

File Structure - Data supply

Seven data tables are supplied in CSV and XML format. The CORE table contains the majority of fields. Separately provided are the SUBJECT table, COST CENTRE table, MODULE table, STUDENT ON MODULE table, a COURSE table, a FINANCIAL SUPPORT table, a MOBILITY table, and a REF DATA 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 C13051 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. To allow delivery of a flat file structure, the three possible occurrences of EntryProfile.PGCESBJ are provided as three fields, EP_USE.PGCESBJ1-3.
  • Derived fields, prefixed with an X, are standard ways of grouping data.
  • 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 also available to download into Excel 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
Institution.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
Student.BIRTHDTEDate of birthBIRTHDTE10
Student.DISABLEDisabilityDISABLE2
Student.ETHNICEthnicityETHNIC2
Student.FNAMESForenamesFNAMES100
Student.GENDERIDGender identityGENDERID2
Student.NATIONNationalityNATION2
Student.NATIOND1National identityNATIOND11
Student.NATIOND2National identityNATIOND21
Student.RELBLFReligion or beliefRELBLF2
Student.SCNScottish Candidate NumberSCN9
Student.SDEPENDDependants in reporting yearSDEPEND2
Student.SEXIDSex identifierSEXID1
Student.SEXORTSexual orientationSEXORT2
Student.SURNAMEFamily nameSURNAME100
Student.TTACCOMTerm-time accommodationTTACCOM1
Student.TTPCODETerm-time postcodeTTPCODE8
Student.UCASPERIDUCAS personal identifierUCASPERID10
Student.ULNUnique Learner NumberULN10
Student.WELSSPWelsh speaker indicatorWELSSP1
EP_USE.ACCESSAccess programmesACCESS1
EP_USE.ARTICLNArticulationARTICLN1
EP_USE.CARELEAVERCare leaver / Looked after statusCARELEAVER2
EP_USE.DOMICILEDomicileDOMICILE2
EP_USE.MARSTATMarital statusMARSTAT2
EP_USE.NIDEPENDDependents on entryNIDEPEND2
EP_USE.PAREDParental educationPARED1
EP_USE.PGCECLSSPGCE class of undergraduate degreePGCECLSS2
EP_USE.PGCESBJ1PGCE subject of undergraduate degreePGCESBJ14
EP_USE.PGCESBJ2PGCE subject of undergraduate degreePGCESBJ24
EP_USE.PGCESBJ3PGCE subject of undergraduate degreePGCESBJ34
EP_USE.POSTCODEPostcodePOSTCODE8
EP_USE.PREVINSTLast institution attendedPREVINST8
EP_USE.QUALENT2Highest qualification on entryQUALENT22
EP_USE.QUALENT3Highest qualification on entryQUALENT33
EP_USE.RELIGIONReligionRELIGION1
EP_USE.SECSocio-economic classificationSEC1
EP_USE.SOC2000Occupation codeSOC20004
EP_USE.UCASAPPIDUCAS Application NumberUCASAPPID9
EP_USE.WELBACCWelsh Baccalaureate Advanced DiplomaWELBACC1
EP_USE.YRLLINSTYear left last institutionYRLLINST4
Instance.BRIDGEFoundation degree to degree bridging courseBRIDGE1
Instance.CAMPIDCampus identifierCAMPID1
Instance.COMDATEStart date of instanceCOMDATE10
Instance.DHFUNDDepartment of Health funding bodyDHFUND3
Instance.DHREGREFRegulatory body reference numberDHREGREF8
Instance.DISALLDisabled Student AllowanceDISALL1
Instance.ELQ Aiming for an Equivalent or Lower QualificationELQ 2
Instance.ENDDATEEnd date of instanceENDDATE10
Instance.EXCHANGEExchange programmesEXCHANGE1
Instance.FEEELIGFee eligibilityFEEELIG1
Instance.FEEREGIMEFee regime indicatorFEEREGIME2
Instance.FESTUMKFE student markerFESTUMK1
Instance.FTEMETHODFTE methodFTEMETHOD1
Instance.FUNDCODEFundability codeFUNDCODE1
Instance.FUNDCOMPCompletion of year of instanceFUNDCOMP1
Instance.FUNDLEVLevel applicable to funding council HESESFUNDLEV2
Instance.GROSSFEEGross feeGROSSFEE6
Instance.INITIATIVES1InitiativesINITIATIVES11
Instance.INITIATIVES2InitiativesINITIATIVES21
Instance.INSTCAMPInstitution's own campus identifierINSTCAMP8
Instance.INTERCALATE IntercalationINTERCALATE 2
Instance.ITTPHSCITT phase/scopeITTPHSC2
Instance.ITTSCHMSITT schemesITTSCHMS1
Instance.LOADYRAFTE in year ALOADYRA5
Instance.LOADYRBFTE in year BLOADYRB5
Instance.LOCSDYLocation of studyLOCSDY1
Instance.MCDATEChange of mode dateMCDATE10
Instance.MODEMode of studyMODE2
Instance.MSTUFEEMajor source of tuition feesMSTUFEE2
Instance.NETFEENet feeNETFEE6
Instance.NHSEMPNHS employerNHSEMP5
Instance.NOTACTSuspension of active studiesNOTACT1
Instance.PHDSUBPhD submission datePHDSUB10
Instance.QTSQualified teacher statusQTS1
Instance.RCSTDIDResearch council student identifierRCSTDID8
Instance.RCSTDNTResearch council studentRCSTDNT2
Instance.REDUCEDIReduced instance return indicatorREDUCEDI2
Instance.RSNENDReason for ending instanceRSNEND2
Instance.SKEITTSubject Knowledge Enhancement institutionSKEITT8
Instance.SPECFEESpecial fee indicatorSPECFEE1
Instance.SPLENGTHExpected length of studySPLENGTH2
Instance.SSNStudent support numberSSN13
Instance.STULOADStudent instance FTESTULOAD5
Instance.TREFNOTeacher Reference NumberTREFNO9
Instance.TYPEYRType of instance yearTYPEYR1
Instance.UNITLGTHUnits of lengthUNITLGTH1
Instance.YEARLGTHLength of current year of instanceYEARLGTH2
Instance.YEARPRGYear of courseYEARPRG2
Instance.YEARSTUYear of student on this instanceYEARSTU2
Course.BITTMBilingual ITT markerBITTM1
Course.COURSEAIMGeneral qualification aim of courseCOURSEAIM3
Course.MSFUNDMajor source of fundingMSFUND2
Course.TTCIDTeacher training courseTTCID1
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
XDLEV301Level of qualification in DLHE - 3 way splitXDLEV3011
XDLEV501Level of qualification in DLHE - 5 way splitXDLEV5011
XDLEV601Level of qualification in DLHE - 6 way splitXDLEV6011
XDOM01Domicile in Cyy051 coding frameXDOM012
XDOMGR01Government Office Region of student DomicileXDOMGR014
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
XFYEAR01First year identifier (to be used with XPDEC01 only)XFYEAR011
XFYRSR01First year identifier (to be used with XPSR01 only)XFYRSR011
XHOOS01Home/overseas studentXHOOS011
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
XMODE01Mode of studyXMODE011
XMSFUND01Analytical protocol major source of fundingXMSFUND012
XMSTUFEE01Analytical protocol major source of tuition feesXMSTUFEE012
XNATGR01Geographic region of student nationalityXNATGR014
XOBTND01DLHE highest qualification obtainedXOBTND013
XPDEC01Population at 1 DecemberXPDEC011
XPDLHE02DLHE population for expanded coverageXPDLHE021
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
XQMODE01Qualification obtained mode of studyXQMODE011
XQOBTN01Highest qualification obtainedXQOBTN013
XQUALENT01Highest qualification on entryXQUALENT011
XSTUDIS01Student disabilityXSTUDIS011
XTARIFFUCAS Tariff for general purposesXTARIFF4

Download: XML Schema for the CORE table file.

Download: Excel field names for the CORE table for use in creating pivot tables.



SUBJECT table

Field name Description Element name in XML output Field length
Instance.INSTANCEKEYUnique key for every student instanceINSTANCEKEY13
Institution.UKPRNUK Provider Reference NumberUKPRN8
Student.HUSIDHESA unique student identifierHUSID13
Instance.NUMHUSStudent instance identifierNUMHUS20
Instance.COURSEIDCourse identifierCOURSEID30
Course.OWNCOURSEIDOwn course identifierOWNCOURSEID50
XFPE01JACS subject by full person equivalentXFPE017
XJACS01JACS subject by full person equivalentXJACS014
XJACS201JACS principal subjectXJACS2013
XJACSA01JACS subject areaXJACSA011
XJACSLEV101Analytical protocol JACS - level 1 groupingXJACSLEV1011
XJACSLEV201Analytical protocol JACS - level 2 groupingXJACSLEV2012
XJACSLEV301Analytical protocol JACS - level 3 groupingXJACSLEV3013

Download: XML Schema for the SUBJECT table file.

Download: Excel field names for the SUBJECT table for use in creating pivot tables.



COST CENTRE table

Field name Description Element name in XML output Field length
Instance.INSTANCEKEYUnique key for every student instanceINSTANCEKEY13
Institution.UKPRNUK Provider Reference NumberUKPRN8
Student.HUSIDHESA unique student identifierHUSID13
Instance.NUMHUSStudent instance identifierNUMHUS20
Module.MODIDModule identifierMODID30
ModuleSubject.COSTCNCost centreCOSTCN3
ModuleSubject.MODSBJSubject of moduleMODSBJ4
XFTE01Full-time equivalent subject by cost centreXFTE016
XJACS201JACS principal subjectXJACS2013

Download: XML Schema for the COST CENTRE table file.

Download: Excel field names for the COST CENTRE table for use in creating pivot tables.



MODULE table

Field name Description Element name in XML output Field length
Institution.UKPRNUK Provider Reference NumberUKPRN8
Module.MODIDModule identifierMODID30
Module.CRDTPTSCredit value of moduleCRDTPTS3
Module.CRDTSCMCredit transfer schemeCRDTSCM1
Module.FRANINDModule franchise indicatorFRANIND1
Module.FTEModule FTEFTE5
Module.LEVLPTSLevel of credit pointsLEVLPTS1
Module.MODLANGModule taught in a Celtic languageMODLANG1
Module.MTITLEModule titleMTITLE80
Module.PCOLABPercentage not taught by this institutionPCOLAB5
Module.TINSTOther institution providing teachingTINST8

Download: XML Schema for the MODULE table file.

Download: Excel field names for the MODULE table for use in creating pivot tables.



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
QOE.QUALGRADEQualification gradeQUALGRADE11
QOE.QUALSBJQualification subjectQUALSBJ3
QOE.QUALSITQualification sittingQUALSIT1
QOE.QUALTYPEQualification typeQUALTYPE2
QOE.QUALYEARQualification yearQUALYEAR4
XQEYEAR01Year QualificationsOnEntry last updatedXQEYEAR014

Download: XML Schema for the QUALIFICATIONS ON ENTRY table file.

Download: Excel field names for the QUALIFICATIONS ON ENTRY register table for use in creating pivot tables.



STUDENT ON MODULE table

Field name Description Element name in XML output Field length
Instance.INSTANCEKEYUnique key for every student instanceINSTANCEKEY13
Institution.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
StudentOnModule.APELAPEL indicatorAPEL1
StudentOnModule.LANGPCNTPercentage of module taught in Celtic languageLANGPCNT5
StudentOnModule.MODCOUNTModule countableMODCOUNT1
StudentOnModule.MODIDModule identifierMODID30
StudentOnModule.MODOUTModule outcomeMODOUT1
StudentOnModule.MODSTATModule statusMODSTAT1
StudentOnModule.MODYRModule yearMODYR2

Download: XML Schema for the STUDENT ON MODULE table file.

Download: Excel field names for the STUDENT ON MODULE table for use in creating pivot tables.



COURSE table

Field name Description Element name in XML output Field length
Institution.UKPRNUK Provider Reference NumberUKPRN8
Course.COURSEIDCourse identifierCOURSEID30
Course.OWNCOURSEIDOwn course identifierOWNCOURSEID50
Course.AWARDBOD1Awarding bodyAWARDBOD18
Course.AWARDBOD2Awarding bodyAWARDBOD28
Course.AWARDBOD3Awarding bodyAWARDBOD38
Course.AWARDBOD4Awarding bodyAWARDBOD48
Course.AWARDBOD5Awarding bodyAWARDBOD58
Course.AWARDBOD6Awarding bodyAWARDBOD68
Course.AWARDBOD7Awarding bodyAWARDBOD78
Course.AWARDBOD8Awarding bodyAWARDBOD88
Course.BITTMBilingual ITT markerBITTM1
Course.CLSDCRSClosed courseCLSDCRS1
Course.COLLORGCollaborating organisationCOLLORG4
Course.COURSEAIMGeneral qualification aim of courseCOURSEAIM3
Course.CTITLECourse titleCTITLE255
Course.FEQAIMCFE general qualification aimFEQAIMC8
Course.MSFUNDMajor source of fundingMSFUND2
Course.REDUCEDCReduced course return indicatorREDUCEDC2
Course.REGBODYRegulatory body for health and social care studentsREGBODY2
Course.SKEOSSubject Knowledge Enhancement placementSKEOS1
Course.SKEUNITSSubject Knowledge Enhancement unitsSKEUNITS2
Course.TQSSECTeaching qualification sought sectorTQSSEC1
Course.TQSSUB1Teaching qualification sought sectorTQSSUB13
Course.TQSSUB2Teaching qualification sought sectorTQSSUB23
Course.TQSSUB3Teaching qualification sought sectorTQSSUB33
Course.TTCIDTeacher training courseTTCID1

Download: XML Schema for the COURSE table file.

Download: Excel field names for the COURSE table for use in creating pivot tables.



FINANCIAL SUPPORT Table

Field name Description Element name in XML output Field length
Instance.INSTANCEKEYUnique key for every student instanceINSTANCEKEY13
Institution.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
FinancialSupport.FINAMOUNTFinancial support amountFINAMOUNT 6
FinancialSupport.FINTYPEFinancial support amountFINTYPE 2

Download: XML Schema for the FINANCIAL SUPPORT table file.

Download: Excel field names for the FINANCIAL SUPPORT table for use in creating pivot tables.



MOBILITY Table

Field name Description Element name in XML output Field length
Instance.INSTANCEKEYUnique key for every student instanceINSTANCEKEY13
Institution.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
Mobility.MOBDURAMobility durationMOBDURA 2
Mobility.MOBLOCAMobility locationMOBLOCA 2
Mobility.MOBSCHEMEMobility schemeMOBSCHEME 2
Mobility.MOBTYPE1Mobility typeMOBTYPE12
Mobility.MOBTYPE2Mobility typeMOBTYPE22
Mobility.MOBTYPE3Mobility typeMOBTYPE32

Download: XML Schema for the MOBILITY table file.

Download: Excel field names for the MOBILITY table for use in creating pivot tables.



REF DATA Table

Field name Description Element name in XML output Field length
Instance.INSTANCEKEYUnique key for every student instanceINSTANCEKEY13
Institution.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
REFData.UOA2014REF unit of assessmentUOA20143
REFData.UOAPCNTUnit of assessment percentageUOAPCNT5

Download: XML Schema for the REF DATA table file.

Download: Excel field names for the REF DATA table for use in creating pivot tables.

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