Skip to main content

HESA Student Record 2009/10

Back to C09051

HESA Student Record 2009/10

File 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.