Student record 2013/14
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.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.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.QUALENT2 | Highest qualification on entry | QUALENT2 | 2 |
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.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.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.INITIATIVES1 | Initiatives | INITIATIVES1 | 1 |
Instance.INITIATIVES2 | Initiatives | INITIATIVES2 | 1 |
Instance.INSTCAMP | Institution's own campus identifier | INSTCAMP | 8 |
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.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.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 |
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 |
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 |
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 |
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 |
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.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.
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.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.
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.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.
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.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.
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.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.
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.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.
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.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.
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.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.
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.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.UOA2014 | REF unit of assessment | UOA2014 | 3 |
REFData.UOAPCNT | Unit of assessment percentage | UOAPCNT | 5 |
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.