Alternative provider student record 2014/15
File structures for downloadable files - Data supply
Version 1.0 Produced 2015-09-02
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 tableBack to top
| Field name | Description | Element name in XML output | Field length |
| Instance.InstanceKEY | Unique key for every student instance | InstanceKEY | 13 |
| Instance.SUBPURPOSE | Submission purpose | SUBPURPOSE | 1 |
| 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 |
| Course.COURSEAIM | General qualification aim of course | COURSEAIM | 3 |
| Course.TTCID | Teacher training course | 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.HEAPESPOP | HEAPES population | HEAPESPOP | 1 |
| Instance.LOCATION01 | Location identifier | LOCATION01 | 15 |
| Instance.LOCATION02 | Location identifier | LOCATION02 | 15 |
| Instance.LOCATION03 | Location identifier | LOCATION03 | 15 |
| Instance.LOCATION04 | Location identifier | LOCATION04 | 15 |
| Instance.LOCATION05 | Location identifier | LOCATION05 | 15 |
| Instance.LOCATION06 | Location identifier | LOCATION06 | 15 |
| Instance.LOCATION07 | Location identifier | LOCATION07 | 15 |
| Instance.LOCATION08 | Location identifier | LOCATION08 | 15 |
| Instance.LOCATION09 | Location identifier | LOCATION09 | 15 |
| Instance.LOCATION10 | Location identifier | LOCATION10 | 15 |
| 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.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.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 |
| XDESIG01 | Designation marker | XDESIG01 | 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 |
| XGROSSFEE01 | Sum of GROSSFEE values for the reporting period | XGROSSFEE01 | 7 |
| 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 |
| XNETFEE01 | Sum of GROSSFEE values for the reporting period | XNETFEE01 | 7 |
| 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 |
| ZSTARTMONTH | Start month of instance | ZSTARTMONTH | 2 |
| ZNOTEND | Withdrawn or suspended | ZNOTEND | 1 |
SUBJECT tableBack to top
| 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 tableBack to top
| 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.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 |
QUALIFICATIONS ON ENTRY registerBack to top
| 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 tableBack to top
| 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.