Student Alternative record 2020/21
File structures for downloadable files - Data supply
Version 1.0 Produced 2021-06-23
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 C20054 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.InstanceKEY | Unique key for every student instance | InstanceKEY | 13 |
Provider.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 (from latest InstancePeriod) | COURSEID | 30 |
Course.OWNCOURSEID | Own course identifier (from latest InstancePeriod) | OWNCOURSEID | 50 |
Course.COURSEAIM | General qualification aim of course (from latest InstancePeriod) | COURSEAIM | 3 |
Course.TTCID | Teacher training course (from latest InstancePeriod) | TTCID | 1 |
Student.BIRTHDTE | Date of birth | BIRTHDTE | 10 |
Student.SURNAME | Family name | SURNAME | 100 |
Student.FNAMES | Forenames | FNAMES | 100 |
Student.SSN | Student support number | SSN | 13 |
Student.UCASPERID | UCAS personal identifier | UCASPERID | 10 |
Student.ULN | Unique Learner Number | ULN | 10 |
StudentEquality.DISABLE | Disability | DISABLE | 2 |
StudentEquality.ETHNIC | Ethnicity | ETHNIC | 2 |
StudentEquality.GENDERID | Gender identity | GENDERID | 2 |
StudentEquality.NATION | Nationality | NATION | 2 |
StudentEquality.RELBLF | Religion or belief | RELBLF | 2 |
StudentEquality.SEXID | Sex identifier | SEXID | 1 |
StudentEquality.SEXORT | Sexual orientation | SEXORT | 2 |
EP_USE.APELCRD | APEL credits | APELCRD | 2 |
EP_USE.CARELEAVER | Care leaver / Looked after status | CARELEAVER | 2 |
EP_USE.CRDPTSTU | Credit points counted towards study | CRDPTSTU | 3 |
EP_USE.CRDSCM | Credit Scheme | CRDSCM | 2 |
EP_USE.DOMICILE | Domicile | DOMICILE | 2 |
EP_USE.PARED | Parental education | PARED | 1 |
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.SEC | Socio-economic classification | SEC | 1 |
EP_USE.UCASSCHEMECODE | UCAS Application Scheme Code | UCASSCHEMECODE | 9 |
Instance.COMDATE | Start date of instance | COMDATE | 10 |
Instance.ENDDATE | End date of instance | ENDDATE | 10 |
Instance.FUNDCODE | Fundability code | FUNDCODE | 1 |
Instance.FUNDCOMP | Completion of year of instance | FUNDCOMP | 1 |
Instance.FUNDLEV | Level applicable to funding council HESES | FUNDCOMP | 2 |
Instance.GROSSFEE | Gross fee | GROSSFEE | 6 |
Instance.INTENTLEV | Study intentions of students on MPhil/PhD programmes | INTENTLEV | 2 |
Instance.NETFEE | Net fee | NETFEE | 6 |
Instance.RSNEND | Reason for ending instance | RSNEND | 2 |
Instance.SPLENGTH | Expected length of study | SPLENGTH | 2 |
Instance.UNITLGTH | Units of length | UNITLGTH | 1 |
InstancePeriod.InstancePeriodKEY | Unique key for every student instance period | InstancePeriodKEY | 13 |
Latest InstancePeriod.CAMPID | Campus identifier | CAMPID | 1 |
Latest InstancePeriod.DISALL | Disabled Student Allowance | DISALL | 1 |
Latest InstancePeriod.EXCHIND | Exchange programmes | EXCHIND | 1 |
Latest InstancePeriod.INITIATIVES01 | Initiatives | INITIATIVES01 | 2 |
Latest InstancePeriod.INITIATIVES02 | Initiatives | INITIATIVES02 | 2 |
Latest InstancePeriod.INITIATIVES03 | Initiatives | INITIATIVES03 | 2 |
Latest InstancePeriod.LOCATION01 | Location identifier | LOCATION01 | 15 |
Latest InstancePeriod.LOCATION02 | Location identifier | LOCATION02 | 15 |
Latest InstancePeriod.LOCATION03 | Location identifier | LOCATION03 | 15 |
Latest InstancePeriod.LOCATION04 | Location identifier | LOCATION04 | 15 |
Latest InstancePeriod.LOCATION05 | Location identifier | LOCATION05 | 15 |
Latest InstancePeriod.LOCATION06 | Location identifier | LOCATION06 | 15 |
Latest InstancePeriod.LOCATION07 | Location identifier | LOCATION07 | 15 |
Latest InstancePeriod.LOCATION08 | Location identifier | LOCATION08 | 15 |
Latest InstancePeriod.LOCATION09 | Location identifier | LOCATION09 | 15 |
Latest InstancePeriod.LOCATION10 | Location identifier | LOCATION10 | 15 |
Latest InstancePeriod.LOCSDY | Location of study | LOCSDY | 1 |
Latest InstancePeriod.MODE | Mode of study | MODE | 2 |
Latest InstancePeriod.MSTUFEE | Major source of tuition fees | MSTUFEE | 2 |
Latest InstancePeriod.NOTACT | Suspension of active studies | NOTACT | 1 |
Latest InstancePeriod.PERIODEND | Instance period end date | PERIODEND | 10 |
Latest InstancePeriod.PERIODSTART | Instance period start date | PERIODSTART | 10 |
Latest InstancePeriod.PRIPROV | Primary provider of teaching | PRIPROV | 8 |
Latest InstancePeriod.YEARPRG | Year of course | YEARPRG | 2 |
Latest InstancePeriod.YEARSTU | Year of student on this instance | YEARSTU | 2 |
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 |
XCLASS01 | Classification of qualification | XCLASS01 | 1 |
XCLASSF01 | Classification of qualification | XCLASSF01 | 2 |
XDESIG02 | Designation marker - instance period level (from latest InstancePeriod) | XDESIG02 | 1 |
XDESIG03 | Designation marker - instance level | XDESIG03 | 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 |
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 HIN 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 |
XHOOS01 | Home/overseas student | XHOOS01 | 1 |
XINACT01 | Inactive for entire reporting year | XINACT01 | 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 |
XMODE02 | Mode of study | XMODE02 | 1 |
XMODE301 | Mode of study - three way grouping | XMODE301 | 1 |
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 | XPGO01 | 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 |
XQUALENT01 | Highest qualification on entry | XQUALENT01 | 1 |
XSTUDIS01 | Student disability | XSTUDIS01 | 1 |
XSTULOAD01 | Sum of student instance FTE for reporting period | XSTULOAD01 | 5 |
XTPOINTS | UCAS Tariff for general purposes | XTPOINTS | 4 |
XTPOINTSGP01 | Tariff analysis groupings | XTPOINTSGP01 | 2 |
XUHN01 | UKPRN-HUSID-NUMHUS combination | XUHN01 | 41 |
ZFUNDCODE01 | FUNDCODE aggregation | ZFUNDCODE01 | 1 |
ZSTARTMONTH01 | Start month of instance | ZSTARTMONTH01 | 2 |
ZNOTEND01 | Withdrawn or suspended | ZNOTEND01 | 1 |
SUBJECT table
Field name | Description | Element name in XML output | Field length |
Provider.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Course.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 | HECOS subject by full person equivalent | XFPE01 | 7 |
XHECOS | HECOS subject by full person equivalent | XHECOS | 6 |
INSTANCE PERIOD table
Field name | Description | Element name in XML output | Field length |
Instance.InstanceKEY | Unique key for every student instance | InstanceKEY | 13 |
InstancePeriod.InstancePeriodKEY | Unique key for every student instance period | InstancePeriodKEY | 13 |
Provider.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 |
InstancePeriod.CAMPID | Campus identifier | CAMPID | 1 |
InstancePeriod.DISALL | Disabled Student Allowance | DISALL | 1 |
InstancePeriod.EXCHIND | Exchange programmes | EXCHIND | 1 |
InstancePeriod.INITIATIVES01 | Initiatives | INITIATIVES01 | 2 |
InstancePeriod.INITIATIVES02 | Initiatives | INITIATIVES02 | 2 |
InstancePeriod.INITIATIVES03 | Initiatives | INITIATIVES03 | 2 |
InstancePeriod.LOCATION01 | Location identifier | LOCATION01 | 15 |
InstancePeriod.LOCATION02 | Location identifier | LOCATION02 | 15 |
InstancePeriod.LOCATION03 | Location identifier | LOCATION03 | 15 |
InstancePeriod.LOCATION04 | Location identifier | LOCATION04 | 15 |
InstancePeriod.LOCATION05 | Location identifier | LOCATION05 | 15 |
InstancePeriod.LOCATION06 | Location identifier | LOCATION06 | 15 |
InstancePeriod.LOCATION07 | Location identifier | LOCATION07 | 15 |
InstancePeriod.LOCATION08 | Location identifier | LOCATION08 | 15 |
InstancePeriod.LOCATION09 | Location identifier | LOCATION09 | 15 |
InstancePeriod.LOCATION10 | Location identifier | LOCATION10 | 15 |
InstancePeriod.LOCSDY | Location of study | LOCSDY | 1 |
InstancePeriod.MODE | Mode of study | MODE | 2 |
InstancePeriod.MSTUFEE | Major source of tuition fees | MSTUFEE | 2 |
InstancePeriod.NOTACT | Suspension of active studies | NOTACT | 1 |
InstancePeriod.PERIODEND | Instance period end date | PERIODEND | 10 |
InstancePeriod.PERIODSTART | Instance period start date | PERIODSTART | 10 |
InstancePeriod.PRIPROV | Primary provider of teaching | PRIPROV | 8 |
InstancePeriod.STULOAD | Student instance FTE | STULOAD | 5 |
InstancePeriod.YEARPRG | Year of course | YEARPRG | 2 |
InstancePeriod.YEARSTU | Year of student on this instance | YEARSTU | 2 |
XDESIG02 | Designation marker - instance period level | XDESIG02 | 1 |
QUALIFICATIONS ON ENTRY register
Field name | Description | Element name in XML output | Field length |
QualificationsOnEntry.HUSID | HESA unique student identifier | HUSID | 13 |
QualificationsOnEntry.UKPRN | UK Provider Reference Number | UKPRN | 8 |
QualificationsOnEntry.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 |
QualificationsOnEntry.OWNQUAL | Provider's own internal identifier for the qualification | OWNQUAL | 20 |
QualificationsOnEntry.QUALGRADE | Qualification grade | QUALGRADE | 11 |
QualificationsOnEntry.QUALSBJ | Qualification subject | QUALSBJ | 3 |
QualificationsOnEntry.QUALSIT | Qualification sitting | QUALSIT | 1 |
QualificationsOnEntry.QUALTYPE | Qualification type | QUALTYPE | 2 |
QualificationsOnEntry.QUALYEAR | Qualification year | QUALYEAR | 4 |
XQEYEAR01 | Year QualificationsOnEntry last updated | XQEYEAR01 | 4 |
COURSE table
Field name | Description | Element name in XML output | Field length |
Provider.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Course.COURSEID | Course identifier | COURSEID | 30 |
Course.OWNCOURSEID | Own course identifier | OWNCOURSEID | 50 |
Course.AWARDBOD01 | Awarding body | AWARDBOD01 | 8 |
Course.AWARDBOD02 | Awarding body | AWARDBOD02 | 8 |
Course.AWARDBOD03 | Awarding body | AWARDBOD03 | 8 |
Course.AWARDBOD04 | Awarding body | AWARDBOD04 | 8 |
Course.AWARDBOD05 | Awarding body | AWARDBOD05 | 8 |
Course.AWARDBOD06 | Awarding body | AWARDBOD06 | 8 |
Course.AWARDBOD07 | Awarding body | AWARDBOD07 | 8 |
Course.AWARDBOD08 | Awarding body | AWARDBOD08 | 8 |
Course.COURSEAIM | General qualification aim of course | COURSEAIM | 3 |
Course.CTITLE | Course title | CTITLE | 255 |
Course.REGBODY01 | Regulatory body for health and social care students | REGBODY01 | 2 |
Course.REGBODY02 | Regulatory body for health and social care students | REGBODY02 | 2 |
Course.TTCID | Teacher training course | TTCID | 1 |
DELIVERY ORGANISATION AND LOCATION table
Field name | Description | Element name in XML output | Field length |
Provider.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Course.COURSEID | Course identifier | COURSEID | 30 |
Course.OWNCOURSEID | Own course identifier | OWNCOURSEID | 50 |
DeliveryOrganisationAndLocation.DELORG | Delivery organisation | DELORG | 8 |
DeliveryOrganisationAndLocation.DELORGPROP | Delivery organisation proportion | DELORGPROP | 5 |
DeliveryOrganisationAndLocation.PCODELOC | Postcode location | PCODELOC | 8 |
FINANCIAL SUPPORT table
Field name | Description | Element name in XML output | Field length |
Instance.InstanceKEY | Unique key for every student instance | InstanceKEY | 13 |
Provider.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.APPSPEND | Access and participation spending commitment | APPSPEND | 2 |
FinancialSupport.FINAMOUNT | Financial support amount | FINAMOUNT | 6 |
FinancialSupport.FINTYPE | Financial support amount | FINTYPE | 2 |
Need help?
Contact Liaison by email or on +44 (0)1242 388 531.