Skip to main content

Student Alternative record 2020/21

Back to C20054

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.