Student record 2014/15
File structures for downloadable files - Data supply
Version 1.0 Produced 2015-04-01
Ten 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 C14051 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.
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 tableBack to top
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 |
Student.BIRTHDTE | Date of birth | BIRTHDTE | 10 |
Student.DISABLE | Disability | DISABLE | 2 |
Student.ETHNIC | Ethnicity | ETHNIC | 2 |
Student.FNAMES | Forenames | FNAMES | 100 |
Student.GENDERID | Gender identity | GENDERID | 2 |
Student.NATION | Nationality | NATION | 2 |
Student.NATIOND1 | National identity | NATIOND1 | 1 |
Student.NATIOND2 | National identity | NATIOND2 | 1 |
Student.ORCID | ORCID identifier | ORCID | 19 |
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.WELBACC | Welsh Baccalaureate Advanced Diploma | WELBACC | 1 |
EP_USE.YRLLINST | Year left last institution | YRLLINST | 4 |
Instance.BRIDGE | Foundation degree to degree bridging course | BRIDGE | 1 |
Instance.CAMPID | Campus identifier | CAMPID | 1 |
Instance.COMDATE | Start date of instance | COMDATE | 10 |
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.EXCHANGE | Exchange programmes | EXCHANGE | 1 |
Instance.FEEELIG | Fee eligibility | FEEELIG | 1 |
Instance.FEEREGIME | Fee regime indicator | FEEREGIME | 2 |
Instance.FESTUMK | FE student marker | FESTUMK | 1 |
Instance.FTEMETHOD | FTE method | FTEMETHOD | 1 |
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.GROSSFEE | Gross fee | GROSSFEE | 6 |
Instance.HEAPESPOP | HEAPES population | HEAPESPOP | 1 |
Instance.INITIATIVES1 | Initiatives | INITIATIVES1 | 1 |
Instance.INITIATIVES2 | Initiatives | INITIATIVES2 | 1 |
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.ITTPHSC | ITT phase/scope | ITTPHSC | 2 |
Instance.ITTSCHMS | ITT schemes | ITTSCHMS | 1 |
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.PHDSUB | PhD submission date | PHDSUB | 10 |
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.SKEITT | Subject Knowledge Enhancement institution | SKEITT | 8 |
Instance.SPECFEE | Special fee indicator | SPECFEE | 1 |
Instance.SPLENGTH | Expected length of study | SPLENGTH | 2 |
Instance.SSELIG | Student support eligibility | SSELIG | 1 |
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.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 |
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 |
XDLEV301 | Level of qualification in DLHE - 3 way split | XDLEV301 | 1 |
XDLEV501 | Level of qualification in DLHE - 5 way split | XDLEV501 | 1 |
XDLEV601 | Level of qualification in DLHE - 6 way split | XDLEV601 | 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 |
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 |
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 |
XOBTND01 | DLHE highest qualification obtained | XOBTND01 | 3 |
XPDEC01 | Population at 1 December | XPDEC01 | 1 |
XPDLHE02 | DLHE 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 |
XQUALENT01 | Highest qualification on entry | XQUALENT01 | 1 |
XSTUDIS01 | Student disability | XSTUDIS01 | 1 |
XTARIFF | UCAS Tariff for general purposes | XTARIFF | 4 |
XTARIFFGP01 | Tariff analysis groupings | XTARIFFGP01 | 2 |
Download: XML Schema for the CORE table file.
SUBJECT tableBack to top
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 |
Instance.COURSEID | Course identifier | COURSEID | 30 |
Course.OWNCOURSEID | Own course identifier | OWNCOURSEID | 50 |
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 tableBack to top
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 of module | 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 tableBack to top
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 registerBack to top
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.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 tableBack to top
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 tableBack to top
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.REGBODY | Regulatory body for health and social care students | REGBODY | 2 |
Course.SKEOS | Subject Knowledge Enhancement placement | SKEOS | 1 |
Course.SKEUNITS | Subject Knowledge Enhancement units | SKEUNITS | 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 tableBack to top
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 tableBack to top
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 tableBack to top
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.
Need help?
Contact Liaison by email or on +44 (0)1242 388 531.