Alternative provider student record 2018/19
File structures for downloadable files - Unistats
Version 1.0 Produced 2019-06-13
The subject data used in tables is based on JACS 3.0. 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_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 HNC students (NOT Course.COURSEAIM = C30)
Full-time and part-time students (XMODE02 = 1, 2 or 3)
Apprenticeship students are to be excluded (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_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 (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 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 HNC students (NOT Course.COURSEAIM = C30)
Full-time and sandwich only (Student.XMODE02 = 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)
Apprenticeship students are to be excluded (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 Y1 year | 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 (Sum of XFPE01) | 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 HNC students (NOT Y1.COURSEAIM = C30)
.
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 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_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)
Apprenticeship students are to be excluded (InstancePeriod.INITIATIVES < > K).
Download: XML Schema for Unistats Table 4.
Contact Liaison by email or on +44 (0)1242 388 531.