Skip to main content

HESA Student record 2011/12

Back to C11051

HESA Student record 2011/12

COMMIT-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.