Skip to main content

HESA Student Record 2009/10

Back to C09051

HESA Student Record 2009/10

File structures for National Student Survey (NSS) downloadable files
return to index

Version 1.1 Produced 2010-08-30

File structure - NSS Person

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
Instance.NUMHUS Student instance number NUMHUS 20
Instance.CAMPID Campus identifier CAMPID 1
Student.BIRTHDTE Date of birth BIRTHDTE 10
Student.GENDER Gender GENDER 1
Instance.COMDATE Date of commencement of programme COMDATE 10
Instance.MODE Mode of study MODE 2
Course.CTITLE Course title CTITLE 255
Student.OWNSTU Institution's own identifier for student OWNSTU 20
DHSTUDENT DH student (0=Excluded from the DH STUDENT population, 1=Included in the DH STUDENT population) DHSTUDENT 1
NSS_ITT ITT Student (0=Excluded from the ITT population, 1=Included in the ITT population) NSS_ITT 1

Download: XML Schema for NSS Person file. Sample XML for NSS Person file.

Example XML file: 

<?xml version="1.0" encoding="UTF-8"?>
<NSSPREPORT>
	<NSSPROWS>
		<NSSPROW>
			<HUSID>0000029921792</HUSID>
			<UKPRN>10007773</UKPRN>
			<NUMHUS>U1</NUMHUS>
			<CAMPID>S</CAMPID>
			<BIRTHDTE>1975-06-21</BIRTHDTE>
			<GENDER>2</GENDER>
			<COMDATE>2007-02-01</COMDATE>
			<MODE>31</MODE>
			<CTITLE>BSc Honours Psychology</CTITLE>
			<OWNSTU>X8774611</OWNSTU>
			<DHSTUDENT> 0</DHSTUDENT>
			<NSS_ITT>0</NSS_ITT>
		</NSSPROW>
		<NSSPROW>
			<HUSID>0000053312345</HUSID>
			<UKPRN>10007773</UKPRN>
			<NUMHUS>U1</NUMHUS>
			<CAMPID>A</CAMPID>
			<BIRTHDTE>1978-12-09</BIRTHDTE>
			<GENDER>2</GENDER>
			<COMDATE>2005-11-01</COMDATE>
			<MODE>31</MODE>
			<CTITLE>BA/BSc Open degree</CTITLE>
			<OWNSTU>X5804659</OWNSTU>
			<DHSTUDENT>0</DHSTUDENT>
			<NSS_ITT>0</NSS_ITT>
		</NSSPROW>
	</NSSPROWS>
</NSSPREPORT>

File structure - NSS Subject

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
Instance.NUMHUS Student instance number NUMHUS 20
NSS_JACS JACS subject code NSS_JACS 4
NSS_LEV1 21 JACS subject groups (Level 1) NSS_LEV1 1
NSS_LEV2 42 JACS subject groups (Level 2) NSS_LEV2 2
NSS_LEV3 108 JACS subject groups (Level 3) NSS_LEV3 3
NSS_FPE Full-Person Equivalent (FPE) (format 000.000) NSS_FPE 7

Download: XML Schema for NSS Subject file. Sample XML for NSS Subject file.

Example XML file: 

<?xml version="1.0" encoding="UTF-8"?>
<NSSSREPORT>
	<NSSSROWS>
		<NSSSROW>
			<HUSID>0000029921792</HUSID>
			<UKPRN>10007773</UKPRN>
			<NUMHUS>U1</NUMHUS>
			<NSS_JACS>Y000</NSS_JACS>
			<NSS_LEV1>L</NSS_LEV1>
			<NSS_LEV2>42</NSS_LEV2>
			<NSS_LEV3>108</NSS_LEV3>
			<NSS_FPE>100.000</NSS_FPE>
		</NSSSROW>
		<NSSSROW>
			<HUSID>0000053312345</HUSID>
			<UKPRN>10007773</UKPRN>
			<NUMHUS>U1</NUMHUS>
			<NSS_JACS>C800</NSS_JACS>
			<NSS_LEV1>3</NSS_LEV1>
			<NSS_LEV2>07</NSS_LEV2>
			<NSS_LEV3>019</NSS_LEV3>
			<NSS_FPE>100.000</NSS_FPE>
		</NSSSROW>		
	</NSSSROWS>
</NSSSREPORT>

File structure - NSS exclusions

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
Instance.NUMHUS Student instance number NUMHUS 20
EXCLUDE Exclude reason (Valid entries 1) EXCLUDE 2

Download: XML Schema for NSS exclusions file. Sample XML for NSS exclusions file.

1
Value Description
02 Postgraduate or FE student
03 In previous year's NSS list
04 Instance.EXCHANGE in (2, 4, 8, 9, A)
05 Instance.MODE in (63, 64)
09 Expected end date (EXPEND*) not within 1 Feb y3 and 31 Jan y4 inclusive
10 Short course
11 Duplicate Student.HUSIDs / Institution.UKPRN
12 Instance.NOTACT in (1, 2)
13 Instance.LOCSDY = S
14 Course.CLSDCRS = 1

Example XML file: 

<?xml version="1.0" encoding="UTF-8"?>
<NSSEXREPORT>
	<NSSEXROWS>
		<NSSEXROW>
			<HUSID>0000029921792</HUSID>
			<UKPRN>10007773</UKPRN>
			<NUMHUS>U1</NUMHUS>
			<EXCLUDE>09</EXCLUDE>
		</NSSEXROW>
		<NSSEXROW>
			<HUSID>0000053312345</HUSID>
			<UKPRN>10007773</UKPRN>
			<NUMHUS>U1</NUMHUS>
			<EXCLUDE>09</EXCLUDE>
		</NSSEXROW>		
	</NSSEXROWS>
</NSSEXREPORT>

Contact Liaison by email or on +44 (0)1242 388 531.