Skip to main content

HESA Student Record 2007/08

Back to C07051

HESA Student Record 2007/08

Summary of validation rules


return to index

Version 1.6 Produced 2008-10-07

Entity Field Name Status Rule Number
Course Error CourseSubject entity must exist for all courses at institutions in Scotland or Northern Ireland. 1
Course Error CourseSubject entity must exist for all courses at institutions in England or Wales where (any Instance.FESTUMK = 2 or 3 or Course.FEQAIMC = '66666666') 2
Course BITTM Error Course.BITTM must exist for institutions in Wales, Northern Ireland or Scotland where Course.TTCID = 1 or 2 and Course.REDUCEDC = 00, 01 or 04 1
Course BITTM Error Course.BITTM must not exist for institutions in Wales, Northern Ireland or Scotland where Course.TTCID does not equal 1 or 2 2
Course BITTM Error Course.BITTM must not exist for institutions in England 3
Course CLSDCRS Error Course.CLSDCRS must exist for institutions in England where Course.REDUCEDC = 00 1
Course CLSDCRS Error Course.CLSDCRS must not exist for institutions not in England 2
Course COLLORG Error Course.COLLORG must exist for institutions in England where Course.REDUCEDC = 00 except where CourseCOURSEAIM = D00, D90, L00, L80, L90, L91 1
Course COLLORG Error Course.COLLORG must not exist for institutions not in England 2
Course COURSEAIM Error Course.COURSEAIM cannot be coded H16, I16, M16 or M86 where the first 2 characters of CourseSubject.SBJCA are 'D1' and Institution.UKPRN not = 10006842, 10007779, 10007786, 10007788, 10007790 or 10007794 1
Course COURSEAIM Error Course.COURSEAIM cannot be coded H16, I16, M16 or M86 where the first character of CourseSubject.SBJCA is 'A' and UKPRN not = 10000886, 10003270, 10003645, 10005343, 10006840, 10006842, 10007143, 10007149, 10007154, 10007157, 10007158, 10007163, 10007167, 10007767, 10007774, 10007775, 10007782, 10007783, 10007784, 10007785, 10007786, 10007788, 10007789, 10007790, 10007792, 10007794, 10007795, 10007796, 10007798, 10007799, 10007801, 10007803, 10007806, 10007814, 10007842, 10007852 or 10007855 2
Course COURSEAIM Error Course.COURSEAIM must be coded H71, M71, H11, I11 or I71 for Institutions in England and Wales where Course.TTCID = 1 3
Course COURSEAIM Error Course.COURSEAIM must be coded H71 or M71 for institutions in England where Course.TTCID = 8 4
Course COURSEAIM Error Institutions in England, Scotland and Northern Ireland cannot use codes X41 to X46 5
Course COURSEAIM Error Institutions in Scotland cannot use code X00 6
Course COURSEAIM Warning Course.COURSEAIM must be coded D00, E00, L00, M00, M01, M10, M11, L80, H50, H60, M50, H80, M80, M70, L80, H70, I70, H72, I72, M72, H61, H81, I61, J20, C20, I60, I80, I81, J80, C90, H90, I90, J90, D90, E90, L90 or M90 where (Course.TTCID = 5 and Course.MSFUND = 07) or where (Course.TTCID = 5 and any Instance.FUNDCODE = 7) 7
Course FEQAIMC Error Course.FEQAIMC must exist for institutions in England or Wales where any Instance.FESTUMK = 1,3 or 4 1
Course FEQAIMC Error The first three characters of Course.FEQAIMC must not be 000 3
Course FEQAIMC Error Course.FEQAIMC must not exist for institutions in Northern Ireland or Scotland 4
Course MSFUND Error Course.MSFUND must exist where Course.REDUCEDC = 00, 01, 02 or 04 1
Course MSFUND Error Course.MSFUND must not be coded 01 where Course.COURSEAIM begins P, Q, R, S or X 4
Course MSFUND Error Course.MSFUND must not be coded 02 or 07 where Course.COURSEAIM begins P, Q, R, S or X 5
Course MSFUND Error Course.MSFUND must not be coded 01 where Course.TTCID is coded 1 or 8 6
Course MSFUND Error Course.MSFUND must not be coded 05 or 06 where any Instance.FESTUMK is coded 2 7
Course MSFUND Error Course.MSFUND must be coded 07 for institutions in England where Course.TTCID = 1 or 8 10
Course MSFUND Error For institutions in Wales Course.MSFUND must not be coded 01, 03, 04, 05 or 07 11
Course MSFUND Error For institutions in England Course.MSFUND must not be coded 02, 03, 04 or 06 12
Course MSFUND Error For institutions in Northern Ireland Course.MSFUND must not be coded 01, 02, 03, 05, 06 or 07 13
Course MSFUND Error For institutions in Scotland Course.MSFUND must not be coded 01, 02, 04, 05, 06 or 07 14
Course MSFUND Warning For institutions in England Course.MSFUND should not be coded 05 or 06 where Course.COURSEAIM begins with D, E, L, M, H, I, J or C 15
Course MSFUND Warning For institutions in Wales Course.MSFUND should not be coded 05 or 06 where Course.COURSEAIM begins with D, E, L, M, H, I or J 16
Course REDUCEDC Error Course.REDUCEDC cannot = 01 or 02 for institutions in England where any Instance.FESTUMK = 1 2
Course REDUCEDC Error Course.REDUCEDC cannot = 02 for institutions in Wales where any Instance.FESTUMK = 1 3
Course REDUCEDC Error If Course.REDUCEDC = 01, the institution must be in England, Scotland or Northern Ireland 4
Course REDUCEDC Error If Course.REDUCEDC = 02, the institution must be in England or Wales 5
Course REDUCEDC Error Course.REDUCEDC code 02 is only available where Course.COURSEAIM begin P, Q, R, S or X 7
Course REGBODY Error Course.REGBODY must exist where Course.COURSEAIM = M16, M76, M86, H16, H76, I16, I76, J26 or J76 and Course.REDUCEDC = 00 or 01 1
Course TQSSEC Error Course.TQSSEC must exist for institutions in Scotland or Northern Ireland where Course.TTCID = 1 or 2 and Course.REDUCEDC = 00 1
Course TQSSEC Error Course.TQSSEC must be coded 1 or 2 for institutions in Scotland or Northern Ireland where Course.TTCID = 1 2
Course TQSSEC Error Course.TQSSEC must be coded 3 or 4 for institutions in Scotland or Northern Ireland where Course.TTCID = 2 3
Course TQSSEC Error Course.TQSSEC must not exist for institutions in Scotland or Northern Ireland where Course.TTCID = 0 or 5 4
Course TQSSEC Error Course.TQSSEC must not exist for institutions in England or Wales 5
Course TQSSUB Error Course.TQSSUB must exist for institutions in Scotland where Course.TQSSEC = 2 and Course.REDUCEDC = 00 1
Course TQSSUB Error When one or more instances of Course.TQSSUB exists, one and only one instance's attribute Main must be set to "1" 2
Course TQSSUB Error Course.TQSSUB must not exist for institutions in England, Northern Ireland or Wales 3
Course TQSSUB Error Course.TQSSUB must not exist for institutions in Scotland where Course.TQSSEC not = 2 4
Course TTCID Error Course.TTCID must exist where Course.REDUCEDC = 00, 01 or 04 1
Course TTCID Error Only institutions in England can use codes 8, 9, A, B, C, D 2
Course TTCID Error Course.TTCID must be coded 1 for institutions in Wales where Course.COURSEAIM = H11 or I11 3
Course TTCID Error If English institution and Course.TTCID is coded 1 or 8, Institution.UKPRN must be 10000291, 10000571, 10000712, 10000886, 10000961, 10001143, 10001282, 10001883, 10002718, 10003614, 10003645, 10003678, 10003861, 10003863, 10003956, 10003957, 10004048, 10004078, 10004113, 10004180, 10004206, 10004351, 10004797, 10004930, 10005790, 10006299, 10006840, 10007137, 10007138, 10007139, 10007140, 10007143, 10007144, 10007145, 10007146, 10007147, 10007148, 10007149, 10007152, 10007154, 10007155, 10007157, 10007158, 10007159, 10007161, 10007163, 10007164, 10007166, 10007167, 10007713, 10007766, 10007767, 10007773, 10007774, 10007776, 10007786, 10007787, 10007788, 10007789, 10007792, 10007795, 10007796, 10007798, 10007799, 10007801, 10007802, 10007806, 10007811, 10007816, 10007823, 10007832, 10007842, 10007843, 10007848, 10007850 or 10007851 4
Course TTCID Error Course.TTCID must not be coded 1 or 8 by institutions in England or Northern Ireland where Instance.FUNDLEV is coded 11 or 21 6
CourseSubject ITTSUBJECT Error At least one CourseSubject.ITTSUBJECT must exist where Institutions in England and Course.TTCID = 1 or 8 and any Instance.ITTPHSC is anything other than 31 or 49 1
CourseSubject ITTSUBJECT Error CourseSubject.ITTSUBJECT must not exist for institutions not in England 2
CourseSubject ITTSUBJECT Error CourseSubject.ITTSUBJECT must not exist where institution is in England and Course.TTCID = 0 3
CourseSubject SBJCA Error The second character of CourseSubject.SBJCA cannot be 0 where any Instance.RCSTDNT = 01 - 09 1
CourseSubject SBJCA Error CourseSubject.SBJCA must be coded C100, C600, F100, F300, G100, G500, L230, L390, L700, Q300, Q560, R100, R200, R400, R500, V100, V600, W200, W300, W400, W500, W900, X900, X120 or Y000 where Course.TTCID = 1 or 8 and Instance.ITTPHSC = 15 - 19, 51 - 53, 61 - 65 or 71 - 77 2
CourseSubject SBJCA Error CourseSubject.SBJCA cannot be coded X120 where Course.TTCID = 1 or 8 and (Instance.ITTPHSC = 15 - 19, 51- 53, 61 - 65 or 71 - 77 and Instance.COMDATE before 2002-09-01) 3
CourseSubject SBJCA Error CourseSubject.SBJCA must be coded C000, C100, C110, C600, D600, F000, F100, F110, F300, F310, G100, G500, G510, H700, H900, J420, L230, L510, L700, L900, N100, N190, N870, P300, Q300, Q560, Q800, R100, R200, R300, R400, R500, R700, R900, V100, V600, W200, W210, W300, W400, W500, W900 or W990 where Course.TTCID = 1 or 8 and Instance.ITTPHSC = 24 - 26, 54 - 57, or 78 - 82 4
CourseSubject SBJCA Error For institutions in England, one, and only one, CourseSubject.SBJCA must be coded F000 where any CourseSubject.SBJCA = C000 and Course.TTCID = 1 or 8 and Instance.ITTPHSC = 24 -26, 54 - 57, or 78 - 82 5
CourseSubject SBJCA Warning If CourseSubject.SBJCA begins with B82 for institutions in England and Course.COURSEAIM ends with '16' then CourseSubject.SBJCA should be coded B821 or B822 6
CourseSubject SBJCA Warning If CourseSubject.SBJCA begins with B7 for institutions in England and Course.COURSEAIM ends with '16' then CourseSubject.SBJCA should be coded B720, B730, B740, B750, B760 or B761 7
CourseSubject SBJCA Error The first character of CourseSubject.SBJCA must be D where Course.COURSEAIM is coded H16, I16, M16 or M86 and Course.REGBODY = 14 8
CourseSubject SBJCA Error The first character of CourseSubject.SBJCA must be A where Course.COURSEAIM is coded H16, I16, M16 or M86 and Course.REGBODY = 02 9
CourseSubject SBJCA Error CourseSubject.SBJCA cannot be coded X110, X120, X121 or X122 for institutions in Scotland or Northern Ireland where Course.TTCID = 1 or 8 and QualificationsAwarded.TQGSEC = 2 10
CourseSubject SBJCA Error CourseSubject.SBJCA cannot be coded X130, X131, X132, X140, X141, X142, X150 or X151 for institutions in Scotland or Northern Ireland where Course.TTCID = 1 or 8 and QualificationsAwarded.TQGSEC = 1 11
CourseSubject SBJCA Warning CourseSubject.SBJCA should not have zero in 3rd or 4th position where Course.MSFUND = 31 and any CourseSubject.SBJCA begins B, C8 or L5 12
CourseSubject SBJCA Error CourseSubject.SBJCA must be unique for each Course entity 13
CourseSubject SBJCA Error For institutions in England, one, and only one, CourseSubject.SBJCA must be coded C000 where any CourseSubject.SBJCA = F000 and Course.TTCID = 1 or 8 and Instance.ITTPHSC = 24 - 26, 54 - 57, or 78 - 82 14
CourseSubject SBJCA Error For institutions in England, CourseSubject.SBJCA codes C110, F110 and F310 can only be used together when Course.TTCID = 1 or 8 and Instance.ITTPHSC = 24 - 26, 54 - 57, or 78 - 82 15
CourseSubject SBJCA Error For institutions in England, CourseSubject.SBJCA codes C100, F100 and F300 can only be used together when Course.TTCID = 1 or 8 and Instance.ITTPHSC = 15 - 19, 51 - 53 or 71 - 77 16
CourseSubject SBJPCNT Error For each Course entity the sum of CourseSubject.SBJPCNT must equal 100 1
CourseSubject SBJPCNT Error All CourseSubject.SBJPCNT must be coded '50' where any CourseSubject.SBJCA = F000 or C000 and Course.TTCID = 1 or 8 and any Instance.ITTPHSC = 24 - 26, 51 - 57, or 78 - 82 2
CourseSubject SBJPCNT Error CourseSubject.SBJPCNT must contain 33, 34, 50, 67 or 100 for institutions in Scotland 3
EntryProfile ACCESS Error EntryProfile.ACCESS must exist for institutions in Scotland where EntryProfile.QUALENT2 = 44 or 45 1
EntryProfile ACCESS Error EntryProfile.ACCESS must not exist for institutions in England, Northern Ireland or Wales 2
EntryProfile ARTICLN Error EntryProfile.ARTICLN must exist for institutions in Scotland where EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM and Course.COURSEAIM = M22, H00, H11, H16, H18, H22, H23, H24, I00, I11 or I16 and Instance.COMDATE is after 2007-07-31 and corresponding Instance.REDUCEDI = 00 1
EntryProfile ARTICLN Error EntryProfile.ARTICLN must not exist for institutions in England, Northern Ireland or Wales 2
EntryProfile DOMICILE Error EntryProfile.DOMICILE can only be coded XC where EntryProfile.UCASAPPID exists or Instance.COMDATE is before 2007-08-01 1
EntryProfile DOMICILE Error EntryProfile.DOMICILE can only be coded XL when Instance.COMDATE is before 2007-08-01 2
EntryProfile MARSTAT Error EntryProfile.MARSTAT must exist for institutions in Northern Ireland where EntryProfile.DOMICILE = XG and corresponding Instance.REDUCEDI = 00 1
EntryProfile MARSTAT Error EntryProfile.MARSTAT must not exist for institutions in England, Scotland or Wales 2
EntryProfile NEWENT Error EntryProfile.NEWENT must exist where Course.COURSEAIM begins D, E, L, M, H, I, J or C and corresponding Instance.REDUCEDI = 00 and Instance.COMDATE is after 31 July 2007 1
EntryProfile NEWENT Error EntryProfile.NEWENT cannot be coded B or C if EntryProfile.QUALENT2 is 01, 03, 04, 10, 11, 25 or 29 2
EntryProfile NEWENT Warning EntryProfile.NEWENT should not be coded B or C if EntryProfile.QUALENT2 is 02, 05, 16, 23, 24, 28, 30, 15, 21, 22 or 27 3
EntryProfile NIDEPEND Error EntryProfile.NIDEPEND must exist for institutions in Northern Ireland where EntryProfile.DOMICILE = XG and the corresponding Instance.REDUCEDI = 00 1
EntryProfile NIDEPEND Error EntryProfile.NIDEPEND must not exist for institutions in England, Scotland or Wales 2
EntryProfile PARED Error EntryProfile.PARED must exist for institutions in England or Scotland where EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM and Course.COURSEAIM = M22, H00, H11, H16, H18, H22, H23, I00, I11, I16, J10, J16, J20, J26, J30, C20 or C30 and Instance.COMDATE is after 2007-07-31 and corresponding Instance.REDUCEDI = 00 1
EntryProfile PARED Error EntryProfile.PARED must not exist for institutions in Northern Ireland or Wales 2
EntryProfile PGCECLSS Error EntryProfile.PGCECLSS must exist where Course.COURSEAIM = M71 or H71 and corresponding Instance.REDUCEDI = 00 1
EntryProfile PGCESBJ Error EntryProfile.PGCESBJ must exist where Course.COURSEAIM = M71 or H71 and corresponding Instance.REDUCEDI = 00 1
EntryProfile POSTCODE Error EntryProfile.POSTCODE must exist where EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM and corresponding Instance.REDUCEDI = 00 or 01 1
EntryProfile POSTCODE Error EntryProfile.POSTCODE must not be null except when ReasonForNull = 1 2
EntryProfile POSTCODE Error EntryProfile.POSTCODE must be null when ReasonForNull = 1 3
EntryProfile POSTCODE Error EntryProfile.POSTCODE must not exist where EntryProfile.DOMICILE is not in (XF, XG, XH, XI, XK, XL, GG, JE or IM) 4
EntryProfile PREVINST Error EntryProfile.PREVINST must exist where EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM and Course.COURSEAIM = M22, H00, H11, H16, H18, H22, H23, I00, I11, I16, J10, J16, J20, J26, J30, C20 or C30 and corresponding Instance.REDUCEDI = 00 1
EntryProfile PREVINST Error Where EntryProfile.PREVINST begins 'H' and is followed by 4 numbers it must be coded H9999 or begin H0 2
EntryProfile QUALENT2 Error EntryProfile.QUALENT2 must exist where corresponding Instance.REDUCEDI = 00 or 01 1
EntryProfile QUALENT2 Error EntryProfile.QUALENT2 cannot be coded 99 where QualificationsOnEntry entity exists 2
EntryProfile QUALENT2 Error EntryProfile.QUALENT2 cannot be coded 99 where EntryProfile.WELBACC = 1 3
EntryProfile QUALENT2 Error EntryProfile.QUALENT2 must be 01-45 where EntryProfile.ACCESS exists 4
EntryProfile RELIGION Error EntryProfile.RELIGION must exist for institutions in Northern Ireland where EntryProfile.DOMICILE = XG and corresponding Instance.REDUCEDI = 00 1
EntryProfile RELIGION Error EntryProfile.RELIGION must not exist for institutions in England, Scotland or Wales 2
EntryProfile SEC Error EntryProfile.SEC must exist where EntryProfile.UCASAPPID exists and Course.COURSEAIM begins H, I, J or C or is M22 and EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM 1
EntryProfile SOC2000 Error EntryProfile.SOC2000 must exist where EntryProfile.UCASAPPID exists and Course.COURSEAIM begins H, I, J or C or is M22 and EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM 1
EntryProfile UCASAPPID Error EntryProfile.UCASAPPID must pass the checksum test as applied to Student.HUSID where it is nine characters long and (digits 1-8 are not in the ranges 06000999 to 06009996 inclusive or 06690999 to 06692257 inclusive) 2
EntryProfile UCASAPPID Error Where EntryProfile.UCASAPPID digits 1-8 are in ranges (06000999 to 06009996 inclusive or 06690999 to 06692257 inclusive), this field must pass either the checksum test as applied to Student.HUSID or the 'incorrectly calculated checksum' test, details of which are in student circular 06_04 3
EntryProfile WELBACC Error EntryProfile.WELBACC must exist for institutions in Wales where EntryProfile.DOMICILE = XI and Course.COURSEAIM begins H, I , J, C, P, Q, R or S and corresponding Instance.COMDATE is greater than 2005-07-31 and corresponding Instance.REDUCEDI = 00 1
EntryProfile WELBACC Warning This element must not exist where Course.COURSEAIM begins D, E, L or M (other than M22) 2
EntryProfile YRLLINST Error EntryProfile.YRLLINST must exist for institutions in Scotland where EntryProfile.ARTICLN = 1, 2, 3 or 4 1
EntryProfile YRLLINST Error EntryProfile.YRLLINST must not exist for institutions in England, Northern Ireland or Wales 2
Instance Error EntryProfile must exist where corresponding Instance.COMDATE is in the current reporting year and Instance.REDUCEDI = 00, 01, 03 or 04 1
Instance Error QualificationsAwarded entity must exist where Instance.ENDDATE is not null and Instance.RSNEND = 01 and Instance.REDUCEDI = 00, 01 or 04 unless either Course.COURSEAIM ends in 99 or (English or Welsh institution and Instance.FESTUMK = 1 or 4 and Instance.PROGRESS = 6, A or B) 1
Instance Warning QualificationsAwarded.QUAL should exist where Instance.RSNEND = 98 and Course.COURSEAIM begins D, E, L, M, H, I, J or C and Instance.REDUCEDI = 00, 01 or 04. 2
Instance Error StudentOnModule entity must exist where Instance.STULOAD is greater than 0 and Instance.REDUCEDI = 00 or 01 1
Instance Error RAEData entity must exist where Course.COURSEAIM = L00, L80, L90 or L99 or begins with D and corresponding Instance.REDUCEDI = 00 1
Instance Error RAEData entity must not exist unless (Course.COURSEAIM = L00, L80, L90 or L99 or Course.COURSEAIM begins with D) 2
Instance ADDSUPCT Error Instance.ADDSUPCT must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 1
Instance ADDSUPCT Error Instance.ADDSUPCT must not exist for institutions not in England 2
Instance ADDSUPCT Error Instance.ADDSUPCT must not exist for institutions in England where Instance.FESTUMK = 2 3
Instance BRIDGE Error Instance.BRIDGE must exist where Instance.REDUCEDI = 00 1
Instance BRIDGE Error Instance.BRIDGE code 1 is only available where Course.COURSEAIM = H16, I16, M16, M86, H11, I11, H00, I00, H23, H24, J16, J30, C90, H90, I90 or J90 2
Instance COMDATE Error Instance.COMDATE must exist where Instance.REDUCEDI = 00, 01, 02 or 03 1
Instance COMDATE Error Instance.COMDATE must not be less than 1991-01-31 2
Instance COMDATE Error Instance.COMDATE must be less than Y2-08-01 4
Instance COURSEID Error This entry must exist in Course.COURSEID 1
Instance CSTAT Error Instance.CSTAT must exist for institutions in England or Wales where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00, 01 or 02 1
Instance CSTAT Error Instance.CSTAT must not exist for institutions in Northern Ireland or Scotland 2
Instance CSTAT Error Instance.CSTAT must not exist for institutions in England or Wales where Instance.FESTUMK = 2 3
Instance DESTIN Error Instance.DESTIN must exist for institutions in Wales where Instance.FESTUMK = 1, 3 or 4 and Course.COURSEAIM is not X41 to X46 and Instance.REDUCEDI = 00 1
Instance DESTIN Error Instance.DESTIN must not exist for institutions in England, Northern Ireland or Scotland 2
Instance DESTIN Error Instance.DESTIN must not exist for institutions in Wales where Instance.FESTUMK = 2 3
Instance DESTOCM Error Instance.DESTOCM must exist for institutions in England, Wales and Northern Ireland where Instance.REDUCEDI = 00 and (Instance.EXCHANGE = 5 or 7 or Instance.LOCSDY = F or G) 1
Instance DESTOCM Error Instance.DESTOCM must not exist for institutions in Scotland 2
Instance DHFUND Error Instance.DHFUND must exist for institutions in England where Course.MSFUND = 31 and Instance.REDUCEDI = 00 or 01 1
Instance DHFUND Warning Instance.DHFUND should not be coded 998 for institutions in England where Course.MSFUND = 31 and CourseSubject.SBJCA = B700, B740, B730, B760, B761, B720, B330, B410, B930, B520, B160, B820, B821, B822, B630, B830 or B610 and Course.COURSEAIM = H76, I76, J76, M76, H16, I16, M16, M86, J26 2
Instance DHFUND Warning Instance.DHFUND should be coded 998 for institutions in England where CourseSubject.SBJCA = A300 or A400 and Course.MSFUND = 31 and Course.COURSEAIM = H16 or I16 3
Instance DHFUND Warning Instance.DHFUND should exist for institutions in England where Course.MSFUND = 31 6
Instance DHFUND Warning Instance.DHFUND should not be coded 998 for institutions in England where Course.MSFUND = 31 unless CourseSubject.SBJCA begins 'L5' 7
Instance DHFUND Error Instance.DHFUND must not exist for institutions not in England 8
Instance DHFUND Error Instance.DHFUND must not exist for institutions in England where Course.MSFUND not = 31 9
Instance DHFUND Error Instance.DHFUND can only be coded LWF01 - LWF27 when Instance.COMDATE is before 1 August 2006 10
Instance DHREGREF Error Instance.DHREGREF must exist where Course.COURSEAIM = M16, M76, M86, H16, H76, I16, I76, J26 or J76 and Course.REGBODY = 06 or 07 and Instance.REDUCEDI = 00 or 01 1
Instance DISALL Error Instance.DISALL must exist where Student.DISABLE = 02 - 96 and Instance.REDUCEDI = 00 1
Instance DISALL Error Instance.DISALL code 4 is only available where Course.COURSEAIM begins D, E, L, M, H, I, J or C 2
Instance DISALL Error Instance.DISALL must not exist where Student.DISABLE = 00, 97, 98 or 99 3
Instance DISALL Error Instance.DISALL can not be coded 4 where (EntryProfile.DOMICILE exists and is not coded GG, JE, XL, XK, IM, XF, XI, XH, XG) 4
Instance DISUPFAC Error Instance.DISUPFAC must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 1
Instance DISUPFAC Error Instance.DISUPFAC must not exist for institutions not in England 2
Instance DISUPFAC Error Instance.DISUPFAC must not exist for institutions in England where Instance.FESTUMK = 2 3
Instance ELIDISUP Error Instance.ELIDISUP must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 1
Instance ELIDISUP Error Instance.ELIDISUP must not exist for institutions not in England 2
Instance ELIDISUP Error Instance.ELIDISUP must not exist for institutions in England where Instance.FESTUMK = 2 3
Instance ELIGENFD Error Instance.ELIGENFD must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 1
Instance ELIGENFD Error Instance.ELIGENFD must not exist for institutions not in England 2
Instance ELIGENFD Error Instance.ELIGENFD must not exist for institutions in England where Instance.FESTUMK = 2 3
Instance EMPROLE Error Instance.EMPROLE must exist for institutions in England or Wales where Instance.FESTUMK = 1, 3 or 4 and Instance. REDUCEDI = 00 or 02 1
Instance EMPROLE Error Instance.EMPROLE codes 1 - 5 are only available to institutions in Wales 2
Instance EMPROLE Error Instance.EMPROLE codes 6 - 8 are only available to institutions in England 3
Instance EMPROLE Error Instance.EMPROLE must not exist for institutions in Northern Ireland or Scotland 4
Instance EMPROLE Error Instance.EMPROLE must not exist for institutions in England or Wales where Instance.FESTUMK = 2 5
Instance ENDDATE Error Instance.ENDDATE must not be null where Instance.RSNEND exists 1
Instance ENDDATE Error Instance.ENDDATE must not be null where Instance.CSTAT = 2 or 3 2
Instance ENDDATE Error Instance.ENDDATE must be null where Instance.CSTAT = 1 3
Instance ENDDATE Error Where exists, Instance.ENDDATE must be less than Y2-08-01 4
Instance ENDDATE Error If Instance.MODE is not equal to 63 or 64, then Instance.ENDDATE (where exists) must be greater than Y1-07-31 5
Instance ENDDATE Error Where exists, Instance.ENDDATE must be greater than (Y2-6)-07-31 when Instance.MODE = 63 or 64 6
Instance ENDDATE Error Instance.ENDDATE (where exists) must be greater than or equal to Instance.COMDATE (where exists) unless (Instance.MODE = 63 or 64 and Instance.ENDDATE = Y0-08-01) 7
Instance ENDDATE Warning Where exists, Instance.ENDDATE must be completed with a date equal to or before 31 July of the reporting period where QualificationsAwarded.QUAL begins D, E, L, M, H, I, J or C 8
Instance EXCHANGE Error Instance.EXCHANGE must exist where Instance.REDUCEDI = 00 or 03 1
Instance EXCHANGE Error Instance.EXCHANGE must be coded 5 when Instance.SPECFEE= 3 2
Instance FEEELIG Error Instance.FEEELIG must exist where Instance.REDUCEDI = 00 or 01 1
Instance FEEELIG Error Instance.FEEELIG must be coded 1 where Instance.FUNDCODE = 1 for institutions in England and Northern Ireland 2
Instance FEEELIG Error Instance.FEEELIG must not be coded 2 where Instance.FUNDCODE is coded 1 or 4 3
Instance FEEELIG Error Instance.FEEELIG must not be coded 3 where Instance.FUNDCODE is coded 1 or 4 for institutions in England and Northern Ireland 4
Instance FEEELIG Error Instance.FEEELIG must be coded 2 where (EntryProfile.DOMICILE exists and it is coded IM, XL, GG or JE) 5
Instance FESTUMK Error Instance.FESTUMK must exist for institutions in England and Wales 1
Instance FESTUMK Error Instance.FESTUMK can only be coded 2 where Course.MSFUND (where exists) not = 05 or 06 2
Instance FESTUMK Error Instance.FESTUMK must be coded 1 or 4 where Course.COURSEAIM begins P, Q, R, S or X. 3
Instance FESTUMK Error Instance.FESTUMK must be coded 2 or 3 where Course .COURSEAIM begins D, E, L, M, H, I, J or C. 4
Instance FESTUMK Error Instance.FESTUMK must not exist for institutions in Northern Ireland or Scotland 5
Instance FRANPART Error Instance.FRANPART must exist for institutions in Wales where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 or 02 1
Instance FRANPART Error Instance.FRANPART must not exist for institutions in England, Northern Ireland or Scotland 2
Instance FRANPART Error Instance.FRANPART must not exist for institutions in Wales where Instance.FESTUMK = 2 3
Instance FROUTARR Error Instance.FROUTARR must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 1
Instance FROUTARR Error Instance.FROUTARR must not exist for institutions not in England 2
Instance FROUTARR Error Instance.FROUTARR must not exist for institutions in England where Instance.FESTUMK = 2 3
Instance FTEMETHOD Error Instance.FTEMETHOD must exist for institutions in Scotland where Instance.REDUCEDI = 00, 01 or 03 1
Instance FTEMETHOD Error Instance.FTEMETHOD must not exist for institutions in England, Northern Ireland or Wales 2
Instance FUNDCODE Error Instance.FUNDCODE must be coded 1 where Instance.FESTUMK = 1 or 3 1
Instance FUNDCODE Error Instance.FUNDCODE cannot be 1 where Instance.FESTUMK = 4 2
Instance FUNDCODE Error Instance.FUNDCODE must exist where Instance.REDUCEDI = 00 or 01 3
Instance FUNDCODE Error Instance.FUNDCODE cannot be coded 1 by institutions in England, Wales or Northern Ireland where Course.MSFUND = 31 and Course.COURSEAIM = H16, I16, M16, M86, H11, I11, H00, I00, H22, M22, H23 or H24 4
Instance FUNDCODE Error Instance.FUNDCODE cannot be coded 4 or 5 by institutions in Scotland or Wales 5
Instance FUNDCODE Error Instance.FUNDCODE cannot be coded 7 by institutions in Scotland, Wales or Northern Ireland 6
Instance FUNDCODE Error Instance.FUNDCODE code 7 is only available where Course.TTCID = 1, 5, 8 or 9 7
Instance FUNDCODE Error Instance.FUNDCODE code 7 is only available where Instance.ITTPHSC not = 31 or 49 8
Instance FUNDCODE Warning For English institutions Instance.FUNDCODE codes 1 or 4 are only available where Course.TTCID not = 1, 5 or 8 9
Instance FUNDCODE Error Instance.FUNDCODE cannot be coded 3 by institutions in England, Wales or Northern Ireland 10
Instance FUNDCODE Warning Instance.FUNDCODE should not be coded 5 or 7 where Course.MSFUND = 01 or 02 11
Instance FUNDCODE Warning Instance.FUNDCODE codes 1 or 4 are only available where Course.MSFUND not = 07 or 31 12
Instance FUNDCODE Error Instance.FUNDCODE must not be coded 1 where Course.CLSDCRS = 1 13
Instance FUNDCODE Error Instance.FUNDCODE cannot be 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)) and Instance.FEEELIG = 2 14
Instance FUNDCOMP Error Instance.FUNDCOMP must exist for institutions in England, Wales and Northern Ireland where Instance.REDUCEDI = 00 or 01 1
Instance FUNDCOMP Error Instance.FUNDCOMP must not exist for institutions in Scotland 2
Instance FUNDCOMP Error Instance.FUNDCOMP cannot be coded 3 where Instance.RSNEND is coded 01 - 11, 98 or 99 3
Instance FUNDCOMP Error Instance.FUNDCOMP code 4 is only available where the institution is in Wales and Instance.MODE = 01, 02, 23, 24, 25 52 or 53 and Course.COURSEAIM does not begin D, L, P, Q, R, S or X 4
Instance FUNDCOMP Warning Instance.FUNDCOMP can only be 2 when (Instance.RSNEND exists and Instance.ENDDATE is not null) or (Instance.NOTACT exists) or (Instance.MODE = 63, 64, 73 or 74) 5
Instance FUNDLEV Error Instance.FUNDLEV must exist for institutions in England or Northern Ireland where Instance.REDUCEDI = 00 or 01 1
Instance FUNDLEV Warning Instance.FUNDLEV should be coded 30, 31 or 99 by institutions in England or Northern Ireland where Course.COURSEAIM begins D or L 2
Instance FUNDLEV Warning Instance.FUNDLEV should be coded 20, 21 or 99 by institutions in England or Northern Ireland where Course.COURSEAIM begins E or M, except M22, or equals H50, H60, H61, H71, H78, H81, H88, I60, I61 and I81 3
Instance FUNDLEV Warning Instance.FUNDLEV should be coded 10, 11 or 99 by institutions in England or Northern Ireland where Course.COURSEAIM begins H, I, J or C, or equals M22 but excluding H50, H60, H61, H71, H78, H81, H88, I60, I61 and I81 4
Instance FUNDLEV Error Instance.FUNDLEV must not exist for institutions in Scotland or Wales 5
Instance GLHRS Error Instance.GLHRS must exist for institutions in England or Wales where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 or 02 1
Instance GLHRS Error Instance.GLHRS must not exist for institutions in Northern Ireland or Scotland 2
Instance GLHRS Error Instance.GLHRS must not exist for institutions in England or Wales where Instance.FESTUMK = 2 3
Instance GOVINIT Error Instance.GOVINIT must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 1
Instance GOVINIT Error Instance.GOVINIT must not exist for institutions not in England 2
Instance GOVINIT Error Instance.GOVINIT must not exist for institutions in England where Instance.FESTUMK = 2 3
Instance IMPRATE Error Instance.IMPRATE must exist for institutions in England where Instance.FESTUMK = 1,3 or 4 and Course.MSFUND = 86, 87, 88, AA, AB, AC or AD and Instance.REDUCEDI = 00 1
Instance IMPRATE Error Instance.IMPRATE must not exist for institutions not in England 2
Instance IMPRATE Error Instance.IMPRATE must not exist for institutions in England where Instance.FESTUMK = 2 3
Instance ITTPHSC Error Instance.ITTPHSC must exist for institutions in England or Wales where Course.TTCID = 1, 2 or 8 and Course.REDUCEDC = 00, 01 or 04 1
Instance ITTPHSC Error Instance.ITTPHSC codes 15 - 26 can be used where Course.TTCID = 1 or 8 and Instance.COMDATE, where it exists, is before 2002-08-01 2
Instance ITTPHSC Error Instance.ITTPHSC codes 61 - 65 are valid only for institutions in Wales where Instance.COMDATE is after 2002-07-31 3
Instance ITTPHSC Error Instance.ITTPHSC codes 71 - 82 are valid only for institutions in England where Instance.COMDATE is after 2007-07-31 4
Instance ITTPHSC Error Instance.ITTPHSC codes 53 - 57 are available for institutions in Wales where (Course.TTCID = 1 or 8 and Instance.COMDATE is after 2002-07-31 5
Instance ITTPHSC Error Instance.ITTPHSC codes 31 or 49 are available only where Course.TTCID is coded 2 6
Instance ITTPHSC Error Instance.ITTPHSC must not exist for institutions in Northern Ireland or Scotland 7
Instance ITTPHSC Error Instance.ITTPHSC must not exist for institutions in England or Wales where Course.TTCID = 0 8
Instance ITTPHSC Error Instance.ITTPHSC 51-57 can only be used by institutions in England where Course.TTCID = 1 or 8 and Instance.COMDATE, where it exists, is between 2002-08-01 and 2007-07-31 9
Instance ITTSCHMS Error Instance.ITTSCHMS must exist where the institution is in England or Wales and Course.TTCID = 1 or 2 and Instance.REDUCEDI = 00, 01 or 04 1
Instance ITTSCHMS Error Instance.ITTSCHMS must not exist for institutions in Northern Ireland or Scotland 2
Instance ITTSCHMS Error Instance.ITTSCHMS must not exist where the institution is in England or Wales and Course.TTCID = 0 3
Instance LEARNDIF Error Instance.LEARNDIF must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 1
Instance LEARNDIF Error Instance.LEARNDIF must not exist for institutions not in England 2
Instance LEARNDIF Error Instance.LEARNDIF must not exist for institutions in England where Instance.FESTUMK = 2 3
Instance LOADYRA Error Instance.LOADYRA must exist where Institution.INSTAPP is coded 1 and Instance.TYPEYR = 2, 3, 4 or 5 1
Instance LOADYRA Error Instance.LOADYRA must not exist where Institution.INSTAPP is coded 0 2
Instance LOADYRA Error Instance.LOADYRA must not exist for institutions in Scotland and Wales 3
Instance LOADYRB Error Instance.LOADYRB must exist where Institution.INSTAPP is coded 1 and Instance.TYPEYR = 2, 3, 4 or 5 1
Instance LOADYRB Error Instance.LOADYRB must not exist where Institution.INSTAPP is coded 0 2
Instance LOADYRB Error Instance.LOADYRB must not exist for institutions in Scotland and Wales 3
Instance LOCSDY Error Instance.LOCSDY must exist where Instance.REDUCEDI = 00 or 01 1
Instance LOCSDY Error Instance.LOCSDY codes A - C, H - R are only available where Instance.FESTUMK = 1, 3 or 4 and the institution is in England or Wales 2
Instance LOCSDY Warning Instance.LOCSDY should be coded F where Instance.SPECFEE = 2 or 3 3
Instance LOCSDY Error Instance.LOCSDY must not be coded D, E, or F where Instance.MODE is coded 01 and the institution is in England or Wales 4
Instance LOCSDY Error Instance.LOCSDY must be coded F where Instance.MODE 52 or 53 and the institution is in England 5
Instance LOCSDY Error Instance.LOCSDY must not be coded D, E, F or G where Instance.MODE is coded 63 or 64 6
Instance MCDATE Error Instance.MCDATE must exist for institutions in England or Northern Ireland and Course.COURSEAIM begins D, E, L or M (excluding M22) and Instance.REDUCEDI = 00 and Instance.MODE is not equal to 63 or 64 1
Instance MCDATE Error Instance.MCDATE must not be null except when ReasonForNull = 9 2
Instance MCDATE Error Instance.MCDATE must be null when ReasonForNull = 9 3
Instance MCDATE Error Instance.MCDATE must be ReasonForNull=9 for institutions in England and Northern Ireland and Course.COURSEAIM begins D, E, L or M (excluding M22) and Instance.MODE = 63 or 64 4
Instance MCDATE Error Instance.MCDATE must not exist for institutions in Scotland or Wales 5
Instance MODE Error Instance.MODE codes 12 - 14 and 32 - 37 are only available to institutions England or Wales 1
Instance MODE Error Instance.MODE cannot be coded 63 or 64 where Instance.COMDATE is in the current reporting period (i.e. on/after 01-Aug-Y1) 2
Instance MODE Error Instance.MODE must be coded 01, 02, 31, 63, 64, 73 or 74 by institutions in England or Wales where Course.TTCID = 1 or 8 3
Instance MODE Error Instance.MODE must be coded 12, 13, 14, 32, 33, 34, 35, 36, 37, 63, 64, 65, 67, 66, 68 or 69 by institutions in England or Wales where Instance.FESTUMK = 1 or 4 4
Instance MODE Error Instance.MODE must not be coded 01 or 02 where Instance.FESTUMK is coded 1 or 4 5
Instance MODE Error Instance.MODE cannot be coded 01 where Instance.REDUCEDI = 01 6
Instance MODE Error Instance.MODE cannot be coded 01 by institutions in Scotland where Instance.YEARLGTH is completed but less than 24 7
Instance MODE Error Instance.MODE cannot be coded 01 by institutions in England, Scotland or Northern Ireland where Instance.UNITLGTH = 3 and Instance.SPLENGTH = 01 to 23 8
Instance MODE Error Instance.MODE cannot be coded 01 by institutions in England, Scotland or Northern Ireland where Instance.UNITLGTH = 2 and Instance.SPLENGTH = 01 to 05 9
Instance MODE Error Instance.MODE cannot be coded 12, 13, 14, 32, 33, 34, 35, 36, 37, 65, 66, 67, 68 or 69 where Instance.FESTUMK = 2 10
Instance MODE Error Institutions in Scotland cannot use code 31 11
Instance MODE Error Institutions in England, Scotland and Northern Ireland cannot use code 67 12
Instance MODE Error Institutions in Scotland and Northern Ireland cannot use code 65, 66, 68 and 69 13
Instance MODE Error Instance.MODE codes 73 or 74 are available only where the institution is in England and Course.COURSEAIM begins D, E, L or M (except M22) 14
Instance MODE Error Instance.MODE must be coded 52 or 53 where Instance.LOCSDY is coded F and the institution is in England or Scotland 15
Instance MODE Warning If Instance.SPECFEE = 1, then Instance.MODE should be coded 23 or 24 or 25 16
Instance MODE Warning If Instance.SPECFEE = 2 or 3, then Instance.MODE should be coded 52 or 53 17
Instance MODE Error If Instance.SPECFEE = 4 or 5 and Instance.MODE = 01 then the institutions must be Welsh 18
Instance MSTUFEE Error Instance.MSTUFEE must exist where Instance.REDUCEDI = 00, 01 or 02 1
Instance MSTUFEE Error Instance.MSTUFEE cannot be coded 07 where Instance.MODE = 01, 12, 23, 24 or > 39, 2
Instance MSTUFEE Error Instance.MSTUFEE code 96 is only available where Instance.FESTUMK = 1 or 4 3
Instance MSTUFEE Error Instance.MSTUFEE cannot be coded 07 where Instance.MODE = 02, 13 or 25, Instance.UNITLGTH = 3 and Instance.SPLENGTH is greater than 23 4
Instance MSTUFEE Error Instance.MSTUFEE cannot be coded 07 where Instance.MODE = 02, 13 or 25, Instance.UNITLGTH = 2 and Instance.SPLENGTH is greater than 05 5
Instance MSTUFEE Error Instance.MSTUFEE must be coded 98 where Instance.EXCHANGE is coded 1, 2, 3 or 6 6
Instance MSTUFEE Error Instance.MSTUFEE must not be 71 where Instance.MODE is less than 40 7
Instance MSTUFEE Warning Instance.MSTUFEE should not be coded 02, 03, 52, 53, 11, 12, 13, 14, 15, 17, 18 or 19 where (EntryProfile.DOMICILE exists and is coded XG) 8
Instance MSTUFEE Warning Instance.MSTUFEE should not be coded 02, 04, 52, 54 where (EntryProfile.DOMICILE exists and is coded XH) 9
Instance MSTUFEE Warning Instance.MSTUFEE should not be coded 03, 04, 53 or 54 where (EntryProfile.DOMICILE exists and is coded XF or XI) 10
Instance NHSEMP Error Instance.NHSEMP must exist for institutions in England where Course.COURSEAIM = M76, H76, I76 or J76 and Instance.REDUCEDI = 00 or 01 1
Instance NHSEMP Error Instance.NHSEMP must not exist for institutions not in England 3
Instance NONPAY Error Instance.NONPAY must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 and Course.MSFUND does not equal 91 1
Instance NONPAY Error Instance.NONPAY must not exist for institutions not in England 2
Instance NONPAY Error Instance.NONPAY must not exist for institutions in England where Instance.FESTUMK = 2 3
Instance NOTACT Warning Instance.NOTACT should not exist where Instance.RSNEND exists and Instance.ENDDATE is not null 1
Instance NOTACT Warning Instance.NOTACT must be 1 where Instance.MODE is 73 or 74 2
Instance NOUNTACH Error Instance.NOUNTACH must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 1
Instance NOUNTACH Error Instance.NOUNTACH must not exist for institutions not in England 2
Instance NOUNTACH Error Instance.NOUNTACH must not exist for institutions in England where Instance.FESTUMK = 2 3
Instance NUMUNITS Error Instance.NUMUNITS must exist for institutions in England or Wales where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 1
Instance NUMUNITS Error Instance.NUMUNITS must not exist for institutions in Northern Ireland or Scotland 2
Instance NUMUNITS Error Instance.NUMUNITS must not exist for institutions in England or Wales where Instance.FESTUMK = 2 3
Instance PHDSUB Error Instance.PHDSUB must exist where Instance.RCSTDNT is not 99 and Course.COURSEAIM = D00 and Instance.REDUCEDI = 00 or 04 1
Instance PHDSUB Error Where Instance.PHDSUB exists then Course.COURSEAIM must = D00 2
Instance PHDSUB Error Instance.PHDSUB must not be null except when ReasonForNull = 9 3
Instance PHDSUB Error Instance.PHDSUB must be null when ReasonForNull = 9 4
Instance PHDSUB Error Instance.PHDSUB must not be greater than Y2-07-31 5
Instance PROGRESS Error Instance.PROGRESS must exist for institutions in England or Wales where Instance.FESTUMK = 1,3 or 4 and Instance.REDUCEDI = 00 or 02 1
Instance PROGRESS Error Instance.PROGRESS cannot be coded A, B, C or D by institutions in Wales 2
Instance PROGRESS Error Instance.PROGRESS cannot be coded W or 6 by institutions in England 3
Instance PROGRESS Error Instance.PROGRESS must be coded 9 where Instance.CSTAT = 1 4
Instance PROGRESS Error Instance.PROGRESS cannot be coded 9 where Instance.CSTAT = 2 5
Instance PROGRESS Error Instance.PROGRESS must not exist for institutions in Northern Ireland or Scotland 6
Instance PROGRESS Error Instance.PROGRESS must not exist for institutions in England or Wales where Instance.FESTUMK = 2 7
Instance QTS Error Instance.QTS must exist for institutions in England and Northern Ireland where Course.TTCID = 5 and Instance.REDUCEDI = 00, 01 or 04 1
Instance QTS Error Instance.QTS cannot be coded 4 where (EntryProfile.QUALENT2 exists and is coded 03 or 10) 2
Instance QTS Error Instance.QTS cannot be coded 3 where (EntryProfile.QUALENT2 exists and is coded 04, 37 - 98) 3
Instance QTS Error Instance.QTS must not exist for institutions in Scotland or Wales 4
Instance QTS Error Instance.QTS must not exist for institutions in England and Northern Ireland where Course.TTCID not = 5 5
Instance RCSTDNT Error Instance.RCSTDNT must exist where Course.COURSEAIM begins D, E, L or M (except M22) and Instance.REDUCEDI = 00 or 04 1
Instance RECFEE Error Instance.RECFEE must exist for institutions in England and Wales where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 1
Instance RECFEE Error Instance.RECFEE must not exist for institutions in Northern Ireland or Scotland 2
Instance RECFEE Error Instance.RECFEE must not exist for institutions in England and Wales where Instance.FESTUMK = 2 3
Instance REDUCEDI Error Instance.REDUCEDI cannot = 01 or 02 for institutions in England where Instance.FESTUMK = 1 1
Instance REDUCEDI Error Instance.REDUCEDI code 01 is only available for institutions in England, Scotland or Northern Ireland 2
Instance REDUCEDI Error Instance.REDUCEDI code 01 is only available where Instance.STULOAD less than or equal to 010.0 3
Instance REDUCEDI Error Instance.REDUCEDI cannot = 02 for institutions in Wales where Instance.FESTUMK = 1 4
Instance REDUCEDI Error Instance.REDUCEDI code 02 is only available where Course.MSFUND = 73-79, 83 or 85-89 and Instance.GLHRS is less than 120 5
Instance REDUCEDI Error Instance.REDUCEDI code 02 is only available where Course.COURSEAIM begins with P, Q, R, S or X 6
Instance REDUCEDI Error Instance.REDUCEDI code 03 is only available where Instance.EXCHANGE = 1, 2, 3, 4 or 6 7
Instance REDUCEDI Error Instance.REDUCEDI code 04 is only available where Instance.MODE = 63 or 64 8
Instance REDUCEDI Warning Instance.REDUCEDI code 02 should not be used where Course.MSFUND = 73, 74, 78 or 79 (and there is LSC or WAG-DCELLS funding) and Instance.GLHRS is less than 120 9
Instance RSNEND Error Instance.RSNEND must exist where Instance.ENDDATE is not null and Instance.REDUCEDI = 00, 01, 02 or 04 1
Instance RSNEND Error Instance.RSNEND must not exist where Instance.FUNDCOMP = 3 2
Instance RSNEND Warning Instance.RSNEND should exist where QualificationsAwarded.QUAL exists 3
Instance SPECFEE Error Instance.SPECFEE must exist where Instance.REDUCEDI = 00 1
Instance SPECFEE Error Instance.SPECFEE must be 1, 4 or 5 where Instance.MODE = 25 6
Instance SPECFEE Error If Instance.SPECFEE = 4 or 5 then Instance.MODE must be 02 8
Instance SPECFEE Error If Instance.SPECFEE = 4 or 5 then Instance.ENDDATE must not be blank 9
Instance SPLENGTH Error Instance.SPLENGTH must exist where Instance.REDUCEDI = 00, 01 or 02 1
Instance SPLENGTH Error Where exists, Instance.SPLENGTH must not be coded 99 by institutions in England where Instance.FESTUMK is coded 1 or 3 2
Instance SPLENGTH Error Where exists, Instance.SPLENGTH cannot be greater than 09 where Instance.MODE = 01, 02, 23, 24 or 25 and Instance.UNITLGTH = 1 3
Instance SPLENGTH Error Where exists, Instance.SPLENGTH cannot be greater than 72 where Instance.MODE = 01, 02, 23, 24 or 25 and Instance.UNITLGTH = 2 4
Instance SPLENGTH Error Instance.SPLENGTH must not be null except when ReasonForNull = 9 5
Instance SPLENGTH Error Instance.SPLENGTH must be null when ReasonForNull = 9 6
Instance ST13 Error Instance.ST13 must exist where the institution is in Wales and Instance.FESTUMK = 1 or 3 and Instance.REDUCEDI = 00 1
Instance ST13 Error Instance.ST13 must not exist for institutions in England, Northern Ireland or Scotland 2
Instance ST13 Error Instance.ST13 must not exist for institutions in Wales where Instance.FESTUMK = 2 3
Instance STULOAD Error Instance.STULOAD must exist where Instance.REDUCEDI = 00, 01, 02 or 03 1
Instance STULOAD Error Instance.STULOAD must be 0 where Instance.MODE = 63 or 64 2
Instance STULOAD Error Instance.STULOAD must not be 0 where Instance.MODE =01, 02, 23, 24, 25, 31, 52, 53, 73 or 74 and Instance.TYPEYR = 1 3
Instance STULOAD Warning Instance.STULOAD should not be 0 where Course.COURSEAIM begins D or L and Instance.MODE = 01 or 02 and Instance.YEARSTU = 01, 02 or 03 4
Instance STULOAD Warning Where REDUCEDI = 00 or 01, Instance.STULOAD+100.0 is less than sum of Module.FTE for the student instance: check modules linked to this instance 5
Instance STULOAD Error Where REDUCEDI = 00 or 01, Instance.STULOAD is greater than 0 where sum of Module.FTE for the student instance is 0 6
Instance TREFNO Error Instance.TREFNO must exist for institutions in England or Wales where the corresponding (QualificationsAwarded.OUTCOME = 1 and QualificationsAwarded.QUAL = H11 or I11) and Course.TTCID = 1 or 8 and Instance.REDUCEDI = 00 or 04 1
Instance TREFNO Error Instance.TREFNO must not exist for institutions in Northern Ireland 2
Instance TREFNO Warning Instance.TREFNO must exist for institutions in England or Wales where the corresponding (QualificationsAwarded.OUTCOME = 1 and QualificationsAwarded.QUAL = M71 or H71) and Course.TTCID = 1 or 8 and Instance.REDUCEDI = 00 or 04 3
Instance TREFNO Error Instance.TREFNO must exist for institutions in Scotland where QualificationsAwarded.QUAL = H11 or I11 and Course.TTCID = 1 or 8 and Instance.REDUCEDI = 00 or 04 4
Instance TREFNO Warning Instance.TREFNO must exist for institutions in Scotland where QualificationsAwarded.QUAL = M71 or H71 and Course.TTCID = 1 or 8 and Instance.REDUCEDI = 00 or 04 5
Instance TYPEYR Error Instance.TYPEYR must exist where Instance.REDUCEDI = 00 or 01 1
Instance TYPEYR Error Instance.TYPEYR must be coded 1 or 2 by institutions in Scotland or Wales 2
Instance TYPEYR Error Instance.TYPEYR must not be coded 1 where Instance.FUNDCOMP = 3 3
Instance TYPEYR Error Instance.TYPEYR must be coded 1 where Instance.COMDATE is greater than or equal to 1 August of the reporting period and Instance.ENDDATE (if not null) is less than or equal to 31 July of the reporting period and Instance.FUNDCOMP =1 4
Instance TYPEYR Error Instance.TYPEYR must be coded 1 where Instance.COMDATE in range 01 August - 31 December (regardless of year) and Instance.ENDDATE in range 01 January - 31 July (regardless of year) and Instance.RSNEND is coded 01 or 98 5
Instance TYPEYR Warning Instance.TYPEYR should not be coded 1 where Instance.FUNDLEV = 11, 21 or 31 and anniversary of Instance.COMDATE in academic year > 20 September and Instance.MODE = 01 6
Instance TYPEYR Warning Instance.TYPEYR should not be coded 1 where Course.COURSEAIM begins D or L 7
Instance UNITLGTH Error Instance.UNITLGTH must exist where Instance.REDUCEDI = 00, 01 or 02 1
Instance UNITLGTH Error Instance.UNITLGTH cannot be coded 5 by institutions in England where Instance.FESTUMK = 1 or 3 2
Instance UNITLGTH Error Instance.UNITLGTH code 9 is only available where Instance.SPLENGTH = ReasonForNull 3
Instance UNITLGTH Error Instance.UNITLGTH must be coded 9 where Instance.SPLENGTH = ReasonForNull 4
Instance YEARLGTH Error Instance.YEARLGTH must exist for institutions in Wales and Scotland where Instance.REDUCEDI = 00 1
Instance YEARLGTH Error Instance.YEARLGTH must be NULL and ReasonForNull = 9 where Instance.LOCSDY = D or F 2
Instance YEARLGTH Error Instance.YEARLGTH must not exist for institutions in England or Northern Ireland 3
Instance YEARPRG Error Instance.YEARPRG must exist where Instance.REDUCEDI = 00 or 01 1
Instance YEARPRG Warning Instance.YEARPRG code 0 is only available where Course.COURSEAIM begins H or I 2
Instance YEARPRG Warning Instance.YEARPRG should be less than or equal to Instance.SPLENGTH where Instance.UNITLGTH = 1 and Instance.MODE is less than 40 and Instance.YEARPRG is not coded 99 3
Instance YEARSTU Error Instance.YEARSTU must exist where Instance.REDUCEDI = 00 1
Instance YEARSTU Error Value cannot be greater than the difference in years between 31 July of the reporting period and the 01 August before Instance.COMDATE 2
Institution INSTAPP Error Institution.INSTAPP must exist for institutions in England and Northern Ireland 1
Institution INSTAPP Error Institution.INSTAPP must not exist for institutions in Scotland and Wales 2
Module CRDTPTS Error Module.CRDTPTS must be coded 999 where Module.CRDTSCM = 9 1
Module CRDTPTS Error Module.CRDTPTS cannot be coded 999 where Welsh institution 2
Module CRDTPTS Warning Module.CRDTPTS should be coded 999 where English or Northern Irish institution and Module.CRDTSCM = 7 or 8 3
Module CRDTPTS Warning Module.CRDTPTS should contain a value greater than 0 4
Module CRDTSCM Error Module.CRDTSCM cannot be coded 9 for institutions in Wales 1
Module CRDTSCM Error Module.CRDTSCM cannot be coded 2 for institutions in England, Wales or Northern Ireland 2
Module FTE Warning Module.FTE should contain a value greater than 0 1
Module LANGPCNT Error Module.LANGPCNT must exist for institutions in Scotland, Wales or Northern Ireland 1
Module LANGPCNT Error Module.LANGPCNT must be greater than 0 where Module.MODLANG = 1, 2 or 3 2
Module LANGPCNT Error Module.LANGPCNT must not exist for institutions in England 3
Module LEVLPTS Error Module.LEVLPTS must exist where Module.CRDTPTS does not equal 999 1
Module LEVLPTS Error Module.LEVLPTS codes D or E are available only for institutions in Scotland 2
Module MODLANG Error Module.MODLANG must exist for institutions in Wales, Scotland or Northern Ireland 1
Module MODLANG Error Module.MODLANG must be 1, 2 or 3 where Module.LANGPCNT is greater than 0 2
Module MODLANG Error Module.MODLANG must not exist for institutions in England 3
Module PCOLAB Error Module.PCOLAB must be greater than 0 where Module.TINST exists 1
Module TINST Error Module.TINST must exist where Module.PCOLAB is greater than 0 1
Module TINST Error Module.TINST must not exist where Module.PCOLAB is 0 3
ModuleSubject MODSBJP Error Sum across all occurrences of ModuleSubject.MODSBJP for a module must be between 99 and 101 1
QualificationsAwarded CLASS Error QualificationsAwarded.CLASS must exist where QualificationsAwarded.QUAL = M22, H00, H11, H16, H18, H22, H23, H24, H50, I00, I11, I16 1
QualificationsAwarded CLASS Error QualificationsAwarded.CLASS code 04 is only available where Institution.UKPRN = 10007788 2
QualificationsAwarded CLASS Error QualificationsAwarded.CLASS must be coded 01 - 11 where QualificationsAwarded.QUAL = M22, H00, H11, H16, H18, H22, H23, H24, H50, I00, I11, I16 3
QualificationsAwarded CLASS Error For institutions in England or Wales QualificationsAwarded.CLASS codes 51 - 90 are only available where QualificationsAwarded.QUAL begins P, Q, R, S or X 4
QualificationsAwarded CLASS Error QualificationsAwarded.CLASS must be coded 07 - 11 where QualificationsAwarded.QUAL = I00, I11 or I16 5
QualificationsAwarded OUTCOME Error QualificationsAwarded.OUTCOME codes 6 - 8, A and B are available only for institutions in England 1
QualificationsAwarded OUTCOME Error QualificationsAwarded.OUTCOME code C is only available for institutions in Wales 2
QualificationsAwarded OUTCOME Error QualificationsAwarded.OUTCOME must exist for institutions in England or Wales where Course.TTCID = 1 or 8 3
QualificationsAwarded OUTCOME Error QualificationsAwarded.OUTCOME must not exist for institutions in Northern Ireland or Scotland 4
QualificationsAwarded OUTCOME Error QualificationsAwarded.OUTCOME must not exist for institutions in England or Wales where Course.TTCID = 0 5
QualificationsAwarded QUAL Error QualificationsAwarded.QUAL cannot be coded H16, I16, M16, M86 where the first two characters of CourseSubject.SBJCA = D1 or D2 and Institution.UKPRN does not equal 10007786, 10007788, 10006842, 10007779, 10007790 or 10007794 2
QualificationsAwarded QUAL Error QualificationsAwarded.QUAL cannot be coded H16, I16, M16 or M86 where the first character of CourseSubject.SBJCA = A and Institution.UKPRN does not equal 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, 10007842, 10007803, 10007814, 10007852, 10007855, 10005343 or 10007798 3
QualificationsAwarded QUAL Error QualificationsAwarded.QUAL cannot be coded X00 where Scottish institution 5
QualificationsAwarded QUAL Error QualificationsAwarded.QUAL must be coded M22, H00, H11, H16, H18, H22, H23, H24, H50, I00, I11, I16, M86 where QualificationsAwarded.CLASS is coded 01 - 11 6
QualificationsAwarded QUAL Error QualificationsAwarded.QUAL cannot begin D, E, L, M, H, I, J or C where Course.COURSEAIM begins P, Q, R, S or X 7
QualificationsAwarded QUAL Warning QualificationsAwarded.QUAL cannot begin D, E, L or M (with the exception of M22) where Course.COURSEAIM begins H, I, J or C 8
QualificationsAwarded QUAL Warning QualificationsAwarded.QUAL cannot begin H or I where Course.COURSEAIM begins J or C 9
QualificationsAwarded TQGSEC Error QualificationsAwarded.TQGSEC must be coded 3 or 4 by institutions in Scotland or Northern Ireland where Course.TTCID = 2 2
QualificationsAwarded TQGSEC Error QualificationsAwarded.TQGSEC must be coded 1 or 2 by institutions in Scotland or Northern Ireland where Course.TTCID = 1 or 2 and QualificationsAwarded.QUAL = H71, M71, H11 or I11 3
QualificationsAwarded TQGSEC Error QualificationsAwarded.TQGSEC must not exist for institutions in Scotland or Northern Ireland where Course.TTCID = 0 or 5 4
QualificationsAwarded TQGSEC Error QualificationsAwarded.TQGSEC must not exist for institutions in England or Wales 5
QualificationsAwarded TQGSUB Error QualificationsAwarded.TQGSUB must exist for institutions in Scotland where QualificationsAwarded.TQGSEC = 2 1
QualificationsAwarded TQGSUB Error QualificationsAwarded.TQGSUB must not exist for institutions in England, Wales or Northern Ireland 2
QualificationsAwarded TQGSUB Warning QualificationsAwarded.TQGSUB cannot be coded 360 by institutions in Scotland where QualificationsAwarded.TQGSEC = 2 4
QualificationsAwarded TQGSUB Error When one or more instances of QualificationsAwarded.TQGSUB exists, one and only one instance's attribute Main must be set to "1" 5
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be Band 1 or Band 2 where QualificationsOnEntry.QUALTYPE is SS 1
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be D, M, U, Q, X, Distinction or Merit where QualificationsOnEntry.QUALTYPE is AE 2
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be P, Q or F where QualificationsOnEntry.QUALTYPE is K2, K3 or K4 3
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be a*, A*, A1, A2, B3, B4, C5, C6, D7, F or X where QualificationsOnEntry.QUALTYPE is I2 4
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be A1, A2, B3, B4, C5, C6, D7, F or X where QualificationsOnEntry.QUALTYPE is AH 5
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be a*, A1, A2, A3, A4, A5, B3, B4, B6, B7, C5, C6, C8, C9, D, D7, F or X where QualificationsOnEntry.QUALTYPE is H 6
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be A, B, C, D, E where QualificationsOnEntry.QUALTYPE is CA 7
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be A, B, C, D, E (can all be followed by #, d, m or p), N, Q, U or X where QualificationsOnEntry.QUALTYPE is A 8
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be A, B, C, D, E (can all be followed by #, d, m or p), Q, U or X where QualificationsOnEntry.QUALTYPE is A1 or AS 9
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be A, B, C, D, E, Q, U, X where QualificationsOnEntry.QUALTYPE is FM 10
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be A, B, C, D or E where QualificationsOnEntry.QUALTYPE is FS 11
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be A, B, C, D, E (can all be followed by #) , U# or X# where QualificationsOnEntry.QUALTYPE is V 13
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be A, B, C, D, E (can all be followed by #) , U# or X# where QualificationsOnEntry.QUALTYPE is V1 14
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be A1, A2, B1, B2, B3, C1, C2, C3, D1, D2, D3, E, F where QualificationsOnEntry.QUALTYPE is IL 15
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be A1, A2, B1, B2, B3, C1, C2, C3, D1, D2, D3, E, F where QualificationsOnEntry.QUALTYPE is IO 16
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be AA, AB, BB, BC, CC, CD, DD, DE, EE, U, UU, XX, Q (can also contain combinations involving #, for example AA#, A#B#) where QualificationsOnEntry.QUALTYPE is AD 17
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be AA, AB, BB, BC, CC, CD, DD, DE, EE, U, UU, XX, Q (can also contain all combinations involving #, for example AA#, A#B#, etc) where QualificationsOnEntry.QUALTYPE is DA 18
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be AA, AB, BB, BC, CC, CD,DD, DE, EE, U, A#, B#, C#, D#, E#, U#, X# where QualificationsOnEntry.QUALTYPE is V2 19
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be AA, BB, CC, DD, EE where QualificationsOnEntry.QUALTYPE is AC 20
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be D, M, P where QualificationsOnEntry.QUALTYPE is 6M, 7M, 8M, M6, M7, M8 21
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be D, M, P where QualificationsOnEntry.QUALTYPE is OC (for Certificate) 22
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be D, M, P, DD, DM, MM, MP, PP, DDD, DDM, DMM, MMM, MMP, MPP, PPP where QualificationsOnEntry.QUALTYPE is B 23
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be D, M, P, DD, DM, MM, MP, PP, DDD, DDM, DMM, MMM, MMP, MPP, PPP where QualificationsOnEntry.QUALTYPE is BE 24
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be D, M1, M2, P1, P2, P3 where QualificationsOnEntry.QUALTYPE is OD (for Diploma) 25
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be D1, D2, M1, M2, M3, P1, P2, P3 where QualificationsOnEntry.QUALTYPE is OE (for extended diploma) 26
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be P where QualificationsOnEntry.QUALTYPE is HK or IK 27
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be P where QualificationsOnEntry.QUALTYPE is WB 28
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be P, F, Pass or Fail where QualificationsOnEntry.QUALTYPE is PE 29
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be P, M, D, Distinction, Merit or Pass where QualificationsOnEntry.QUALTYPE is FA 30
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should exist where QualificationsOnEntry.QUALTYPE = 6M, 7M, 8M, A, A1, AC, AD, AE, AH, AS, B, CA, DA, FM, FS, H, HK, I2, IK, IL, IO, K2, K3, K4, M6, M7, M8, V, V1, V2, WB, BE, FA, OC, OD, OE, PE or SS 31
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be A, B, C, D, E (can all be follwed by #, d, m, p, u) where QualificationsOnEntry.QUALTYPE is SP 32
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be A, B, C, D, E, F, M, P, Q, U or X where QualificationsOnEntry.QUALTYPE is AI 33
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be A*, a* where QualificationsOnEntry.QUALTYPE is I1 34
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be P or X where QualificationsOnEntry.QUALTYPE is ND or NC 35
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be A1, A2, B3, B4, C5, C6, D7, F or X where QualificationsOnEntry.QUALTYPE is SW 36
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be H1, H2, H3, H4, H5, H6, H7, HN or HP where QualificationsOnEntry.QUALTYPE is IB 37
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be A, B, C, D, E, N or P where QualificationsOnEntry.QUALTYPE is IC 38
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be 0, 1, 2, 3, +1, +2, +3, FC, N, P where QualificationsOnEntry.QUALTYPE is ID 39
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be a 2-digit number in the range 24-45 where QualificationsOnEntry.QUALTYPE is IE 40
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be B, D, F, P or W where QualificationsOnEntry.QUALTYPE is IF 41
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be S1, S2, S3, S4, S5, S6, S7, SN or SP where QualificationsOnEntry.QUALTYPE is IS 42
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be EA, EB, EC, ED, EE, EN or EP where QualificationsOnEntry.QUALTYPE is IX 43
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be P, F or Q where QualificationsOnEntry.QUALTYPE is K1 44
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be P, F, Pass or Fail where QualificationsOnEntry.QUALTYPE is CO 45
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be A, B, C, D or E where QualificationsOnEntry.QUALTYPE is FD 46
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be S, 1, 2, 3 or U where QualificationsOnEntry.QUALTYPE is ST 47
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be D, M or P where QualificationsOnEntry.QUALTYPE is O6 48
QualificationsOnEntry QUALGRADE Warning QualificationsOnEntry.QUALGRADE should be D, M1, M2, P1, P2 or P3 where QualificationsOnEntry.QUALTYPE is OT 49
QualificationsOnEntry QUALSBJ Warning QualificationsOnEntry.QUALSBJ must be K20, K21, K22, K23, K72 or K92 where QualificationsOnEntry.QUALTYPE is K2 1
QualificationsOnEntry QUALSBJ Warning QualificationsOnEntry.QUALSBJ must be K30, K31, K32, K33, K73, K93, K41, K42, K43, K74 or K94 where QualificationsOnEntry.QUALTYPE is K3 2
QualificationsOnEntry QUALSBJ Warning QualificationsOnEntry.QUALSBJ must be K41, K42, K43, K74 or K94 where QualificationsOnEntry.QUALTYPE is K4 3
QualificationsOnEntry QUALSBJ Warning QualificationsOnEntry.QUALSBJ must be K44, K45, K46, K47, K48, K49, K50, K51, K52, K53 or K54 where QualificationsOnEntry.QUALTYPE is IK 4
QualificationsOnEntry QUALSBJ Warning QualificationsOnEntry.QUALSBJ must be K55, K56, K57, K58, K59, K60, K62 or K63 where QualificationsOnEntry.QUALTYPE is HK 5
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 1951 or later where QualificationsOnEntry.QUALTYPE is A 1
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 1986 or later where QualificationsOnEntry.QUALTYPE is SS 2
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 1987 or later where QualificationsOnEntry.QUALTYPE is A1 or AS 3
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2000 or later where QualificationsOnEntry.QUALTYPE is H 4
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2000 or later where QualificationsOnEntry.QUALTYPE is HK or IK 5
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2000 or later where QualificationsOnEntry.QUALTYPE is I2 6
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2000 or later where QualificationsOnEntry.QUALTYPE is K2, K3, K4 7
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2001 or later where QualificationsOnEntry.QUALTYPE is CA or AC 8
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2001 or later where QualificationsOnEntry.QUALTYPE is FA 9
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2001 or later where QualificationsOnEntry.QUALTYPE is VI 10
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2001 or later where QualificationsOnEntry.QUALTYPE is AH 11
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2002 or later where QualificationsOnEntry.QUALTYPE is AE 12
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2002 or later where QualificationsOnEntry.QUALTYPE is FM 13
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2002 or later where QualificationsOnEntry.QUALTYPE is FS 14
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2002 or later where QualificationsOnEntry.QUALTYPE is V 15
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2003 or later where QualificationsOnEntry.QUALTYPE is B 17
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2003 or later where QualificationsOnEntry.QUALTYPE is BE 18
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2003 or later where QualificationsOnEntry.QUALTYPE is OC (for Certificate) 19
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2003 or later where QualificationsOnEntry.QUALTYPE is OD (for Diploma) 20
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2003 or later where QualificationsOnEntry.QUALTYPE is OE (for extended diploma) 21
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2004 or later where QualificationsOnEntry.QUALTYPE is PE 22
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2005 or later where QualificationsOnEntry.QUALTYPE is WB 23
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2006 or later where QualificationsOnEntry.QUALTYPE is AD 24
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be 2007 or later where QualificationsOnEntry.QUALTYPE is DA 25
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR must be less than or equal to Instance.COMDATE year 26
RAEData UOAPCNT Error For each Instance in which it occurs the sum of RAEData.UOAPCNT must equal 100 1
Student BIRTHDTE Error Where exists, Student.BIRTHDTE cannot be before 1906-11-01 1
Student BIRTHDTE Error Where exists, Student.BIRTHDTE cannot be greater than Y1-07-31 2
Student BIRTHDTE Warning Where exists, Student.BIRTHDTE should be less than (Y1-20)-08-01 where Course.COURSEAIM = M71 or H71 3
Student BIRTHDTE Warning Where exists, Student.BIRTHDTE should be less than (Y1-17)-08-01 where Course.COURSEAIM = H11 or I11 4
Student BIRTHDTE Warning Where exists, Student.BIRTHDTE should be greater than (Y1-70)-07-31 5
Student BIRTHDTE Warning Where exists, Student.BIRTHDTE should be less than (Y1-14)-07-31 6
Student BIRTHDTE Error Student.BIRTHDTE must not be null except when ReasonForNull = 1 8
Student BIRTHDTE Error Student.BIRTHDTE must be null when ReasonForNull = 1 9
Student DISABLE Error Student.DISABLE must exist where any Instance.REDUCEDI = 00 or 01 1
Student ETHNIC Error Student.ETHNIC code 14 is only available for institutions in Northern Ireland 1
Student ETHNIC Error Student.ETHNIC must exist where (EntryProfile.DOMICILE exists and is coded XF, XG, XH, XI, XK, XL, GG, JE, IM) and Instance.REDUCEDI = 00 or 01 2
Student FNAMES Error Student.FNAMES must exist where any Instance.REDUCEDI = 00, 01 or 04 1
Student FNAMES Error Student.FNAMES must not be null except when ReasonForNull = 9 2
Student FNAMES Error Student.FNAMES must be null when ReasonForNull = 9 3
Student HUSID Error Student.HUSID must not contain all zeros 1
Student HUSID Error If characters 1-4 are not 0000 then chars 3-6 of Student.HUSID must be a valid INSTID plus 1000. 2
Student HUSID Error Student.HUSID must pass the checksum test given in the coding manual 3
Student HUSID Error If characters 1 - 4 of Student.HUSID are not 0000 then characters 3 - 6 of Student.HUSID must not be 3001 when Instance.COMDATE is after 2007-07-31 (this HESA identifier is now invalid). 4
Student NATION Error Student.NATION must exist for institutions in England, Wales or Scotland where any Instance.REDUCEDI = 00 or 03 and Instance.COMDATE is on or after 2007-08-01 1
Student NATION Error Student.NATION can only be XL when Instance.COMDATE is before 2007-08-01 2
Student NATIOND Error Student.NATIOND must exist for institutions in Wales where any (EntryProfile.DOMICILE exists and is coded XI) and the corresponding Instance.REDUCEDI = 00 or 02 1
Student NATIOND Error Student.NATIOND must not exist for institutions in England, Northern Ireland or Scotland 2
Student SCN Error Student.SCN must pass the checksum test as shown in the coding manual 1
Student SCN Error Student.SCN must exist where (EntryProfile.DOMICILE exists and is coded XH) and EntryProfile.UCASAPPID exists and Course.COURSEAIM begins H, I, J, C, P, Q, R or S 2
Student SCN Error Student.SCN must exist for institutions in Scotland where (EntryProfile.DOMICILE exists and is coded XH) and Course.COURSEAIM begins H, I, J, C, P, Q, R or S 3
Student SCN Error Student.SCN must not be null except when ReasonForNull = 1 4
Student SCN Error Student.SCN must be null when ReasonForNull = 1 5
Student SDEPEND Error Student.SDEPEND must exist for all students at institutions in Scotland where any Instance.REDUCEDI = 00 1
Student SDEPEND Error Student.SDEPEND must not exist for institutions in England, Northern Ireland or Wales 2
Student SURNAME Error Student.SURNAME must exist where any Instance.REDUCEDI = 00, 01 or 04 1
Student TTACCOM Error Student.TTACCOM must exist where any Instance.MODE = 01, 02, 23, 24 or 25 and the corresponding Instance.REDUCEDI = 00 1
Student TTACCOM Warning Student.TTACCOM should not be coded 6 where Instance.LOCSDY = X 2
Student TTPCODE Error Student.TTPCODE must exist where any Instance.LOCSDY does not equal 6, 9, D or F and the corresponding Instance.REDUCEDI = 00 1
Student TTPCODE Error Where exists, Student.TTPCODE must not equal EntryProfile.POSTCODE where Student.TTACCOM = 1 or 9 2
Student TTPCODE Error Student.TTPCODE must not be null except when ReasonForNull = 1 3
Student TTPCODE Error Student.TTPCODE must be null when ReasonForNull = 1 4
Student ULN Error Student.ULN must pass the checksum test 1
Student WELSSP Error Student.WELSSP must exist for institutions in Wales where any (EntryProfile.DOMICILE exists and is coded XI) and the corresponding Instance.REDUCEDI = 00 or 02 1
Student WELSSP Error Student.WELSSP must not exist for institutions in England, Northern Ireland or Scotland 2
StudentOnModule MODID Error StudentOnModule.MODID must exist on Module.MODID 1
StudentOnModule MODOUT Error Institutions in Wales cannot use StudentOnModule.MODOUT code 7 1
StudentOnModule MODOUT Error StudentOnModule.MODOUT must be coded 6 where Welsh institution and StudentOnModule.MODSTAT = 3 2
StudentOnModule MODOUT Error Institutions not in Wales cannot use StudentOnModule.MODOUT code 3 3
StudentOnModule MODSTAT Error StudentOnModule.MODSTAT cannot be coded 5 where institution is in Wales 1
StudentOnModule MODYR Error StudentOnModule.MODYR must exist where Institution.INSTAPP =1 and Instance.TYPEYR = 2, 3, 4 or 5 1
StudentOnModule MODYR Error StudentOnModule.MODYR must not exist where Institution.INSTAPP = 0 2
StudentOnModule MODYR Error StudentOnModule.MODYR must not exist for institutions in Scotland and Wales 3

Contact Liaison by email or on 01242 211144.