Skip to main content

Alternative provider student record 2017/18

Back to C17054

File structures for downloadable files - NSS

Version 1.0 Produced 2018-11-07

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
Student.SURNAME Family name SURNAME 100
Student.FNAMES Forenames FNAMES 100
Student.BIRTHDTE Date of birth BIRTHDTE 10
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.OWNSTU Provider's own identifier for student OWNSTU 20
Instance.OWNINST Provider'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 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_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
Provider.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
Latest InstancePeriod.YEARPRG Year of course YEARPRG 2
Instance.SPLENGTH Expected length of study SPLENGTH 2
Instance.UNITLGTH Units of length UNITLGTH 1
XSTULOAD01 Student instance FTE STULOAD 5
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.