Student Alternative record 2020/21
File structures for downloadable files - NSS
Version 1.0 Produced 2021-07-20
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 |
Provider.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Instance.NUMHUS | Student instance number | NUMHUS | 20 |
InstancePeriod.CAMPID | Campus identifier | CAMPID | 1 |
Student.SURNAME | Family name | SURNAME | 100 |
Student.FNAMES | Forenames | FNAMES | 100 |
StudentEquality.SEXID | Sex identifier | SEXID | 1 |
Instance.COMDATE | Start date of instance | COMDATE | 10 |
Latest InstancePeriod.MODE | Mode of study | MODE | 2 |
Course.COURSEID | Course identifier | COURSEID | 30 |
Course.CTITLE | Course title | CTITLE | 255 |
Student.BIRTHDTE | Date of birth | BIRTHDTE | 10 |
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 | Apprentice | 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 |
Provider.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_HECOS | HECOS subject code | NSS_HECOS | 6 |
NSS_LEV1 | 23 CAH subject groups (Level 1) | NSS_LEV1 | 1 |
NSS_LEV2 | 34 CAH subject groups (Level 2) | NSS_LEV2 | 2 |
NSS_LEV3 | 155 CAH 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 |
Provider.UKPRN | UK Provider Reference Number | UKPRN | 8 |
Instance.NUMHUS | Student instance number | NUMHUS | 20 |
Student.BIRTHDTE | Date of birth | BIRTHDTE | 10 |
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 |
Latest InstancePeriod.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.INITIATIVES1 | Initiatives 1 | INITIATIVES1 | 2 |
Instance.INITIATIVES2 | Initiatives 2 | INITIATIVES2 | 2 |
Instance.INITIATIVES3 | Initiatives 3 | INITIATIVES3 | 2 |
XSTULOAD01 | Student instance FTE | STULOAD | 5 |
AGE31JUL | Age at 31 July in reporting year | AGE31JUL | 2 |
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 code | EXCLUDE | 2 |
EXCLUDE_TEXT | Exclude reason text | EXCLUDE_TEXT | 100 |
Download: XML Schema for NSS Exclusions file.
Contact Liaison by email or on +44 (0)1242 388 531.