Skip to main content

Student record 2018/19

Back to C18051

File structures for downloadable files - NSS

Version 1.1 Produced 2019-08-30

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.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
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.INITIATIVES1 Initiatives 1 INITIATIVES1 1
Instance.INITIATIVES2 Initiatives 2 INITIATIVES2 1
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 code EXCLUDE 2
EXCLUDE_TEXT Exclude reason EXCLUDE_TEXT 100

Download: XML Schema for NSS exclusions file.

Contact Liaison by email or on 01242 211144.