HESA Student Record 2009/10
HESA Student Record 2009/10File structures for downloadable files |
return to index |
Version 1.0 Produced 2010-04-30
File Structure - Data supply
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 Cyy051 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 via the Aardvark system.
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.PGCECLSS | 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 |
XLEV601 | 1 | Level of study - 6 way split |
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 |
XQLEV601 | 1 | Level of qualification obtained - 6 way split |
XQLEV1003 | 2 | Analytical protocol level of qualification awarded - 10 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 |
XTARIFF04 | 4 | 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 |
Student.OWNSTU | 20 | |
Instance.OWNINST | 30 |
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 |
Instance.COURSEID | 30 |
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 | |
ModuleSubject.COSTCN | 2 | |
ModuleSubject.MODSBJ | 4 | |
XFTE01 | 5 | Full-time equivalent Subject by cost centre |
XJACS201 | 3 | JACS principal subject |
Module.MODID | 30 |
Contact Liaison by email or on +44 (0)1242 388 531.