Student Alternative record 2019/20
File structures for downloadable files - Unistats
Version 1.0 Produced 2020-06-26
The subject data used in tables is based on CAH 1.2. Where data is used or calculated at an InstancePeriod level, the most recent InstancePeriod value is used.
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 and comma separated value (CSV) 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 |
Provider.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_XCAH03 | Common Aggregation Hierarchy, third level grouping | UNISTATS_XCAH03 | 11 |
XCAH01 | Common Aggregation Hierarchy, first level grouping | XCAH01 | 5 |
XCAH02 | Common Aggregation Hierarchy, second level grouping | XCAH02 | 8 |
XCAH03 | Common Aggregation Hierarchy, third level grouping | XCAH03 | 11 |
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:
1. HESA Standard Registration population (HE records only) (XPSR01 = 1)
2. First year students (XFYRSR01=1)
3. First degree and other undergraduate level only (XLEV501 = 3 or 4)
Exclude HNC students (NOT Course.COURSEAIM = C30)
4. Full-time and part-time students (XMODE02 = 1, 2 or 3)
5. Exclude apprenticeships (Where exists InstancePeriod.INITIATIVES 'K').
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 and comma separated value (CSV) 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 |
Provider.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_XCAH03 | Common Aggregation Hierarchy, third level grouping | UNISTATS_XCAH03 | 11 |
XCAH01 | Common Aggregation Hierarchy, first level grouping | XCAH01 | 5 |
XCAH02 | Common Aggregation Hierarchy, second level grouping | XCAH02 | 8 |
XCAH03 | Common Aggregation Hierarchy, third level grouping | XCAH03 | 11 |
UNISTATS_PROGTYPE | Unistats programme type | UNISTATS_PROGTYPE | 1 |
UNISTATS_XLEV501 | Unistats level of study | UNISTATS_XLEV501 | 1 |
UNISTATS_TARIFF_SCORE (XTPOINTS) | 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 2 filter:
1. HESA Standard Registration population (HE records only) (Student.XPSR01 = 1)
2. First year students (Student.XFYRSR01=1)
3. First degree and other undergraduate level only (Student.XLEV501 = 3 or 4)
Exclude HNC students (NOT Course.COURSEAIM = C30)
4. Full-time and sandwich only (Student.XMODE02 = 1 or 2)
5. Under 21 years of age (Student.XAGRP601 =1, 2)
6. Highest qualification on entry (EntryProfile.QUALENT3) LIKE P% AND P92
7. Total tariff points (numeric value of Instance_Derive. XTPOINTS)
8. Exclude apprenticeships (Where exists InstancePeriod.INITIATIVES 'K').
Download: XML Schema for Unistats Table 2.
File structure: Table 3 - Continuation information for first year undergraduates
Files are produced in XML and comma separated value (CSV) 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 (Student.HUSID) | HUSID_Y1 | 13 |
Y1.UKPRN | UK Provider Reference Number (Provider.UKPRN) | UKPRN_Y1 | 8 |
Y1.COURSEID | Course identifier (Course.COURSEID) | 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 (Instance.NUMHUS) | NUMHUS_Y1 | 20 |
Y1.UNISTATS_XJACS203 | UNISTATS 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 3 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.
1. HESA Standard Registration population (HE records only) (Y1.XPSR01 = 1)
2. First year students (Y1.XFYRSR01=1)
3. Full-time and part-time students (Y1.XMODE02 = 1, 2 or 3)
4. First degree and other undergraduate level only (Y1.XLEV501 = 3 or 4)
Excluding professional and unspecified qualification aims
(Y1.COURSEAIM codes not H76,I76,J76,H70,I70,H72,I72,C99,H99,I99,J99)
Exclude HNC students (NOT Course.COURSEAIM = C30)
Exclude apprenticeships (Where exists Y1.Instance.INITIATIVES 'K')
Download: XML Schema for Unistats Table 3.
Contact Liaison by email or on +44 (0)1242 388 531.