HESA Student record 2011/12
HESA Student record 2011/12COMMIT-stage validation |
return to index |
Version 1.2 Produced 2012-07-31
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
Field Name | Number | Severity | Rule |
Course.BITTM | 1 | Warning | Where Course.BITTM is coded 1 or 2 at least one StudentOnModule entity for students on that course should have StudentOnModule.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 = 10007846, 10007858, 10007854, 10007856 or 10007857 |
Course.BITTM | 3 | Warning | Where an institution is in Wales Course.BITTM should not be coded 0 where Course.TTCID = 2 and any associated CourseSubject.SBJCA = Q560. It is expected that where one of the subjects for an ITT course is Welsh, the course will enable students to teach bilingually. |
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.COURSEAIM | 5 | Error | For institutions in England, there must not be more than 3 instances for a single Student.HUSID where Course.COURSEAIM begins D, E, L or M (excluding M22 and M26). |
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 Aim Reference Application (LARA). |
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 Reference Application (LARA) 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) and not '66666666' and 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 20% 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. |
CourseSubject.SBJCA | 1 | Warning | More than 10% of instances where any CourseSubject.SBJCA = Y000. |
CourseSubject.SBJCA | 3 | Error | For institutions in Northern Ireland and Wales, where Course.COURSEAIM = H16 and Instance.MODE = 01, where any CourseSubject.SBJCA = A300, there must be at least one occurrence of CourseSubject.SBJCA = A100 linked to a course where Course.COURSEAIM = H16. |
CourseSubject.SBJCA | 4 | Error | For institutions in Northern Ireland and Wales, where Course.COURSEAIM = H16 and Instance.MODE = 01, where any CourseSubject.SBJCA = A400, there must be at least one occurrence of CourseSubject.SBJCA = A200 linked to a course where Course.COURSEAIM = H16. |
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.DOMICILE | 5 | Error | Where the institution is in England, Scotland or Wales, more than 5% of instances have EntryProfile.DOMICILE = XK where Instance.COMDATE > Y1-07-31 and Course.COURSEAIM is not equal to X41 - X46 |
EntryProfile.DOMICILE | 6 | Warning | Where the institution is in England, Scotland or Wales, more than 2% of instances have EntryProfile.DOMICILE = XK where Instance.COMDATE > Y1-07-31 and Course.COURSEAIM is not equal to X41 - X46 |
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.PREVINST | 5 | Warning | Where EntryProfile.PREVINST begins with D, H or U and (EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM) and (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and corresponding Instance.COMDATE is later than Y1-07-31, the school code is not a known value in the PI reference data. If the data is genuine please contact HESA so that the record of school codes can be updated prior to the publication of performance indicators. |
EntryProfile.QUALENT3 | 1 | Error | More than 5% of instances at an institution in England where Instance.FUNDCODE = 1 and (Instance.MODE = 01, 23 or 24) and where exists in the in-coming data (EntryProfile.QUALENT3 = X06 or EntryProfile.QUALENT2 = 99). |
EntryProfile.QUALENT3 | 2 | Error | More than 20% of instances at an institution in England where Instance.FUNDCODE = 1 and (Instance.MODE = 02, 25 or 31) and where exists in the in-coming data (EntryProfile.QUALENT3 = X06 or EntryProfile.QUALENT2 = 99). |
EntryProfile.QUALENT3 | 3 | Warning | More than 5% of instances at an institution in Northern Ireland, Scotland or Wales where Instance.FUNDCODE = 1 and (Instance.MODE = 01, 23 or 24) and where exists in the in-coming data (EntryProfile.QUALENT3 = X06 or EntryProfile.QUALENT2 = 99). |
EntryProfile.QUALENT3 | 4 | Warning | More than 20% of instances at an institution in Northern Ireland, Scotland or Wales where Instance.FUNDCODE = 1 and (Instance.MODE = 02, 25 or 31) and where exists in the in-coming data (EntryProfile.QUALENT3 = X06 or EntryProfile.QUALENT2 = 99). |
EntryProfile.QUALENT3 | 5 | Error | EntryProfile.QUALENT3 must not be coded P92 or begin with Q, R or X when the tariff score is greater than 0. |
EntryProfile.QUALENT3 | 6 | Warning | EntryProfile.QUALENT3 is unknown (X06), 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.QUALENT3 | 7 | Error | EntryProfile.QUALENT3 must not be coded P91 where none of the associated QualificationsOnEntry.QUALTYPE is a tariff bearing qualification in either the HESA or UCAS definition of the tariff score. Please see the appendix in the specification for XTARIFF for details of the qualifications included in the tariff definitions. |
EntryProfile.QUALENT3 | 8 | Error | EntryProfile.QUALENT3 must not be coded P92 where at least one of the associated QualificationsOnEntry.QUALTYPE is a tariff bearing qualification in either the HESA or UCAS definition of the tariff score. Please see the appendix in the specification for XTARIFF for details of the qualifications included in the tariff definitions. |
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.QualificationsOnEntry | 6 | Error | More than 5% of instances where Instance.COMDATE > Y1-07-31 and Student.BIRTHDTE later than (Y1-21)-08-31 and Instance.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 is coded P41, P42, P46, P50, P51, P62, P63, P64, P65, P68, P80 or P91) with no QualificationsOnEntry entity. |
EntryProfile.QualificationsOnEntry | 7 | Warning | Where the institution is in Northern Ireland, Scotland or Wales there are more than 10% of instances where Instance.COMDATE > Y1-07-31 and (Student.BIRTHDTE is null or earlier than (Y1-21)-09-01) and Instance.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 is coded P41, P42, P46, P50, P51, P62, P63, P64, P65, P68, P80 or P91) with no QualificationsOnEntry entity. |
EntryProfile.QualificationsOnEntry | 8 | Warning | Where the institution is in England more than 2% of instances where Instance.COMDATE > Y1-07-31 and Student.BIRTHDTE later than (Y1-21)-08-31 and Instance.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 is coded P41, P42, P46, P50, P51, P62, P63, P64, P65, P68, P80 or P91) with no QualificationsOnEntry entity. |
EntryProfile.QualificationsOnEntry | 9 | Error | Where the institution is in England there are more than 10% of instances where Instance.COMDATE > Y1-07-31 and (Student.BIRTHDTE is null or earlier than (Y1-21)-09-01) and Instance.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 is coded P41, P42, P46, P50, P51, P62, P63, P64, P65, P68, P80 or P91) with no QualificationsOnEntry entity. |
EntryProfile.QualificationsOnEntry | 10 | Warning | Where the institution is in England there are more than 5% of instances where Instance.COMDATE > Y1-07-31 and (Student.BIRTHDTE is null or earlier than (Y1-21)-09-01) and Instance.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 is coded P41, P42, P46, P50, P51, P62, P63, P64, P65, P68, P80 or P91) with no QualificationsOnEntry entity. |
EntryProfile.QualificationsOnEntry | 11 | Error | Where the institution is in England, a tariff bearing qualification in the UCAS (*J) data is not present in the HESA return for an instance where (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and (Instance.MODE = 01, 23 or 24) and (Instance.COMDATE > Y1-07-31) and (EntryProfile.DOMICILE = XK, XF, XI, XH or XG) and (EntryProfile.QUALENT3 begins with P). |
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.COMDATE | 6 | Warning | Where the institution is England, 1% or more of instances starting in this reporting year where (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and Instance.FUNDCODE = 1 and Instance.STULOAD > 19.9 have Instance.COMDATE = Y1-08-01. Please explain why this is genuine for your institution when the query relating to this specific warning is raised in Minerva. |
Instance.COMDATE | 7 | Warning | Where the institution is England, 5% or more of instances starting in this reporting year where (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and Instance.FUNDCODE = 1 and Instance.STULOAD > 19.9 have Instance.COMDATE between Y1-08-01 and Y1-08-31 inclusive. Please explain why this is genuine for your institution when the query relating to this specific warning is raised in Minerva. |
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.DISALL | 2 | Error | More than 10 students where Instance.DISALL exists and Student.DISABLE = 00, 97, 98 or 99. |
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.FUNDCODE | 3 | Error | Where the institution is in England or Northern Ireland no instances have Instance.FUNDCODE = 1 where (Course.COURSEAIM begins with D or L) and (EntryProfile.DOMICILE is UK or Other EU). |
Instance.FUNDCODE | 4 | Warning | Where the institution is in England or Northern Ireland less than 80% of instances have Instance.FUNDCODE = 1 where (Course.COURSEAIM begins with D or L) and (EntryProfile.DOMICILE is UK or Other EU). |
Instance.FUNDCODE | 5 | Warning | Where the institution is in England, Northern Ireland or Wales more than 20 instances have Instance.FUNDCODE = 1 where Course.MSFUND = 13 or 31. It is not expected that instances will be fundable by Funding Council when the major source of funding for the course is NLIAH/NHS. |
Instance.FUNDCOMP | 1 | Warning | More than 10% of instances with Instance.FUNDCOMP = 9 where Course.COURSEAIM begins with D or L (excluding L99) and Instance.MODE = 01, 02, 23, 24, 25, 52 or 53 and Instance.STULOAD is greater than or equal to 3 and Instance.EXCHANGE is not equal to 2, 4, 8, 9 or A and Institution.UKPRN is not equal to 10007787, 10008010 or 10008026. |
Instance.FUNDCOMP | 2 | Warning | More than 10% of instances with Instance.FUNDCOMP = 9 where Course.COURSEAIM begins with E or M (excluding M22, M26 and M99) and Instance.MODE = 01, 02, 23, 24, 25, 52 or 53 and Instance.STULOAD is greater than or equal to 3 and Instance.EXCHANGE is not equal to 2, 4, 8, 9 or A and Institution.UKPRN is not equal to 10007787, 10008010 or 10008026. |
Instance.FUNDCOMP | 3 | Warning | More than 10% of instances with Instance.FUNDCOMP = 9 where Course.COURSEAIM begins with H, I, J, C or is M22 or M26 (excluding H99, I99, J99 and C99) and Instance.MODE = 01, 02, 23, 24, 25, 52 or 53 and Instance.STULOAD is greater than or equal to 3 and Instance.EXCHANGE is not equal to 2, 4, 8, 9 or A and Institution.UKPRN is not equal to 10007787, 10008010 or 10008026. |
Instance.FUNDCOMP | 4 | Warning | More than 10% of instances with Instance.FUNDCOMP = 9 where Course.COURSEAIM begins with D or L (excluding L99) and Instance.MODE = 31 and Instance.STULOAD is greater than or equal to 3 and Instance.EXCHANGE is not equal to 2, 4, 8, 9 or A and Institution.UKPRN is not equal to 10007787, 10008010 or 10008026. |
Instance.FUNDCOMP | 5 | Warning | More than 10% of instances with Instance.FUNDCOMP = 9 where Course.COURSEAIM begins with E or M (excluding M22, M26 and M99) and Instance.MODE = 31 and Instance.STULOAD is greater than or equal to 3 and Instance.EXCHANGE is not equal to 2, 4, 8, 9 or A and Institution.UKPRN is not equal to 10007787, 10008010 or 10008026. |
Instance.FUNDCOMP | 6 | Warning | More than 10% of instances with Instance.FUNDCOMP = 9 where Course.COURSEAIM begins with H, I, J, C or is M22 or M26 (excluding H99, I99, J99 and C99) and Instance.MODE = 31 and Instance.STULOAD is greater than or equal to 3 and Instance.EXCHANGE is not equal to 2, 4, 8, 9 or A and Institution.UKPRN is not equal to 10007787, 10008010 or 10008026. |
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.INITIATIVES | 1 | Warning | More than 25% difference in the number of instances returned for a given code in Instance.INITIATIVES where Instance.MODE not equal to 63 or 64, and the number of students reported by HEFCE. |
Instance.INITIATIVES | 2 | Error | No instances returned with Instance.INITIATIVES = 3, 4 or 5 where Institution.UKPRN = 10000291, 10003861, 10006299, 10007138, 10007145, 10007150, 10007801 or 10007851. |
Instance.INITIATIVES | 3 | Error | No instances returned with Instance.INITIATIVES = 7 where Institution.UKPRN = 10007793 or 10007853. |
Instance.INITIATIVES | 4 | Warning | Where Institution.UKPRN = 10007793 or 10007853, the count of instances where Instance.INITIATIVES = 7 is outside of the range of 200 to 1500 expected by HEFCW. |
Instance.INITIATIVES | 5 | Warning | For institutions in England there are no instances with Instance.INITIATIVES = B where (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and (Instance.MODE = 01, 23 or 24) and Instance.COMDATE > Y1-07-31 and (EntryProfile.DOMICILE = XK, XF, XI, XH or XG) and at least one occurrence of QualificationsOnEntry.QUALTYPE = LD. In-line with HEFCE's guidance on the classification of Access to HE Diplomas for student control numbers, check that none of these entrants meet the criteria for initiatives code B. |
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.MODE | 2 | Warning | For institutions in England, where Course.COURSEAIM begins, D, E, L or M (excluding M22 and M26) and Instance.MODE not equal to 43, 44, 51, 63 or 64, no instances have been coded with Instance.MODE = 73 or 74. Please check it is correct that no postgraduate students have changed from an active to a dormant mode part way through the reporting year. |
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 entity (including those previously sent) has (EntryProfile.QUALENT2 = 03 or 10) or EntryProfile.QUALENT3 = H11. |
Instance.QTS | 2 | Error | Instance.QTS cannot be coded 3 where the corresponding EntryProfile entity (including those previously sent) has (EntryProfile.QUALENT2 = 04, 37 - 98) or EntryProfile.QUALENT3 begins with P, Q, R or X (excluding X06). |
Instance.QTS | 3 | Warning | Instance.QTS should not be coded 4 where EntryProfile.QUALENT3 (including those previously sent) is coded M71 or H71. |
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.SKEITT | 1 | Error | The UKPRN in Instance.SKEITT is not in the list of approved ITT providers supplied by the TA. |
Instance.SPECFEE | 1 | Warning | No instances where Instance.EXCHANGE = C have Instance.SPECFEE = 2 or 3. Please check that Instance.SPECFEE has been coded correctly for the outgoing LLP ERASMUS students. |
Instance.StudentOnModule | 1 | Warning | More than 40 StudentOnModule entity occurrences for this instance. |
Instance.STULOAD | 1 | Error | For institutions in England, Northern Ireland and Wales, where Course.COURSEAIM begins D, E, L, M, H, I, J or C and Instance.COMDATE > Y1-07-31 and Instance.ENDDATE is null, Instance.STULOAD must not be greater than 5 times the number of elapsed weeks between Instance.COMDATE and Y2-07-31 (inclusive) unless Instance.BRIDGE = 1 at an institution in England or Northern Ireland. |
Instance.STULOAD | 2 | Error | For institutions in England, Northern Ireland and Wales, where Course.COURSEAIM begins D, E, L, M, H, I, J or C and Instance.COMDATE < Y1-08-01 and Instance.ENDDATE > Y1-07-31, Instance.STULOAD must not be greater than 5 times the number of elapsed weeks between Y1-08-01 and Instance.ENDDATE (inclusive) unless Instance.BRIDGE = 1 at an institution in England or Northern Ireland. |
Instance.STULOAD | 3 | Error | For institutions in England, Northern Ireland and Wales, where Course.COURSEAIM begins D, E, L, M, H, I, J or C and both Instance.COMDATE and Instance.ENDDATE are in this reporting year, Instance.STULOAD must not be greater than 5 times the number of elapsed weeks between Instance.COMDATE and Instance.ENDDATE (inclusive) unless Instance.BRIDGE = 1 at an institution in England or Northern Ireland. |
Instance.STULOAD | 4 | Error | For institutions in England and Northern Ireland, where Course.COURSEAIM begins M, H, I, J or C and Instance.BRIDGE = 1 and Instance.COMDATE > Y1-07-31 and Instance.ENDDATE is null, (Instance.STULOAD - 30) must not be greater than 5 times the number of elapsed weeks between Instance.COMDATE and Y2-07-31 (inclusive). |
Instance.STULOAD | 5 | Error | For institutions in England and Northern Ireland, where Course.COURSEAIM begins M, H, I, J or C and Instance.BRIDGE = 1 and Instance.COMDATE < Y1-08-01 and Instance.ENDDATE > Y1-07-31, (Instance.STULOAD - 30) must not be greater than 5 times the number of elapsed weeks between Y1-08-01 and Instance.ENDDATE (inclusive) |
Instance.STULOAD | 6 | Error | For institutions in England and Northern Ireland, where Course.COURSEAIM begins M, H, I, J or C and Instance.BRIDGE = 1 and both Instance.COMDATE and Instance.ENDDATE are in this reporting year, (Instance.STULOAD - 30) must not be greater than 5 times the number of elapsed weeks between Instance.COMDATE and Instance.ENDDATE (inclusive) |
Instance.STULOAD | 7 | Warning | For institutions in England, Northern Ireland and Wales, where Course.COURSEAIM begins P, Q, R, S or X (excluding X41 - X46) and Instance.COMDATE > Y1-07-31 and Instance.ENDDATE is null, Instance.STULOAD must not be greater than 5 times the number of elapsed weeks between Instance.COMDATE and Y2-07-31 (inclusive). |
Instance.STULOAD | 8 | Warning | For institutions in England, Northern Ireland and Wales, where Course.COURSEAIM begins P, Q, R, S or X (excluding X41 - X46) and Instance.COMDATE < Y1-08-01 and Instance.ENDDATE > Y1-07-31, Instance.STULOAD must not be greater than 5 times the number of elapsed weeks between Y1-08-01 and Instance.ENDDATE (inclusive). |
Instance.STULOAD | 9 | Warning | For institutions in England, Northern Ireland and Wales, where Course.COURSEAIM begins P, Q, R, S or X (excluding X41 - X46) and both Instance.COMDATE and Instance.ENDDATE are in this reporting year, Instance.STULOAD must not be greater than 5 times the number of elapsed weeks between Instance.COMDATE and Instance.ENDDATE (inclusive). |
Instance.YEARSTU | 1 | Warning | More than 5% of instances where Instance.TYPEYR = 1 have Instance.YEARSTU less than the difference in years between Instance.COMDATE and Y2-07-31. |
Instance.YEARSTU | 2 | Warning | Instance.YEARSTU is greater than 10 where the programme of study is full-time (Instance.MODE = 01, 02 or 73). |
Institution.INSTAPP | 1 | Error | Institution.INSTAPP must be consistent within an institution's return. |
Module.CRDTPTS | 1 | Error | Where Module.CRDTPTS is coded 999 for institutions in Wales, all associated Course.COURSEAIM codes (linking via StudentOnModule and Instance) must begin with P, Q, R, S or X. |
Module.CRDTSCM | 1 | Error | Where Module.CRDTSCM is coded 9 for institutions in Wales, all associated Course.COURSEAIM codes (linking via StudentOnModule and Instance) must begin with P, Q, R, S or X. |
Module.CRDTSCM | 2 | Error | Module.CRDTSCM must be coded 2 for institutions in Scotland where any associated Course.COURSEAIM codes (linking via StudentOnModule and Instance) do not begin with D or L. |
Module.CRDTSCM | 3 | Error | Module.CRDTSCM must be coded 2 or 9 for institutions in Scotland where all associated Course.COURSEAIM codes (linking via StudentOnModule and Instance) begin with D or L. |
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 = 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 | Where the institution is in Northern Ireland, Scotland or Wales more than 10% of QualificationsOnEntry records with no QualificationsOnEntry.QUALGRADE. |
QualificationsOnEntry.QUALGRADE | 3 | Error | QualificationsOnEntry.QUALGRADE is invalid for the HESA tariff bearing qualification in QualificationsOnEntry.QUALTYPE. |
QualificationsOnEntry.QUALGRADE | 4 | Warning | QualificationsOnEntry.QUALGRADE is invalid for the HESA non-tariff bearing qualification in QualificationsOnEntry.QUALTYPE. |
QualificationsOnEntry.QUALGRADE | 6 | Error | Where the institution is in England more than 1% of QualificationsOnEntry records for a tariff bearing qualification with no QualificationsOnEntry.QUALGRADE for instances where (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and Instance.COMDATE > Y1-07-31 and Instance.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 begins with P). |
QualificationsOnEntry.QUALGRADE | 7 | Warning | Where the institution is in England more than 0.5% of QualificationsOnEntry records for a tariff bearing qualification with no QualificationsOnEntry.QUALGRADE for instances where (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and Instance.COMDATE > Y1-07-31 and Instance.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 begins with P). |
QualificationsOnEntry.QUALGRADE | 8 | Error | Where the institution is in England, more than 1% of tariff bearing qualifications in the HESA return have a lower grade than the same qualification in the UCAS (*J) data for instances where (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and (Instance.MODE = 01, 23 or 24) and (Instance.COMDATE > Y1-07-31) and (EntryProfile.DOMICILE = XK, XF, XI, XH or XG) and (EntryProfile.QUALENT3 begins with P). |
QualificationsOnEntry.QUALGRADE | 9 | Warning | Where the institution is in England, more than 0.5% of tariff bearing qualifications in the HESA return have a lower grade than the same qualification in the UCAS (*J) data for instances where (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and (Instance.MODE = 01, 23 or 24) and (Instance.COMDATE > Y1-07-31) and (EntryProfile.DOMICILE = XK, XF, XI, XH or XG) and (EntryProfile.QUALENT3 begins with P). |
QualificationsOnEntry.QUALTYPE | 1 | Warning | The grade structure is not known by HESA for the qualification returned in QualificationsOnEntry.QUALTYPE. Please check the qualification details are correct. |
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 M6, M7, M8, 6M, 7M, 8M or 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 coded as no known disability (00) 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 | 2 | Error | More than 10 students where Student.DISABLE = 00, 97, 98 or 99 and Instance.DISALL exists. |
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 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 and Course.COURSEAIM begins with H, I, J, C, P, Q, R, S or X or is M22 or M26. |
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) and Instance.LOCSDY is not coded 6, 9, D, F or S. |
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 and the corresponding Instance.REDUCEDI is not equal to 04. |
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. |
StudentOnModule.LANGPCNT | 1 | Error | At least one StudentOnModule.LANGPCNT must be greater than 0 where Module.MODLANG is coded 1, 2 or 3. |
StudentOnModule.MODCOUNT | 1 | Warning | For institutions in Wales, more than 40% of student on module records coded as StudentOnModule.MODCOUNT = 1 where Course.COURSEAIM begins D, E, L, M, H, I, J or C and Instance.FUNDCODE = 2. It is expected that most modules will count towards the credit points of the qualification. |
StudentOnModule.MODOUT | 1 | Warning | For institutions in England and Wales, more than 5% of student on module records coded as StudentOnModule.MODOUT = 6 where StudentOnModule.MODSTAT = 1 and Instance.MODE = 01, 02, 23, 24, 25, 52 or 53. |
StudentOnModule.MODOUT | 2 | Warning | For institutions in England and Wales, more than 15% of student on module records coded as StudentOnModule.MODOUT = 6 where StudentOnModule.MODSTAT = 1 and Instance.MODE = 31. |
StudentOnModule.MODOUT | 3 | Warning | For institutions in England and Wales, more than 5% of student on module records coded as StudentOnModule.MODOUT = 6 where StudentOnModule.MODSTAT = 2 and Instance.MODE = 01, 02, 23, 24, 25, 52 or 53. |
StudentOnModule.MODOUT | 4 | Warning | For institutions in England and Wales, more than 15% of student on module records coded as StudentOnModule.MODOUT = 6 where StudentOnModule.MODSTAT = 2 and Instance.MODE = 31. |
StudentOnModule.MODSTAT | 1 | Warning | For institutions in England and Wales where Course.COURSEAIM begins D, E, L, M, H, I, J or C, there are more than 500 student on module records where StudentOnModule.MODSTAT = 1, but no records where StudentOnModule.MODSTAT = 3. |
StudentOnModule.MODSTAT | 2 | Warning | For institutions in England and Wales where Course.COURSEAIM begins D, E, L, M, H, I, J or C, there are more than 500 student on module records where StudentOnModule.MODSTAT = 3, but no records where StudentOnModule.MODSTAT = 1. |
StudentOnModule.MODSTAT | 3 | Warning | For institutions in England and Wales where Course.COURSEAIM begins D, E, L, M, H, I, J or C, where there are more than 500 student on module records where StudentOnModule.MODSTAT = 1, the count of records where StudentOnModule.MODSTAT = 3 should be at least 50% of the count of records where StudentOnModule.MODSTAT = 1. |
StudentOnModule.MODSTAT | 4 | Warning | For institutions in England and Wales where Course.COURSEAIM begins D, E, L, M, H, I, J or C, where there are more than 500 student on module records where StudentOnModule.MODSTAT = 3, the count of records where StudentOnModule.MODSTAT = 1 should be at least 50% of the count of records where StudentOnModule.MODSTAT = 3. |
Contact Liaison by email or on +44 (0)1242 388 531.