Skip to main content

Student record 2017/18

Back to C17051

File structures for downloadable files - FE continuity reports A, B and C


Version 1.0 Produced 2018-06-29

FE continuity report A - Linked instances: data inconsistenciesBack to top

This file is available as an XML file or as a CSV (comma separated value) file.

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
Institution.NUMHUS Student instance identifier NUMHUS 20
Course.CTITLE Course title CTITLE 255
CTITLE_T Course title - from Continuity Register CTITLE_T 255
Student.OWNSTU Provider's own identifier for student OWNSTU 20
OWNSTU_T Provider's own identifier for student - from Continuity Register OWNSTU_T 20
Course.COURSEAIM General qualification aim of course COURSEAIM 3
COURSEAIM_T General qualification aim of course - from Continuity Register COURSEAIM_T 3
Instance.COMDATE Start date of instance COMDATE 10
COMDATE_T Start date of instance - from Continuity Register COMDATE_T 10
Instance.MODE Mode of study MODE 2
MODE_T Mode of study - from Continuity Register MODE_T 2
EntryProfile.QUALENT3 Highest qualification on entry QUALENT3 3
QUALENT3_T Highest qualification on entry - from Continuity Register QUALENT3_T 3
EntryProfile.POSTCODE Postcode POSTCODE 8
POSTCODE_T Postcode - from Continuity Register POSTCODE_T 8
NAMECAT Name from incoming data1 NAMECAT 102
NAMECAT_T Name from Continuity Register NAMECAT_T 102
EntryProfile.DOMICILE Domicile DOMICILE 2
DOMICILE_T Domicile - from Continuity Register DOMICILE_T 2
Student.ETHNIC Ethnicity ETHNIC 2
ETHNIC_T Ethnicity - from Continuity Register ETHNIC_T 2
Student.SEXID Sex identifier SEXID 1
SEXID_GENDER_T Sex identifier or Gender2 – a hybrid field (SEXID_GENDER_T) from Continuity Register fields SEXID and GENDER. SEXID_GENDER_T 1
Student.BIRTHDTE Date of birth BIRTHDTE 10
BIRTHDTE_T Date of birth - from Continuity Register BIRTHDTE_T 10
Course.COURSEID Course identifier COURSEID 30
COURSEID_T Course identifier - from Continuity Register COURSEID_T 30
Course.FEQAIMC FE general qualification aim FEQAIMC 8
FEQAIMC_T FE general qualification aim – from Continuity Register FEQAIMC_T 8
Instance.OWNINST Provider's own identifier for instance OWNINST 30
OWNINST_T Provider's own identifier for instance - from Continuity Register OWNINST_T 30
Instance.OWNCOURSEID Own course identifier OWNCOURSEID 50
OWNCOURSEID_T Own course identifier - from Continuity Register OWNCOURSEID_T 50
Instance.INTERCALATE Intercalation INTERCALATE 2
INTERCALATE_T Intercalation - from Continuity Register INTERCALATE_T 2
POPGRP Population Group (PI, Other, CE or FE) POPGRP 5
POPGRP_T Population Group (PI, Other, CE or FE)- from Continuity Register POPGRP_T 5
XYEARM01 Last year in which an active record for a UHN was sent to HESA XYEARM01 4
WARNON Lists the checks that the record has failed. It is a comma separated list of the continuity check codes for all the rules triggered for this instance. WARNON 150

Download: XML Schema for FE continuity report A file.

Notes

1SURNAME (up to 100 characters) + ',' + FNAMES (first character)

2From the Continuity Register - If SEXID is null use GENDER otherwise use SEXID.

FE continuity report B and C - Continuing or Expected instances not previously returnedBack to top

This file is available as an XML file or as a fixed length file.

Field name Description Element name in XML output Field length
Student.HUSID HESA unique student identifier HUSID 13
HUSID_T Student identifier - from Continuity Register HUSID_T 13
NAMECAT Name from incoming data1> NAMECAT 102
NAMECAT_T Name from Continuity Register NAMECAT_T 102
Student.BIRTHDTE Date of birth BIRTHDTE 10
BIRTHDTE_T Date of birth - from Continuity Register BIRTHDTE_T 10
Student.OWNSTU Provider's own identifier for student OWNSTU 20
OWNSTU_T Provider's own identifier for student - from Continuity Register OWNSTU_T 20
Instance.NUMHUS Student instance identifier NUMHUS 20
NUMHUS_T Student instance identifier - from Continuity Register NUMHUS_T 20
Course.COURSEAIM General qualification aim of course COURSEAIM 3
COURSEAIM_T General qualification aim of course - from Continuity Register COURSEAIM_T 3
Course.CTITLE Course title CTITLE 255
CTITLE_T Course title - from Continuity Register CTITLE_T 255
Instance.COMDATE Start date of instance COMDATE 10
COMDATE_T Start date of instance - from Continuity Register COMDATE_T 10
Instance.MODE Mode of study MODE 2
MODE_T Mode of study - from Continuity Register MODE_T 2
QualificationsAwarded.QUAL Qualification awarded QUAL 3
QUAL_T Qualification awarded - from Continuity Register QUAL_T 3
Instance.ENDDATE End date of instance ENDDATE 10
ENDDATE_T End date of instance - from Continuity Register ENDDATE_T 10
Instance.NOTACT Suspension of active studies NOTACT 1
NOTACT_T Suspension of active studies - from Continuity Register NOTACT_T 1
Instance.RSNEND Reason for ending instance RSNEND 2
RSNEND_T Reason for ending instance - from Continuity Register RSNEND_T 2
Course.COURSEID Course identifier COURSEID 30
COURSEID_T Course identifier - from Continuity Register COURSEID_T 30
Instance.OWNINST Provider's own identifier for instance OWNINST 30
OWNINST_T Provider's own identifier for instance - from Continuity Register OWNINST_T 30
POPGRP Population group (PI, Other, CE or FE) POPGRP 5
POPGRP_T Population group (PI, Other, CE or FE) - from Continuity Register POPGRP_T 5
XYEARM01 Last year in which an active record for a UHN was sent to HESA XYEARM01 4
WARNON Lists the checks that the record has failed. It is a comma separated list of the continuity check codes for all the rules triggered for this instance. WARNON 150

Download: XML Schema for HE continuity report B file.

Download: XML Schema for HE continuity report C file.

Notes

1SURNAME (up to 100 characters) + ',' + FNAMES (first character)


Need help?

Contact Liaison by email or on +44 (0)1242 388 531.