Skip to main content

HESA Student Record 2009/10

Back to C10051

HESA Student Record 2010/11

File 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.