HESA Student record 2018/19
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.InstanceKEY | Unique key for every student instance | INSTANCEKEY | 13 |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Student.HUSID | HESA unique student identifier | HUSID | 13 |
Instance.NUMHUS | Student instance identifier | NUMHUS | 20 |
Student.OWNSTU | Institution's own identifier for student | OWNSTU | 20 |
Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
Course.COURSEID | Course identifier | COURSEID | 30 |
Course.OWNCOURSEID | Own course identifier | OWNCOURSEID | 50 |
Institution.ILRGEN | Indicator for ILR file generation | ILRGEN | 1 |
Student.BIRTHDTE | Date of birth | BIRTHDTE | 10 |
Student.Carer | Carer | CARER | 2 |
Student.DISABLE | Disability | DISABLE | 2 |
Student.ETHNIC | Ethnicity | ETHNIC | 2 |
Student.FNAMES | Forenames | FNAMES | 100 |
Student.GENDERID | Gender identity | GENDERID | 2 |
Student.LEARNREFNO | Learner reference number | LEARNREFNO | 12 |
Student.NATION | Nationality | NATION | 2 |
Student.NATIOND1 | National identity | NATIOND1 | 1 |
Student.NATIOND2 | National identity | NATIOND2 | 1 |
Student.ORCID | ORCID identifier | ORCID | 19 |
Student.PREVLEARNREFNO | Learner reference number in previous year | PREVLEARNREFNO | 12 |
Student.PREVUKPRN | UKPRN in previous year | PREVUKPRN | 8 |
Student.PRIORATTAIN | Prior attainment | PRIORATTAIN | 2 |
Student.RELBLF | Religion or belief | RELBLF | 2 |
Student.SCN | Scottish Candidate Number | SCN | 9 |
Student.SDEPEND | Dependants in reporting year | SDEPEND | 2 |
Student.SEXID | Sex identifier | SEXID | 1 |
Student.SEXORT | Sexual orientation | SEXORT | 2 |
Student.SURNAME | Family name | SURNAME | 100 |
Student.TTACCOM | Term-time accommodation | TTACCOM | 1 |
Student.TTPCODE | Term-time postcode | TTPCODE | 8 |
Student.UCASPERID | UCAS personal identifier | UCASPERID | 10 |
Student.ULN | Unique Learner Number | ULN | 10 |
Student.WELSSP | Welsh speaker indicator | WELSSP | 1 |
EP_USE.ACCESS | Access programmes | ACCESS | 1 |
EP_USE.ARTICLN | Articulation | ARTICLN | 1 |
EP_USE.CARELEAVER | Care leaver / Looked after status | CARELEAVER | 2 |
EP_USE.DOMICILE | Domicile | DOMICILE | 2 |
EP_USE.MARSTAT | Marital status | MARSTAT | 2 |
EP_USE.NIDEPEND | Dependents on entry | NIDEPEND | 2 |
EP_USE.PARED | Parental education | PARED | 1 |
EP_USE.PGCECLSS | PGCE class of undergraduate degree | PGCECLSS | 2 |
EP_USE.PGCESBJ1 | PGCE subject of undergraduate degree | PGCESBJ1 | 4 |
EP_USE.PGCESBJ2 | PGCE subject of undergraduate degree | PGCESBJ2 | 4 |
EP_USE.PGCESBJ3 | PGCE subject of undergraduate degree | PGCESBJ3 | 4 |
EP_USE.POSTCODE | Postcode | POSTCODE | 8 |
EP_USE.PREVINST | Last institution attended | PREVINST | 8 |
EP_USE.QUALENT3 | Highest qualification on entry | QUALENT3 | 3 |
EP_USE.RELIGION | Religion | RELIGION | 1 |
EP_USE.SEC | Socio-economic classification | SEC | 1 |
EP_USE.SOC2000 | Occupation code | SOC2000 | 4 |
EP_USE.SOC2010 | Occupation code | SOC2010 | 4 |
EP_USE.UCASAPPID | UCAS Application Number | UCASAPPID | 9 |
EP_USE.YRLLINST | Year left last institution | YRLLINST | 4 |
Instance.ACHDATE | Achievement date | ACHDATE | 10 |
Instance.AIMTYPE | The type of aim recorded | AIMTYPE | 1 |
Instance.BRIDGE | Foundation degree to degree bridging course | BRIDGE | 1 |
Instance.CAMPID | Campus identifier | CAMPID | 1 |
Instance.COLFROMDATE | Date a student has transferred from another collaborating provider | COLFROMDATE | 10 |
Instance.COLFROMPROV | Collaborating provider that a student has transferred from | COLFROMPROV | 8 |
Instance.COLTODATE | Date a student has transferred to another collaborating provider | COLTODATE | 10 |
Instance.COLTOPROV | Collaborating provider that a student has transferred to | COLTOPROV | 8 |
Instance.COMDATE | Start date of instance | COMDATE | 10 |
Instance.CSTAT | Completion status | CSTAT | 1 |
Instance.DHFUND | Department of Health funding body | DHFUND | 3 |
Instance.DHREGREF | Regulatory body reference number | DHREGREF | 8 |
Instance.DISALL | Disabled Student Allowance | DISALL | 1 |
Instance.ELQ | Aiming for an Equivalent or Lower Qualification | ELQ | 2 |
Instance.EMPFEES | Employer fees | EMPFEES | 2 |
Instance.EMPFUND | Employer funding | EMPFUND | 2 |
Instance.ENDDATE | End date of instance | ENDDATE | 10 |
Instance.ENTRYRTE | ITT entry route | ENTRYRTE | 2 |
Instance.EXCHANGE | Exchange programmes | EXCHANGE | 1 |
Instance.FEEELIG | Fee eligibility | FEEELIG | 1 |
Instance.FEEREGIME | Fee regime indicator | FEEREGIME | 2 |
Instance.FEEWAIVEAMT | Fee waiver amount | FEEWAIVEAMT | 6 |
Instance.FEEWAIVETYPE | Fee waiver type | FEEWAIVETYPE | 2 |
Instance.FEOUTCOME | Outcome | FEOUTCOME | 1 |
Instance.FESTUMK | FE student marker | FESTUMK | 1 |
Instance.FTEMETHOD | FTE method | FTEMETHOD | 1 |
Instance.FUNDADJOTH | Other funding adjustment | FUNDADJOTH | 3 |
Instance.FUNDADJPRIOR | Funding adjustment for prior learning | FUNDADJPRIOR | 2 |
Instance.FUNDCODE | Fundability code | FUNDCODE | 1 |
Instance.FUNDCOMP | Completion of year of instance | FUNDCOMP | 1 |
Instance.FUNDLEV | Level applicable to funding council HESES | FUNDLEV | 2 |
Instance.FUNDMODEL | Funding model | FUNDMODEL | 2 |
Instance.FWORKCODE | Framework code | FUNDLEV | 3 |
Instance.GROSSFEE | Gross fee | GROSSFEE | 6 |
Instance.HEAPESPOP | HEAPES population | HEAPESPOP | 1 |
Instance.INITIATIVES1 | Initiatives | INITIATIVES1 | 2 |
Instance.INITIATIVES2 | Initiatives | INITIATIVES2 | 2 |
Instance.INSTCAMP | Institution's own campus identifier | INSTCAMP | 8 |
Instance.INTENTLEV | Intended level of MPhil/PhD studies | INTENTLEV | 2 |
Instance.INTERCALATE | Intercalation | INTERCALATE | 2 |
Instance.ITTAIM | ITT qualification aim | ITTAIM | 3 |
Instance.ITTPHSC | ITT phase/scope | ITTPHSC | 2 |
Instance.ITTSCHMS | ITT schemes | ITTSCHMS | 1 |
Instance.LEARNPLANENDDATE | Learning Planned end date | LEARNPLANENDDATE | 10 |
Instance.LOADYRA | FTE in year A | LOADYRA | 5 |
Instance.LOADYRB | FTE in year B | LOADYRB | 5 |
Instance.LOCATION01 | Location identifier | LOCATION01 | 15 |
Instance.LOCATION02 | Location identifier | LOCATION02 | 15 |
Instance.LOCATION03 | Location identifier | LOCATION03 | 15 |
Instance.LOCATION04 | Location identifier | LOCATION04 | 15 |
Instance.LOCATION05 | Location identifier | LOCATION05 | 15 |
Instance.LOCATION06 | Location identifier | LOCATION06 | 15 |
Instance.LOCATION07 | Location identifier | LOCATION07 | 15 |
Instance.LOCATION08 | Location identifier | LOCATION08 | 15 |
Instance.LOCATION09 | Location identifier | LOCATION09 | 15 |
Instance.LOCATION10 | Location identifier | LOCATION10 | 15 |
Instance.LOCSDY | Location of study | LOCSDY | 1 |
Instance.MCDATE | Change of mode date | MCDATE | 10 |
Instance.MODE | Mode of study | MODE | 2 |
Instance.MSTUFEE | Major source of tuition fees | MSTUFEE | 2 |
Instance.NETFEE | Net fee | NETFEE | 6 |
Instance.NHSEMP | NHS employer | NHSEMP | 5 |
Instance.NOTACT | Suspension of active studies | NOTACT | 1 |
Instance.NUMHUSPREV | NUMHUS used by a previous provider where a student has transferred | NUMHUSPREV | 20 |
Instance.PARTNERUKPRN | Subcontracted or partnership UKPRN | PARTNERUKPRN | 8 |
Instance.PHDSUB | PhD submission date | PHDSUB | 10 |
Instance.PROGTYPE | Programme type | PROGTYPE | 2 |
Instance.PWAYCODE | Apprenticeship pathway | PWAYCODE | 3 |
Instance.QTS | Qualified teacher status | QTS | 1 |
Instance.RCSTDID | Research council student identifier | RCSTDID | 8 |
Instance.RCSTDNT | Research council student | RCSTDNT | 2 |
Instance.REDUCEDI | Reduced instance return indicator | REDUCEDI | 2 |
Instance.RSNEND | Reason for ending instance | RSNEND | 2 |
Instance.SDEMPLOY | School Direct employer | SDEMPLOY | 6 |
Instance.SDLEAD | School Direct lead school | SDLEAD | 6 |
Instance.SPECFEE | Special fee indicator | SPECFEE | 1 |
Instance.SPLENGTH | Expected length of study | SPLENGTH | 2 |
Instance.SSN | Student support number | SSN | 13 |
Instance.STULOAD | Student instance FTE | STULOAD | 5 |
Instance.TREFNO | Teacher Reference Number | TREFNO | 9 |
Instance.TYPEYR | Type of instance year | TYPEYR | 1 |
Instance.UNITLGTH | Units of length | UNITLGTH | 1 |
Instance.WITHDRAWREASON | Withdrawal Reason | WITHDRAWREASON | 2 |
Instance.YEARLGTH | Length of current year of instance | YEARLGTH | 2 |
Instance.YEARPRG | Year of course | YEARPRG | 2 |
Instance.YEARSTU | Year of student on this instance | YEARSTU | 2 |
Course.BITTM | Bilingual ITT marker | BITTM | 1 |
Course.COURSEAIM | General qualification aim of course | COURSEAIM | 3 |
Course.MSFUND | Major source of funding | MSFUND | 2 |
Course.TTCID | Teacher training course | TTCID | 1 |
QualificationsAwarded.OUTCOME1 | Outcome of ITT instance | OUTCOME | 1 |
QualificationsAwarded.OUTCOME2 | Outcome of ITT instance | OUTCOME | 1 |
XAGEA01 | Age at 31 August in reporting year | XAGEA01 | 2 |
XAGEJ01 | Age at 31 July in reporting year | XAGEJ01 | 2 |
XAGRP601 | Age grouping at 31 August in reporting year - 6 way split | XAGRP601 | 1 |
XAGRPA01 | Age grouping at 31 August in reporting year | XAGRPA01 | 1 |
XAGRPJ01 | Age grouping at 31 July in reporting year | XAGRPJ01 | 1 |
XAPP01 | Apprenticeship identifier | XAPP01 | 2 |
XAPPMK01 | Apprenticeship marker | XAPPMK01 | 2 |
XCLASS01 | Classification of qualification | XCLASS01 | 1 |
XCLASSF01 | Classification of qualification | XCLASSF01 | 2 |
XDOM01 | Domicile in Cyy051 coding frame | XDOM01 | 2 |
XDOMGR01 | Government Office Region of student Domicile | XDOMGR01 | 4 |
XDOMGR401 | Region of student domicile - 4 way grouping | XDOMGR401 | 1 |
XDOMHM01 | Domicile (participation by nation) | XDOMHM01 | 1 |
XDOMREG01 | Analytical protocol domicile region | XDOMREG01 | 4 |
XDOMUC01 | Domicile (country/unitary authority level) | XDOMUC01 | 4 |
XELSP01 | Expected length of study programme | XELSP01 | 1 |
XEPYEAR01 | Last year in which an Entry Profile for a UHN was supplied to HESA | XEPYEAR01 | 4 |
XETHNIC01 | Analytical protocol ethnicity | XETHNIC01 | 2 |
XETHNIC02 | Analytical protocol ethnicity 2 | XETHNIC02 | 2 |
XFYEAR01 | First year identifier (to be used with XPDEC01 only) | XFYEAR01 | 1 |
XFYRSR01 | First year identifier (to be used with XPSR01 only) | XFYRSR01 | 1 |
XGLEV301 | Level of qualification in Graduate Outcomes - 3 way split | XGLEV301 | 1 |
XGLEV501 | Level of qualification in Graduate Outcomes - 5 way split | XGLEV501 | 1 |
XHOOS01 | Home/overseas student | XHOOS01 | 1 |
XINSTC01 | Country of institution | XINSTC01 | 1 |
XINSTG01 | Government Office Region of institution location | XINSTG01 | 1 |
XINSTID01 | Derived HESA institution identifier | XINSTID01 | 4 |
XLEV301 | Level of study - 3 way split | XLEV301 | 1 |
XLEV501 | Level of study - 5 way split | XLEV501 | 1 |
XLEV601 | Level of study - 6 way split | XLEV601 | 1 |
XMODE01 | Mode of study | XMODE01 | 1 |
XMODE301 | Mode of study - three way grouping | XMODE301 | 1 |
XMSFUND01 | Analytical protocol major source of funding | XMSFUND01 | 2 |
XMSTUFEE01 | Analytical protocol major source of tuition fees | XMSTUFEE01 | 2 |
XNATGR01 | Geographic region of student nationality | XNATGR01 | 4 |
XOBTNG01 | Graduate Outcomes highest qualification obtained | XOBTNG01 | 3 |
XPDEC01 | Population at 1 December | XPDEC01 | 1 |
XPGO01 | Graduate Outcomes population for expanded coverage | XPDLHE02 | 1 |
XPQUAL01 | Qualifications obtained population | XPQUAL01 | 1 |
XPSES01 | Session population | XPSES01 | 1 |
XPSR01 | Standard registration population | XPSR01 | 1 |
XQLEV1003 | Level of qualification - 10 way split | XQLEV1003 | 2 |
XQLEV301 | Level of qualification - 3 way split | XQLEV301 | 1 |
XQLEV501 | Level of qualification - 5 way split | XQLEV501 | 1 |
XQLEV601 | Level of qualification - 6 way split | XQLEV601 | 1 |
XQLEV701 | Level of qualification - 7 way split | XQLEV701 | 1 |
XQMODE01 | Qualification obtained mode of study | XQMODE01 | 1 |
XQOBTN01 | Highest qualification obtained | XQOBTN01 | 3 |
XQPREV01 | Qualification previously submitted | XQPREV01 | 3 |
XQUALENT01 | Highest qualification on entry | XQUALENT01 | 1 |
XSTUDIS01 | Student disability | XSTUDIS01 | 1 |
XTPOINTS | UCAS tariff point aggregation | XTPOINTS | 4 |
XTPOINTSGP01 | Tariff analysis groupings | XTPOINTSGP01 | 2 |
Download: XML Schema for the CORE table file.
SUBJECT table
Field name | Description | Element name in XML output | Field length |
Instance.InstanceKEY | Unique key for every student instance | INSTANCEKEY | 13 |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Student.HUSID | HESA unique student identifier | HUSID | 13 |
Instance.NUMHUS | Student instance identifier | NUMHUS | 20 |
Student.OWNSTU | Provider's own identifier for student | OWNSTU | 20 |
Instance.OWNINST | Provider's own instance identifier | OWNINST | 30 |
Instance.COURSEID | Course identifier | COURSEID | 30 |
Course.OWNCOURSEID | Own course identifier | OWNCOURSEID | 50 |
XCAH01 | Common Aggregation Hierarchy, first level grouping | XCAH01 | 5 |
XCAH02 | Common Aggregation Hierarchy, second level grouping | XCAH02 | 8 |
XCAH03 | Common Aggregation Hierarchy, third level grouping | XCAH03 | 11 |
XFPE01 | JACS subject by full person equivalent | XFPE01 | 7 |
XJACS01 | JACS subject by full person equivalent | XJACS01 | 4 |
XJACS201 | JACS principal subject | XJACS201 | 3 |
XJACSA01 | JACS subject area | XJACSA01 | 1 |
XJACSLEV101 | Analytical protocol JACS - level 1 grouping | XJACSLEV101 | 1 |
XJACSLEV201 | Analytical protocol JACS - level 2 grouping | XJACSLEV201 | 2 |
XJACSLEV301 | Analytical protocol JACS - level 3 grouping | XJACSLEV301 | 3 |
Download: XML Schema for the SUBJECT table file.
COST CENTRE table
Field name | Description | Element name in XML output | Field length |
Instance.InstanceKEY | Unique key for every student instance | INSTANCEKEY | 13 |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Student.HUSID | HESA unique student identifier | HUSID | 13 |
Instance.NUMHUS | Student instance identifier | NUMHUS | 20 |
Module.MODID | Module identifier | MODID | 30 |
ModuleSubject.COSTCN | Cost centre | COSTCN | 3 |
ModuleSubject.MODSBJ | Subject/HESA cost centre percentage | MODSBJ | 4 |
XFTE01 | Full-time equivalent subject by cost centre | XFTE01 | 6 |
XJACS201 | JACS principal subject | XJACS201 | 3 |
Download: XML Schema for the COST CENTRE table file.
MODULE table
Field name | Description | Element name in XML output | Field length |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Module.MODID | Module identifier | MODID | 30 |
Module.CRDTPTS | Credit value of module | CRDTPTS | 3 |
Module.CRDTSCM | Credit transfer scheme | CRDTSCM | 1 |
Module.FRANIND | Module franchise indicator | FRANIND | 1 |
Module.FTE | Module FTE | FTE | 5 |
Module.LEVLPTS | Level of credit points | LEVLPTS | 1 |
Module.MODLANG | Module taught in a Celtic language | MODLANG | 1 |
Module.MTITLE | Module title | MTITLE | 80 |
Module.PCOLAB | Percentage not taught by this institution | PCOLAB | 5 |
Module.TINST | Other institution providing teaching | TINST | 8 |
Download: XML Schema for the MODULE table file.
QUALIFICATIONS ON ENTRY register
Field name | Description | Element name in XML output | Field length |
QOE.HUSID | HESA unique student identifier | HUSID | 13 |
QOE.UKPRN | UK Provider Reference Number | UKPRN | 8 |
QOE.NUMHUS | Student instance identifier | NUMHUS | 20 |
Student.OWNSTU | Institution's own identifier for student | OWNSTU | 20 |
Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
QOE.OWNQUAL | Provider's own identifier for qualification | OWNQUAL | 20 |
QOE.QUALGRADE | Qualification grade | QUALGRADE | 11 |
QOE.QUALSBJ | Qualification subject | QUALSBJ | 3 |
QOE.QUALSIT | Qualification sitting | QUALSIT | 1 |
QOE.QUALTYPE | Qualification type | QUALTYPE | 2 |
QOE.QUALYEAR | Qualification year | QUALYEAR | 4 |
XQEYEAR01 | Year QualificationsOnEntry last updated | XQEYEAR01 | 4 |
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.InstanceKEY | Unique key for every student instance | INSTANCEKEY | 13 |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Student.HUSID | HESA unique student identifier | HUSID | 13 |
Instance.NUMHUS | Student instance identifier | NUMHUS | 20 |
Student.OWNSTU | Institution's own identifier for student | OWNSTU | 20 |
Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
StudentOnModule.APEL | APEL indicator | APEL | 1 |
StudentOnModule.LANGPCNT | Percentage of module taught in Celtic language | LANGPCNT | 5 |
StudentOnModule.MODCOUNT | Module countable | MODCOUNT | 1 |
StudentOnModule.MODID | Module identifier | MODID | 30 |
StudentOnModule.MODOUT | Module outcome | MODOUT | 1 |
StudentOnModule.MODSTAT | Module status | MODSTAT | 1 |
StudentOnModule.MODYR | Module year | MODYR | 2 |
Download: XML Schema for the STUDENT ON MODULE table file.
COURSE table
Field name | Description | Element name in XML output | Field length |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Course.COURSEID | Course identifier | COURSEID | 30 |
Course.OWNCOURSEID | Own course identifier | OWNCOURSEID | 50 |
Course.AWARDBOD1 | Awarding body | AWARDBOD1 | 8 |
Course.AWARDBOD2 | Awarding body | AWARDBOD2 | 8 |
Course.AWARDBOD3 | Awarding body | AWARDBOD3 | 8 |
Course.AWARDBOD4 | Awarding body | AWARDBOD4 | 8 |
Course.AWARDBOD5 | Awarding body | AWARDBOD5 | 8 |
Course.AWARDBOD6 | Awarding body | AWARDBOD6 | 8 |
Course.AWARDBOD7 | Awarding body | AWARDBOD7 | 8 |
Course.AWARDBOD8 | Awarding body | AWARDBOD8 | 8 |
Course.BITTM | Bilingual ITT marker | BITTM | 1 |
Course.CLSDCRS | Closed course | CLSDCRS | 1 |
Course.COLLORG | Collaborating organisation | COLLORG | 4 |
Course.COURSEAIM | General qualification aim of course | COURSEAIM | 3 |
Course.CTITLE | Course title | CTITLE | 255 |
Course.FEQAIMC | FE general qualification aim | FEQAIMC | 8 |
Course.MSFUND | Major source of funding | MSFUND | 2 |
Course.REDUCEDC | Reduced course return indicator | REDUCEDC | 2 |
Course.REGBODY1 | Regulatory body for health and social care students | REGBODY1 | 2 |
Course.REGBODY2 | Regulatory body for health and social care students | REGBODY2 | 2 |
Course.TQSSEC | Teaching qualification sought sector | TQSSEC | 1 |
Course.TQSSUB1 | Teaching qualification sought sector | TQSSUB1 | 3 |
Course.TQSSUB2 | Teaching qualification sought sector | TQSSUB2 | 3 |
Course.TQSSUB3 | Teaching qualification sought sector | TQSSUB3 | 3 |
Course.TTCID | Teacher training course | TTCID | 1 |
Download: XML Schema for the COURSE table file.
FINANCIAL SUPPORT table
Field name | Description | Element name in XML output | Field length |
Instance.InstanceKEY | Unique key for every student instance | INSTANCEKEY | 13 |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Student.HUSID | HESA unique student identifier | HUSID | 13 |
Instance.NUMHUS | Student instance identifier | NUMHUS | 20 |
Student.OWNSTU | Institution's own identifier for student | OWNSTU | 20 |
Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
FinancialSupport.FINAMOUNT | Financial support amount | FINAMOUNT | 6 |
FinancialSupport.FINTYPE | Financial support amount | FINTYPE | 2 |
Download: XML Schema for the FINANCIAL SUPPORT table file.
MOBILITY table
Field name | Description | Element name in XML output | Field length |
Instance.InstanceKEY | Unique key for every student instance | INSTANCEKEY | 13 |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Student.HUSID | HESA unique student identifier | HUSID | 13 |
Instance.NUMHUS | Student instance identifier | NUMHUS | 20 |
Student.OWNSTU | Institution's own identifier for student | OWNSTU | 20 |
Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
Mobility.MOBDURA | Mobility duration | MOBDURA | 2 |
Mobility.MOBLOCA | Mobility location | MOBLOCA | 2 |
Mobility.MOBSCHEME | Mobility scheme | MOBSCHEME | 2 |
Mobility.MOBTYPE1 | Mobility type | MOBTYPE1 | 2 |
Mobility.MOBTYPE2 | Mobility type | MOBTYPE2 | 2 |
Mobility.MOBTYPE3 | Mobility type | MOBTYPE3 | 2 |
Download: XML Schema for the MOBILITY table file.
REF DATA table
Field name | Description | Element name in XML output | Field length |
Instance.InstanceKEY | Unique key for every student instance | INSTANCEKEY | 13 |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Student.HUSID | HESA unique student identifier | HUSID | 13 |
Instance.NUMHUS | Student instance identifier | NUMHUS | 20 |
Student.OWNSTU | Institution's own identifier for student | OWNSTU | 20 |
Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
REFData.COLPROV | Collaborating provider | COLPROV | 8 |
REFData.UOA2014 | REF unit of assessment | UOA2014 | 3 |
REFData.UOAPCNT | Unit of assessment percentage | UOAPCNT | 5 |
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.InstanceKEY | Unique key for every student instance | INSTANCEKEY | 13 |
LearnerEmploymentStatus.LEARNEREMPLOYMENTSTATUSKEY | Unique key for learner employment status | LEARNEREMPLOYMENTSTATUSKEY | 13 |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Student.HUSID | HESA unique student identifier | HUSID | 13 |
Instance.NUMHUS | Student instance identifier | NUMHUS | 20 |
Student.OWNSTU | Institution's own identifier for student | OWNSTU | 20 |
Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
LearnerFAM.LEARNFAMCODE | Learner funding and monitoring code | LEARNFAMCODE | 3 |
LearnerFAM.LEARNFAMTYPE | Learner funding and monitoring type | LEARNFAMTYPE | 3 |
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.InstanceKEY | Unique key for every student instance | INSTANCEKEY | 13 |
LearnerEmploymentStatus.LEARNEREMPLOYMENTSTATUSKEY | Unique key for learner employment status | LEARNEREMPLOYMENTSTATUSKEY | 13 |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Student.HUSID | HESA unique student identifier | HUSID | 13 |
Instance.NUMHUS | Student instance identifier | NUMHUS | 20 |
Student.OWNSTU | Institution's own identifier for student | OWNSTU | 20 |
Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
LearningDeliveryFAM.LEARNDELFAMCODE | Learning delivery funding and monitoring code | LEARNDELFAMCODE | 5 |
LearningDeliveryFAM.LEARNDELFAMFROM | Learning delivery funding and monitoring date applies from | LEARNDELFAMFROM | 10 |
LearningDeliveryFAM.LEARNDELFAMTO | Learning delivery funding and monitoring date applies to | LEARNDELFAMTO | 10 |
LearningDeliveryFAM.LEARNDELFAMTYPE | Learning delivery funding and monitoring type | LEARNDELFAMTYPE | 3 |
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.InstanceKEY | Unique key for every student instance | INSTANCEKEY | 13 |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Student.HUSID | HESA unique student identifier | HUSID | 13 |
Instance.NUMHUS | Student instance identifier | NUMHUS | 20 |
Student.OWNSTU | Institution's own identifier for student | OWNSTU | 20 |
Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
ITTPlacement.PLMNTDYS | Number of days spent in placement school | PLMNTDYS | 3 |
ITTPlacement.PLMNTSCH | Placement school | PLMNTSCH | 6 |
Download: XML Schema for the ITT PLACEMENT table file.
LEARNER EMPLOYMENT STATUS Table
Field name | Description | Element name in XML output | Field length |
Instance.InstanceKEY | Unique key for every student instance | INSTANCEKEY | 13 |
LearnerEmploymentStatus.LEARNEREMPLOYMENTSTATUSKEY | Unique key for learner employment status | LEARNEREMPLOYMENTSTATUSKEY | 13 |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Student.HUSID | HESA unique student identifier | HUSID | 13 |
Instance.NUMHUS | Student instance identifier | NUMHUS | 20 |
Student.OWNSTU | Institution's own identifier for student | OWNSTU | 20 |
Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
LearnerEmploymentStatus.DATEEMPSTATAPP | Date employment status applies to | DATEEMPSTATAPP | 10 |
LearnerEmploymentStatus.EMPID | Employer identifier | EMPID | 9 |
LearnerEmploymentStatus.EMPSTAT | Employment status | EMPSTAT | 2 |
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.InstanceKEY | Unique key for every student instance | INSTANCEKEY | 13 |
LearnerEmploymentStatus.LEARNEREMPLOYMENTSTATUSKEY | Unique key for learner employment status | LEARNEREMPLOYMENTSTATUSKEY | 13 |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Student.HUSID | HESA unique student identifier | HUSID | 13 |
Instance.NUMHUS | Student instance identifier | NUMHUS | 20 |
Student.OWNSTU | Institution's own identifier for student | OWNSTU | 20 |
Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
EmploymentStatusMonitoring.ESMCODE | Employment status monitoring code | ESMCODE | 2 |
EmploymentStatusMonitoring.ESMTYPE | Employment status monitoring type | ESMTYPE | 3 |
Download: XML Schema for the EMPLOYMENT STATUS MONITORING table file.
Need help?
Contact Liaison by email or on +44 (0)1242 388 531.