Skip to main content

Student record 2013/14

Back to C13051

COMMIT-stage validation


Version 1.1 Produced 2014-06-26

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 or 24 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 or 24) 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, 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, M26 and M28).
Course.COURSEID 1 Error Course.COURSEID must contain a unique identifier within an institution's return (i.e. all Course and CourseSubject entity data for the given COURSEID must be consistent).
Course.CourseSubject 1 Warning CourseSubject entity must exist for all courses at institutions in England where Course.FEQAIMC exists and is not in the Learning Aims Rates Service (LARS).
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 Rates Service (LARS) 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 3 Error For institutions in England, Course.MSFUND must not exist where all linked instances have Instance.FESTUMK = 1, 3 or 4.
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 4 or G.
Course.REDUCEDC 4 Error Course.REDUCEDC code 04 must have all occurrences of Instance.MODE coded 63 or 64.
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.CARELEAVER 1 Warning Where the institution is in England and holds the Buttle UK Quality Mark there are occurrences of EntryProfile.CARELEAVER = 04 and no occurrences of EntryProfile.CARELEAVER = 01. Please check it is correct that none of the students reported as care leavers meet the legal definition of a care leaver.
EntryProfile.CARELEAVER 2 Warning Where EntryProfile.CARELEAVER exists and Instance.COMDATE > Y1-07-31, more than 3% of instances, where this is a minimum of 10 instances, have EntryProfile.CARELEAVER = 01, 02, 03 or 04. As this appears to be a high level of care leavers, please check there are no systemic errors causing this field to be returned incorrectly.
EntryProfile.CARELEAVER 3 Warning For institutions in England, Northern Ireland and Wales, EntryProfile.CARELEAVER is coded as not known (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.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.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, M26 or M28) 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, M26 or M28) 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, M26 or M28) 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, M26 or M28) 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, M26 or M28) 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.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, M28, M50, M71, M86, E00 or D00 and Instance.INTERCALATE does not exist. 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, HR, 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, 31, 37 or 38. 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 or 25 and Instance.STULOAD is greater than or equal to 3 and Instance.EXCHANGE is not equal to 4 or G 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, M28 and M99) and Instance.MODE = 01, 02, 23, 24 or 25 and Instance.STULOAD is greater than or equal to 3 and Instance.EXCHANGE is not equal to 4 or G 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, M26 or M28 (excluding H99, I99, J99 and C99) and Instance.MODE = 01, 02, 23, 24 or 25 and Instance.STULOAD is greater than or equal to 3 and Instance.EXCHANGE is not equal to 4 or G 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 4 or G 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, M28 and M99) and Instance.MODE = 31 and Instance.STULOAD is greater than or equal to 3 and Instance.EXCHANGE is not equal to 4 or G 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, M26 or M28 (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 4 or G 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.FinancialSupport 1 Warning The total FinancialSupport.FINAMOUNT returned for instances where (Instance.REDUCEDI = 00 or 01) and Instance.FEEELIG = 1 and (Instance.FUNDCODE = 1 or 7) and (Course.COURSEAIM begins with H, I, J, C or is M22, M26, M28, M71 or M88 (excluding H50, H60, H61, H62, H78, H81, I60, I61 and I81)) and (Instance.EXCHANGE = N or Y or Instance.EXCHANGE does not exist) is less than the minimum value reported by OFFA . Please check that all financial support has been returned.
Instance.FinancialSupport 2 Warning The total number of instances where at least one occurrence of Instance.FinancialSupport exists and (Instance.REDUCEDI = 00 or 01) and Instance.FEEELIG = 1 and (Instance.FUNDCODE = 1 or 7) and (Course.COURSEAIM begins with H, I, J, C or is M22, M26, M28, M71 or M88 (excluding H50, H60, H61, H62, H78, H81, I60, I61 and I81)) and (Instance.EXCHANGE = N or Y or Instance.EXCHANGE does not exist), is less than the minimum number reported by OFFA. Please check that all financial support has been returned.
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.SPECFEE does 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, M28, M88, H00, H11, H16, H18, H22, H23, 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.SPECFEE does 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, M28, M88, H00, H11, H16, H18, H22, H23, 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.SPECFEE does 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.GROSSFEE 9 Warning Instance.GROSSFEE > 0 where Instance.TYPEYR = 2, 3, 4 or 5 and Instance.COMDATE < Y1-08-01 and Instance.ENDDATE > Y1-07-31 and Instance.ENDDATE < the anniversary of Instance.COMDATE and Instance.MODE is not equal to 43 or 44. In line with the published guidance, please check these fees are correct as it is expected that the full-fee for the year of instance will be returned in the reporting year within which the year of instance commenced.
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.
Instance.INITIATIVES 4 Warning Where Institution.UKPRN = 10007793, the count of instances where Instance.INITIATIVES = 7 is outside of the range of 1000 to 3500 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, M26 or M28) 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 or other non-UK EU country.
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, 10007796, 10007823, 10007848, 10007851 or 10040812.
Instance.INITIATIVES 8 Warning 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.INTERCALATE 1 Warning No instances with Instance.INTERCALATE = 01 where Instance.REDUCEDI = 00,01,03 and Course.COURSEAIM begins D,E,L,M,H,I and Institution.UKPRN = 10000886, 10007801, 10006840, 10007785, 10007786, 10007788, 10007143, 10007789, 10007792, 10007149, 10007767, 10007795, 10007796, 10006842, 10003270, 10003645, 10007775, 10007782, 10007784, 10007799, 10007154, 10007774, 10007157, 10007158, 10007806, 10007163, 10007167, 10007790, 10007794, 10007783, 10007814, 10007852, 10007855, 10005343, 10007798, 10007141, 10007768.
Instance.LOCSDY 1 Warning Instance.LOCSDY = S where EntryProfile.DOMICILE is coded XF, XG, XH, XI, or XK. Where the student is abroad for the whole or a proportion of the year as part of a UK based course Instance.LOCSDY should be coded T or U.
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, M26 and M28) 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, M26 and M28)) and (Instance.COMDATE < Y2-04-01) and (Instance.STULOAD less than or equal to 10) and (Instance.ENDDATE is null) and (Instance.EXCHANGE = N, 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.Mobility 1 Warning Where more than one mobility entity has been returned for an instance, the combination of Mobility.MOBDURA, Mobility.MOBLOCA, Mobility.MOBSCHEME and Mobility.MOBTYPE is not unique. Please check it is correct that identical mobilities have taken place during the year and that a mobility has not been duplicated.
Instance.NETFEE 1 Warning Instance.NETFEE = 0 where Instance.MODE = 01, 02, 23, 24, 25, 43 or 73 and Instance.SSN does not exist and (Instance.TYPEYR = 1 or (Instance.TYPEYR > 1 and Instance.ENDDATE is null)) and ((Instance.SPECFEE = 0, 1, 2, 4, 5, 6 or 9 or Instance.SPECFEE does not exist) and (Instance.MSTUFEE = 01-04, 06-26, 32-61, 96, 97 or 99) and (Course.MSFUND = 01-06, 11-29, 32-35, 38-91 and Instance.FUNDCODE = 2, 3, 5 or 7)). Please check it is correct that the net fee is zero for these instances.
Instance.NETFEE 2 Warning Instance.NETFEE = 0 where Instance.MODE = 31, 44 or 74 and Instance.SSN does not exist and (Instance.TYPEYR = 1 or (Instance.TYPEYR > 1 and Instance.ENDDATE is null)) and ((Instance.SPECFEE = 0, 1, 2, 4, 5, 6 or 9 or Instance.SPECFEE does not exist) and (Instance.MSTUFEE = 01-04, 06-26, 32-61, 96, 97 or 99) and (Course.MSFUND = 01-06, 11-29, 32-35, 38-91 and Instance.FUNDCODE = 2, 3, 5 or 7)). Please check it is correct that the net fee is zero for these instances.
Instance.NUMHUS 1 Error All Instance.NUMHUS for a Student.HUSID must be unique.
Instance.PLANEEPHOURS 1 Error When a Student.HUSID has more than one instance where Instance.PLANEEPHOURS exists, all occurrences of Instance.PLANEEPHOURS must be identical.
Instance.PLANLEARNHOURS 1 Error When a Student.HUSID has more than one instance where Instance.PLANLEARNHOURS exists, all occurrences of Instance.PLANLEARNHOURS must be identical.
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.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, M28, 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 have Instance.SPECFEE = 2 or 3 where any associated Mobility entity has Mobility.MOBSCHEME = 03. Please check that Instance.SPECFEE has been coded correctly for the outgoing 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 H60, H61, H62, I60, I61 and those ending with 90 or 99) or is M22, M26 or M28) and (Instance.MODE = 01, 02, 23, 24 or 25) 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 80% of instances where (Course.COURSEAIM begins H, I, J or C (excluding codes H60, H61, H62, I60, I61 and those ending with 90 or 99) or is M22, M26 or M28) 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 where Instance.MODE is not equal to 63 or 64.
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 and Instance.MODE is not equal to 63 or 64.
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 and Instance.MODE is not equal to 63 or 64.
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, M26 or M28) 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, M26 or M28) 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.STULOAD 14 Warning For institutions in England, Northern Ireland and Wales, Instance.STULOAD > 80 where Instance.MODE = 31 and Instance.TYPEYR = 1. Please check that the correct FTE has been reported for these instances.
Instance.STULOAD 15 Warning For institutions in England, Northern Ireland and Wales, Instance.STULOAD > 80 where Instance.MODE = 31 and Instance.TYPEYR = 2, 3, 4 or 5. Please check that the correct FTE has been reported for these instances.
Instance.StudentOnModule 1 Warning More than 40 StudentOnModule entity occurrences for this instance.
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 or 25.
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 or 25.
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.
Mobility.MOBLOCA 1 Warning More than 5% of all Instance.Mobility entities, where this is a minimum of 10 mobilities, have Mobility.MOBLOCA = EU, XP, XQ, XR, XS, XT, XU, XV, XW, XX or ZZ. Please check whether Mobility.MOBLOCA can be coded more accurately.
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.CRDTPTS 2 Error For institutions in England and Northern Ireland, Module.CRDTPTS must be coded 0 or 999 where Module.FTE = 0 and any associated instance ( linking via StudentOnModule ) has Instance.MODE not equal to 63 or 64.
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 2 Warning Where Module.TINST exists more than 10% are coded 4001.
Module.TINST 3 Error For institutions in England, Northern Ireland or Scotland, Module.TINST must contain a valid UKPRN where Course.CTITLE ( linking via StudentOnModule and Instance ) includes the word 'college'.
ModuleSubject.COSTCN 1 Error Where ModuleSubject.COSTCN is not equal to 999 and Module.TINST does not exist, 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.COSTCN 3 Warning Where ModuleSubject.COSTCN is not equal to 999 and Module.TINST exists and Module.PCOLAB < 100, the academic cost centre has not been submitted in AcademicCostCentres.ACCENTRE in the Institution profile record. When this is queried in Minerva please explain why this is genuine as a value of < 100 in Module.PCOLAB indicates that part of this module is being taught at the returning institution.
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 or 24 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.OUTCOME 1 Warning For institutions in England and Wales, where QualificationsAwarded.QUAL = I11, I71, H11, H71 or M71 and Instance.ITTPHSC is not equal to 31 or 49 and Course.TTCID = 1, 8, G, H, L, M, N or P, less than 80% of the awards have QualificationsAwarded.OUTCOME = 1. Please check whether it is genuine that QTS has been withheld for these ITT awards.
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.QUAL 5 Warning Where QualificationsAwarded.QUAL = D00 or D01, Instance.RSNEND = 02, 03, 04 or 06-99 or Instance.RSNEND does not exist. Please check that Instance.RSNEND is coded correctly as these doctoral awards do not meet the critieria for inclusion in REF.
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, M26 or M28) 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, M26 or M28) 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, M26 or M28) 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, M26 or M28) 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.
REFData.UOA2014 1 Error Where REFData.UOA2014 ends with A, B or C, i.e. is a multiple submission, the combination of Unit of Assessment code and multiple submission code do not exist in the look-up file of multiple submissions registered for REF2014 supplied by HEFCE.
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 For institutions in Northern Ireland, Scotland or Wales, 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 or 01.
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.ETHNIC 5 Error For institutions in England, 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 or Course.TTCID = 1, 8, G, H, L, M, N, P) and the corresponding Instance.REDUCEDI = 00, 01 or 07.
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, M26 or M28.
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, S or T.
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 or 25.
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 or 25.
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 01242 211144.