Skip to main content

HESA Student record 2018/19

Back to C18051

File structures for downloadable files - Data supply

Version 1.0 Produced 2019-05-23

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 C18051 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. 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.

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
Institution.ILRGENIndicator for ILR file generationILRGEN1
Student.BIRTHDTEDate of birthBIRTHDTE10
Student.CarerCarerCARER2
Student.DISABLEDisabilityDISABLE2
Student.ETHNICEthnicityETHNIC2
Student.FNAMESForenamesFNAMES100
Student.GENDERIDGender identityGENDERID2
Student.LEARNREFNOLearner reference numberLEARNREFNO12
Student.NATIONNationalityNATION2
Student.NATIOND1National identityNATIOND11
Student.NATIOND2National identityNATIOND21
Student.ORCIDORCID identifierORCID19
Student.PREVLEARNREFNOLearner reference number in previous yearPREVLEARNREFNO12
Student.PREVUKPRNUKPRN in previous yearPREVUKPRN8
Student.PRIORATTAINPrior attainmentPRIORATTAIN2
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.QUALENT3Highest qualification on entryQUALENT33
EP_USE.RELIGIONReligionRELIGION1
EP_USE.SECSocio-economic classificationSEC1
EP_USE.SOC2000Occupation codeSOC20004
EP_USE.SOC2010Occupation codeSOC20104
EP_USE.UCASAPPIDUCAS Application NumberUCASAPPID9
EP_USE.YRLLINSTYear left last institutionYRLLINST4
Instance.ACHDATEAchievement dateACHDATE10
Instance.AIMTYPEThe type of aim recordedAIMTYPE1
Instance.BRIDGEFoundation degree to degree bridging courseBRIDGE1
Instance.CAMPIDCampus identifierCAMPID1
Instance.COLFROMDATEDate a student has transferred from another collaborating providerCOLFROMDATE10
Instance.COLFROMPROVCollaborating provider that a student has transferred fromCOLFROMPROV8
Instance.COLTODATEDate a student has transferred to another collaborating providerCOLTODATE10
Instance.COLTOPROVCollaborating provider that a student has transferred toCOLTOPROV8
Instance.COMDATEStart date of instanceCOMDATE10
Instance.CSTATCompletion statusCSTAT1
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.EMPFEESEmployer feesEMPFEES2
Instance.EMPFUNDEmployer fundingEMPFUND2
Instance.ENDDATEEnd date of instanceENDDATE10
Instance.ENTRYRTEITT entry routeENTRYRTE2
Instance.EXCHANGEExchange programmesEXCHANGE1
Instance.FEEELIGFee eligibilityFEEELIG1
Instance.FEEREGIMEFee regime indicatorFEEREGIME2
Instance.FEEWAIVEAMTFee waiver amountFEEWAIVEAMT6
Instance.FEEWAIVETYPEFee waiver typeFEEWAIVETYPE2
Instance.FEOUTCOMEOutcomeFEOUTCOME1
Instance.FESTUMKFE student markerFESTUMK1
Instance.FTEMETHODFTE methodFTEMETHOD1
Instance.FUNDADJOTHOther funding adjustmentFUNDADJOTH3
Instance.FUNDADJPRIORFunding adjustment for prior learningFUNDADJPRIOR2
Instance.FUNDCODEFundability codeFUNDCODE1
Instance.FUNDCOMPCompletion of year of instanceFUNDCOMP1
Instance.FUNDLEVLevel applicable to funding council HESESFUNDLEV2
Instance.FUNDMODELFunding modelFUNDMODEL2
Instance.FWORKCODEFramework codeFUNDLEV3
Instance.GROSSFEEGross feeGROSSFEE6
Instance.HEAPESPOPHEAPES populationHEAPESPOP1
Instance.INITIATIVES1InitiativesINITIATIVES12
Instance.INITIATIVES2InitiativesINITIATIVES22
Instance.INSTCAMPInstitution's own campus identifierINSTCAMP8
Instance.INTENTLEVIntended level of MPhil/PhD studiesINTENTLEV2
Instance.INTERCALATEIntercalationINTERCALATE 2
Instance.ITTAIMITT qualification aimITTAIM 3
Instance.ITTPHSCITT phase/scopeITTPHSC2
Instance.ITTSCHMSITT schemesITTSCHMS1
Instance.LEARNPLANENDDATELearning Planned end dateLEARNPLANENDDATE10
Instance.LOADYRAFTE in year ALOADYRA5
Instance.LOADYRBFTE in year BLOADYRB5
Instance.LOCATION01Location identifierLOCATION0115
Instance.LOCATION02Location identifierLOCATION0215
Instance.LOCATION03Location identifierLOCATION0315
Instance.LOCATION04Location identifierLOCATION0415
Instance.LOCATION05Location identifierLOCATION0515
Instance.LOCATION06Location identifierLOCATION0615
Instance.LOCATION07Location identifierLOCATION0715
Instance.LOCATION08Location identifierLOCATION0815
Instance.LOCATION09Location identifierLOCATION0915
Instance.LOCATION10Location identifierLOCATION1015
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.NUMHUSPREVNUMHUS used by a previous provider where a student has transferredNUMHUSPREV20
Instance.PARTNERUKPRNSubcontracted or partnership UKPRNPARTNERUKPRN8
Instance.PHDSUBPhD submission datePHDSUB10
Instance.PROGTYPEProgramme typePROGTYPE2
Instance.PWAYCODEApprenticeship pathwayPWAYCODE3
Instance.QTSQualified teacher statusQTS1
Instance.RCSTDIDResearch council student identifierRCSTDID8
Instance.RCSTDNTResearch council studentRCSTDNT2
Instance.REDUCEDIReduced instance return indicatorREDUCEDI2
Instance.RSNENDReason for ending instanceRSNEND2
Instance.SDEMPLOYSchool Direct employerSDEMPLOY6
Instance.SDLEADSchool Direct lead schoolSDLEAD6
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.WITHDRAWREASONWithdrawal ReasonWITHDRAWREASON2
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
QualificationsAwarded.OUTCOME1Outcome of ITT instanceOUTCOME1
QualificationsAwarded.OUTCOME2Outcome of ITT instanceOUTCOME1
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
XAPP01Apprenticeship identifierXAPP012
XAPPMK01Apprenticeship markerXAPPMK012
XCLASS01Classification of qualificationXCLASS011
XCLASSF01Classification of qualificationXCLASSF012
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 UHN 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
XGLEV301Level of qualification in Graduate Outcomes - 3 way splitXGLEV3011
XGLEV501Level of qualification in Graduate Outcomes - 5 way splitXGLEV5011
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
XMODE301Mode of study - three way groupingXMODE3011
XMSFUND01Analytical protocol major source of fundingXMSFUND012
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 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
XQLEV701Level of qualification - 7 way splitXQLEV7011
XQMODE01Qualification obtained mode of studyXQMODE011
XQOBTN01Highest qualification obtainedXQOBTN013
XQPREV01Qualification previously submittedXQPREV013
XQUALENT01Highest qualification on entryXQUALENT011
XSTUDIS01Student disabilityXSTUDIS011
XTPOINTSUCAS tariff point aggregationXTPOINTS4
XTPOINTSGP01Tariff analysis groupingsXTPOINTSGP012

Download: XML Schema for the CORE table file.

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
Student.OWNSTUProvider's own identifier for studentOWNSTU20
Instance.OWNINSTProvider's own instance identifierOWNINST30
Instance.COURSEIDCourse identifierCOURSEID30
Course.OWNCOURSEIDOwn course identifierOWNCOURSEID50
XCAH01Common Aggregation Hierarchy, first level groupingXCAH015
XCAH02Common Aggregation Hierarchy, second level groupingXCAH028
XCAH03Common Aggregation Hierarchy, third level groupingXCAH0311
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.

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.MODSBJPSubject/HESA cost centre percentageMODSBJP5
XFTE01Full-time equivalent subject by cost centreXFTE016
XJACS201JACS principal subjectXJACS2013

Download: XML Schema for the COST CENTRE table file.

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.

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.OWNQUALProvider's own identifier for qualificationOWNQUAL20
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.

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.

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.REGBODY1Regulatory body for health and social care studentsREGBODY12
Course.REGBODY2Regulatory body for health and social care studentsREGBODY22
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.

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.

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.

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.COLPROVCollaborating providerCOLPROV8
REFData.UOA2014REF unit of assessmentUOA20143
REFData.UOAPCNTUnit of assessment percentageUOAPCNT5

Download: XML Schema for the REF DATA table file.

LEARNER FUNDING AND MONITORING Table

Field name Description Element name in XML output Field length
Instance.InstanceKEYUnique key for every student instanceINSTANCEKEY13
LearnerEmploymentStatus.LEARNEREMPLOYMENTSTATUSKEYUnique key for learner employment statusLEARNEREMPLOYMENTSTATUSKEY13
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
LearnerFAM.LEARNFAMCODELearner funding and monitoring codeLEARNFAMCODE3
LearnerFAM.LEARNFAMTYPELearner funding and monitoring typeLEARNFAMTYPE3

Download: XML Schema for the LEARNER FUNDING AND MONITORING table file.

LEARNING DELIVERY FUNDING AND MONITORING Table

Field name Description Element name in XML output Field length
Instance.InstanceKEYUnique key for every student instanceINSTANCEKEY13
LearnerEmploymentStatus.LEARNEREMPLOYMENTSTATUSKEYUnique key for learner employment statusLEARNEREMPLOYMENTSTATUSKEY13
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
LearningDeliveryFAM.LEARNDELFAMCODELearning delivery funding and monitoring codeLEARNDELFAMCODE5
LearningDeliveryFAM.LEARNDELFAMFROMLearning delivery funding and monitoring date applies fromLEARNDELFAMFROM10
LearningDeliveryFAM.LEARNDELFAMTOLearning delivery funding and monitoring date applies toLEARNDELFAMTO10
LearningDeliveryFAM.LEARNDELFAMTYPELearning delivery funding and monitoring typeLEARNDELFAMTYPE3

Download: XML Schema for the LEARNING DELIVERY FUNDING AND MONITORING table file.

ITT PLACEMENT 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
ITTPlacement.PLMNTDYSNumber of days spent in placement schoolPLMNTDYS3
ITTPlacement.PLMNTSCHPlacement schoolPLMNTSCH6

Download: XML Schema for the ITT PLACEMENT table file.

LEARNER EMPLOYMENT STATUS Table

Field name Description Element name in XML output Field length
Instance.InstanceKEYUnique key for every student instanceINSTANCEKEY13
LearnerEmploymentStatus.LEARNEREMPLOYMENTSTATUSKEYUnique key for learner employment statusLEARNEREMPLOYMENTSTATUSKEY13
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
LearnerEmploymentStatus.DATEEMPSTATAPPDate employment status applies toDATEEMPSTATAPP10
LearnerEmploymentStatus.EMPIDEmployer identifierEMPID9
LearnerEmploymentStatus.EMPSTATEmployment statusEMPSTAT2

Download: XML Schema for the LEARNER EMPLOYMENT STATUS table file.

EMPLOYMENT STATUS MONITORING Table

Field name Description Element name in XML output Field length
Instance.InstanceKEYUnique key for every student instanceINSTANCEKEY13
LearnerEmploymentStatus.LEARNEREMPLOYMENTSTATUSKEYUnique key for learner employment statusLEARNEREMPLOYMENTSTATUSKEY13
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
EmploymentStatusMonitoring.ESMCODEEmployment status monitoring codeESMCODE2
EmploymentStatusMonitoring.ESMTYPEEmployment status monitoring typeESMTYPE3

Download: XML Schema for the EMPLOYMENT STATUS MONITORING table file.


Need help?

Contact Liaison by email or on 01242 211144.