Student record 2017/18
File structures for downloadable files - Unistats
Version 1.0 Produced 2018-06-29
The subject data used in tables 1, 2 and 4 is based on JACS 3.0. Subject data used in table 3 is based on JACS 2.0.
Unistats derived field specifications may be downloaded from the derived field specifications page, under the 'Unistats' section.
File structure: Table 1 - Entry information for first year undergraduates
Files are produced in XML format.
Field name | Description | Element name in XML output | Field length |
InstanceKEY | System generated identifier | InstanceKEY | 13 |
Student.HUSID | HESA unique student identifier | HUSID | 13 |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Course.COURSEID | Course identifier | COURSEID | 30 |
UNISTATS_TPROV | Unistats HE provider delivering majority of teaching in current year | UNISTATS_TPROV | 8 |
Instance.NUMHUS | Student instance number | NUMHUS | 20 |
UNISTATS_XJACS203 | JACS principal subject | UNISTATS_XJACS203 | 3 |
XJACSLEV101 | 21 JACS subject groups (Level 1) | XJACSLEV101 | 1 |
XJACSLEV201 | 42 JACS subject groups (Level 2) | XJACSLEV201 | 2 |
XJACSLEV301 | 108 JACS subject groups (Level 3) | XJACSLEV301 | 3 |
UNISTATS_PROGTYPE | Unistats programme type | UNISTATS_PROGTYPE | 1 |
UNISTATS_XLEV501 | Unistats level of study | UNISTATS_XLEV501 | 1 |
UNISTATS_MODE | Unistats mode of study | UNISTATS_MODE | 1 |
UNISTATS_HIQUAL2 | Unistats highest qualification on entry | UNISTATS_HIQUAL2 | 2 |
UNISTATS_ITT | Unistats ITT student identifier | UNISTATS_ITT | 1 |
COUNTER | Percentage of a student registration (Full Person Equivalence) | COUNTER | 7 |
Table 1 filters:
HESA Standard Registration population (HE records only) (XPSR01 = 1)
First year students (XFYRSR01=1)
First degree and other undergraduate level only (XLEV501 = 3 or 4)
Exclude Early Years Teacher Status (EYTS) where the scheme is EYITT Graduate Entry, EYITT Graduate employment-based, EYITT Assessment Only (NOT (Course.COURSEAIM = I73 and Instance.INITIATIVES = F, G or I))
Exclude HNC students (NOT Course.COURSEAIM = C30)
Full-time and part-time students (XMODE01 = 1, 2 or 3).
Download: XML Schema for Unistats Table 1.
File structure: Table 2 - Full-time first year undergraduates under 21 years with tariff qualifications
Files are produced in XML format.
Field name | Description | Element name in XML output | Field length |
InstanceKEY | System generated identifier | InstanceKEY | 13 |
Student.HUSID | HESA unique student identifier | HUSID | 13 |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Course.COURSEID | Course identifier | COURSEID | 30 |
UNISTATS_TPROV | Unistats HE provider delivering majority of teaching in current year | UNISTATS_TPROV | 8 |
Instance.NUMHUS | Student instance number | NUMHUS | 20 |
UNISTATS_XJACS203 | JACS principal subject | UNISTATS_XJACS203 | 3 |
XJACSLEV101 | 21 JACS subject groups (Level 1) | XJACSLEV101 | 1 |
XJACSLEV201 | 42 JACS subject groups (Level 2) | XJACSLEV201 | 2 |
XJACSLEV301 | 108 JACS subject groups (Level 3) | XJACSLEV301 | 3 |
UNISTATS_PROGTYPE | Unistats programme type | UNISTATS_PROGTYPE | 1 |
UNISTATS_XLEV501 | Unistats level of study | UNISTATS_XLEV501 | 1 |
UNISTATS_TARIFF_SCORE (XTPOINTS01) | Unistats tariff score | UNISTATS_TARIFF_SCORE | 4 |
UNISTATS_ITT | Unistats ITT student identifier | UNISTATS_ITT | 1 |
COUNTER | Percentage of a student registration (Full Person Equivalence) | COUNTER | 7 |
Table filter:
HESA Standard Registration population (HE records only) (Student.XPSR01 = 1)
First year students (Student.XFYRSR01=1)
First degree and other undergraduate level only (Student.XLEV501 = 3 or 4)
Exclude Early Years Teacher Status (EYTS) where the scheme is EYITT Graduate Entry, EYITT Graduate employment-based, EYITT Assessment Only (NOT (Course.COURSEAIM = I73 and Instance.INITIATIVES = F, G or I))
Exclude HNC students (NOT Course.COURSEAIM = C30)
Full-time and sandwich only (Student.XMODE01 = 1 or 2)
Under 21 years of age (Student.XAGRP601 =1, 2)
Highest qualification on entry (EntryProfile.QUALENT3) LIKE P% AND P92
Total tariff points Instance_Derive.XTPOINTS 0000, (numeric value of Instance_Derive. XTPOINTS >0)
Download: XML Schema for Unistats Table 2.
File structure: Table 3 - Continuation information
Files are produced in XML format.
Field name | Description | Element name in XML output | Field length |
Y1.InstanceKEY | System generated identifier | InstanceKEY_Y1 | 13 |
Y1.HUSID | HESA unique student identifier | HUSID_Y1 | 13 |
Y1.UKPRN | UK Provider Reference Number | UKPRN_Y1 | 8 |
Y1.COURSEID | Course identifier | COURSEID_Y1 | 30 |
Y1.UNISTATS_TPROV_Y1 | Unistats provider delivering majority of teaching in year 1 | UNISTATS_TPROV_Y1 | 8 |
Y1.NUMHUS | Student instance number | NUMHUS_Y1 | 20 |
Y1.UNISTATS_XJACS203 | JACS principal subject | UNISTATS_XJACS203_Y1 | 3 |
Y1.XJACSLEV101 | 21 JACS subject groups (Level 1) | XJACSLEV101_Y1 | 1 |
Y1.XJACSLEV201 | 42 JACS subject groups (Level 2) | XJACSLEV201_Y1 | 2 |
Y1.XJACSLEV301 | 108 JACS subject groups (Level 3) | XJACSLEV301_Y1 | 3 |
Y1.UNISTATS_PROGTYPE | Unistats programme type | UNISTATS_PROGTYPE_Y1 | 1 |
Y1.UNISTATS_XLEV501 | Unistats level of study | UNISTATS_XLEV501_Y1 | 1 |
Y1.UNISTATS_MODE | Unistats mode of study | UNISTATS_MODE_Y1 | 1 |
Y1.UNISTATS_COURSEAIM | Unistats course aim | UNISTATS_COURSEAIM_Y1 | 2 |
Y1.UNISTATS_XQOBTN02 | Unistats qualification obtained | UNISTATS_XQOBTN02_Y1 | 2 |
Y1.NOTACT | Suspension of active studies | NOTACT_Y1 | 1 |
Y1.UNISTATS_ITT | Unistats ITT student identifier | UNISTATS_ITT_Y1 | 1 |
Y2.UNISTATS_XPSR01 | Unistats standard registration population | UNISTATS_XPSR01_Y2 | 1 |
Y2.UNISTATS_XQOBTN02 | Unistats qualification obtained | UNISTATS_XQOBTN02_Y2 | 2 |
UNISTATS_CONT_STAT | Unistats continuation status | UNISTATS_CONT_STAT | 1 |
Y1.COUNTER | Percentage of a student registration (Full Person Equivalence) | COUNTER_Y1 | 7 |
Table filter:
The continuation table uses two years of HESA data, Y1 and Y2, where Y2 is the academic year of the current collection and Y1 is the year before. Where applicable, these year references are used to indicate the year from which the data is taken.
HESA Standard Registration population (HE records only) (Y1.XPSR01 = 1)
First year students (Y1.XFYRSR01=1)
Exclude HNC students (NOT Course.COURSEAIM = C30)
First degree and other undergraduate level only (Y1.XLEV501 = 3 or 4)
Full-time and part-time students (Y1.XMODE01 = 1, 2 or 3)
Excluding professional and unspecified qualification aims
(Y1.COURSEAIM codes not H76,I76,J76,H70,I70,H72,I72,C99,H99,I99,J99)
Exclude Early Years Teacher Status (EYTS) where the scheme is EYITT Graduate Entry, EYITT Graduate employment-based, EYITT Assessment Only or EYITT School Direct (NOT(Y1.Course.COURSEAIM = I73 and Y1.Instance.ENTRYRTE = 04, 05, 07 or 08))
Exclude apprenticeships (Where exists Instance.PROGTYPE ≠ 02, 03, 20, 21, 22, 23 or 25).
Download: XML Schema for Unistats Table 3.
File structure: Table 4 - Achievement information for first degree students obtaining first degree qualifications
Files are produced in XML format.
Field name | Description | Element name in XML output | Field length |
InstanceKEY | System generated identifier | InstanceKEY | 13 |
Student.HUSID | HESA unique student identifier | HUSID | 13 |
Institution.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Course.COURSEID | Course identifier | COURSEID | 30 |
UNISTATS_TPROV | Unistats HE provider delivering majority of teaching in current year | UNISTATS_TPROV | 8 |
Instance.NUMHUS | Student instance number | NUMHUS | 20 |
UNISTATS_XJACS203 | JACS principal subject | UNISTATS_XJACS203 | 3 |
XJACSLEV101 | 21 JACS subject groups (Level 1) | XJACSLEV101 | 1 |
XJACSLEV201 | 42 JACS subject groups (Level 2) | XJACSLEV201 | 2 |
XJACSLEV301 | 108 JACS subject groups (Level 3) | XJACSLEV301 | 3 |
UNISTATS_PROGTYPE | Unistats programme type | UNISTATS_PROGTYPE | 1 |
UNISTATS_MODE | Unistats qualifiers mode | UNISTATS_MODE | 1 |
UNISTATS_CLASS | Unistats class of first degree | UNISTATS_CLASS | 1 |
UNISTATS_ITT | Unistats ITT student identifier | UNISTATS_ITT | 1 |
COUNTER | Percentage of a student registration (Full Person Equivalence) | COUNTER | 7 |
Table filter:
HESA Qualifications obtained population (XPQUAL01 = 1)
First degree level only (XLEV501 = 3)
First degree qualifiers (XQLEV501 = 3)
Full-time and part-time qualifiers (XQMODE01 = 1 or 2)
Exclude institutions in Scotland (XINSTC01S).
Download: XML Schema for Unistats Table 4.
Need help?
Contact Liaison by email or on +44 (0)1242 388 531.