Student record 2017/18
Student record 2017/18 - File structures for downloadable files - Graduate Outcomes survey population file
Version 1.0 Produced 2018-04-26
Files are produced in XML format.
Derived fields, prefixed with an X, are standard ways of grouping data. The specifications for these fields are made available under the 'Submission process and quality assurance' section of the manual when finalised.
Field name | Description | Element name in XML output | Field length |
Student.HUSID | HESA unique student identifier | HUSID | 13 |
Student.SURNAME | Family name | SURNAME | 100 |
Student.FNAMES | Forenames | FNAMES | 100 |
Student.OWNSTU | Provider's own identifier for student | OWNSTU | 20 |
Course.CTITLE | Course title | CTITLE | 255 |
Course.COURSEID | Course identifier | COURSEID | 30 |
Course.OWNCOURSEID | Own course identifier | OWNCOURSEID | 50 |
XQMODE01 | Qualification mode of study | XQMODE01 | 1 |
QualificationsAwarded.QUAL1 | Qualification awarded | QUAL1 | 3 |
QualificationsAwarded.QUAL2 | Qualification awarded 2 | QUAL2 | 3 |
XOBTNG01 | Graduate Outcomes Highest qualification obtained: the highest entry where more than one occurrence is returned of QualificationsAwarded.QUAL | XOBTNG01 | 3 |
XGLEV301 | Level of qualification in Graduate Outcome - 3 way split | XGLEV301 | 1 |
HOMEEUOS | Home/Other EU/Other Overseas flag 1 | HOMEEUOS | 1 |
Course.TTCID | Teacher training course | TTCID | 1 |
Instance.RCSTDNT | Research Council student | RCSTDNT | 2 |
Instance.NUMHUS | Student instance identifier | NUMHUS | 20 |
CENSUS | Census1 | CENSUS | 3 |
Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
DORMANT | Dormant flag1 | DORMANT | 1 |
XGLEV501 | Level of qualification in Graduate Outcomes - 5 way split | XGLEV501 | 1 |
XJACSLEV101_1 | Analytical protocol JACS - level 1 grouping3 | XJACSLEV101_1 | 1 |
XJACSLEV101_2 | Analytical protocol JACS - level 1 grouping3 | XJACSLEV101_2 | 1 |
XJACSLEV101_3 | Analytical protocol JACS - level 1 grouping3 | XJACSLEV101_3 | 1 |
XJACSLEV201_1 | Analytical protocol JACS - level 2 grouping3 | XJACSLEV201_1 | 2 |
XJACSLEV201_2 | Analytical protocol JACS - level 2 grouping3 | XJACSLEV201_2 | 2 |
XJACSLEV201_3 | Analytical protocol JACS - level 2 grouping3 | XJACSLEV201_3 | 2 |
XJACSLEV301_1 | Analytical protocol JACS - level 3 grouping3 | XJACSLEV301_1 | 3 |
XJACSLEV301_2 | Analytical protocol JACS - level 3 grouping3 | XJACSLEV301_2 | 3 |
XJACSLEV301_3 | Analytical protocol JACS - level 3 grouping3 | XJACSLEV301_3 | 3 |
EP_USE.XDOM01 | Domicile (Processing)4 | XDOM01 | 2 |
Student.NATION | Defines the country of legal nationality | NATION | 2 |
Notes
1 Field attributes:
Field name | Code | Derived from |
HOMEEUOS | 1 (Home) | XDOMHM01 = 1, 2, 3, 4 or 5 |
2 (EU) | XDOMHM01 = 6 | |
3 (Overseas) | XDOMHM01 = 7 | |
4 (Not known) | XDOMHM01 = 8 | |
DORMANT | 1 (Dormant) | Instance.MODE = 63 or 64 |
0 (Not Dormant) | Instance.MODE not in (63 or 64) | |
CENSUS | Dec (December Census) | Instance.ENDDATE >= 01-AUG-Y1 and Instance.ENDDATE <= 31-OCT-Y1 |
Mar (March Census) | Instance.ENDDATE >= 01-NOV-Y1 and Instance.ENDDATE <= 31-JAN-Y2 | |
Jun (June Census) | Instance.ENDDATE >= 01-FEB-Y2 and Instance.ENDDATE <= 30-APR-Y2 | |
Sep (September Census) | Instance.ENDDATE >= 01-MAY-Y2 and Instance.ENDDATE <= 31-JUL-Y2 |
2 If only one qualification exists the second qualification field will be blank.
3 The XJACSLEV101, XJACSLEV201 and XJACSLEV301 fields are derived from the CourseSubject entity which, for Graduate Outcomes, will always have at least one occurrence and may have up to 3 (this is enforced in the business rule QR.Cyy051.Course.CourseSubject.2 as the level is HE). The derived fields are held in the Cyy051_SJ table and each Instance.INSTANCEKEY will link to the table between 1 and 3 times. Consequently, XJACSLEV101_1, XJACSLEV201_1 and XJACSLEV301_1 will always be populated but XJACSLEV101_2, XJACSLEV201_2, XJACSLEV301_2, XJACSLEV101_3, XJACSLEV201_3 and XJACSLEV301_3 may not be.
4 The domicile field is taken from the latest Entry Profile data received. This is recorded in the EP_USE table in the XDOM field which has been updated with the current submission. The table is linked to the Instance via UKPRN+HUSID+NUMHUS.
Download: XML Schema for Graduate Outcomes survey population file.
Need help?
Contact Liaison by email or on +44 (0)1242 388 531.