HESA Student record 2012/13
File structures for downloadable files
Version 1.1 Produced 2013-07-30
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 and 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 C12051 submission prefixed with the appropriate entity; Instance, Student, Course, Module, Subject, StudentOnModule, or QualificationsOnEntry.
- 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 |
| Course.COURSEID | Course identifier | COURSEID | 30 |
| Student.SEXID | Sex identifier | SEXID | 1 |
| Student.DISABLE | Disability | DISABLE | 2 |
| Student.ETHNIC | Ethnicity | ETHNIC | 2 |
| Student.BIRTHDTE | Date of birth | BIRTHDTE | 10 |
| Student.NATION | Nationality | NATION | 2 |
| Student.TTACCOM | Term-time accommodation | TTACCOM | 1 |
| Student.WELSSP | Welsh speaker indicator | WELSSP | 1 |
| Instance.REDUCEDI | Reduced instance return indicator | REDUCEDI | 2 |
| Instance.YEARPRG | Year of course | YEARPRG | 2 |
| Instance.YEARSTU | Year of student on this instance | YEARSTU | 2 |
| Instance.COMDATE | Start date of instance | COMDATE | 10 |
| Instance.ENDDATE | End date of instance | ENDDATE | 10 |
| Instance.RSNEND | Reason for ending instance | RSNEND | 2 |
| Instance.ITTPHSC | ITT phase/scope | ITTPHSC | 2 |
| Instance.ITTSCHMS | ITT schemes | ITTSCHMS | 1 |
| Instance.LOCSDY | Location of study | LOCSDY | 1 |
| Instance.DISALL | Disabled Student Allowance | DISALL | 1 |
| Instance.STULOAD | Student instance FTE | STULOAD | 5 |
| Instance.FEEELIG | Fee eligibility | FEEELIG | 1 |
| Instance.MSTUFEE | Major source of tuition fees | MSTUFEE | 2 |
| Instance.CAMPID | Campus identifier | CAMPID | 1 |
| Instance.NOTACT | Suspension of active studies | NOTACT | 1 |
| Instance.TYPEYR | Type of instance year | TYPEYR | 1 |
| Instance.FUNDCODE | Fundability code | FUNDCODE | 1 |
| Instance.FUNDCOMP | Completion of year of instance | FUNDCOMP | 1 |
| Instance.MODE | Mode of study | MODE | 2 |
| Instance.EXCHANGE | Exchange programmes | EXCHANGE | 1 |
| Instance.SPECFEE | Special fee indicator | SPECFEE | 1 |
| Instance.YEARLGTH | Length of current year of instance | YEARLGTH | 2 |
| EP_USE.QUALENT2 | Highest qualification on entry | QUALENT2 | 2 |
| EP_USE.QUALENT3 | Highest qualification on entry | QUALENT3 | 3 |
| EP_USE.POSTCODE | Postcode | POSTCODE | 8 |
| EP_USE.PREVINST | Last institution attended | PREVINST | 8 |
| EP_USE.NEWENT | New entrant to higher education | NEWENT | 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.SEC | Socio-economic classification | SEC | 1 |
| EP_USE.ACCESS | Access programmes | ACCESS | 1 |
| EP_USE.ARTICLN | Articulation | ARTICLN | 1 |
| EP_USE.NIDEPEND | Dependents on entry | NIDEPEND | 2 |
| EP_USE.MARSTAT | Marital status | MARSTAT | 2 |
| EP_USE.SOC2000 | Occupation code | SOC2000 | 4 |
| EP_USE.PARED | Parental education | PARED | 1 |
| EP_USE.RELIGION | Religion | RELIGION | 1 |
| 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 |
| Course.COURSEAIM | General qualification aim of course | COURSEAIM | 3 |
| Course.MSFUND | Major source of funding | MSFUND | 2 |
| Course.TTCID | Teacher training course | TTCID | 1 |
| Course.BITTM | Bilingual ITT marker | BITTM | 1 |
| Student.UCASPERID | UCAS personal identifier | UCASPERID | 10 |
| Instance.FEEREGIME | Fee regime indicator | FEEREGIME | 2 |
| Instance.GROSSFEE | Gross fee | GROSSFEE | 5 |
| Instance.NETFEE | Net fee | NETFEE | 5 |
| Instance.SSN | Student support number | SSN | 13 |
| XPSR01 | Standard registration population | XPSR01 | 1 |
| XFYRSR01 | First year identifier (to be used with XPSR01 only) | XFYRSR01 | 1 |
| XPDEC01 | Population at 1 December | XPDEC01 | 1 |
| XFYEAR01 | First year identifier (to be used with XPDEC01 only) | XFYEAR01 | 1 |
| XPSES01 | Session population | XPSES01 | 1 |
| XPQUAL01 | Qualifications obtained population | XPQUAL01 | 1 |
| 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 |
| XQOBTN01 | Highest qualification obtained | XQOBTN01 | 3 |
| XCLASS01 | Classification of qualification | XCLASS01 | 1 |
| 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 |
| XQLEV1003 | Level of qualification - 10 way split | XQLEV1003 | 2 |
| XQUALENT01 | Highest qualification on entry | XQUALENT01 | 1 |
| XOBTND01 | DLHE highest qualification obtained | XOBTND01 | 3 |
| XDOMUC01 | Domicile (country/unitary authority level) | XDOMUC01 | 4 |
| XDOMGR01 | Government Office Region of student Domicile | XDOMGR01 | 4 |
| XDOMHM01 | Domicile (participation by nation) | XDOMHM01 | 1 |
| XHOOS01 | Home/overseas student | XHOOS01 | 1 |
| XINSTG01 | Government Office Region of institution location | XINSTG01 | 1 |
| XINSTC01 | Country of institution | XINSTC01 | 1 |
| XAGEA01 | Age at 31 August in reporting year | XAGEA01 | 2 |
| XAGEJ01 | Age at 31 July in reporting year | XAGEJ01 | 2 |
| XAGRPA01 | Age grouping at 31 August in reporting year | XAGRPA01 | 1 |
| XAGRP601 | Age grouping at 31 August in reporting year - 6 way split | XAGRP601 | 1 |
| XAGRPJ01 | Age grouping at 31 July in reporting year | XAGRPJ01 | 1 |
| XELSP01 | Expected length of study programme | XELSP01 | 1 |
| XMODE01 | Mode of study | XMODE01 | 1 |
| XQMODE01 | Qualification obtained mode of study | XQMODE01 | 1 |
| XTARIFF | UCAS Tariff for general purposes | XTARIFF | 4 |
| XINSTID01 | Derived HESA institution identifier | XINSTID01 | 4 |
| XDOM01 | Domicile in Cyy051 coding frame | XDOM01 | 2 |
| XEPYEAR01 | Last year in which an Entry Profile for a HIN was supplied to HESA | XEPYEAR01 | 4 |
| XDOMREG01 | Analytical protocol domicile region | XDOMREG01 | 4 |
| XETHNIC01 | Analytical protocol ethnicity | XETHNIC01 | 2 |
| XMSFUND01 | Analytical protocol major source of funding | XMSFUND01 | 2 |
| XMSTUFEE01 | Analytical protocol major source of tuition fees | XMSTUFEE01 | 2 |
| XSTUDIS01 | Student disability | XSTUDIS01 | 1 |
| XNATGR01 | Geographic region of student nationality | XNATGR01 | 4 |
| XPDLHE02 | DLHE population for expanded coverage | XPDLHE02 | 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 |
| Student.OWNSTU | Institution's own identifier for student | OWNSTU | 20 |
| Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
| Instance.INSTCAMP | Institution's own campus identifier | INSTCAMP | 8 |
Download: XML Schema for CORE table file. Sample XML for 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 |
| XJACS01 | JACS subject by full person equivalent | XJACS01 | 4 |
| XFPE01 | JACS subject by full person equivalent | XFPE01 | 7 |
| XJACSA01 | JACS subject area | XJACSA01 | 1 |
| XJACS201 | JACS principal subject | XJACS201 | 3 |
| 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 |
| Instance.COURSEID | Course identifier | COURSEID | 30 |
Download: XML Schema for SUBJECT table file. Sample XML for 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 |
| 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 |
| Module.MODID | Module identifier | MODID | 30 |
Download: XML Schema for COST CENTRE table file. Sample XML for 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.MTITLE | Module title | MTITLE | 80 |
| Module.CRDTSCM | Credit transfer scheme | CRDTSCM | 1 |
| Module.CRDTPTS | Credit value of module | CRDTPTS | 3 |
| Module.LEVLPTS | Level of credit points | LEVLPTS | 1 |
| Module.MODLANG | Module taught in a Celtic language | MODLANG | 1 |
| Module.FTE | Module FTE | FTE | 5 |
| Module.TINST | Other institution providing teaching | TINST | 8 |
| Module.PCOLAB | Percentage not taught by this institution | PCOLAB | 5 |
| Module.FRANIND | Module franchise indicator | FRANIND | 1 |
Download: XML Schema for MODULE table file. Sample XML for 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 |
| QOE.QUALGRADE | Qualification grade | QUALGRADE | 11 |
| QOE.QUALSIT | Qualification sitting | QUALSIT | 1 |
| QOE.QUALSBJ | Qualification subject | QUALSBJ | 3 |
| QOE.QUALTYPE | Qualification type | QUALTYPE | 2 |
| QOE.QUALYEAR | Qualification year | QUALYEAR | 4 |
| XQEYEAR01 | Year QualificationsOnEntry last updated | XQEYEAR01 | 4 |
| Student.OWNSTU | Institution’s own identifier for student | OWNSTU | 20 |
| Instance.OWNINST | Institution’s own instance identifier | OWNINST | 30 |
Download: XML Schema for QUALIFICATIONS ON ENTRY table file. Sample XML for 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 |
| 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 |
| Student.OWNSTU | Institution’s own identifier for student | OWNSTU | 20 |
| Instance.OWNINST | Institution’s own instance identifier | OWNINST | 30 |
Download: XML Schema for STUDENT ON MODULE table file. Sample XML for 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.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.COURSEID | Course identifier | COURSEID | 30 |
| Course.CTITLE | Course title | CTITLE | 255 |
| Course.FEQAIMC | FE general qualification aim | FEQAIMC | 8 |
| Course.MSFUND | Major source of funding | MSFUND | 2 |
| Course.NHSBURSARY | NHS bursaries | NHSBURSARY | 1 |
| 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 COURSE table file. Sample XML for COURSE table file.
Contact Liaison by email or on +44 (0)1242 388 531.