Student record 2017/18
File structures for downloadable files - NSS
Version 1.0 Produced 2018-06-29
File structure - NSS Person
Files are produced in XML and comma separated value (CSV) 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.COURSEID | Course identifier | COURSEID | 30 |
Course.OWNCOURSEID | Own course identifier | OWNCOURSEID | 50 |
Course.CTITLE | Course title | CTITLE | 255 |
Student.OWNSTU | Provider's own identifier for student | OWNSTU | 20 |
Instance.OWNINST | Provider's own instance identifier | OWNINST | 30 |
DHSTUDENT | DH Student | DHSTUDENT | 1 |
APPRENTICE | Apprenticeship Student | APPRENTICE | 1 |
NSS_ITT | ITT Student | NSS_ITT | 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 |
Download: XML Schema for NSS Person file.
File structure - NSS Subject
Files are produced in XML and comma separated value (CSV) 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 | Provider's own identifier for student | OWNSTU | 20 |
Instance.OWNINST | Provider'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 comma separated value (CSV) 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 |
Course.CTITLE | Course title | CTITLE | 255 |
Student.OWNSTU | Provider's own identifier for student | OWNSTU | 20 |
Instance.OWNINST | Provider'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 |
Instance.PROGTYPE | Programme type | PROGTYPE | 2 |
Instance.INITIATIVES | Initiatives | INITIATIVES | 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 code | EXCLUDE | 2 |
EXCLUDE_TEXT | Exclude reason | EXCLUDE_TEXT | 100 |
Download: XML Schema for NSS exclusions file.
Contact Liaison by email or on +44 (0)1242 388 531.