Skip to main content

HESA Student record 2010/11

Back to C10051

HESA Student record 2010/11

Commit-stage validation


return to index

Version 1.2 Produced 2011-08-31

This document lists the COMMIT validation checks that will be applied during the COMMIT transaction of the data collection system. An explanation of the different stages of validation is shown in the validation overview document.

Validation Checks at COMMIT

Course.BITTM 1 Warning Where Course.BITTM is coded 1 or 2 at least one StudentOnModule entity for students on that course should have StudentOnModule.LANGPCNT > 0.
Course.BITTM 2 Warning There are no courses where Course.TTCID = 1 or 2 and Course.BITTM = 1 or 2 for Institution.UKPRN = 10007846, 10007858, 10007854, 10007856 or 10007857
Course.BITTM 3 Warning Where an institution is in Wales Course.BITTM should not be coded 0 where Course.TTCID = 1 or 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 Aims Database (LAD).
Course.CourseSubject 2 Warning CourseSubject entity must exist for all courses at institutions in Wales where Course.FEQAIMC exists and (is not in the Welsh Learning Aims Database (WLAD) and Course.COURSEAIM is not coded X41 - X46)
Course.FEQAIMC 1 Warning Course.FEQAIMC not found in Learning Aims Database (LAD) or not '66666666' where institution in England and Instance.FESTUMK = 1, 3 or 4.
Course.FEQAIMC 2 Error Course.FEQAIMC must not exist for institutions in England or Wales where all Instance.FESTUMK = 2.
Course.FEQAIMC 4 Warning Course.FEQAIMC not found in the Welsh Learning Aims Database (WLAD) and not '66666666' and not a Welsh For Adults Course (WFA courses have Course.COURSEAIM = X41 - X46) where institution in Wales and Instance.FESTUMK = 1, 3 or 4.
Course.MSFUND 2 Error Course.MSFUND codes 47, 62 - 64, 73 - 79, 83, 85 - 89, 92 - 99, AA, AB, AC and AD must have all Instance.FESTUMK = 1 or 4
Course.NHSBURSARY 1 Error All courses have Course.NHSBURSARY = 0 where all occurrences of CourseSubject.SBJCA have a first character of A or B and Institution.UKPRN = 10000886, 10003270, 10003645, 10006840, 10006842, 10007143, 10007149, 10007154, 10007157, 10007158, 10007163, 10007167, 10007767, 10007774, 10007775, 10007782, 10007784, 10007785, 10007786, 10007788, 10007789, 10007792, 10007795, 10007796, 10007798, 10007799, 10007801, or 10007806.
Course.REDUCEDC 1 Warning Where Course.REDUCEDC not equal to 00 all linked instances must either have Instance.REDUCEDI = 00 or Instance.REDUCEDI must be equal to the value in Course.REDUCEDC.
Course.REDUCEDC 2 Error Course.REDUCEDC code 01 must have all occurrences of Instance.STULOAD less than or equal to 010.0.
Course.REDUCEDC 3 Error Course.REDUCEDC code 03 must have all occurrences of Instance.EXCHANGE coded 2, 4, 8, 9 or A.
Course.REDUCEDC 4 Error Course.REDUCEDC code 04 must have all occurrences of Instance.MODE coded 63 or 64.
Course.REGBODY 1 Error No instances have been returned for courses where Course.REGBODY = 08, but the General Social Care Council have reported that there are students on their approved courses at this institution.
Course.REGBODY 2 Error Instances have been returned for courses where Course.REGBODY = 08, but the General Social Care Council have reported that there are no students on their approved courses at this institution.
Course.REGBODY 3 Warning More than 20% difference in the number of instances returned for courses where Course.REGBODY = 08 and Instance.MODE not equal to 63 or 64, and the number of students reported by the General Social Care Council as actively studying on their approved courses at this institution.
Course.TTCID 1 Error Multiple instances appear for a single Student.HUSID where Course.TTCID = E and Instance.MODE not equal to 63 or 64.
CourseSubject.SBJCA 1 Warning More than 10% of instances where any CourseSubject.SBJCA = Y000.
CourseSubject.SBJCA 2 Warning CourseSubject.SBJCA should not be coded C000, C100, C600, C800, F000, L230, L390, L700, L900, N100, P300, P390, Q300, Q800, R900, V100, V600, W210, W300, W400, W500, W900 or X900 where Course.TTCID = E. The TDA have advised that these subject codes are not valid for SAS courses and will fail the TDA validation rules.
EntryProfile.DOMICILE 4 Warning EntryProfile.DOMICILE is unknown (ZZ), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return.
EntryProfile.NEWENT 1 Warning More than 500 students aged 18 or under with EntryProfile.NEWENT = A and Course.COURSEAIM begins D,E,L,M,H,I,J,C.
EntryProfile.PGCECLSS 4 Warning EntryProfile.PGCECLSS is unknown (99), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return.
EntryProfile.POSTCODE 1 Error Where exists EntryProfile.POSTCODE must contain a valid full postcode or a valid outward part of a postcode.
EntryProfile.POSTCODE 4 Error More than 10 young (between 18 and 21), full-time, undergraduate students returned with identical EntryProfile.POSTCODE (where exists).
EntryProfile.POSTCODE 5 Warning More than 10 young (between 18 and 21), full-time, undergraduate students, not in own accommodation (Student.TTACCOM = 1,4,8,9), have EntryProfile.POSTCODE = Student.TTPCODE (where EntryProfile.POSTCODE and Student.TTPCODE exists).
EntryProfile.POSTCODE 6 Warning For institutions in England, Scotland and Wales, where exists EntryProfile.POSTCODE should be located in the country of EntryProfile.DOMICILE
EntryProfile.POSTCODE 7 Error For institutions in Northern Ireland, where exists EntryProfile.POSTCODE must be located in the country of EntryProfile.DOMICILE. (Restricted to cases where either EntryProfile.POSTCODE or EntryProfile.DOMICILE is coded as being in Northern Ireland.)
EntryProfile.POSTCODE 8 Warning For institutions in Northern Ireland, where exists EntryProfile.POSTCODE should be located in the country of EntryProfile.DOMICILE. (Excludes cases where either EntryProfile.POSTCODE or EntryProfile.DOMICILE is coded as being in Northern Ireland.)
EntryProfile.POSTCODE 9 Warning EntryProfile.POSTCODE is unknown (null), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return.
EntryProfile.PREVINST 4 Warning EntryProfile.PREVINST is a generic or unknown code, but has a learner provider code in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return.
EntryProfile.PREVINST 5 Warning Where EntryProfile.PREVINST begins with D, H or U and (EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM) and (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and corresponding Instance.COMDATE is later than Y1-07-31, the school code is not a known value in the PI reference data. If the data is genuine please contact HESA so that the record of school codes can be updated prior to the publication of performance indicators.
EntryProfile.QUALENT3 1 Error More than 5% of instances at an institution in England where Instance.FUNDCODE = 1 and (Instance.MODE = 01, 23 or 24) and where exists in the in-coming data (EntryProfile.QUALENT3 = X06 or EntryProfile.QUALENT2 = 99).
EntryProfile.QUALENT3 2 Error More than 20% of instances at an institution in England where Instance.FUNDCODE = 1 and (Instance.MODE = 02, 25 or 31) and where exists in the in-coming data (EntryProfile.QUALENT3 = X06 or EntryProfile.QUALENT2 = 99).
EntryProfile.QUALENT3 3 Warning More than 5% of instances at an institution in Northern Ireland, Scotland or Wales where Instance.FUNDCODE = 1 and (Instance.MODE = 01, 23 or 24) and where exists in the in-coming data (EntryProfile.QUALENT3 = X06 or EntryProfile.QUALENT2 = 99).
EntryProfile.QUALENT3 4 Warning More than 20% of instances at an institution in Northern Ireland, Scotland or Wales where Instance.FUNDCODE = 1 and (Instance.MODE = 02, 25 or 31) and where exists in the in-coming data (EntryProfile.QUALENT3 = X06 or EntryProfile.QUALENT2 = 99).
EntryProfile.QUALENT3 5 Error EntryProfile.QUALENT3 must not be coded P92 or begin with Q, R or X when the tariff score is greater than 0.
EntryProfile.QUALENT3 6 Warning EntryProfile.QUALENT3 is unknown (X06), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return.
EntryProfile.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 P50, P62, P63, P64, P65, P68 or P91) with no QualificationsOnEntry entity.
EntryProfile.QualificationsOnEntry 7 Warning Where the institution is in Northern Ireland, Scotland or Wales there are more than 10% of instances where Instance.COMDATE > Y1-07-31 and (Student.BIRTHDTE is null or earlier than (Y1-21)-09-01) and Instance.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 is coded P50, P62, P63, P64, P65, P68 or P91) with no QualificationsOnEntry entity.
EntryProfile.QualificationsOnEntry 8 Warning Where the institution is in England more than 2% of instances where Instance.COMDATE > Y1-07-31 and Student.BIRTHDTE later than (Y1-21)-08-31 and Instance.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 is coded P50, P62, P63, P64, P65, P68 or P91) with no QualificationsOnEntry entity.
EntryProfile.QualificationsOnEntry 9 Error Where the institution is in England there are more than 10% of instances where Instance.COMDATE > Y1-07-31 and (Student.BIRTHDTE is null or earlier than (Y1-21)-09-01) and Instance.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 is coded P50, P62, P63, P64, P65, P68 or P91) with no QualificationsOnEntry entity.
EntryProfile.QualificationsOnEntry 10 Warning Where the institution is in England there are more than 5% of instances where Instance.COMDATE > Y1-07-31 and (Student.BIRTHDTE is null or earlier than (Y1-21)-09-01) and Instance.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 is coded P50, P62, P63, P64, P65, P68 or P91) with no QualificationsOnEntry entity.
EntryProfile.QualificationsOnEntry 11 Error Where the institution is in England, a tariff bearing qualification in the UCAS (*J) data is not present in the HESA return for an instance where (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and (Instance.MODE = 01, 23 or 24) and (Instance.COMDATE > Y1-07-31) and (EntryProfile.DOMICILE = XK, XF, XI, XH or XG) and (EntryProfile.QUALENT3 begins with P).
EntryProfile.SEC 4 Warning EntryProfile.SEC is not classified (9), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return.
EntryProfile.SOC2000 4 Warning EntryProfile.SOC2000 is coded as not stated (0000), Information refused (0001) or not known (0009), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return.
EntryProfile.UCASAPPID 1 Error More than 20% of instances where Instance.COMDATE is in the current reporting year and Instance.MODE is in (01, 23, 24) and Instance.LOCSDY not equal to S and Course.COURSEAIM (begins H, I, J, C or is M22 or M26) and EntryProfile.DOMICILE is in (XK, XF, XI, XH, XG) and EntryProfile.UCASAPPID does not exist.
EntryProfile.YRLLINST 4 Warning EntryProfile.YRLLINST is unknown (9999), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return.
Instance.CAMPID 1 Error Instance.CAMPID must contain a valid character 1 - 9, A - Z and have been submitted in the Campus Information System.
Instance.COMDATE 2 Error More than 100 instances at an institution in England where Instance.MODE in (02, 25, 31, 74) and Course.COURSEAIM does not end with '90' have Instance.COMDATE earlier than (Y1-7)-07-31.
Instance.COMDATE 3 Error More than 50 instances at an institution in England where Instance.MODE in (01, 23, 24) and CourseSubject.SBJCA does not begin with A have Instance.COMDATE earlier than (Y1-5)-07-31.
Instance.COMDATE 4 Warning More than 100 instances at an institution in Northern Ireland, Scotland or Wales where Instance.MODE in (02, 25, 31, 74) and Course.COURSEAIM does not end with '90' have Instance.COMDATE earlier than (Y1-7)-07-31.
Instance.COMDATE 5 Warning More than 50 instances at an institution in Northern Ireland, Scotland or Wales where Instance.MODE in (01, 23, 24) and CourseSubject.SBJCA does not begin with A have Instance.COMDATE earlier than (Y1-5)-07-31.
Instance.COMDATE 6 Warning Where the institution is England, 1% or more of instances starting in this reporting year where (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and Instance.FUNDCODE = 1 and Instance.STULOAD > 19.9 have Instance.COMDATE = Y1-08-01. Please explain why this is genuine for your institution when the query relating to this specific warning is raised in Minerva.
Instance.COMDATE 7 Warning Where the institution is England, 5% or more of instances starting in this reporting year where (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and Instance.FUNDCODE = 1 and Instance.STULOAD > 19.9 have Instance.COMDATE between Y1-08-01 and Y1-08-31 inclusive. Please explain why this is genuine for your institution when the query relating to this specific warning is raised in Minerva.
Instance.DESTOCM 1 Warning More than 10 students with an instance where Instance.DESTOCM = ZZ.
Instance.DISALL 1 Error Instance.DISALL code 4 must have an EntryProfile.DOMICILE (including those previously sent for the student) = GG, JE, XL, XK, IM, XF, XI, XH or XG.
Instance.EntryProfile 2 Error EntryProfile entity must exist where the corresponding Instance has not been previously reported (i.e. cannot be found on the EP Lookup Table).
Instance.FEEELIG 1 Error Instance.FEEELIG must be coded 2 where the corresponding EntryProfile.DOMICILE (including those previously sent for the student) = IM, XL, GG or JE unless Instance.FESTUMK = 1 or 3.
Instance.FUNDCODE 1 Error More than 500 instances where institution in England, Wales or Northern Ireland and Instance.FUNDCODE coded 1 where (EntryProfile.DOMICILE exists and is not in (XK, XL, GG, JE, IM, XF, XI, XH, XG, AT, BE, XA, CZ, DK, FI, FR, DE, GI, GR, HU, IE, IT, LU, MT, NL, PL, PT, ES, SE, ZZ, AA, EE, LV, LT, SI, SK, RO, BG)) .
Instance.FUNDCODE 2 Warning Instance.FUNDCODE should not be coded 1 where Instance.LOCSDY = 6 and Instance.COMDATE earlier than Y1-08-01 and EntryProfile.DOMICILE not in (XF, XG, XH, XI or XK).
Instance.FUNDCODE 3 Error Where the institution is in England or Northern Ireland no instances have Instance.FUNDCODE = 1 where (Course.COURSEAIM begins with D or L) and (EntryProfile.DOMICILE is UK or Other EU).
Instance.FUNDCODE 4 Warning Where the institution is in England or Northern Ireland less than 80% of instances have Instance.FUNDCODE = 1 where (Course.COURSEAIM begins with D or L) and (EntryProfile.DOMICILE is UK or Other EU).
Instance.FUNDCODE 5 Warning Where the institution is in Wales more than 20 instances have Instance.FUNDCODE = 1 where Course.MSFUND = 13. It is not expected that instances will be fundable by Funding Council when the major source of funding for the course is the Welsh Assembly Government.
Instance.FUNDLEV 1 Warning If any Instance.FUNDLEV = 20 or 21 for a Course.COURSEID then Instance.FUNDLEV must be 20, 21 or 99 for all other instances for the same Course.COURSEID.
Instance.FUNDLEV 2 Warning If any Instance.FUNDLEV = 10 or 11 for a Course.COURSEID then Instance.FUNDLEV must be 10,11 or 99 for all other instances for the same Course.COURSEID.
Instance.FUNDLEV 3 Warning If any Instance.FUNDLEV = 30 or 31 for a Course.COURSEID then Instance.FUNDLEV must be 30,31 or 99 for all other instances for the same Course.COURSEID.
Instance.INITIATIVES 1 Warning More than 25% difference in the number of instances returned for a given code in Instance.INITIATIVES where Instance.MODE not equal to 63 and 64 and the number of students reported by HEFCE.
Instance.INITIATIVES 2 Error No instances returned with Instance.INITIATIVES = 3, 4 or 5 where Institution.UKPRN = 10000291, 10003861, 10006299, 10007138, 10007145, 10007150, 10007801 or 10007851.
Instance.INSTCAMP 1 Error Instance.INSTCAMP must exist and contain a valid full postcode or a valid outward postcode for institutions in Wales where Course.COURSEAIM is coded X41 to X46
Instance.LOCSDY 1 Warning Instance.LOCSDY = S where EntryProfile.DOMICILE is coded XF, XG, XH, XI, or XK. Where the student is on a study year abroad as part of a UK based course Instance.LOCSDY should be coded F or G.
Instance.MODE 1 Warning More than 6 students with an instance where Instance.MODE = 51.
Instance.MSTUFEE 1 Warning Instance.MSTUFEE should not be coded 02, 04, 52 or 54 where the corresponding EntryProfile.DOMICILE (including those previously sent for the student) = XH.
Instance.MSTUFEE 2 Warning Instance.MSTUFEE should not be coded 02, 03, 52 or 53 where the corresponding EntryProfile.DOMICILE (including those previously sent for the student)= XG.
Instance.MSTUFEE 3 Warning Instance.MSTUFEE should not be coded 03, 04, 53 or 54 where the corresponding EntryProfile.DOMICILE (including those previously sent for the student)= XF or XI.
Instance.NUMHUS 1 Error All Instance.NUMHUS for a Student.HUSID must be unique.
Instance.QTS 1 Error Instance.QTS cannot be coded 4 where the corresponding EntryProfile entity (including those previously sent) has (EntryProfile.QUALENT2 = 03 or 10) or EntryProfile.QUALENT3 = H11.
Instance.QTS 2 Error Instance.QTS cannot be coded 3 where the corresponding EntryProfile entity (including those previously sent) has (EntryProfile.QUALENT2 = 04, 37 - 98) or EntryProfile.QUALENT3 begins with P, Q, R or X (excluding X06).
Instance.QTS 3 Warning Instance.QTS should not be coded 4 where EntryProfile.QUALENT3 (including those previously sent) is coded M71 or H71.
Instance.RCSTDNT 1 Warning No Research Council funded instances have been returned for a given Research Council, but the Research Council have reported that there are funded students at this institution.
Instance.RCSTDNT 2 Warning Research Council funded instances have been returned for a given Research Council, but the Research Council have reported that there are no funded students at this institution.
Instance.RCSTDNT 3 Warning More than 10% of Research Council funded instances have Instance.RCSTDNT = 09 (Research Council not specified). The instances should be coded to the appropriate Research Council where possible.
Instance.RSNEND 1 Error More than 20% of instances where Instance.RSNEND does not exist where QualificationsAwarded.QUAL exists.
Instance.SASSCHL 1 Error The URN for the school in Instance.SASSCHL was not active in the EduBase Database during the current reporting year and is not coded 'XXXXXX'.
Instance.SASSCHL 2 Error More than 5% of instances where Course.TTCID = E have unknown Instance.SASSCHL (XXXXXX).
Instance.SKEITT 1 Warning The UKPRN in Instance.SKEITT is not in the list of approved ITT providers supplied by the TDA. If this data is genuine, please contact HESA so that it can be confirmed with the TDA.
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 Instance.COMDATE > Y1-07-31 and Instance.ENDDATE is null, Instance.STULOAD must not be greater than 4.2 times the number of elapsed weeks between Instance.COMDATE and Y2-07-31 (inclusive).
Instance.STULOAD 2 Error For institutions in England, Northern Ireland and Wales, where Instance.COMDATE < Y1-08-01 and Instance.ENDDATE > Y1-07-31, Instance.STULOAD must not be greater than 4.2 times the number of elapsed weeks between Y1-08-01 and Instance.ENDDATE (inclusive).
Instance.STULOAD 3 Error For institutions in England, Northern Ireland and Wales, where both Instance.COMDATE and Instance.ENDDATE are in this reporting year, Instance.STULOAD must not be greater than 4.2 times the number of elapsed weeks between Instance.COMDATE and Instance.ENDDATE (inclusive).
Instance.YEARSTU 1 Warning More than 5% of instances where Instance.TYPEYR = 1 have Instance.YEARSTU less than the difference in years between Instance.COMDATE and Y2-07-31.
Instance.YEARSTU 2 Warning Instance.YEARSTU is greater than 10 where the programme of study is full-time (Instance.MODE = 01, 02 or 73).
Institution.INSTAPP 1 Error Institution.INSTAPP must be consistent within an institution's return.
Module.MODID 1 Error Module.MODID must be unique within an institution's return (i.e. all Module and ModuleSubject entity data for a given Module must be consistent).
Module.TINST 1 Error Module.TINST must = 4002, 4003 or 4004 where all linked Instance.FROUTARR = 01 - 80.
Module.TINST 2 Warning Where Module.TINST exists more than 10% are coded 4001.
ModuleSubject.MODSBJ 1 Warning Where (first character of Course.COURSEAIM = D, E, L, M, H, I, J or C and second and third characters of Course.COURSEAIM are not 90 or 99) and Instance.MODE = 01, 23, 24, 52 or 53 and a student instance is attached to a single module then at least one ModuleSubject.MODSBJ must contain a code in the same JACS Subject Area (XJACSA01) as at least one of the CourseSubject.SBJCA codes.
QualificationsAwarded.QUAL 1 Warning Multiple identical occurrences of QualificationsAwarded.QUAL appear for a single Student.HUSID where (first character of QualificationsAwarded.QUAL = D, E, L, M, and second and third characters of QualificationsAwarded.QUAL are not 90).
QualificationsAwarded.QUAL 4 Warning Multiple identical occurrences of QualificationsAwarded.QUAL appear for a single Student.HUSID where (first character of QualificationsAwarded.QUAL = H, I, J or C and second and third characters of QualificationsAwarded.QUAL are not 90).
QualificationsAwarded.TQGSUB 1 Error If QualificationsAwarded.TQGSUB is coded 360 for more than 10 records then fail.
QualificationsOnEntry.QUALGRADE 1 Error Where the institution is in Northern Ireland, Scotland or Wales more than 10% QualificationsOnEntry records with no QualificationsOnEntry.QUALGRADE.
QualificationsOnEntry.QUALGRADE 3 Error QualificationsOnEntry.QUALGRADE is invalid for the tariff bearing qualification in QualificationsOnEntry.QUALTYPE.
QualificationsOnEntry.QUALGRADE 4 Warning QualificationsOnEntry.QUALGRADE is invalid for the qualification in QualificationsOnEntry.QUALTYPE.
QualificationsOnEntry.QUALGRADE 5 Warning QualificationsOnEntry.QUALGRADE can only include a lower case d, m or p as part of the grade where QualificationsOnEntry.QUALTYPE is coded A, AS or A1.
QualificationsOnEntry.QUALGRADE 6 Error Where the institution is in England more than 1% of QualificationsOnEntry records for a tariff bearing qualification with no QualificationsOnEntry.QUALGRADE for instances where (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and Instance.COMDATE > Y1-07-31 and Instance.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 begins with P).
QualificationsOnEntry.QUALGRADE 7 Warning Where the institution is in England more than 0.5% of QualificationsOnEntry records for a tariff bearing qualification with no QualificationsOnEntry.QUALGRADE for instances where (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and Instance.COMDATE > Y1-07-31 and Instance.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 begins with P).
QualificationsOnEntry.QUALGRADE 8 Error Where the institution is in England, more than 1% of tariff bearing qualifications in the HESA return have a lower grade than the same qualification in the UCAS (*J) data for instances where (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and (Instance.MODE = 01, 23 or 24) and (Instance.COMDATE > Y1-07-31) and (EntryProfile.DOMICILE = XK, XF, XI, XH or XG) and (EntryProfile.QUALENT3 begins with P).
QualificationsOnEntry.QUALGRADE 9 Warning Where the institution is in England, more than 0.5% of tariff bearing qualifications in the HESA return have a lower grade than the same qualification in the UCAS (*J) data for instances where (Course.COURSEAIM begins H, I, J or C or is M22 or M26) and (Instance.MODE = 01, 23 or 24) and (Instance.COMDATE > Y1-07-31) and (EntryProfile.DOMICILE = XK, XF, XI, XH or XG) and (EntryProfile.QUALENT3 begins with P).
QualificationsOnEntry.QUALTYPE 1 Warning The tariff status is unknown for the qualification in QualificationsOnEntry.QUALTYPE. Please check that the correct qualification type has been returned for the qualification awarded.
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.ETHNIC 1 Error Student.ETHNIC must exist where any EntryProfile.DOMICILE (including those previously sent for the student) = XF, XG, XH, XI, XK, XL, GG, JE or IM and the corresponding Instance.REDUCEDI = 00, 01, 06 or 07
Student.ETHNIC 4 Warning Student.ETHNIC is unknown (90) or information refused (98), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return.
Student.GENDER 2 Error More than 1 student where Student.GENDER = 9.
Student.HUSID 1 Error Student.HUSID must be unique within an institutions return (i.e. all student entity data for the given HUSID must be consistent).
Student.HUSID 2 Warning Multiple occurrences of Student.BIRTHDTE, Student.GENDER, soundex (Student.SURNAME) and soundex (Student.FNAMES), with different Student.HUSIDs.
Student.NATION 1 Error Student.NATION code XC must have Instance.COMDATE before 2007-08-01 unless EntryProfile.UCASAPPID exists.
Student.NATION 2 Warning Student.NATION is unknown (ZZ), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return.
Student.NATIOND 1 Error Student.NATIOND must exist where Welsh institution and any EntryProfile.DOMICILE (including those previously sent for the student) = XI and the corresponding Instance.REDUCEDI = 00 or 02.
Student.NATIOND 2 Warning Student.NATIOND is unknown (U) or information refused (R), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return.
Student.SCN 1 Error Student.SCN must exist where any EntryProfile.DOMICILE (including those previously sent for the student) = XH and the corresponding EntryProfile.UCASAPPID exists and Course.COURSEAIM begins H, I, J, C, P, Q, R or S.
Student.SCN 2 Error Student.SCN must exist where Scottish institution and any EntryProfile.DOMICILE (including those previously sent for the student) = XH and Course.COURSEAIM begins H, I, J, C, P, Q, R or S.
Student.TTPCODE 1 Warning More than 50 young (between 18 and 21), full-time, undergraduate students, at parental home (Student.TTACCOM = 2), have Student.TTPCODE (where exists) not equal to EntryProfile.POSTCODE
Student.TTPCODE 2 Warning More than 150 students have the same Student.TTPCODE (where exists) and do not have Student.TTACCOM =1 or 9.
Student.TTPCODE 3 Error More than 600 students have the same Student.TTPCODE (where exists) and do not have Student.TTACCOM =1 or 9.
Student.TTPCODE 4 Warning Where exists Student.TTPCODE must contain a valid full postcode or a valid outward part of a postcode.
Student.TTPCODE 5 Error Where exists Student.TTPCODE must not equal EntryProfile.POSTCODE where Student.TTACCOM = 1 or 9 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 8 Error More than 50% of students on courses where Course.TTCID = E have Student.TTPCODE coded as null (unknown)
Student.TTPCODE 9 Error More than 50% of students on courses where Course.TTCID = F have Student.TTPCODE coded as null (unknown)
Student.UCASPERID 2 Error Student.UCASPERID must exist where any EntryProfile.UCASAPPID (including those previously sent for the student) exists and is a 4 character code and the corresponding Instance.REDUCEDI is not equal to 04.
Student.WELSSP 1 Error Student.WELSSP must exist where Welsh institution and any EntryProfile.DOMICILE (including those previously sent for the student) = XI and the corresponding Instance.REDUCEDI = 00.
StudentOnModule.LANGPCNT 1 Error At least one StudentOnModule.LANGPCNT must be greater than 0 where Module.MODLANG is coded 1, 2 or 3.

Contact Liaison by email or on +44 (0)1242 388 531.