HESA Student Record 2009/10
HESA Student Record 2009/10File structures for Teaching Quality Information (TQI) downloadable files |
return to index |
Version 1.0 Produced 2010-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 |
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_XJACS201 | JACS principal subject | TQI_XJACS201 | 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.
Example XML file:
<?xml version="1.0" encoding="utf-8"?> <TQI0REPORT> <TQI0ROWS> <TQI0ROW> <HUSID>0000029921792</HUSID> <UKPRN>10007773</UKPRN> <TQI_INST>10007773</TQI_INST> <NUMHUS>U1</NUMHUS> <TQI_XJACS201>N2 </TQI_XJACS201> <SBJ_LEV1>E</SBJ_LEV1> <SBJ_LEV2>26</SBJ_LEV2> <SBJ_LEV3>063</SBJ_LEV3> <TQI_PROGTYPE>S</TQI_PROGTYPE> <TQI_MODE2>2</TQI_MODE2> <TQI_LEVEL5>3</TQI_LEVEL5> <TQI_DOM>1</TQI_DOM> <GENDER>2</GENDER> <TQI_AGEGRP2>3</TQI_AGEGRP2> <TQI_ITT>0</TQI_ITT> <COUNTER>100.000</COUNTER> </TQI0ROW> <TQI0ROW> <HUSID>0000053312345</HUSID> <UKPRN>10007773</UKPRN> <TQI_INST>10007773</TQI_INST> <NUMHUS>U1</NUMHUS> <TQI_XJACS201>Y0 </TQI_XJACS201> <SBJ_LEV1>L</SBJ_LEV1> <SBJ_LEV2>42</SBJ_LEV2> <SBJ_LEV3>108</SBJ_LEV3> <TQI_PROGTYPE>S</TQI_PROGTYPE> <TQI_MODE2>2</TQI_MODE2> <TQI_LEVEL5>3</TQI_LEVEL5> <TQI_DOM>1</TQI_DOM> <GENDER>1</GENDER> <TQI_AGEGRP2>3</TQI_AGEGRP2> <TQI_ITT>0</TQI_ITT> <COUNTER>100.000</COUNTER> </TQI0ROW> </TQI0ROWS> </TQI0REPORT>
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_XJACS201 | JACS principal subject | TQI_XJACS201 | 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_HIQUAL | TQI highest qualification on entry | TQI_HIQUAL | 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.
Example XML file:
<?xml version="1.0" encoding="utf-8"?> <TQI1REPORT> <TQI1ROWS> <TQI1ROW> <HUSID>0000029921792</HUSID> <UKPRN> 10007822</UKPRN> <TQI_INST>10007822</TQI_INST> <NUMHUS>01</NUMHUS> <TQI_XJACS201>H7 </TQI_XJACS201> <SBJ_LEV1>A</SBJ_LEV1> <SBJ_LEV2>15</SBJ_LEV2> <SBJ_LEV3>038</SBJ_LEV3> <TQI_PROGTYPE>S</TQI_PROGTYPE> <TQI_LEVEL4>1</TQI_LEVEL4> <TQI_MODE>2</TQI_MODE> <TQI_AGRP>X</TQI_AGRP> <TQI_HIQUAL>01</TQI_HIQUAL> <TQI_ITT>0</TQI_ITT> <COUNTER>100.000</COUNTER> </TQI1ROW> <TQI1ROW> <HUSID>0000053312345</HUSID> <UKPRN> 10007822</UKPRN> <TQI_INST>10007822</TQI_INST> <NUMHUS>01</NUMHUS> <TQI_XJACS201>D4 </TQI_XJACS201> <SBJ_LEV1>5</SBJ_LEV1> <SBJ_LEV2>09</SBJ_LEV2> <SBJ_LEV3>024</SBJ_LEV3> <TQI_PROGTYPE>S</TQI_PROGTYPE> <TQI_LEVEL4>1</TQI_LEVEL4> <TQI_MODE>1</TQI_MODE> <TQI_AGRP>X</TQI_AGRP> <TQI_HIQUAL>01</TQI_HIQUAL> <TQI_ITT>0</TQI_ITT> <COUNTER>100.000</COUNTER> </TQI1ROW> </TQI1ROWS> </TQI1REPORT>
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_XJACS201 | JACS principal subject | TQI_XJACS201 | 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 (XTARIFF04) | 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.
Example XML file:
<?xml version="1.0" encoding="utf-8"?> <TQI2REPORT> <TQI2ROWS> <TQI2ROW> <HUSID>0000029921792</HUSID> <UKPRN> 10000975</UKPRN> <TQI_INST>10000975</TQI_INST> <NUMHUS>1</NUMHUS> <TQI_XJACS201>N2 </TQI_XJACS201> <SBJ_LEV1>E</SBJ_LEV1> <SBJ_LEV2>26</SBJ_LEV2> <SBJ_LEV3>063</SBJ_LEV3> <TQI_PROGTYPE>C</TQI_PROGTYPE> <TQI_LEVEL4>2</TQI_LEVEL4> <TQI_TARIFF_SCORE>171</TQI_TARIFF_SCORE> <TQI_ITT>0</TQI_ITT> <COUNTER>037.000</COUNTER> </TQI2ROW> <TQI2ROW> <HUSID>0000053312345</HUSID> <UKPRN> 10000975</UKPRN> <TQI_INST>10000975</TQI_INST> <NUMHUS>1</NUMHUS> <TQI_XJACS201>W3 </TQI_XJACS201> <SBJ_LEV1>I</SBJ_LEV1> <SBJ_LEV2>37</SBJ_LEV2> <SBJ_LEV3>097</SBJ_LEV3> <TQI_PROGTYPE>C</TQI_PROGTYPE> <TQI_LEVEL4>2</TQI_LEVEL4> <TQI_TARIFF_SCORE>171</TQI_TARIFF_SCORE> <TQI_ITT>0</TQI_ITT> <COUNTER>063.000</COUNTER> </TQI2ROW> </TQI2ROWS> </TQI2REPORT>
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_XJACS201 | JACS principal subject | TQI_XJACS201_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.
Example XML file:
<?xml version="1.0" encoding="utf-8"?> <TQI3REPORT> <TQI3ROWS> <TQI3ROW> <HUSID_Y1>0000053312345</HUSID_Y1> <INSTID_Y1>0001</INSTID_Y1> <TQI_INST_Y1>10007773</TQI_INST_Y1> <NUMHUS_Y1>6</NUMHUS_Y1> <TQI_XJACS201_Y1>C8 </TQI_XJACS201_Y1> <SBJ_LEV1_Y1>3</SBJ_LEV1_Y1> <SBJ_LEV2_Y1>07</SBJ_LEV2_Y1> <SBJ_LEV3_Y1>019</SBJ_LEV3_Y1> <TQI_PROGTYPE_Y1>S</TQI_PROGTYPE_Y1> <TQI_LEVEL4_Y1>3</TQI_LEVEL4_Y1> <TQI_MODE_Y1>2</TQI_MODE_Y1> <TQI_FYEAR_Y1>1</TQI_FYEAR_Y1> <TQI_XPSR01_Y1>1</TQI_XPSR01_Y1> <TQI_COURSEAIM_Y1>07</TQI_COURSEAIM_Y1> <TQI_XQOBTN02_Y1>__</TQI_XQOBTN02_Y1> <NOTACT_Y1/> <TQI_ITT_Y1>0</TQI_ITT_Y1> <TQI_XPSR01_Y2>1</TQI_XPSR01_Y2> <TQI_XQOBTN02_Y2>07</TQI_XQOBTN02_Y2> <TQI_CONT_STAT>1</TQI_CONT_STAT> <COUNTER_Y1>100.000</COUNTER_Y1> </TQI3ROW> <TQI3ROW> <HUSID_Y1>0000029921792</HUSID_Y1> <INSTID_Y1>0001</INSTID_Y1> <TQI_INST_Y1>10007773</TQI_INST_Y1> <NUMHUS_Y1>3</NUMHUS_Y1> <TQI_XJACS201_Y1>W3 </TQI_XJACS201_Y1> <SBJ_LEV1_Y1>I</SBJ_LEV1_Y1> <SBJ_LEV2_Y1>37</SBJ_LEV2_Y1> <SBJ_LEV3_Y1>097</SBJ_LEV3_Y1> <TQI_PROGTYPE_Y1>C</TQI_PROGTYPE_Y1> <TQI_LEVEL4_Y1>2</TQI_LEVEL4_Y1> <TQI_MODE_Y1>1</TQI_MODE_Y1> <TQI_FYEAR_Y1>1</TQI_FYEAR_Y1> <TQI_XPSR01_Y1>1</TQI_XPSR01_Y1> <TQI_COURSEAIM_Y1>05</TQI_COURSEAIM_Y1> <TQI_XQOBTN02_Y1>__</TQI_XQOBTN02_Y1> <NOTACT_Y1/> <TQI_ITT_Y1>0</TQI_ITT_Y1> <TQI_XPSR01_Y2>0</TQI_XPSR01_Y2> <TQI_XQOBTN02_Y2>__</TQI_XQOBTN02_Y2> <TQI_CONT_STAT>5</TQI_CONT_STAT> <COUNTER_Y1>063.000</COUNTER_Y1> </TQI3ROW> </TQI3ROWS> </TQI3REPORT>
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_XJACS201 | JACS principal subject | TQI_XJACS201 | 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.
Example XML file:
<?xml version="1.0" encoding="utf-8"?> <TQI4REPORT> <TQI4ROWS> <TQI4ROW> <HUSID>0000029921792</HUSID> <UKPRN>10007773</UKPRN> <TQI_INST>10007773</TQI_INST> <NUMHUS>U2</NUMHUS> <TQI_XJACS201>L5 </TQI_XJACS201> <SBJ_LEV1>C</SBJ_LEV1> <SBJ_LEV2>23</SBJ_LEV2> <SBJ_LEV3>059</SBJ_LEV3> <TQI_PROGTYPE>S</TQI_PROGTYPE> <TQI_QMODE>2</TQI_QMODE> <TQI_CLASS>5</TQI_CLASS> <TQI_ITT>0</TQI_ITT> <COUNTER>100.000</COUNTER> </TQI4ROW> <TQI4ROW> <HUSID>0000053312345</HUSID> <UKPRN>10007773</UKPRN> <TQI_INST>10007773</TQI_INST> <NUMHUS>U1</NUMHUS> <TQI_XJACS201>Y0 </TQI_XJACS201> <SBJ_LEV1>L</SBJ_LEV1> <SBJ_LEV2>42</SBJ_LEV2> <SBJ_LEV3>108</SBJ_LEV3> <TQI_PROGTYPE>S</TQI_PROGTYPE> <TQI_QMODE>2</TQI_QMODE> <TQI_CLASS>6</TQI_CLASS> <TQI_ITT>0</TQI_ITT> <COUNTER>100.000</COUNTER> </TQI4ROW> </TQI4ROWS> </TQI4REPORT>
Contact Liaison by email or on +44 (0)1242 388 531.