HESA Student record 2012/13
COMMIT-stage validation
Version 1.4 Produced 2013-09-12
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.AWARDBOD | 1 | Error | Where Course.AWARDBOD contains a UKPRN, it must be the UKPRN of an institution with degree awarding powers. |
Course.AWARDBOD | 2 | Error | Where the institution is in England (excluding Colleges and Institutes of the University of London), Scotland or Northern Ireland and Institution.UKPRN is an institution with degree awarding powers, more than 20% of instances where (Course.COURSEAIM begins D, E, L, M, H, I, J or C and does not end with 99) and (Instance.REDUCEDI = 00, 01, 03, 04 or 08) do not have an occurrence of Course.AWARDBOD = Institution.UKPRN. |
Course.AWARDBOD | 3 | Error | Where the institution is a College or Institute of the University of London and Institution.UKPRN is an institution with degree awarding powers, more than 20% of instances where (Course.COURSEAIM begins D, E, L, M, H, I, J or C and does not end with 99) and (Instance.REDUCEDI = 00, 01, 03, 04 or 08) do not have an occurrence of Course.AWARDBOD = Institution.UKPRN or equal to 10007797. |
Course.AWARDBOD | 4 | Error | Where the institution is in Wales and Institution.UKPRN is an institution with degree awarding powers, more than 20% of instances where (Course.COURSEAIM begins D, E, L, M, H, I, J or C and does not end with 99) and (Instance.REDUCEDI = 00, 01, 03, 04 or 08) do not have an occurrence of Course.AWARDBOD = Institution.UKPRN or equal to 10008574. |
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 = 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 | Error | Course.FEQAIMC not found in Learning Aims Reference Application (LARA) 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.MSFUND | 3 | Error | For institutions in England, Course.MSFUND must not exist where all linked instances have Instance.FESTUMK = 1, 3 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 Health and Care Professions 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 Health and Care Professions 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 Health and Care Professions 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 (excluding X00 and X01) 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 or P94 where all of the associated QualificationsOnEntry.QUALTYPE are non-tariff bearing qualifications 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.QUALENT3 | 9 | Warning | EntryProfile.QUALENT3 should not be coded P93 where any associated QualificationsOnEntry.QUALTYPE is a non-tariff bearing level 3 qualification in either the HESA or UCAS definition of the tariff score. Please check that all the non-tariff bearing qualifications are level 2. If any of them are level 3, please review the coding of EntryProfile.QUALENT3. |
EntryProfile.QUALENT3 | 10 | Error | Where the institution is in England, more than 10% of instances where Course.COURSEAIM begins (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and Instance.COMDATE > Y1-07-31 and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) have EntryProfile.QUALENT3 = P80 and no QualificationsOnEntry data. |
EntryProfile.QUALENT3 | 11 | Warning | Where the institution is in England, more than 5% of instances where Course.COURSEAIM begins (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and Instance.COMDATE > Y1-07-31 and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) have EntryProfile.QUALENT3 = P80 and no QualificationsOnEntry data. |
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, P47, P50, P51, P62, P63, P64, P65, P68, P80, P93 or P94) 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, P47, P50, P51, P62, P63, P64, P65, P68, P80, P93 or P94) 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, P47, P50, P51, P62, P63, P64, P65, P68, P80, P93 or P94) 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, P47, P50, P51, P62, P63, P64, P65, P68, P80, P93 or P94) 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, P47, P50, P51, P62, P63, P64, P65, P68, P80, P93 or P94) with no QualificationsOnEntry entity. |
EntryProfile.QualificationsOnEntry | 11 | Error | Where the institution is in England, a level 3 tariff bearing qualification present 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 or is equal to X00 or X01). |
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 Instance.REDUCEDI not equal to 08 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 Institution profile 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.ENDDATE | 1 | Warning | Instance.ENDDATE should not be null where any QualificationsAwarded.QUAL = H00, H11, H16, H22, H23, H50, M00, M01, M10, M11, M16, M22, M50, M71, M86, E00 or D00. Please check it is correct that there is no end date for these awards as it is excluding them from the DLHE population. |
Instance.ENDDATE | 2 | Error | Instance.ENDDATE must be earlier than Instance.COMDATE + 15 days where Instance.REDUCEDI = 08. |
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.FEEREGIME | 1 | Warning | For institutions in England and Wales where Instance.FEEREGIME exists and Instance.COMDATE > 2012-08-31, more than 5% of instances have Instance.FEEREGIME = 10. |
Instance.FEEREGIME | 2 | Warning | For institutions in England, Northern Ireland and Wales where Instance.FEEREGIME exists and Instance.COMDATE < 2012-09-01, more than 5% of instances have Instance.FEEREGIME = 20. |
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 Welsh Government/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.GROSSFEE | 1 | Error | For institutions in England, Instance.GROSSFEE must be less than or equal to the OFFA agreed amount for postgraduate_ITT where (Course.COURSEAIM = M71, H71 or I71) and (Instance.FUNDCODE = 1 or 7) and (Instance.SPECFEE = 0, 3, 5, 6, 9 or Instance.SPECFEEdoes not exist). |
Instance.GROSSFEE | 2 | Error | For institutions in England, Instance.GROSSFEE must be less than or equal to 50% of the OFFA agreed amount for postgraduate_ITT where Course.COURSEAIM = (M71, H71 or I71) and (Instance.FUNDCODE = 1 or 7) and Instance.SPECFEE = 1, 2 or 4. |
Instance.GROSSFEE | 3 | Error | For institutions in England, Instance.GROSSFEE must be less than or equal to the OFFA agreed amount for first degrees where (Course.COURSEAIM = M22, M26, M88, H00, H11, H16, H18, H22, H23, H24, H41, H42, H43, H70, H76, H80, H88, H90, H99, I00, I11, I16, I70, I76, I80, I81, I90 or I99) and Instance.FUNDCODE = 1 and (Instance.SPECFEE = 0, 3, 5, 6, 9 or Instance.SPECFEEdoes not exist). |
Instance.GROSSFEE | 4 | Error | For institutions in England, Instance.GROSSFEE must be less than or equal to 50% of the OFFA agreed amount for first degrees where (Course.COURSEAIM = M22, M26, M88, H00, H11, H16, H18, H22, H23, H24, H41, H42, H43, H70, H76, H80, H88, H90, H99, I00, I11, I16, I70, I76, I80, I81, I90 or I99) and Instance.FUNDCODE = 1 and (Instance.SPECFEE = 1, 2 or 4). |
Instance.GROSSFEE | 5 | Error | For institutions in England, Instance.GROSSFEE must be less than or equal to the OFFA agreed amount for foundation degrees where (Course.COURSEAIM = J10 or J16) and Instance.FUNDCODE = 1 and (Instance.SPECFEE = 0, 3, 5, 6, 9 or Instance.SPECFEEdoes not exist). |
Instance.GROSSFEE | 6 | Error | For institutions in England, Instance.GROSSFEE must be less than or equal to 50% of the OFFA agreed amount for foundation degrees where (Course.COURSEAIM = J10 or J16) and Instance.FUNDCODE = 1 and (Instance.SPECFEE = 1, 2 or 4). |
Instance.GROSSFEE | 7 | Error | For institutions in England, Instance.GROSSFEE must be less than or equal to the OFFA agreed amount for HNC, HND, HE Certificates and HE Diplomas where (Course.COURSEAIM = J20, J26, J30, J41, J42, J43, J76, J80, J90, J99, C20, C30, C41, C42, C43, C80, C90 or C99) and Instance.FUNDCODE = 1 and (Instance.SPECFEE = 0, 3, 5, 6, 9 or Instance.SPECFEE does not exist). |
Instance.GROSSFEE | 8 | Error | For institutions in England, Instance.GROSSFEE must be less than or equal to 50% of the OFFA agreed amount for HNC, HND, HE Certificates and HE Diplomas where (Course.COURSEAIM = J20, J26, J30, J41, J42, J43, J76, J80, J90, J99, C20, C30, C41, C42, C43, C80, C90 or C99) and Instance.FUNDCODE = 1 and (Instance.SPECFEE = 1, 2 or 4). |
Instance.INITIATIVES | 1 | Warning | For institutions in England, the number of instances returned for a given code in Instance.INITIATIVES where Instance.MODE not equal to 63 or 64 is outside of the expected tolerance of -1% to +25% when compared with the number of students reported by HEFCE. |
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, Y1, Y2, Y3, Y4, Y5, Y6, Y7, Y8, Y9, YA, YB, YC, YD or YF. Please check that none of these entrants meet the criteria for initiatives code B. |
Instance.INITIATIVES | 6 | Error | Where Instance.INITIATIVES = A more than 5% of the instances do not have EntryProfile.DOMICILE = XF. |
Instance.INITIATIVES | 7 | Error | No instances returned with Instance.INITIATIVES = 2 where Institution.UKPRN = 10000291, 10000571, 10000886, 10001143, 10001282, 10001726, 10004351, 10004930, 10005790, 10006299, 10006566, 10007144, 10007145, 10007147, 10007161, 10007759, 10007785, 10007823, 10007848, 10007851 or 10040812. |
Instance.INITIATIVES | 8 | Error | For institutions in Wales, the number of instances returned for a given code in Instance.INITIATIVES where Instance.MODE not equal to 63 or 64 is outside of the expected tolerance of minimum of 5 instances being returned to +5% when compared with the number of students reported by HEFCW. |
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.MODE | 3 | Warning | Where Course.COURSEAIM begins D or L and Instance.MODE not equal to 51, 63, 64, 73 or 74, no instances have been coded with Instance.MODE = 43 or 44. Please check it is correct that no postgraduate research students have been writing-up during this reporting year. |
Instance.MODE | 4 | Warning | Instance.MODE has been coded 01 where Course.COURSEAIM begins D or L and Instance.YEARSTU > 4 and Instance.ENDDATE is null. Please check it is correct that these students are studying full-time and are not writing-up. |
Instance.MODE | 5 | Warning | For institutions in England, Instance.MODE should not be coded 01 where (Course.COURSEAIM begins D, E, L or M (excluding M22 and M26)) and (Instance.COMDATE < Y2-04-01) and (Instance.STULOAD less than or equal to 10) and (Instance.ENDDATE is null) and (Instance.EXCHANGE = 0, 7, B, C, D, E, Y or Z) and (Instance.LOCSDY not equal to S) and Instance.MCDATE is null. It is expected that these students will be in writing-up mode |
Instance.MODE | 6 | Warning | For institutions in England, Instance.MODE should not be coded 01, 23 or 24 where Instance.RSNEND = 01 and (Instance.ENDDATE > the anniversary of Instance.COMDATE + 14 days) and (Instance.ENDDATE < the anniversary of Instance.COMDATE + 24 weeks). Where a student has successfully completed the course, they have to study for at least 24 weeks within the year of instance to be returned as full-time or sandwich. |
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.NETFEE | 1 | Warning | Instance.NETFEE = 0 where Instance.MODE = 01, 02, 23, 24, 25, 43, 52, 53 or 73 and (Instance.SPECFEE = 0, 1, 2, 4, 5, 6 or 9 or Instance.SPECFEE does not exist) |
Instance.NETFEE | 2 | Warning | Instance.NETFEE = 0 where Instance.MODE = 31, 44 or 74 and (Instance.SPECFEE = 0, 1, 2, 4, 5, 6 or 9 or Instance.SPECFEE does not exist) |
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.REDUCEDI | 1 | Warning | There are no instances with Instance.REDUCEDI = 08 where (Course.COURSEAIM begins H, I, J, C (excluding H90, H99, I90, I99, J90, J99, C90, C99), or is M22, M26, M71 or M88) and (Instance.MODE = 01, 02, 23, 24 or 25) and Instance.COMDATE > Y1-07-31. Please check that any students who have applied for a loan and started and left the course within the first two weeks have been included in the student collection as a full return. |
Instance.RSNEND | 1 | Error | More than 20% of instances where Instance.RSNEND does not exist where QualificationsAwarded.QUAL exists. |
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.SSN | 1 | Error | The same Instance.SSN must not be returned for more than one Student.HUSID as Instance.SSN is unique to a person. The same person should not have more than one HUSID |
Instance.SSN | 2 | Warning | For a single Student.HUSID the same Instance.SSN has been returned for more than one instance. Please check that the student support genuinely applies to all the instances. |
Instance.SSN | 3 | Warning | A Student.HUSID has more than one instance where Instance.SSN exists and not all of the occurrences of Instance.SSN are identical. Please check it is correct for the student to have more than one SSN. |
Instance.SSN | 4 | Error | For institutions in England, Northern Ireland and Wales no Instance.SSN has been returned for more than 20% of instances where (Course.COURSEAIM begins H, I, J or C (excluding codes ending with 90 or 99) or is M22 or M26) and (Instance.MODE = 01, 02, 23, 24, 25, 52 or 53) and Instance.FEEELIG = 1 and (Instance.FUNDCODE = 1 or 7). |
Instance.SSN | 5 | Error | For institutions in England and Northern Ireland, no Instance.SSN has been returned for more than 75% of instances where (Course.COURSEAIM begins H, I, J or C (excluding codes ending with 90 or 99) or is M22 or M26) and (Instance.MODE = 31) and Instance.FEEELIG = 1 and (Instance.FUNDCODE = 1 or 7). |
Instance.SSN | 6 | Warning | Where Instance.SSN links to the data supplied by the SLC, Student.BIRTHDTE is not equal to the date of birth held by the SLC. Please check that the date of birth in the HESA return is correct. |
Instance.SSN | 7 | Warning | For institutions in England, Northern Ireland and Wales, Instance.SSN does not link to the data supplied by the SLC. |
Instance.SSN | 8 | Warning | For institutions in Scotland, Instance.SSN does not link to the data supplied by the SLC where EntryProfile.DOMICILE (including those previously sent for the student) = XH. |
Instance.SSN | 9 | Warning | For institutions in Scotland, Instance.SSN does not link to the data supplied by the SLC where EntryProfile.DOMICILE (including those previously sent for the student) is not equal to XH. |
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.STULOAD | 10 | Warning | For institutions in England, Northern Ireland and Wales, more than 5% of instances have Instance.STULOAD greater than or equal to 100 where Instance.TYPEYR not equal to 1 and Instance.COMDATE > Y1-07-31. For further information please see the documentation in the coding manual - Further guidance on FTE reporting. |
Instance.STULOAD | 11 | Warning | For institutions in England, Northern Ireland and Wales, more than 5% of instances have Instance.STULOAD greater than or equal to 100 where Instance.TYPEYR not equal to 1 and Instance.ENDDATE > Y1-07-31. For further information please see the documentation in the coding manual - Further guidance on FTE reporting. |
Instance.STULOAD | 12 | Warning | Instance.STULOAD < 100 where (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and Instance.TYPEYR = 1 and Instance.MODE = 01 and Instance.COMDATE between Y1-08-31 and Y1-10-31 inclusive and Instance.ENDDATE is null and Instance.NOTACT does not exist. Please check that the correct FTE has been reported for these instances. |
Instance.STULOAD | 13 | Warning | For institutions in England, Northern Ireland and Wales, Instance.STULOAD < 50 where (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and Instance.MODE = 01 and Instance.COMDATE between Y1-11-01 and Y2-01-31 inclusive and Instance.ENDDATE is null and Instance.NOTACT does not exist. Please check that the correct FTE has been reported for these instances. |
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). |
Instance.YEARSTU | 3 | Warning | Instance.YEARSTU minus Instance.YEARPRG is greater than 2 where Instance.YEARSTU > Instance.YEARPRG and Instance.MODE = 01, 02, 23, 24 25, 52 or 53. |
Instance.YEARSTU | 4 | Warning | Instance.YEARSTU minus Instance.YEARPRG is greater than 2 where Instance.YEARSTU > Instance.YEARPRG and Instance.MODE = 31, 38 or 39. |
Instance.YEARSTU | 5 | Warning | Instance.YEARPRG minus Instance.YEARSTU is greater than 2 where Instance.YEARPRG > Instance.YEARSTU and Instance.YEARPRG is not equal to 99 and Instance.MODE = 01, 02, 23, 24 25, 52 or 53. |
Instance.YEARSTU | 6 | Warning | Instance.YEARPRG minus Instance.YEARSTU is greater than 2 where Instance.YEARPRG > Instance.YEARSTU and Instance.YEARPRG is not equal to 99 and Instance.MODE = 31, 38 or 39. |
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.FRANIND | 1 | Error | Module.FRANIND must exist for institutions in Wales where any associated Course.COURSEAIM (linking via StudentOnModule and Instance) begins with D, E, L, M, H, I, J or C. |
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.COSTCN | 1 | Error | Where ModuleSubject.COSTCN is not equal to 999 the academic cost centre has not been submitted in AcademicCostCentres.ACCENTRE in the Institution profile record. |
ModuleSubject.COSTCN | 2 | Error | Where AcademicCostCentres.ACCENTRE has been submitted in the Institution profile record but is not coded in any occurrence of ModuleSubject.COSTCN. Please note that for a match on AcademicCostCentres.ACCENTRE to ModuleSubject.COSTCN there must be at least one student studying that module. |
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 level 3 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 or is equal to X00 or X01). |
QualificationsOnEntry.QUALGRADE | 7 | Warning | Where the institution is in England more than 0.5% of QualificationsOnEntry records for a level 3 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 or is equal to X00 or X01). |
QualificationsOnEntry.QUALGRADE | 8 | Error | Where the institution is in England, more than 1% of level 3 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 or is equal to X00 or X01). |
QualificationsOnEntry.QUALGRADE | 9 | Warning | Where the institution is in England, more than 0.5% of level 3 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 or is equal to X00 or X01). |
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.GENDERID | 1 | Warning | Where Student.GENDERID has been returned, all occurrences are coded 98. Please check that code 98 is not being used as an unknown value where the question has not been asked, rather than indicating that the student preferred not to answer the question. |
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.SEXID, 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. |
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.RELBLF | 1 | Warning | Where Student.RELBLF has been returned, all occurrences are coded 98. Please check that code 98 is not being used as an unknown value where the question has not been asked, rather than indicating that the student preferred not to answer the question. |
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.SEXID | 1 | Warning | It is not expected for there to be more than 2% of students with Student.SEXID = 3. Please check that there are no systemic errors causing this field to be returned incorrectly. |
Student.SEXORT | 1 | Warning | Where Student.SEXORT has been returned, all occurrences are coded 98. Please check that code 98 is not being used as an unknown value where the question has not been asked, rather than indicating that the student preferred not to answer the question. |
Student.SEXORT | 2 | Warning | Where Student.SEXORT has been returned, it is not expected for there to be more than 5% of students with Student.SEXORT = 02 and Student.SEXID = 2. Please check that there are no systemic errors causing this field to be returned incorrectly. |
Student.SEXORT | 3 | Warning | Where Student.SEXORT has been returned, it is not expected for there to be more than 5% of students with Student.SEXORT = 03 and Student.SEXID = 1. Please check that there are no systemic errors causing this field to be returned incorrectly. |
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.APEL | 1 | Error | Where StudentOnModule.APEL = 2 all occurrences of StudentOnModule.APEL for the same StudentOnModule.MODID must be coded 2. |
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.