Skip to main content

HESA Student Record 2008/09

Back to C08051

HESA Student Record 2008/09

File 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 1Standard registration population
XFYRSR01 1First Year within Standard Registration population
XPDEC01 1Population at 1 December
XFYEAR01 1First Year within 1st December population
XPSES01 1Session population
XPQUAL01 1Qualifications obtained population
XPDLHE01 1DLHE population
XLEV301 1Level of study - 3 way split
XLEV501 1Level of study - 5 way split
XLEV502 1Analytical protocol level of study - 5 way split
XLEV601 1Level of study - 6 way split
XLEV602 1Analytical protocol level of study - 6 way split
XLEV902 1Analytical protocol level of study - 9 way spilt
XQOBTN01 3Highest qualification obtained
XCLASS01 1Classification of qualification
XQLEV301 1Level of qualification obtained - 3 way spilt
XQLEV501 1Level of qualification obtained - 5 way split
XQLEV502 1Analytical protocol level of qualification awarded - 5 way split
XQLEV601 1Level of qualification obtained - 6 way split
XQLEV1003 2Analytical protocol level of qualification awarded - 10 way split
XQLEV1101 2Analytical protocol level of qualification awarded - 11 way split
XHQUAL01 1Highest qualification on entry
XOBTND01 3DLHE Highest qualification obtained
XDOMUC01 4Domicile (county level)
XDOMGR01 4Government office region of student domicile
XDOMHM01 1Domicile (participation by nation)
XHOOS01 1Home/overseas student
XINSTG01 1Government Office Region of Institution Location
XINSTC01 1Country of Institution
XAGEA01 2Age as at 31 August in reporting year
XAGEJ01 2Age as at 31 July in reporting year
XAGRPA01 1Age grouping as at 31 August in reporting period
XAGRP601 1Age grouping as at 31 August in reporting period - 6 way split
XAGRPJ01 1Age grouping as at 31 July in reporting period
XELSP01 1Expected length of study programme
XMODE01 1Mode of study
XQMODE01 1Qualification obtained mode of study
XTARIFF03 3TQI Tariff
XINSTID01 4Derived HESA Institution Identifier
XDOM01 2Domicile in Cyy051 coding frame
XEPYEAR01 4Last year in which and Entry Profile for a HIN was supplied to HESA
XDOMREG01 4Analytical protocol domicile region
XETHNIC01 2Analytical protocol ethnicity
XMSFUND01 2Analytical protocol major source of funding
XMSTUFEE01 2Analytical 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 4JACS subject
XFPE01 7Full person equivalent
XJACSA01 1JACS subject area
XJACS201 3JACS 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 5Full-time equivalent Subject by cost centre
XJACS201 3JACS principal subject


Contact Liaison by email or on +44 (0)1242 388 531.