HESA Student record 2012/13
File structures for downloadable files
Version 1.0 Produced 2013-04-30
File structures for National Student Survey (NSS) downloadable files
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.SURNAME | Family name | SURNAME | 100 |
Student.FNAMES | Forenames | FNAMES | 100 |
Student.BIRTHDTE | Date of birth | BIRTHDTE | 10 |
Student.SEXID | Sex identifier | SEXID | 1 |
Instance.COMDATE | Start date of instance | 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 |
Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
DHSTUDENT | DH Student | DHSTUDENT | 1 |
NSS_ITT | ITT Student | NSS_ITT | 1 |
Download: XML Schema for NSS Person file. Sample XML for NSS Person file.
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 |
Student.OWNSTU | Institution's own identifier for student | OWNSTU | 20 |
Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
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) | NSS_FPE | 7 (format 000.000) |
Download: XML Schema for NSS Subject file. Sample XML for NSS Subject file.
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 |
Course.COURSEID | Course identifier | COURSEID | 30 |
Student.OWNSTU | Institution's own identifier for student | OWNSTU | 20 |
Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
Instance.COMDATE | Start date of instance | COMDATE | 10 |
Instance.ENDDATE | End date of instance | ENDDATE | 10 |
Instance.YEARPRG | Year of course | YEARPRG | 2 |
Instance.SPLENGTH | Expected length of study | SPLENGTH | 2 |
Instance.UNITLGTH | Units of length | UNITLGTH | 1 |
Instance.STULOAD | Student instance FTE | STULOAD | 5 |
Instance.FTEMETHOD | FTE method | FTEMETHOD | 1 |
Instance.TYPEYR | Type of instance year | TYPEYR | 1 |
YEAR0 | Foundation year ever returned marker (Y/N) | YEAR0 | 1 |
STULOADY1_1 | Student instance FTE for Y1-1 | STULOADY1_1 | 5 |
STULOADY1_2 | Student instance FTE for Y1-2 | STULOADY1_2 | 5 |
YEARADJ | Year adjustment | YEARADJ | 2 |
EXPEND | Expected end date | EXPEND | 10 |
TOTFTE | Total FTE | TOTFTE | 5 |
EXCLUDE | Exclude reason (Valid entries 1) | EXCLUDE | 2 |
Download: XML Schema for NSS exclusions file. Sample XML for NSS exclusions file.
1 Valid entries for EXCLUDE are:
Value | Description |
---|---|
02 | Postgraduate or FE student |
03 | In previous year's NSS list |
04 | Instance.EXCHANGE in ('2', '4', '8', '9', 'A', 'Z') |
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') |
15 | Course.COURSEAIM = ('C30') |
Contact Liaison by email or on +44 (0)1242 388 531.