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 2011-04-28
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 |
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 |
SBJ_LEV1 | 21 JACS subject groups (Level 1) | SBJ_LEV1 | 1 |
SBJ_LEV2 | 42 JACS subject groups (Level 2) | SBJ_LEV2 | 2 |
SBJ_LEV3 | 108 JACS subject groups (Level 3) | SBJ_LEV3 | 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 |
Download: XML Schema for TQI Table 0. Sample XML for TQI Table 0.
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 |
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 |
SBJ_LEV1 | 21 JACS subject groups (Level 1) | SBJ_LEV1 | 1 |
SBJ_LEV2 | 42 JACS subject groups (Level 2) | SBJ_LEV2 | 2 |
SBJ_LEV3 | 108 JACS subject groups (Level 3) | SBJ_LEV3 | 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 |
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 |
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 |
SBJ_LEV1 | 21 JACS subject groups (Level 1) | SBJ_LEV1 | 1 |
SBJ_LEV2 | 42 JACS subject groups (Level 2) | SBJ_LEV2 | 2 |
SBJ_LEV3 | 108 JACS subject groups (Level 3) | SBJ_LEV3 | 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 |
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.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 |
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 |
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 |
SBJ_LEV1 | 21 JACS subject groups (Level 1) | SBJ_LEV1 | 1 |
SBJ_LEV2 | 42 JACS subject groups (Level 2) | SBJ_LEV2 | 2 |
SBJ_LEV3 | 108 JACS subject groups (Level 3) | SBJ_LEV3 | 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 |
Download: XML Schema for TQI Table 4. Sample XML for TQI Table 4.
Contact Liaison by email or on +44 (0)1242 388 531.