Student record 2013/14
File structures for downloadable files
Version 1.0 Produced 2014-04-29
File structures for National Student Survey (NSS) downloadable files
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.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.
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.
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 |
| Course.OWNCOURSEID | Own course identifier | OWNCOURSEID | 50 |
| 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.
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.