HESA Student Record 2009/10
HESA Student Record 2010/11File structures for Teaching Quality Information (TQI) downloadable files |
return to index |
Version 1.0 Produced 2012-04-30
File structure: Table 0 - Context statistics that 'describe' the whole institution
Files are produced in XML and fixed length 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 |
TQI_INST | TQI Institution delivering majority of teaching in year 1 | TQI_INST | 8 |
Instance.NUMHUS | Student instance number | NUMHUS | 20 |
TQI_XJACS202 | JACS principal subject | TQI_XJACS202 | 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 |
TQI_PROGTYPE | TQI programme type | TQI_PROGTYPE | 1 |
TQI_MODE2 | Mode of study | TQI_MODE2 | 1 |
TQI_LEVEL5 | Level of study | TQI_LEVEL5 | 1 |
TQI_DOM | Country of domicile | TQI_DOM | 1 |
Student.GENDER | Gender | GENDER | 1 |
TQI_AGEGRP2 | Age group | TQI_AGEGRP2 | 1 |
TQI_ITT | TQI ITT student identifier | TQI_ITT | 1 |
COUNTER | Percentage of a student registration (Full Person Equivalence) | COUNTER | 7 |
Table filter:
HESA Standard Registration population (HE records only).
File structure: Table 1 - Entry information for first year students
Files are produced in XML and fixed length 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 |
TQI_INST | TQI Institution delivering majority of teaching in year 1 | TQI_INST | 8 |
Instance.NUMHUS | Student instance number | NUMHUS | 20 |
TQI_XJACS202 | JACS principal subject | TQI_XJACS202 | 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 |
TQI_PROGTYPE | TQI programme type | TQI_PROGTYPE | 1 |
TQI_LEVEL4 | TQI level of study | TQI_LEVEL4 | 1 |
TQI_MODE | TQI mode of study | TQI_MODE | 1 |
TQI_AGRP | TQI age group | TQI_AGRP | 1 |
TQI_HIQUAL2 | TQI highest qualification on entry | TQI_HIQUAL2 | 2 |
TQI_ITT | TQI ITT student identifier | TQI_ITT | 1 |
COUNTER | Percentage of a student registration (Full Person Equivalence) | COUNTER | 7 |
Table filter:
HESA Standard Registration population (HE records only).
First year students.
Exclude postgraduate research students.
Download: XML Schema for TQI Table 1. Sample XML for TQI Table 1.
File structure: Table 2 - Full-time students with Tariff qualifications
Files are produced in XML and fixed length 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 |
TQI_INST | TQI Institution delivering majority of teaching in year 1 | TQI_INST | 8 |
Instance.NUMHUS | Student instance number | NUMHUS | 20 |
TQI_XJACS202 | JACS principal subject | TQI_XJACS202 | 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 |
TQI_PROGTYPE | TQI programme type | TQI_PROGTYPE | 1 |
TQI_LEVEL4 | TQI level of study | TQI_LEVEL4 | 1 |
TQI_TARIFF_SCORE (XTARIFF) | TQI tariff score | TQI_TARIFF_SCORE | 4 |
TQI_ITT | TQI ITT student identifier | TQI_ITT | 1 |
COUNTER | Percentage of a student registration (Full Person Equivalence) | COUNTER | 7 |
Table filter:
HESA Standard Registration population (HE records only).
First degree and other undergraduate level only.
Full-time and sandwich only.
First year students.
Under 21 years of age.
Highest qualification on entry (EntryProfile.QUALENT3) LIKE P% AND P92
Total tariff points (calculated from entry data) numeric value >0, XTARIFF 0000, $$$$, ____
Download: XML Schema for TQI Table 2. Sample XML for TQI Table 2.
File structure: Table 3 - Continuation information
Files are produced in XML and fixed length 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.INSTID | HESA institution identifier | INSTID_Y1 | 4 |
Y1.TQI_INST | TQI Institution delivering majority of teaching in year 1 | TQI_INST_Y1 | 8 |
Y1.NUMHUS | Student instance number | NUMHUS_Y1 | 20 |
Y1.TQI_XJACS202 | JACS principal subject | TQI_XJACS202_Y1 | 3 |
Y1.SBJ_LEV1 | 21 JACS subject groups (Level 1) | SBJ_LEV1_Y1 | 1 |
Y1.SBJ_LEV2 | 42 JACS subject groups (Level 2) | SBJ_LEV2_Y1 | 2 |
Y1.SBJ_LEV3 | 108 JACS subject groups (Level 3) | SBJ_LEV3_Y1 | 3 |
Y1.TQI_PROGTYPE | TQI programme type | TQI_PROGTYPE_Y1 | 1 |
Y1.TQI_LEVEL4 | TQI level of study | TQI_LEVEL4_Y1 | 1 |
Y1.TQI_MODE | TQI mode of study | TQI_MODE_Y1 | 1 |
Y1.TQI_FYEAR | TQI first year | TQI_FYEAR_Y1 | 1 |
Y1.TQI_XPSR01 | TQI standard registration population | TQI_XPSR01_Y1 | 1 |
Y1.TQI_COURSEAIM | TQI course aim | TQI_COURSEAIM_Y1 | 2 |
Y1.TQI_XQOBTN02 | TQI qualification obtained | TQI_XQOBTN02_Y1 | 2 |
Y1.NOTACT | Suspension of active studies | NOTACT_Y1 | 1 |
Y1.TQI_ITT | TQI ITT student identifier | TQI_ITT_Y1 | 1 |
Y2.TQI_XPSR01 | TQI standard registration population | TQI_XPSR01_Y2 | 1 |
Y2.TQI_XQOBTN02 | TQI qualification obtained | TQI_XQOBTN02_Y2 | 2 |
TQI_CONT_STAT | TQI continuation status | TQI_CONT_STAT | 1 |
Y1.COUNTER | Percentage of a student registration (Full Person Equivalence) | COUNTER_Y1 | 7 |
Table filter:
HESA Standard Registration population (HE records only).
Excluding postgraduate research students.
Excluding professional and unspecified qualification aims (COURSEAIM codes not M70,H76,I76,M76,J76,H70,I70,H72,I72,M72,C99,H99,I99,J99,L99,M99,X99).
Download: XML Schema for TQI Table 3. Sample XML for TQI Table 3.
File structure: Table 4 - Achievement information
Files are produced in XML and fixed length 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 |
TQI_INST | TQI Institution delivering majority of teaching in year 1 | TQI_INST | 8 |
Instance.NUMHUS | Student instance number | NUMHUS | 20 |
TQI_XJACS202 | JACS principal subject | TQI_XJACS202 | 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 |
TQI_PROGTYPE | TQI programme type | TQI_PROGTYPE | 1 |
TQI_QMODE | TQI qualifiers mode | TQI_QMODE | 1 |
TQI_CLASS | TQI class of first degree | TQI_CLASS | 1 |
TQI_ITT | TQI ITT student identifier | TQI_ITT | 1 |
COUNTER | Percentage of a student registration (Full Person Equivalence) | COUNTER | 7 |
Table filter:
Qualifications obtained population.
First degrees only.
Download: XML Schema for TQI Table 4. Sample XML for TQI Table 4.
Contact Liaison by email or on +44 (0)1242 388 531.