Alternative provider student record 2015/16
File structures for downloadable files - Data supply
Version 1.0 Produced 2016-08-04
Five data tables are supplied in CSV and XML format. The CORE table contains the majority of fields. Separately provided are the SUBJECT table, an INSTANCE PERIOD table, and a COURSE table.
Also provided is a QUALIFICATIONS ON ENTRY Register which details the qualifications on entry data returned for each instance.
The tables contain the following types of field:
- Instance.InstanceKEY which is a unique key within the database and is used to link records across tables
- Base fields from the C14054 submission prefixed with the appropriate entity
- 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 or Z, are standard ways of grouping data. View details of the derived field specifications.
- QOE fields are the Qualification On Entry Register fields collected for new entrants, and which may be updated in subsequent years if the data submitted originally is found to be incorrect.
The field names for each table are given in the first line of each downloadable file ready for use in creating pivot tables. The HESA website provides guidance on creating and using pivot tables.
CORE table
| Field name | Description | Element name in XML output | Field length |
| Instance.InstanceKEY | Unique key for every student instance | InstanceKEY | 13 |
| Provider.UKPRN | UK Provider Reference Number | UKPRN | 8 |
| Student.HUSID | HESA unique student identifier | HUSID | 13 |
| Instance.NUMHUS | Student instance identifier | NUMHUS | 20 |
| Student.OWNSTU | Institution's own identifier for student | OWNSTU | 20 |
| Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
| Course.COURSEID | Course identifier (from latest InstancePeriod) | COURSEID | 30 |
| Course.OWNCOURSEID | Own course identifier (from latest InstancePeriod) | OWNCOURSEID | 50 |
| Course.COURSEAIM | General qualification aim of course (from latest InstancePeriod) | COURSEAIM | 3 |
| Course.TTCID | Teacher training course (from latest InstancePeriod) | TTCID | 1 |
| Student.BIRTHDTE | Date of birth | BIRTHDTE | 10 |
| Student.SURNAME | Family name | SURNAME | 100 |
| Student.FNAMES | Forenames | FNAMES | 100 |
| Student.SSN | Student support number | SSN | 13 |
| Student.ULN | Unique Learner Number | ULN | 10 |
| StudentEquality.DISABLE | Disability | DISABLE | 2 |
| StudentEquality.ETHNIC | Ethnicity | ETHNIC | 2 |
| StudentEquality.GENDERID | Gender identity | GENDERID | 2 |
| StudentEquality.NATION | Nationality | NATION | 2 |
| StudentEquality.RELBLF | Religion or belief | RELBLF | 2 |
| StudentEquality.SCN | Scottish Candidate Number | SCN | 9 |
| StudentEquality.SEXID | Sex identifier | SEXID | 1 |
| StudentEquality.SEXORT | Sexual orientation | SEXORT | 2 |
| EP_USE.DOMICILE | Domicile | DOMICILE | 2 |
| EP_USE.POSTCODE | Postcode | POSTCODE | 8 |
| EP_USE.PREVINST | Last institution attended | PREVINST | 8 |
| EP_USE.QUALENT3 | Highest qualification on entry | QUALENT3 | 3 |
| 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.SPLENGTH | Expected length of study | SPLENGTH | 2 |
| Instance.UNITLGTH | Units of length | UNITLGTH | 1 |
| InstancePeriod.InstancePeriodKEY | Unique key for every student instance period | InstancePeriodKEY | 13 |
| Latest InstancePeriod.DISALL | Disabled Student Allowance | DISALL | 1 |
| Latest InstancePeriod.EXCHIND | Exchange programmes | EXCHIND | 1 |
| Latest InstancePeriod.GROSSFEE | Gross fee | GROSSFEE | 6 |
| Latest InstancePeriod.HEAPESPOP | HEAPES population | HEAPESPOP | 1 |
| Latest InstancePeriod.LOCATION01 | Location identifier | LOCATION01 | 15 |
| Latest InstancePeriod.LOCATION02 | Location identifier | LOCATION02 | 15 |
| Latest InstancePeriod.LOCATION03 | Location identifier | LOCATION03 | 15 |
| Latest InstancePeriod.LOCATION04 | Location identifier | LOCATION04 | 15 |
| Latest InstancePeriod.LOCATION05 | Location identifier | LOCATION05 | 15 |
| Latest InstancePeriod.LOCATION06 | Location identifier | LOCATION06 | 15 |
| Latest InstancePeriod.LOCATION07 | Location identifier | LOCATION07 | 15 |
| Latest InstancePeriod.LOCATION08 | Location identifier | LOCATION08 | 15 |
| Latest InstancePeriod.LOCATION09 | Location identifier | LOCATION09 | 15 |
| Latest InstancePeriod.LOCATION10 | Location identifier | LOCATION10 | 15 |
| Latest InstancePeriod.LOCSDY | Location of study | LOCSDY | 1 |
| Latest InstancePeriod.MODE | Mode of study | MODE | 2 |
| Latest InstancePeriod.MSTUFEE | Major source of tuition fees | MSTUFEE | 2 |
| Latest InstancePeriod.NETFEE | Net fee | NETFEE | 6 |
| Latest InstancePeriod.NOTACT | Suspension of active studies | NOTACT | 1 |
| Latest InstancePeriod.PERIODEND | Instance period end date | PERIODEND | 10 |
| Latest InstancePeriod.PERIODSTART | Instance period start date | PERIODSTART | 10 |
| Latest InstancePeriod.PRIPROV | Primary provider of teaching | PRIPROV | 8 |
| Latest InstancePeriod.SSELIG | Student support eligibility | SSELIG | 1 |
| Latest InstancePeriod.YEARPRG | Year of course | YEARPRG | 2 |
| Latest InstancePeriod.YEARSTU | Year of student on this instance | YEARSTU | 2 |
| XAGEA01 | Age at 31 August in reporting year | XAGEA01 | 2 |
| XAGEJ01 | Age at 31 July in reporting year | XAGEJ01 | 2 |
| XAGRP601 | Age grouping at 31 August in reporting year - 6 way split | XAGRP601 | 1 |
| XAGRPA01 | Age grouping at 31 August in reporting year | XAGRPA01 | 1 |
| XAGRPJ01 | Age grouping at 31 July in reporting year | XAGRPJ01 | 1 |
| XCLASS01 | Classification of qualification | XCLASS01 | 1 |
| XCLASSF01 | Classification of qualification | XCLASSF01 | 2 |
| XDESIG02 | Designation marker - instance period level (from latest InstancePeriod) | XDESIG02 | 1 |
| XDESIG03 | Designation marker - instance level | XDESIG03 | 1 |
| XDLEV301 | Level of qualification in DLHE - 3 way split | XDLEV301 | 1 |
| XDLEV501 | Level of qualification in DLHE - 5 way split | XDLEV501 | 1 |
| XDLEV601 | Level of qualification in DLHE - 6 way split | XDLEV601 | 1 |
| XDOM01 | Domicile in Cyy051 coding frame | XDOM01 | 2 |
| XDOMGR01 | Government Office Region of student Domicile | XDOMGR01 | 4 |
| XDOMGR401 | Region of student domicile - 4 way grouping | XDOMGR401 | 1 |
| XDOMHM01 | Domicile (participation by nation) | XDOMHM01 | 1 |
| XDOMREG01 | Analytical protocol domicile region | XDOMREG01 | 4 |
| XDOMUC01 | Domicile (country/unitary authority level) | XDOMUC01 | 4 |
| XELSP01 | Expected length of study programme | XELSP01 | 1 |
| XEPYEAR01 | Last year in which an Entry Profile for a HIN was supplied to HESA | XEPYEAR01 | 4 |
| XETHNIC01 | Analytical protocol ethnicity | XETHNIC01 | 2 |
| XFYEAR01 | First year identifier (to be used with XPDEC01 only) | XFYEAR01 | 1 |
| XFYRSR01 | First year identifier (to be used with XPSR01 only) | XFYRSR01 | 1 |
| XHOOS01 | Home/overseas student | XHOOS01 | 1 |
| XINACT01 | Inactive for entire reporting year | XINACT01 | 1 |
| XINSTC01 | Country of institution | XINSTC01 | 1 |
| XINSTG01 | Government Office Region of institution location | XINSTG01 | 1 |
| XINSTID01 | Derived HESA institution identifier | XINSTID01 | 4 |
| 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 |
| XMODE02 | Mode of study | XMODE02 | 1 |
| XMODE301 | Mode of study - three way grouping | XMODE301 | 1 |
| XMSTUFEE01 | Analytical protocol major source of tuition fees | XMSTUFEE01 | 2 |
| XOBTND01 | DLHE highest qualification obtained | XOBTND01 | 3 |
| XPDEC01 | Population at 1 December | XPDEC01 | 1 |
| XPDLHE02 | DLHE population for expanded coverage | XPDLHE02 | 1 |
| XPQUAL01 | Qualifications obtained population | XPQUAL01 | 1 |
| XPSES01 | Session population | XPSES01 | 1 |
| XPSR01 | Standard registration population | XPSR01 | 1 |
| XQLEV1003 | Level of qualification - 10 way split | XQLEV1003 | 2 |
| 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 |
| XQLEV701 | Level of qualification - 7 way split | XQLEV701 | 1 |
| XQMODE01 | Qualification obtained mode of study | XQMODE01 | 1 |
| XQOBTN01 | Highest qualification obtained | XQOBTN01 | 3 |
| XQUALENT01 | Highest qualification on entry | XQUALENT01 | 1 |
| XSTUDIS01 | Student disability | XSTUDIS01 | 1 |
| XSTULOAD01 | Sum of student instance FTE for reporting period | XSTULOAD01 | 5 |
| XTARIFF | UCAS Tariff for general purposes | XTARIFF | 4 |
| XTARIFFGP01 | Tariff analysis groupings | XTARIFFGP01 | 2 |
| XUHN01 | UKPRN-HUSID-NUMHUS combination | XUHN01 | 41 |
| ZSTARTMONTH | Start month of instance | ZSTARTMONTH | 2 |
| ZNOTEND | Withdrawn or suspended | ZNOTEND | 1 |
SUBJECT table
| Field name | Description | Element name in XML output | Field length |
| Provider.UKPRN | UK Provider Reference Number | UKPRN | 8 |
| Course.COURSEID | Course identifier | COURSEID | 30 |
| Course.OWNCOURSEID | Own course identifier | OWNCOURSEID | 50 |
| XFPE01 | JACS subject by full person equivalent | XFPE01 | 7 |
| XJACS01 | JACS subject by full person equivalent | XJACS01 | 4 |
| XJACS201 | JACS principal subject | XJACS201 | 3 |
| XJACSA01 | JACS subject area | XJACSA01 | 1 |
| XJACSLEV101 | Analytical protocol JACS - level 1 grouping | XJACSLEV101 | 1 |
| XJACSLEV201 | Analytical protocol JACS - level 2 grouping | XJACSLEV201 | 2 |
| XJACSLEV301 | Analytical protocol JACS - level 3 grouping | XJACSLEV301 | 3 |
INSTANCE PERIOD table
| Field name | Description | Element name in XML output | Field length |
| Instance.InstanceKEY | Unique key for every student instance | InstanceKEY | 13 |
| Latest InstancePeriod.InstancePeriodKEY | Unique key for every student instance period | InstancePeriodKEY | 13 |
| Provider.UKPRN | UK Provider Reference Number | UKPRN | 8 |
| Student.HUSID | HESA unique student identifier | HUSID | 13 |
| Instance.NUMHUS | Student instance identifier | NUMHUS | 20 |
| Student.OWNSTU | Institution's own identifier for student | OWNSTU | 20 |
| Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
| Course.COURSEID | Course identifier | COURSEID | 30 |
| Course.OWNCOURSEID | Own course identifier | OWNCOURSEID | 50 |
| InstancePeriod.DISALL | Disabled Student Allowance | DISALL | 1 |
| InstancePeriod.EXCHIND | Exchange programmes | EXCHIND | 1 |
| InstancePeriod.GROSSFEE | Gross fee | GROSSFEE | 6 |
| InstancePeriod.HEAPESPOP | HEAPES population | HEAPESPOP | 1 |
| InstancePeriod.LOCATION01 | Location identifier | LOCATION01 | 15 |
| InstancePeriod.LOCATION02 | Location identifier | LOCATION02 | 15 |
| InstancePeriod.LOCATION03 | Location identifier | LOCATION03 | 15 |
| InstancePeriod.LOCATION04 | Location identifier | LOCATION04 | 15 |
| InstancePeriod.LOCATION05 | Location identifier | LOCATION05 | 15 |
| InstancePeriod.LOCATION06 | Location identifier | LOCATION06 | 15 |
| InstancePeriod.LOCATION07 | Location identifier | LOCATION07 | 15 |
| InstancePeriod.LOCATION08 | Location identifier | LOCATION08 | 15 |
| InstancePeriod.LOCATION09 | Location identifier | LOCATION09 | 15 |
| InstancePeriod.LOCATION10 | Location identifier | LOCATION10 | 15 |
| InstancePeriod.LOCSDY | Location of study | LOCSDY | 1 |
| InstancePeriod.MODE | Mode of study | MODE | 2 |
| InstancePeriod.MSTUFEE | Major source of tuition fees | MSTUFEE | 2 |
| InstancePeriod.NETFEE | Net fee | NETFEE | 6 |
| InstancePeriod.NOTACT | Suspension of active studies | NOTACT | 1 |
| InstancePeriod.PERIODEND | Instance period end date | PERIODEND | 10 |
| InstancePeriod.PERIODSTART | Instance period start date | PERIODSTART | 10 |
| InstancePeriod.PRIPROV | Primary provider of teaching | PRIPROV | 8 |
| InstancePeriod.SSELIG | Student support eligibility | SSELIG | 1 |
| InstancePeriod.STULOAD | Student instance FTE | STULOAD | 5 |
| InstancePeriod.YEARPRG | Year of course | YEARPRG | 2 |
| InstancePeriod.YEARSTU | Year of student on this instance | YEARSTU | 2 |
| XDESIG02 | Designation marker - instance period level | XDESIG02 | 1 |
QUALIFICATIONS ON ENTRY register
| Field name | Description | Element name in XML output | Field length |
| QOE.HUSID | HESA unique student identifier | HUSID | 13 |
| QOE.UKPRN | UK Provider Reference Number | UKPRN | 8 |
| QOE.NUMHUS | Student instance identifier | NUMHUS | 20 |
| Student.OWNSTU | Institution’s own identifier for student | OWNSTU | 20 |
| Instance.OWNINST | Institution’s own instance identifier | OWNINST | 30 |
| QOE.QUALGRADE | Qualification grade | QUALGRADE | 11 |
| QOE.QUALSBJ | Qualification subject | QUALSBJ | 3 |
| QOE.QUALSIT | Qualification sitting | QUALSIT | 1 |
| QOE.QUALTYPE | Qualification type | QUALTYPE | 2 |
| QOE.QUALYEAR | Qualification year | QUALYEAR | 4 |
| XQEYEAR01 | Year QualificationsOnEntry last updated | XQEYEAR01 | 4 |
COURSE table
| Field name | Description | Element name in XML output | Field length |
| Provider.UKPRN | UK Provider Reference Number | UKPRN | 8 |
| Course.COURSEID | Course identifier | COURSEID | 30 |
| Course.OWNCOURSEID | Own course identifier | OWNCOURSEID | 50 |
| Course.COURSEAIM | General qualification aim of course | COURSEAIM | 3 |
| Course.CTITLE | Course title | CTITLE | 255 |
| Course.REGBODY | Regulatory body for health and social care students | REGBODY | 2 |
| Course.TTCID | Teacher training course | TTCID | 1 |
Need help?
Contact Liaison by email or on +44 (0)1242 388 531.