HESA Student Record 2010/11
HESA Student Record 2010/11File structures for downloadable files |
return to index |
Version 1.1 Produced 2011-05-06
File Structure - Data supply
Four data tables are supplied in CSV and XML format. The CORE table contains the majority of fields excluding subject information, which is held in the SUBJECT table, cost centre information which is held in the COST CENTRE table and module information which is held in the MODULE table.
The tables contain the following types of field:
- Instance.INSTANCEKEY which is a unque key within the database and is used to link records across tables
- Base fields from the C10051 submission prefixed with the appropriate entity; Instance, Student, Course or Module Subject
- 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. Specifications including a contents list will be provided via the Aardvark system.
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.GENDER | Gender | GENDER | 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 |
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 |
XPDLHE01 | DLHE population | XPDLHE01 | 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 |
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 |
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 | 2 |
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 |
Download: XML Schema for Module table file. Sample XML for Module table file.
Contact Liaison by email or on +44 (0)1242 388 531.