HESA Student Record 2008/09

HESA Student Record 2009/10

File structures for downloadable files

Version 1.0 Produced 2010-06-30

File Structure - HIN Target List File specification (HE and FE)

HIN HE Target list

The HIN HE Target list is a list of students for whom a record is expected in the 2010/11 return. The list consists of HE level records that have been returned as 'live' in 2009/10.

This file is available as an XML file or as a fixed length file.

Field name	Description	Element name in XML output	Field length
Student.HUSID	Student identifier	HUSID	13
Institution.UKPRN	UK Provider Reference Number	UKPRN	8
Instance.NUMHUS	Student instance identifier	NUMHUS	20
Instance.CAMPID	Campus identifier	CAMPID	1
NAMECAT (* see below)	Name concatenation	NAMECAT	102
Course.COURSEAIM	General qualification aim of course	COURSEAIM	3
Course.CTITLE	Course title	CTITLE	255
Student.OWNSTU	Institution's own identifier for student	OWNSTU	20
STATUS (* see below)	HIN target register status	STATUS	2
YEAR (* see below)	Last year in which an active record for a HIN was went to HESA	YEAR	4
EntryProfile.QUALENT2	Highest qualification on entry	QUALENT2	2
Instance.COMDATE	Start date of instance	COMDATE	10
EntryProfile.POSTCODE	Postcode	POSTCODE	8
Student.ETHNIC	Ethnicity	ETHNIC	2
EntryProfile.DOMICILE	Domicile	DOMICILE	2
EntryProfile.YRLLINST	Year left last institution	YRLLINST	4
EntryProfile.UCASAPPID	UCAS Application Number	UCASAPPID	9
Instance.OWNINST	Institution's own identifier for instance	OWNINST	30
Course.TTCID	Teacher training course	TTCID	1

Download: XML Schema for HIN HE Target list file. Sample XML for HIN HE Target list file.

* Fields which do not appear in the coding manual

NAMECAT - "Student.SURNAME (up to 100 characters) + ','+Student.FNAMES (first character)"
STATUS - Category of record based on whether it can be matched to a record held on the HIN Register and its status in last year's collection. Entries are as follows:
13 - match to a record on the HIN register, previously returned as left now live
23 - Match to a record on the HIN Register, previously returned as not active now live
33 - Match to a record on the HIN Register, previously returned as live now live
43 - Match to a record on the HIN Register but previously no record was submitted now live
53 - No match to a record on the HIN Register but now live
Note 'previously' refers to the 2008/09 collection
YEAR - The year this record was last active.

Example XML file:

<?xml version="1.0" encoding="utf-8"?>
<TARLREPORT>
	<TARLROWS>
		<TARLROW>
			<HUSID>0011031241400</HUSID>
			<UKPRN>10008640</UKPRN>
			<NUMHUS>2</NUMHUS>
			<CAMPID>A</CAMPID>
			<NAMECAT>BLOGGS,F</NAMECAT>
			<COURSEAIM>L00</COURSEAIM>
			<CTITLE>Communication Art and Design</CTITLE>
			<OWNSTU/>
			<STATUS>33</STATUS>
			<YEAR>2008</YEAR>
			<QUALENT2>01</QUALENT2>
			<COMDATE>2006-10-02</COMDATE>
			<POSTCODE>CF5 3NB</POSTCODE>
			<ETHNIC>10</ETHNIC>
			<DOMICILE>XF</DOMICILE>
			<YRLLINST/>
			<UCASAPPID/>
			<OWNINST/>
			<TTCID/>
		</TARLROW>
		<TARLROW>
			<HUSID>0112081245777</HUSID>
			<UKPRN>10008640</UKPRN>
			<NUMHUS>2</NUMHUS>
			<CAMPID>A</CAMPID>
			<NAMECAT>OTHER,A</NAMECAT>
			<COURSEAIM>D00</COURSEAIM>
			<CTITLE>Ceramics & Glass</CTITLE>
			<OWNSTU/>
			<STATUS>33</STATUS>
			<YEAR>2008</YEAR>
			<QUALENT2>01</QUALENT2>
			<COMDATE>2006-10-02</COMDATE>
			<POSTCODE>GL53 8HS</POSTCODE>
			<ETHNIC>10</ETHNIC>
			<DOMICILE>XF</DOMICILE>
			<YRLLINST/>
			<UCASAPPID/>
			<OWNINST/>
			<TTCID/>
		</TARLROW>		
	</TARLROWS>
</TARLREPORT>

HIN FE Target list

The HIN FE Target list is a list of students for whom a record is expected in the 2010/11 return. The list consists of FE level records that have been returned as 'live' in 2009/10.