HESA Student Record 2009/10
HESA Student Record 2009/10Commit-stage validation |
return to index |
Version 1.1 Produced 2010-08-30
This document lists the COMMIT validation checks that will be applied during the COMMIT transaction of the data collection system. An explanation of the different stages of validation is shown in the validation overview document.
Validation Checks at COMMIT
| Course.BITTM | 1 | Warning | Where Course.BITTM is coded 1 or 2 at least one module in that course should have Module.LANGPCNT > 0. |
| Course.BITTM | 2 | Warning | There are no courses where Course.TTCID = 1 or 2 and Course.BITTM = 1 or 2 for Institution.UKPRN = 10007048, 10007846, 10007854, 10007856 or 10007857 |
| Course.COURSEAIM | 2 | Error | Multiple occurrences of Course.COURSEAIM appear for a single Student.HUSID where (first character of Course.COURSEAIM = D, E, L, M, H, I, J or C and second and third characters of Course.COURSEAIM are not 90 or 99) and Instance.MODE = 01, 23, 24, 52 or 53 and Instance.ENDDATE is blank and the sum of all Instance.STULOAD for the Student.HUSID is greater than 125.0. |
| Course.COURSEAIM | 3 | Warning | Multiple occurrences of Course.COURSEAIM appear for a single Student.HUSID where Course.COURSEAIM in (C90, H90, I90, J90, D90, E90, L90, M90, C99, H99, I99, J99, L99, M99) and Instance.MODE in (01, 23, 24, 52, 53) and Instance.ENDDATE is blank and the sum of all Instance.STULOAD for the Student.HUSID is greater than 125.0. |
| Course.COURSEAIM | 4 | Warning | Multiple occurrences of Course.COURSEAIM appear for a single Student.HUSID where (first character of Course.COURSEAIM = D, E, L, M, H, I, J or C and second and third characters of Course.COURSEAIM are not 90 or 99) and Instance.MODE not in (01, 23, 24, 52, 53, 63, 64) and Instance.ENDDATE is blank. |
| Course.COURSEID | 1 | Error | Course.COURSEID must contain a unique identifier within an institution's return (i.e. all Course and CourseSubject entity data for the given COURSEID must be consistent). |
| Course.CourseSubject | 1 | Warning | CourseSubject entity must exist for all courses at institutions in England where Course.FEQAIMC exists and is not in the Learning Aims Database (LAD). |
| Course.CourseSubject | 2 | Warning | CourseSubject entity must exist for all courses at institutions in Wales where Course.FEQAIMC exists and (is not in the Welsh Learning Aims Database (WLAD) and Course.COURSEAIM is not coded X41 - X46) |
| Course.FEQAIMC | 1 | Warning | Course.FEQAIMC not found in Learning Aims Database (LAD) or not ‘66666666’ where institution in England and Instance.FESTUMK = 1, 3 or 4. |
| Course.FEQAIMC | 2 | Error | Course.FEQAIMC must not exist for institutions in England or Wales where all Instance.FESTUMK = 2. |
| Course.FEQAIMC | 4 | Warning | Course.FEQAIMC not found in the Welsh Learning Aims Database (WLAD) or not ‘66666666’ or not a Welsh For Adults Course (WFA courses have Course.COURSEAIM = X41 - X46) where institution in Wales and Instance.FESTUMK = 1, 3 or 4. |
| Course.MSFUND | 2 | Error | Course.MSFUND codes 47, 62 - 64, 73 - 79, 83, 85 - 89, 92 - 99, AA, AB, AC and AD must have all Instance.FESTUMK = 1 or 4 |
| Course.NHSBURSARY | 1 | Error | All courses have Course.NHSBURSARY = 0 where all occurrences of CourseSubject.SBJCA have a first character of A or B and Institution.UKPRN = 10000886, 10003270, 10003645, 10006840, 10006842, 10007143, 10007149, 10007154, 10007157, 10007158, 10007163, 10007167, 10007767, 10007774, 10007775, 10007782, 10007784, 10007785, 10007786, 10007788, 10007789, 10007792, 10007795, 10007796, 10007798, 10007799, 10007801, or 10007806. |
| Course.REDUCEDC | 1 | Warning | Where Course.REDUCEDC not equal to 00 all linked instances must either have Instance.REDUCEDI = 00 or Instance.REDUCEDI must be equal to the value in Course.REDUCEDC. |
| Course.REDUCEDC | 2 | Error | Course.REDUCEDC code 01 must have all occurrences of Instance.STULOAD less than or equal to 010.0. |
| Course.REDUCEDC | 3 | Error | Course.REDUCEDC code 03 must have all occurrences of Instance.EXCHANGE coded 2, 4, 8, 9 or A. |
| Course.REDUCEDC | 4 | Error | Course.REDUCEDC code 04 must have all occurrences of Instance.MODE coded 63 or 64. |
| Course.REGBODY | 1 | Error | No instances have been returned for courses where Course.REGBODY = 08, but the General Social Care Council have reported that there are students on their approved courses at this institution. |
| Course.REGBODY | 2 | Error | Instances have been returned for courses where Course.REGBODY = 08, but the General Social Care Council have reported that there are no students on their approved courses at this institution. |
| Course.REGBODY | 3 | Warning | More than 10% difference in the number of instances returned for courses where Course.REGBODY = 08 and Instance.MODE not equal to 63 or 64, and the number of students reported by the General Social Care Council as actively studying on their approved courses at this institution. |
| Course.TTCID | 1 | Error | Multiple instances appear for a single Student.HUSID where Course.TTCID = E and Instance.MODE not equal to 63 or 64. |
| CourseSubject.SBJCA | 1 | Warning | More than 10% of instances where any CourseSubject.SBJCA = Y000. |
| EntryProfile.DOMICILE | 4 | Warning | EntryProfile.DOMICILE is unknown (ZZ), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return. |
| EntryProfile.NEWENT | 1 | Warning | More than 500 students aged 18 or under with EntryProfile.NEWENT = A and Course.COURSEAIM begins D,E,L,M,H,I,J,C. |
| EntryProfile.PGCECLSS | 4 | Warning | EntryProfile.PGCECLSS is unknown (99), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return. |
| EntryProfile.POSTCODE | 1 | Error | Where exists EntryProfile.POSTCODE must contain a valid full postcode or a valid outward part of a postcode. |
| EntryProfile.POSTCODE | 4 | Error | More than 10 young (between 18 and 21), full-time, undergraduate students returned with identical EntryProfile.POSTCODE (where exists). |
| EntryProfile.POSTCODE | 5 | Warning | More than 10 young (between 18 and 21), full-time, undergraduate students, not in own accommodation (Student.TTACCOM = 1,4,8,9), have EntryProfile.POSTCODE = Student.TTPCODE (where EntryProfile.POSTCODE and Student.TTPCODE exists). |
| EntryProfile.POSTCODE | 6 | Warning | For institutions in England, Scotland and Wales, where exists EntryProfile.POSTCODE should be located in the country of EntryProfile.DOMICILE |
| EntryProfile.POSTCODE | 7 | Error | For institutions in Northern Ireland, where exists EntryProfile.POSTCODE must be located in the country of EntryProfile.DOMICILE. (Restricted to cases where either EntryProfile.POSTCODE or EntryProfile.DOMICILE is coded as being in Northern Ireland.) |
| EntryProfile.POSTCODE | 8 | Warning | For institutions in Northern Ireland, where exists EntryProfile.POSTCODE should be located in the country of EntryProfile.DOMICILE. (Excludes cases where either EntryProfile.POSTCODE or EntryProfile.DOMICILE is coded as being in Northern Ireland.) |
| EntryProfile.POSTCODE | 9 | Warning | EntryProfile.POSTCODE is unknown (null), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return. |
| EntryProfile.PREVINST | 4 | Warning | EntryProfile.PREVINST is a generic or unknown code, but has a learner provider code in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return. |
| EntryProfile.QUALENT2 | 4 | Error | More than 5% of instances at an institution in England where Instance.FUNDCODE = 1 and Instance.MODE in ( 01, 23, 24) and where exists in the in-coming data EntryProfile.QUALENT2 = 99. |
| EntryProfile.QUALENT2 | 5 | Error | More than 20% of instances at an institution in England where Instance.FUNDCODE = 1 and Instance.MODE in ( 02, 25, 31) and where exists in the in-coming data EntryProfile.QUALENT2 = 99. |
| EntryProfile.QUALENT2 | 6 | Warning | More than 5% of instances at an institution in Northern Ireland, Scotland or Wales where Instance.FUNDCODE = 1 and Instance.MODE in ( 01, 23, 24) and where exists in the in-coming data EntryProfile.QUALENT2 = 99. |
| EntryProfile.QUALENT2 | 7 | Warning | More than 20% of instances at an institution in Northern Ireland, Scotland or Wales where Instance.FUNDCODE = 1 and Instance.MODE in ( 02, 25, 31) and where exists in the in-coming data EntryProfile.QUALENT2 = 99. |
| EntryProfile.QUALENT2 | 8 | Warning | EntryProfile.QUALENT2 is unknown (99), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return. |
| EntryProfile.QualificationsOnEntry | 1 | Error | More than 50% of instances where Instance.COMDATE is in the current reporting year and EntryProfile.UCASAPPID exists and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and Instance.MODE is in (01, 23, 24) and (EntryProfile.QUALENT2 exists and is coded 39 or 40) with no QualificationsOnEntry entity. |
| EntryProfile.QualificationsOnEntry | 4 | Error | Multiple identical qualifications on entry for this instance i.e. the combination of QualificationsOnEntry.QUALTYPE, QualificationsOnEntry.QUALSBJ, QualificationsOnEntry.QUALGRADE, QualificationsOnEntry.QUALYEAR and QualificationsOnEntry.QUALSIT all occur more than once |
| EntryProfile.QualificationsOnEntry | 5 | Warning | The total tariff score for this instance is greater than 1000 points. |
| EntryProfile.SEC | 4 | Warning | EntryProfile.SEC is not classified (9), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return. |
| EntryProfile.SOC2000 | 4 | Warning | EntryProfile.SOC2000 is coded as not stated (0000), Information refused (0001) or not known (0009), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return. |
| EntryProfile.UCASAPPID | 1 | Error | More than 20% of instances where Instance.COMDATE is in the current reporting year and Instance.MODE is in (01, 23, 24) and Instance.LOCSDY not equal to S and Course.COURSEAIM (begins H, I, J, C or is M22 or M26) and EntryProfile.DOMICILE is in (XK, XF, XI, XH, XG) and EntryProfile.UCASAPPID does not exist. |
| EntryProfile.YRLLINST | 4 | Warning | EntryProfile.YRLLINST is unknown (9999), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return. |
| Instance.CAMPID | 1 | Error | Instance.CAMPID must contain a valid character 1 - 9, A - Z and have been submitted in the Campus Information System. |
| Instance.COMDATE | 2 | Error | More than 100 instances at an institution in England where Instance.MODE in (02, 25, 31, 74) and Course.COURSEAIM does not end with '90' have Instance.COMDATE earlier than (Y1-7)-07-31. |
| Instance.COMDATE | 3 | Error | More than 50 instances at an institution in England where Instance.MODE in (01, 23, 24) and CourseSubject.SBJCA does not begin with A have Instance.COMDATE earlier than (Y1-5)-07-31. |
| Instance.COMDATE | 4 | Warning | More than 100 instances at an institution in Northern Ireland, Scotland or Wales where Instance.MODE in (02, 25, 31, 74) and Course.COURSEAIM does not end with '90' have Instance.COMDATE earlier than (Y1-7)-07-31. |
| Instance.COMDATE | 5 | Warning | More than 50 instances at an institution in Northern Ireland, Scotland or Wales where Instance.MODE in (01, 23, 24) and CourseSubject.SBJCA does not begin with A have Instance.COMDATE earlier than (Y1-5)-07-31. |
| Instance.DESTOCM | 1 | Warning | More than 10 students with an instance where Instance.DESTOCM = ZZ. |
| Instance.DISALL | 1 | Error | Instance.DISALL code 4 must have an EntryProfile.DOMICILE (including those previously sent for the student) = GG, JE, XL, XK, IM, XF, XI, XH or XG. |
| Instance.EntryProfile | 2 | Error | EntryProfile entity must exist where the corresponding Instance has not been previously reported (i.e. cannot be found on the EP Lookup Table). |
| Instance.FEEELIG | 1 | Error | Instance.FEEELIG must be coded 2 where the corresponding EntryProfile.DOMICILE (including those previously sent for the student) = IM, XL, GG or JE unless Instance.FESTUMK = 1 or 3. |
| Instance.FUNDCODE | 1 | Error | More than 500 instances where institution in England, Wales or Northern Ireland and Instance.FUNDCODE coded 1 where (EntryProfile.DOMICILE exists and is not in (XK, XL, GG, JE, IM, XF, XI, XH, XG, AT, BE, XA, CZ, DK, FI, FR, DE, GI, GR, HU, IE, IT, LU, MT, NL, PL, PT, ES, SE, ZZ, AA, EE, LV, LT, SI, SK, RO, BG)) . |
| Instance.FUNDCODE | 2 | Warning | Instance.FUNDCODE should not be coded 1 where Instance.LOCSDY = 6 and Instance.COMDATE earlier than Y1-08-01 and EntryProfile.DOMICILE not in (XF, XG, XH, XI or XK). |
| Instance.FUNDLEV | 1 | Warning | If any Instance.FUNDLEV = 20 or 21 for a Course.COURSEID then Instance.FUNDLEV must be 20, 21 or 99 for all other instances for the same Course.COURSEID. |
| Instance.FUNDLEV | 2 | Warning | If any Instance.FUNDLEV = 10 or 11 for a Course.COURSEID then Instance.FUNDLEV must be 10,11 or 99 for all other instances for the same Course.COURSEID. |
| Instance.FUNDLEV | 3 | Warning | If any Instance.FUNDLEV = 30 or 31 for a Course.COURSEID then Instance.FUNDLEV must be 30,31 or 99 for all other instances for the same Course.COURSEID. |
| Instance.INSTCAMP | 1 | Error | Instance.INSTCAMP must exist and contain a valid full postcode or a valid outward postcode for institutions in Wales where Course.COURSEAIM is coded X41 to X46 |
| Instance.LOCSDY | 1 | Warning | Instance.LOCSDY = S where EntryProfile.DOMICILE is coded XF, XG, XH, XI, or XK. Where the student is on a study year abroad as part of a UK based course Instance.LOCSDY should be coded F or G. |
| Instance.MODE | 1 | Warning | More than 6 students with an instance where Instance.MODE = 51. |
| Instance.MSTUFEE | 1 | Warning | Instance.MSTUFEE should not be coded 02, 04, 52 or 54 where the corresponding EntryProfile.DOMICILE (including those previously sent for the student) = XH. |
| Instance.MSTUFEE | 2 | Warning | Instance.MSTUFEE should not be coded 02, 03, 52 or 53 where the corresponding EntryProfile.DOMICILE (including those previously sent for the student)= XG. |
| Instance.MSTUFEE | 3 | Warning | Instance.MSTUFEE should not be coded 03, 04, 53 or 54 where the corresponding EntryProfile.DOMICILE (including those previously sent for the student)= XF or XI. |
| Instance.NUMHUS | 1 | Error | All Instance.NUMHUS for a Student.HUSID must be unique. |
| Instance.QTS | 1 | Error | Instance.QTS cannot be coded 4 where the corresponding EntryProfile.QUALENT2 (including those previously sent) = 03 or 10. |
| Instance.QTS | 2 | Error | Instance.QTS cannot be coded 3 where the corresponding EntryProfile.QUALENT2 (including those previously sent) = 04, 37 - 98. |
| Instance.RCSTDNT | 1 | Warning | No Research Council funded instances have been returned for a given Research Council, but the Research Council have reported that there are funded students at this institution. |
| Instance.RCSTDNT | 2 | Warning | Research Council funded instances have been returned for a given Research Council, but the Research Council have reported that there are no funded students at this institution. |
| Instance.RCSTDNT | 3 | Warning | More than 10% of Research Council funded instances have Instance.RCSTDNT = 09 (Research Council not specified). The instances should be coded to the appropriate Research Council where possible. |
| Instance.RSNEND | 1 | Error | More than 20% of instances where Instance.RSNEND does not exist where QualificationsAwarded.QUAL exists. |
| Instance.SASSCHL | 1 | Error | The URN for the school in Instance.SASSCHL was not active in the EduBase Database during the current reporting year and is not coded 'XXXXXX'. |
| Instance.SASSCHL | 2 | Error | All occurrences of Instance.SASSCHL = ‘XXXXXX’ (unknown). |
| Instance.StudentOnModule | 1 | Warning | More than 40 StudentOnModule entity occurrences for this instance. |
| Institution.INSTAPP | 1 | Error | Institution.INSTAPP must be consistent within an institution's return. |
| Module.MODID | 1 | Error | Module.MODID must be unique within an institution's return (i.e. all Module and ModuleSubject entity data for a given Module must be consistent). |
| Module.TINST | 1 | Error | Module.TINST must = 4001, 4002, 4003 or 4004 where all linked Instance.FROUTARR = 01 - 80. |
| Module.TINST | 2 | Warning | Where Module.TINST exists more than 10% are coded 4001. |
| ModuleSubject.MODSBJ | 1 | Warning | Where (first character of Course.COURSEAIM = D, E, L, M, H, I, J or C and second and third characters of Course.COURSEAIM are not 90 or 99) and Instance.MODE = 01, 23, 24, 52 or 53 and a student instance is attached to a single module then at least one ModuleSubject.MODSBJ must contain a code in the same JACS Subject Area (XJACSA01) as at least one of the CourseSubject.SBJCA codes. |
| QualificationsAwarded.QUAL | 1 | Warning | Multiple identical occurrences of QualificationsAwarded.QUAL appear for a single Student.HUSID where (first character of QualificationsAwarded.QUAL = D, E, L, M, and second and third characters of QualificationsAwarded.QUAL are not 90). |
| QualificationsAwarded.QUAL | 4 | Warning | Multiple identical occurrences of QualificationsAwarded.QUAL appear for a single Student.HUSID where (first character of QualificationsAwarded.QUAL = H, I, J or C and second and third characters of QualificationsAwarded.QUAL are not 90). |
| QualificationsAwarded.TQGSUB | 1 | Error | If QualificationsAwarded.TQGSUB is coded 360 for more than 10 records then fail. |
| QualificationsOnEntry.QUALGRADE | 1 | Error | More than 10% QualificationsOnEntry records with no QualificationsOnEntry.QUALGRADE. |
| QualificationsOnEntry.QUALYEAR | 1 | Error | For institutions in England, Northern Ireland and Wales, where Student.BIRTHDTE is not null and more than 10 students ( Student.HUSID ) where at least one QualificationsOnEntry.QUALYEAR for QualificationsOnEntry.QUALTYPE other than SS is not greater than (Student.BIRTHDTE + 15) year. |
| Student.BIRTHDTE | 3 | Warning | Student.BIRTHDTE is unknown (null), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return. |
| Student.DISABLE | 1 | Warning | Student.DISABLE is unknown (99), not sought (98) or refused (97) but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return. |
| Student.ETHNIC | 1 | Error | Student.ETHNIC must exist where any EntryProfile.DOMICILE (including those previously sent for the student) = XF, XG, XH, XI, XK, XL, GG, JE or IM and the corresponding Instance.REDUCEDI = 00, 01, 06 or 07 |
| Student.ETHNIC | 4 | Warning | Student.ETHNIC is unknown (90) or information refused (98), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return. |
| Student.GENDER | 2 | Error | More than 1 student where Student.GENDER = 9. |
| Student.HUSID | 1 | Error | Student.HUSID must be unique within an institutions return (i.e. all student entity data for the given HUSID must be consistent). |
| Student.HUSID | 2 | Warning | Multiple occurrences of Student.BIRTHDTE, Student.GENDER, soundex (Student.SURNAME) and soundex (Student.FNAMES), with different Student.HUSIDs. |
| Student.NATION | 1 | Error | Student.NATION code XC must have Instance.COMDATE before 2007-08-01 unless EntryProfile.UCASAPPID exists. |
| Student.NATION | 2 | Warning | Student.NATION is unknown (ZZ), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return. |
| Student.NATIOND | 1 | Error | Student.NATIOND must exist where Welsh institution and any EntryProfile.DOMICILE (including those previously sent for the student) = XI and the corresponding Instance.REDUCEDI = 00 or 02. |
| Student.NATIOND | 2 | Warning | Student.NATIOND is unknown (U) or information refused (R), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return. |
| Student.SCN | 1 | Error | Student.SCN must exist where any EntryProfile.DOMICILE (including those previously sent for the student) = XH and the corresponding EntryProfile.UCASAPPID exists and Course.COURSEAIM begins H, I, J, C, P, Q, R or S. |
| Student.SCN | 2 | Error | Student.SCN must exist where Scottish institution and any EntryProfile.DOMICILE (including those previously sent for the student) = XH and Course.COURSEAIM begins H, I, J, C, P, Q, R or S. |
| Student.TTPCODE | 1 | Warning | More than 50 young (between 18 and 21), full-time, undergraduate students, at parental home (Student.TTACCOM = 2), have Student.TTPCODE (where exists) not equal to EntryProfile.POSTCODE |
| Student.TTPCODE | 2 | Warning | More than 150 students have the same Student.TTPCODE (where exists) and do not have Student.TTACCOM =1 or 9. |
| Student.TTPCODE | 3 | Error | More than 600 students have the same Student.TTPCODE (where exists) and do not have Student.TTACCOM =1 or 9. |
| Student.TTPCODE | 4 | Warning | Where exists Student.TTPCODE must contain a valid full postcode or a valid outward part of a postcode. |
| Student.TTPCODE | 5 | Error | Where exists Student.TTPCODE must not equal EntryProfile.POSTCODE where Student.TTACCOM = 1 or 9. |
| Student.TTPCODE | 6 | Warning | Where exists Student.TTPCODE should not equal EntryProfile.POSTCODE where Student.TTACCOM = 8. |
| Student.TTPCODE | 7 | Error | Student.TTPCODE must not be in Northern Ireland, Channel Islands or Isle of Man where institution is in England, Scotland or Wales and Instance.MODE is in (01,12,23,24,73). |
| Student.TTPCODE | 8 | Error | More than 50% of students on courses where Course.TTCID = E have Student.TTPCODE coded as null (unknown) |
| Student.TTPCODE | 9 | Error | More than 50% of students on courses where Course.TTCID = F have Student.TTPCODE coded as null (unknown) |
| Student.UCASPERID | 2 | Error | Student.UCASPERID must exist where any EntryProfile.UCASAPPID (including those previously sent for the student) exists and is a 4 character code. |
| Student.WELSSP | 1 | Error | Student.WELSSP must exist where Welsh institution and any EntryProfile.DOMICILE (including those previously sent for the student) = XI and the corresponding Instance.REDUCEDI = 00. |
Contact Liaison by email or on +44 (0)1242 388 531.