HESA Student Record 2008/09
HESA Student Record 2008/09File structures for downloadable files |
return to index |
Version 1.1 Produced 2009-07-30
File Structure - Data tables
Three data tables are supplied in CSV format. The CORE table contains the majority of fields excluding subject information, which is held in the SUBJECT table and cost centre information which is held in the COST CENTRE 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 C08051 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 have been 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 in a zipped file in July.
Core table
Field name | Field length | Derived field description |
Instance.INSTANCEKEY | 13 | Unique key for every student instance |
Institution.UKPRN | 8 | |
Student.HUSID | 13 | |
Instance.NUMHUS | 20 | |
Course.COURSEID | 30 | |
Student.GENDER | 1 | |
Student.DISABLE | 2 | |
Student.ETHNIC | 2 | |
Student.BIRTHDTE | 10 | |
Student.NATION | 2 | |
Student.TTACCOM | 1 | |
Student.WELSSP | 1 | |
Instance.REDUCEDI | 2 | |
Instance.YEARPRG | 2 | |
Instance.YEARSTU | 2 | |
Instance.COMDATE | 10 | |
Instance.ENDDATE | 10 | |
Instance.RSNEND | 2 | |
Instance.ITTPHSC | 2 | |
Instance.ITTSCHMS | 1 | |
Instance.LOCSDY | 1 | |
Instance.DISALL | 1 | |
Instance.STULOAD | 5 | |
Instance.FEEELIG | 1 | |
Instance.MSTUFEE | 2 | |
Instance.CAMPID | 1 | |
Instance.NOTACT | 1 | |
Instance.TYPEYR | 1 | |
Instance.FUNDCODE | 1 | |
Instance.FUNDCOMP | 1 | |
Instance.MODE | 2 | |
Instance.EXCHANGE | 1 | |
Instance.SPECFEE | 1 | |
Instance.YEARLGTH | 2 | |
EP_USE.QUALENT2 | 2 | |
EP_USE.POSTCODE | 8 | |
EP_USE.PREVINST | 8 | |
EP_USE.NEWENT | 1 | |
EP_USE.PGCECLS | 2 | |
EP_USE.PGCESBJ1 | 4 | |
EP_USE.PGCESBJ2 | 4 | |
EP_USE.PGCESBJ3 | 4 | |
EP_USE.SEC | 1 | |
EP_USE.ACCESS | 1 | |
EP_USE.ARTICLN | 1 | |
EP_USE.NIDEPEND | 2 | |
EP_USE.MARSTAT | 2 | |
EP_USE.SOC2000 | 4 | |
EP_USE.PARED | 1 | |
EP_USE.RELIGION | 1 | |
EP_USE.UCASAPPID | 9 | |
EP_USE.WELBACC | 1 | |
EP_USE.YRLLINST | 4 | |
Course.COURSEAIM | 3 | |
Course.MSFUND | 2 | |
Course.TTCID | 1 | |
Course.BITTM | 1 | |
XPSR01 | 1 | Standard registration population |
XFYRSR01 | 1 | First Year within Standard Registration population |
XPDEC01 | 1 | Population at 1 December |
XFYEAR01 | 1 | First Year within 1st December population |
XPSES01 | 1 | Session population |
XPQUAL01 | 1 | Qualifications obtained population |
XPDLHE01 | 1 | DLHE population |
XLEV301 | 1 | Level of study - 3 way split |
XLEV501 | 1 | Level of study - 5 way split |
XLEV502 | 1 | Analytical protocol level of study - 5 way split |
XLEV601 | 1 | Level of study - 6 way split |
XLEV602 | 1 | Analytical protocol level of study - 6 way split |
XLEV902 | 1 | Analytical protocol level of study - 9 way spilt |
XQOBTN01 | 3 | Highest qualification obtained |
XCLASS01 | 1 | Classification of qualification |
XQLEV301 | 1 | Level of qualification obtained - 3 way spilt |
XQLEV501 | 1 | Level of qualification obtained - 5 way split |
XQLEV502 | 1 | Analytical protocol level of qualification awarded - 5 way split |
XQLEV601 | 1 | Level of qualification obtained - 6 way split |
XQLEV1003 | 2 | Analytical protocol level of qualification awarded - 10 way split |
XQLEV1101 | 2 | Analytical protocol level of qualification awarded - 11 way split |
XHQUAL01 | 1 | Highest qualification on entry |
XOBTND01 | 3 | DLHE Highest qualification obtained |
XDOMUC01 | 4 | Domicile (county level) |
XDOMGR01 | 4 | Government office region of student domicile |
XDOMHM01 | 1 | Domicile (participation by nation) |
XHOOS01 | 1 | Home/overseas student |
XINSTG01 | 1 | Government Office Region of Institution Location |
XINSTC01 | 1 | Country of Institution |
XAGEA01 | 2 | Age as at 31 August in reporting year |
XAGEJ01 | 2 | Age as at 31 July in reporting year |
XAGRPA01 | 1 | Age grouping as at 31 August in reporting period |
XAGRP601 | 1 | Age grouping as at 31 August in reporting period - 6 way split |
XAGRPJ01 | 1 | Age grouping as at 31 July in reporting period |
XELSP01 | 1 | Expected length of study programme |
XMODE01 | 1 | Mode of study |
XQMODE01 | 1 | Qualification obtained mode of study |
XTARIFF03 | 3 | TQI Tariff |
XINSTID01 | 4 | Derived HESA Institution Identifier |
XDOM01 | 2 | Domicile in Cyy051 coding frame |
XEPYEAR01 | 4 | Last year in which and Entry Profile for a HIN was supplied to HESA |
XDOMREG01 | 4 | Analytical protocol domicile region |
XETHNIC01 | 2 | Analytical protocol ethnicity |
XMSFUND01 | 2 | Analytical protocol major source of funding |
XMSTUFEE01 | 2 | Analytical protocol major source of tuition fees |
Subject table
Field name | Field length | Derived field description |
Instance.INSTANCEKEY | 13 | Unique key for every student instance |
Institution.UKPRN | 8 | |
Student.HUSID | 13 | |
Instance.NUMHUS | 20 | |
XJACS01 | 4 | JACS subject |
XFPE01 | 7 | Full person equivalent |
XJACSA01 | 1 | JACS subject area |
XJACS201 | 3 | JACS principal subject |
Cost centre table
Field name | Field length | Derived field description |
Instance.INSTANCEKEY | 13 | Unique key for every student instance |
Institution.UKPRN | 8 | |
Student.HUSID | 13 | |
Instance.NUMHUS | 20 | |
Module.COSTCN | 2 | |
Module.MODSBJ | 4 | |
XFTE01 | 5 | Full-time equivalent Subject by cost centre |
XJACS201 | 3 | JACS principal subject |
Contact Liaison by email or on +44 (0)1242 388 531.