HESA Student Record 2007/08
HESA Student Record 2007/08Summary 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 +44 (0)1242 388 531.