Skip to main content

Student record 2018/19

Back to C18051

File structures for downloadable files - Unistats

Version 1.0 Produced 2019-05-23

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 01242 211144.