# HESA Student Record 2008/09

## HESA Student Record 2008/09## Summary of business rules |
return to index |

Version 1.6 Produced 2009-10-08

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, 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 should 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 | Course.FEQAIMC must not exist for institutions in Northern Ireland or Scotland | 4 |

Course | FEQAIMC | Warning | Course.FEQAIMC should not be coded '66666666' where Course.MSFUND = 05 or 06. | 5 |

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 must have a Course.COURSEAIM beginning with 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 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X | 1 |

Course | TTCID | Error | Course.TTCID codes 8, 9, A, B, C, and D must be for an institution in England | 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, 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, 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 |

Course | TTCID | Error | Course.TTCID must not be coded 0 where Course.COURSEAIM is coded H71 or M71 | 7 |

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, P390, Q300, Q560, R100, R200, R300, 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, C800, D600, F000, F100, F110, F300, F310, G100, G500, G510, H700, H900, J420, L230, L390, L510, L700, L900, N100, N190, N870, P300, P390, 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 where Course.TTCID = 1 or 8 and Instance.ITTPHSC = 24 - 26, 54 - 57, or 78 - 82, CourseSubject.SBJCA codes C110, F110 and F310 must always be used together as a triplet | 15 |

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 | Warning | There are more than 30 occurrences of QualificationsOnEntry for an instance | 1 | |

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 code XC must have an Instance.COMDATE before 2007-08-01 or EntryProfile.UCASAPPID must exist | 1 |

EntryProfile | DOMICILE | Error | EntryProfile.DOMICILE code XL must have an Instance.COMDATE 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 2007-07-31 | 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 exist for institutions in Wales or Northern Ireland 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 2008-07-31 and corresponding Instance.REDUCEDI = 00 and EntryProfile.UCASAPPID exists. | 3 |

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 | PGCESBJ | Error | Where EntryProfile.PGCESBJ is 9998 or 9999, there must be only one occurrence of EntryProfile.PGCESBJ | 2 |

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 | POSTCODE | Error | Where exists EntryProfile.POSTCODE must contain: a valid full postcode structure or a valid outward postcode structure | 5 |

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 | QUALENT2 | Error | EntryProfile.QUALENT2 must exist where Instance.REDUCEDI = 04 and EntryProfile.DOMICILE exists. This rule has been used as a proxy to check that a full EntryProfile is returned so that data previously returned is not over-written by null values. | 5 |

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 | UCASAPPID | Error | Where EntryProfile.UCASAPPID exists it must be nine characters long where Student.UCASPERID does not exist | 4 |

EntryProfile | UCASAPPID | Error | EntryProfile.UCASAPPID must not contain all zeroes | 5 |

EntryProfile | UCASAPPID | Warning | EntryProfile.UCASAPPID should be four characters long where Student.UCASPERID exists | 6 |

EntryProfile | WELBACC | Error | EntryProfile.WELBACC must exist for institutions in Wales where EntryProfile.DOMICILE = XI and Course.COURSEAIM begins H, I , J, C and corresponding Instance.COMDATE is greater than 2005-07-31 and corresponding Instance.REDUCEDI = 00 | 1 |

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 | 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 Course.COURSEAIM ends with 99 | 1 | |

Instance | Error | QualificationsAwarded entity must occur only once where Instance.FESTUMK is coded 1 or 4 | 3 | |

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 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X | 1 |

Instance | BRIDGE | Error | Instance.BRIDGE code 1 must have 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 1971-02-01 | 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 | CSTAT | Error | Instance.CSTAT must be coded 1 where Instance.PROGRESS is coded 9 | 4 |

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 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 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 codes LWF01 - LWF27 must have an Instance.COMDATE before 2006-08-01 | 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 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X | 1 |

Instance | DISALL | Error | Instance.DISALL code 4 must have a Course.COURSEAIM beginning with 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 where Instance.FESTUMK = 1, 3 or 4 and Instance. REDUCEDI = 00 or 02 | 1 |

Instance | EMPROLE | Error | Instance.EMPROLE codes 1 - 5 must be for an institution in Wales | 2 |

Instance | EMPROLE | Error | Instance.EMPROLE codes 6 - 8 must be for an institution 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, 3 or 4 | 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 | If Instance.MODE = 63 or 64, then Instance.ENDDATE (where exists) must be greater than (Y2-6)-07-31 | 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 | Error | Instance.ENDDATE must be null with ReasonForNull = 9 where Instance.RSNEND does not exist and Instance.REDUCEDI = 00, 01, 02 or 04 | 9 |

Instance | ENDDATE | Error | Instance.ENDDATE must not be null except when ReasonForNull = 9 | 10 |

Instance | EXCHANGE | Error | Instance.EXCHANGE must exist where Instance.REDUCEDI = 00 or 03 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X | 1 |

Instance | EXCHANGE | Error | Instance.EXCHANGE must be coded 5 when Instance.SPECFEE= 3 | 2 |

Instance | EXCHANGE | Error | Instance.EXCHANGE must be coded 0, 5 or 7 where Instance.LOCSDY = F or G | 3 |

Instance | EXCHANGE | Warning | Instance.EXCHANGE should not be coded 0 where Instance.LOCSDY = F or G | 4 |

Instance | FEEELIG | Error | Instance.FEEELIG must exist where Instance.REDUCEDI = 00 or 01 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X | 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 is coded IM, XL, GG or JE) and Instance.FESTUMK not coded 1 or 3 | 5 |

Instance | FESTUMK | Error | Instance.FESTUMK must exist for institutions in England and Wales | 1 |

Instance | FESTUMK | Error | Instance.FESTUMK code 2 must not have Course.MSFUND = 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 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 must have Course.TTCID = 1, 5, 8, 9, A, B, C or D | 7 |

Instance | FUNDCODE | Error | Instance.FUNDCODE code 7 must not have Instance.ITTPHSC = 31 or 49 | 8 |

Instance | FUNDCODE | Error | For English institutions Instance.FUNDCODE codes 1 or 4 must not have Course.TTCID = 1, 8, 9, A, B, C, D | 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 should not have Course.MSFUND = 07 or 31 | 12 |

Instance | FUNDCODE | Error | Instance.FUNDCODE must not be coded 1 where Course.CLSDCRS = 1 | 13 |

Instance | FUNDCODE | Warning | Instance.FUNDCODE should not be coded 1 by institutions in England, Wales or Northern Ireland 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, EE, LV, LT, SI, SK, RO, BG)) | 14 |

Instance | FUNDCODE | Error | Instance.FUNDCODE must not be coded 2 or 3 where Instance.LOCSDY = 9 | 15 |

Instance | FUNDCODE | Warning | Instance.FUNDCODE should not be coded 1 where Instance.FUNDLEV = 20 or 21 and EntryProfile.QUALENT2 = 01, 02, 05, 14, 15 | 16 |

Instance | FUNDCODE | Warning | Instance.FUNDCODE should not be coded 1 where Instance.FUNDLEV = 10 or 11 and Course.COURSEAIM begins D, E, L, M, H or I and EntryProfile.QUALENT2 is coded 01, 02, 05, 14, 15, 03, 04, 10,11, 12, 13 or 16 | 17 |

Instance | FUNDCODE | Warning | Instance.FUNDCODE should not be coded 1 where Instance.FUNDLEV = 10 or 11 and Course.COURSEAIM equals J10, J16 or J30 and EntryProfile.QUALENT2 is coded 01, 02, 05, 14, 15, 03, 04, 10, 11, 12, 13, 16 or 31 | 18 |

Instance | FUNDCODE | Warning | Instance.FUNDCODE should not be coded 1 where Instance.FUNDLEV = 10 or 11 and Course.COURSEAIM begins J (excluding J10, J16, J30), C, P, Q, R, S, X and EntryProfile.QUALENT2 is coded 01, 02, 05, 14, 15, 03, 04, 10, 11, 12, 13, 16, 31, 24 or 25 | 19 |

Instance | FUNDCODE | Error | Instance.FUNDCODE must not be coded 1 or 4 where Instance.QTS = 3 and Course.TTCID = 5 | 20 |

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 | Where Instance.FUNDCOMP is 4, the institution must be in Wales and Instance.MODE must be 01, 02, 23, 24, 25, 52 or 53 and Course.COURSEAIM must not begin with D, L, P, Q, R, S or X | 4 |

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 or I, or equals M22. This rule is not applied when Course.COURSEAIM is one of the following: 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 | FUNDLEV | Error | Instance.FUNDLEV must not be coded 10 or 11 by institutions in England or Northern Ireland where Course.COURSEAIM = D00, E00 | 6 |

Instance | FUNDLEV | Error | Instance.FUNDLEV must not be coded 30 or 31 by institutions in England or Northern Ireland where Course.COURSEAIM = E00, E90 or begins M, H, I | 7 |

Instance | FUNDLEV | Error | Instance.FUNDLEV must be coded 10, 11 or 99 by institutions in England or Northern Ireland where Course.COURSEAIM begins J, C | 8 |

Instance | FUNDLEV | Error | Instance.FUNDLEV must be coded 20, 21 or 99 by institutions in England or Northern Ireland where Course.COURSEAIM = H61, I61 and Instance.FUNDCODE =1 | 9 |

Instance | FUNDLEV | Warning | Instance.FUNDLEV should not be coded 10 or 11 by institutions in England or Northern Ireland where Course.COURSEAIM begins M and is not M22 | 10 |

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 | INSTCAMP | Error | Instance.INSTCAMP must exist and contain a valid full postcode structure or a valid outward postcode structure for institutions in Wales where Course.COURSEAIM is coded X41 to X46 | 1 |

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 must have Course.TTCID = 1 or 8 and Instance.COMDATE (where exists) before 2002-08-01 | 2 |

Instance | ITTPHSC | Error | Instance.ITTPHSC codes 61 to 65 must be for an institution in Wales where Instance.COMDATE (where exists) is after 2002-07-31 | 3 |

Instance | ITTPHSC | Error | Instance.ITTPHSC codes 71 - 82 must be for an institution in England where Instance.COMDATE (where exists) is after 2007-07-31 | 4 |

Instance | ITTPHSC | Error | Where Instance.ITTPHSC codes 53 - 57 are used and institution in Wales and Course.TTCID = 1 or 8, Instance.COMDATE (where it exists) must be after 2002-07-31 | 5 |

Instance | ITTPHSC | Error | Instance.ITTPHSC codes 31 or 49 must have Course.TTCID = 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 | Where Instance.ITTPHSC codes 51-57 are used and institution in England and Course.TTCID = 1 or 8, Instance.COMDATE (where it exists) must be between 2002-08-01 and 2007-07-31 | 9 |

Instance | ITTPHSC | Warning | Instance.ITTPHSC codes 51 and 52 should not be used by institutions in Wales | 10 |

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 | ITTSCHMS | Error | Instance.ITTSCHMS codes 1 or 3 must have an Instance.COMDATE earlier than 2007-08-01 | 4 |

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 and Course.COURSEAIM does not begin D, L, P, Q, R, S, X | 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 and Course.COURSEAIM does not begin D, L, P, Q, R, S, X | 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 must have Instance.FESTUMK = 1, 3 or 4 and the institution must be 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 | Warning | Instance.LOCSDY should not be coded D, E, F or G where Instance.MODE is coded 63 or 64 | 6 |

Instance | LOCSDY | Error | Instance.LOCSDY must be coded D, E, F or G where Instance.EXCHANGE is coded 5 or 7 | 7 |

Instance | LOCSDY | Error | Instance.LOCSDY must be coded D, E, F or G where Instance.SPECFEE = 1 | 8 |

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 | Where Instance.MCDATE is not null, it must be < Y1-08-01 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 | MCDATE | Error | Where exists and is not null Instance.MCDATE must be later than Y1-07-31 unless Instance.MODE = 63 or 64 | 6 |

Instance | MODE | Error | Instance.MODE codes 12 - 14 and 32 - 37 must not be used by institutions in Scotland and Northern Ireland | 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 | When Instance.MODE codes 73 and 74 are used the institution must be in England and Course.COURSEAIM must begin with D, E, L or M (excluding 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 | Instance.MODE must be coded 01, 02 or 25 for institutions in Wales where Instance.SPECFEE is coded 4 or 5 | 18 |

Instance | MODE | Error | Instance.MODE must be coded 02 or 25 for institutions in England, Scotland and Northern Ireland where Instance.SPECFEE is coded 4 or 5 | 19 |

Instance | MODE | Error | Instance.MODE must not be coded 23, 24 or 25 where Course.COURSEAIM is H16, I16, M16 or M86 and the first character of CourseSubject.SBJCA is 'A' | 20 |

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 must have 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 or 53 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 | MSTUFEE | Warning | For institutions in Northern Ireland Instance.MSTUFEE should not be coded 11, 12, 13, 14, 15, 17, or 18 | 11 |

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 | Error | Instance.NOTACT must be 1 where Instance.MODE is 73 or 74 | 2 |

Instance | NOUNTACH | Error | Instance.NOUNTACH must exist for institutions in England and Wales 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 and Wales | 2 |

Instance | NOUNTACH | Error | Instance.NOUNTACH must not exist for institutions in England and Wales 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 | PHDSUB | Warning | Where Instance.PHDSUB exists it should not be earlier than (Y1-2)-08-01 when Instance.MODE is not 63 or 64 | 6 |

Instance | PHDSUB | Warning | Where Instance.PHDSUB exists it should not be earlier than (Instance.COMDATE + 24 months) | 7 |

Instance | PHDSUB | Error | Instance.PHDSUB must not be earlier than Instance.COMDATE | 8 |

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 is coded 2, 3 or 4 | 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 | PROGRESS | Error | Instance.PROGRESS must be coded A, B or 7 for institutions in England where Instance.RSNEND is coded 01 | 8 |

Instance | PROGRESS | Error | Instance.PROGRESS must be coded 6 or 7 for institutions in Wales where Instance.RSNEND is coded 01 | 9 |

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 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 must be for an institution in England, Scotland or Northern Ireland | 2 |

Instance | REDUCEDI | Error | Instance.REDUCEDI code 01 must have 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 must have Course.MSFUND = 73-79, 83 or 85-89 and Instance.GLHRS less than 120 | 5 |

Instance | REDUCEDI | Error | Instance.REDUCEDI code 02 must have a Course.COURSEAIM beginning with P, Q, R, S or X | 6 |

Instance | REDUCEDI | Error | Instance.REDUCEDI code 03 must have Instance.EXCHANGE = 1, 2, 3, 4 or 6 | 7 |

Instance | REDUCEDI | Error | Instance.REDUCEDI code 04 must have Instance.MODE = 63 or 64 | 8 |

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 | RSNEND | Error | Instance.RSNEND must be coded 01 where Instance.PROGRESS is coded A or B | 4 |

Instance | RSNEND | Error | Instance.RSNEND must be coded 01 where Instance.PROGRESS is coded 6 | 5 |

Instance | SPECFEE | Error | Instance.SPECFEE must exist where Instance.REDUCEDI = 00 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X | 1 |

Instance | SPECFEE | Error | For institutions in England, Northern Ireland and Wales, if Instance.SPECFEE = 4 or 5 then Instance.ENDDATE must not be blank | 9 |

Instance | SPECFEE | Error | Instance.SPECFEE must be coded 9 where Course.COURSEAIM = D00 or D90 | 10 |

Instance | SPECFEE | Warning | For institutions in Scotland if Instance.SPECFEE = 4 or 5 then Instance.ENDDATE should not be blank | 11 |

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 must not be 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 should 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 should 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 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X. | 1 |

Instance | TYPEYR | Error | Instance.TYPEYR must be coded 1 or 2 by institutions in Scotland or Wales | 2 |

Instance | TYPEYR | Warning | Instance.TYPEYR should 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 must have Instance.SPLENGTH ReasonForNull = 9 | 3 |

Instance | UNITLGTH | Error | Instance.UNITLGTH must be coded 9 where Instance.SPLENGTH ReasonForNull = 9 | 4 |

Instance | YEARLGTH | Error | Instance.YEARLGTH must exist for institutions in Wales and Scotland where Instance.REDUCEDI = 00 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X | 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 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X | 1 |

Instance | YEARPRG | Warning | Instance.YEARPRG code 0 should have Course.COURSEAIM beginning with 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 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X | 1 |

Instance | YEARSTU | Error | Instance.YEARSTU 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 | 1 |

Institution | INSTAPP | Error | Institution.INSTAPP must not exist for institutions in Scotland and Wales | 2 |

Institution | INSTAPP | Error | Institution.INSTAPP must exist for institutions in Northern Ireland where Instance.REDUCEDI = 00, 01, 03 or 04 | 3 |

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 unless Course.COURSEAIM begins with P, Q, R, S or X | 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 unless this module links (via StudentOnModule and Instance) to a course where Course.COURSEAIM begins with P, Q, R, S or X | 1 |

Module | CRDTSCM | Error | Module.CRDTSCM cannot be coded 2 for institutions in England, Wales or Northern Ireland | 2 |

Module | CRDTSCM | Error | Module.CRDTSCM must be coded 2 where Scottish institution unless this module links (via StudentOnModule and Instance) to a course where Course.COURSEAIM begins with D or L, in which case Module.CRDTSCM can be coded 9 or 2 | 3 |

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 must be for an institution 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 |

Module | TINST | Error | Module.TINST must not be coded 4001 for institutions in England | 4 |

Module | TINST | Warning | Module.TINST should not be coded 4003 or 4004 for institutions in England | 5 |

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 must have 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 must have QualificationsAwarded.QUAL beginning with 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 | CLASS | Warning | QualificationsAwarded.CLASS must exist where QualificationsAwarded.QUAL begins C, P, Q, R, S or X and Instance.FESTUMK is coded 1 or 3 | 6 |

QualificationsAwarded | OUTCOME | Error | QualificationsAwarded.OUTCOME codes 6 - 8, A and B must be for an institution in England | 1 |

QualificationsAwarded | OUTCOME | Error | QualificationsAwarded.OUTCOME code C must be for an institution 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, 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 should not begin D, E, L or M (excluding M22) where Course.COURSEAIM begins H, I, J or C | 8 |

QualificationsAwarded | QUAL | Warning | QualificationsAwarded.QUAL should not 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 should not 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 | Where exists QualificationsOnEntry.QUALGRADE should be Band 1 or Band 2 where QualificationsOnEntry.QUALTYPE is SS | 1 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be D, M, U, Q, X, 'Distinction', 'Merit' where QualificationsOnEntry.QUALTYPE is AE | 2 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be P, Q, U, F, X or 'Pass' where QualificationsOnEntry.QUALTYPE is K2, K3 or K4 | 3 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be a*, A*, A, A1, A2, B, B3, B4, C, C5, C6, D7, F, X, U, Q where QualificationsOnEntry.QUALTYPE is I2 | 4 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be A, A1, A2, B, B3, B4, C, C5, C6, D, D7, F, X, U, Q where QualificationsOnEntry.QUALTYPE is AH | 5 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be a*, A*, A, A1, A2, A3, A4, A5, B, B3, B4, B6, B7, C, C5, C6, C8, C9, D, D7, F, X, U, Q where QualificationsOnEntry.QUALTYPE is H | 6 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be A, B, C, D, E where QualificationsOnEntry.QUALTYPE is CA | 7 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be A, B, C, D, E (can all be followed by #, d, m or p), N, Q, U, U#, X, X# where QualificationsOnEntry.QUALTYPE is A | 8 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be A, B, C, D, E (can all be followed by #, d, m or p), Q, U, U#, X, X# where QualificationsOnEntry.QUALTYPE is A1 or AS | 9 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be A, B, C, D, E, Q, U, U#, X where QualificationsOnEntry.QUALTYPE is FM | 10 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be A, B, C, D, E, U, X, Q where QualificationsOnEntry.QUALTYPE is FS | 11 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be A, B, C, D, E, U, X, Q (can all be followed by #) where QualificationsOnEntry.QUALTYPE is V | 13 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be A, B, C, D, E, U, X, Q (can all be followed by #) where QualificationsOnEntry.QUALTYPE is V1 | 14 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be A1, A2, B1, B2, B3, C1, C2, C3, D1, D2, D3, E, F where QualificationsOnEntry.QUALTYPE is IL | 15 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be A1, A2, B1, B2, B3, C1, C2, C3, D1, D2, D3, E, F where QualificationsOnEntry.QUALTYPE is IO | 16 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be AA, AB, BB, BC, CC, CD, DD, DE, EE, U, UU, X, XX, Q, QQ (can also contain all combinations involving # for example AA#, A#B#) where QualificationsOnEntry.QUALTYPE is AD | 17 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be AA, AB, BB, BC, CC, CD, DD, DE, EE, U, UU, X, XX, Q, QQ (can also contain all combinations involving # for example AA#, A#B#) where QualificationsOnEntry.QUALTYPE is DA | 18 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be AA, AB, BB, BC, CC, CD,DD, DE, EE, U, X, Q, UU, XX, QQ (can also contain all combinations involving # for example B#C#, DE#) where QualificationsOnEntry.QUALTYPE is V2 | 19 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be AA, BB, CC, DD, EE, A, B, C, D, E where QualificationsOnEntry.QUALTYPE is AC | 20 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be D, M, P, F where QualificationsOnEntry.QUALTYPE is 6M, 7M, 8M, M6, M7, M8 | 21 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be P, F where QualificationsOnEntry.QUALTYPE is OC (for Certificate) | 22 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be D, M, P, DD, DM, MM, MP, PP, DDD, DDM, DMM, MMM, MMP, MPP, PPP, X, Q, U where QualificationsOnEntry.QUALTYPE is B | 23 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be D, M, P, DD, DM, MM, MP, PP, DDD, DDM, DMM, MMM, MMP, MPP, PPP, X, Q, U where QualificationsOnEntry.QUALTYPE is BE | 24 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be P, F where QualificationsOnEntry.QUALTYPE is OD (for Diploma) | 25 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be D1, D2, M1, M2, M3, P1, P2, P3 where QualificationsOnEntry.QUALTYPE is OE (for extended diploma) | 26 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be P where QualificationsOnEntry.QUALTYPE is HK or IK | 27 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be P, F, X, Q, U where QualificationsOnEntry.QUALTYPE is WB | 28 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be P, M, D, Distinction, Merit or Pass where QualificationsOnEntry.QUALTYPE is FA | 30 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be A, B, C, D, E (can all be followed by #, d, m, p, u) where QualificationsOnEntry.QUALTYPE is SP | 32 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be A, B, C, D, E, F, M, P, Q, U, X where QualificationsOnEntry.QUALTYPE is AI | 33 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be A*, a* where QualificationsOnEntry.QUALTYPE is I1 | 34 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be P, X, U, Q where QualificationsOnEntry.QUALTYPE is ND or NC | 35 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be A1, A2, B3, B4, C5, C6, D7, F, P, X, Q, U where QualificationsOnEntry.QUALTYPE is SW | 36 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be H1, H2, H3, H4, H5, H6, H7, HN, HP where QualificationsOnEntry.QUALTYPE is IB | 37 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be A, B, C, D, E, N, P where QualificationsOnEntry.QUALTYPE is IC | 38 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be 0, 1, 2, 3, +1, +2, +3, FC, N, P, X, Q, U where QualificationsOnEntry.QUALTYPE is ID | 39 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be a 2-digit number in the range 16 - 45, X, Q, U, or 0 [zero] where QualificationsOnEntry.QUALTYPE is IE | 40 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be B, D, F, P, W, X, Q, U where QualificationsOnEntry.QUALTYPE is IF | 41 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be S1, S2, S3, S4, S5, S6, S7, SN, SP where QualificationsOnEntry.QUALTYPE is IS | 42 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be EA, EB, EC, ED, EE, EN, EP where QualificationsOnEntry.QUALTYPE is IX | 43 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be P, F, Q, X, U where QualificationsOnEntry.QUALTYPE is K1 | 44 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be P, F, Pass or Fail where QualificationsOnEntry.QUALTYPE is CO | 45 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be A, B, C, D, E, U, Q, X where QualificationsOnEntry.QUALTYPE is FD | 46 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be S, 1, 2, 3, U, X, Q where QualificationsOnEntry.QUALTYPE is ST | 47 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be D, M or P where QualificationsOnEntry.QUALTYPE is O6 | 48 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be D, M1, M2, P1, P2 or P3 where QualificationsOnEntry.QUALTYPE is OT | 49 |

QualificationsOnEntry | QUALGRADE | Error | Where exists QualificationsOnEntry.QUALGRADE must be AA, AB, BB, BC, CC, CD,DD, DE, EE, U, X, Q, UU, XX, QQ where QualificationsOnEntry.QUALTYPE is 9U | 50 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be A, B, C, D, E, Q, U, X where QualificationsOnEntry.QUALTYPE is EP | 51 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be A, B, C, D, E, S, Q, U, X where QualificationsOnEntry.QUALTYPE is H1 | 52 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be A, B, C, D, E, S, Q, U, X where QualificationsOnEntry.QUALTYPE is H2 | 53 |

QualificationsOnEntry | QUALGRADE | Warning | Where exists QualificationsOnEntry.QUALGRADE should be D, M, P, Q, U, X where QualificationsOnEntry.QUALTYPE is H3 | 54 |

QualificationsOnEntry | QUALGRADE | Warning | QualificationsOnEntry.QUALTYPE is IE and QualificationsOnEntry.QUALGRADE is less than 24 (ie. no tariff score) | 55 |

QualificationsOnEntry | QUALGRADE | Warning | QualificationsOnEntry.QUALTYPE is AC and QualificationsOnEntry.QUALGRADE is A, B, C, D or E (ie. no tariff score) | 56 |

QualificationsOnEntry | QUALSBJ | Warning | QualificationsOnEntry.QUALSBJ should be K20, K21, K22, K23, K72 or K92 where QualificationsOnEntry.QUALTYPE is K2 | 1 |

QualificationsOnEntry | QUALSBJ | Warning | QualificationsOnEntry.QUALSBJ should be K30, K31, K32, K33, K73 or K93 where QualificationsOnEntry.QUALTYPE is K3 | 2 |

QualificationsOnEntry | QUALSBJ | Warning | QualificationsOnEntry.QUALSBJ should be K41, K42, K43, K74 or K94 where QualificationsOnEntry.QUALTYPE is K4 | 3 |

QualificationsOnEntry | QUALSBJ | Warning | QualificationsOnEntry.QUALSBJ should be K44, K45, K46, K47, K48, K49, K50, K51, K52, K53 or K54 where QualificationsOnEntry.QUALTYPE is IK | 4 |

QualificationsOnEntry | QUALSBJ | Warning | QualificationsOnEntry.QUALSBJ should be K55, K56, K57, K58, K59, K60, K61, K62, K63, K64 or K65 where QualificationsOnEntry.QUALTYPE is HK | 5 |

QualificationsOnEntry | QUALSBJ | Warning | QualificationsOnEntry.QUALSBJ code 'U01' (unknown subject) used more than once so may not be counted in the tariff score | 6 |

QualificationsOnEntry | QUALSBJ | Error | QualificationsOnEntry.QUALSBJ must be coded 'WBA' where QualificationsOnEntry.QUALTYPE = 'WB' | 7 |

QualificationsOnEntry | QUALTYPE | Error | QualificationsOnEntry.QUALTYPE = IE must occur only once | 1 |

QualificationsOnEntry | QUALTYPE | Error | QualificationsOnEntry.QUALTYPE = WB must occur only once | 2 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 1951 or later where QualificationsOnEntry.QUALTYPE is A | 1 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 1986 or later where QualificationsOnEntry.QUALTYPE is SS | 2 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 1987 or later where QualificationsOnEntry.QUALTYPE is A1 or AS | 3 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2000 or later where QualificationsOnEntry.QUALTYPE is H | 4 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2000 or later where QualificationsOnEntry.QUALTYPE is HK or IK | 5 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2000 or later where QualificationsOnEntry.QUALTYPE is I2 | 6 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2000 or later where QualificationsOnEntry.QUALTYPE is K2, K3, K4 | 7 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2001 or later where QualificationsOnEntry.QUALTYPE is CA or AC | 8 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2001 or later where QualificationsOnEntry.QUALTYPE is FA | 9 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2001 or later where QualificationsOnEntry.QUALTYPE is V1 | 10 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2001 or later where QualificationsOnEntry.QUALTYPE is AH | 11 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2002 or later where QualificationsOnEntry.QUALTYPE is AE | 12 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2002 or later where QualificationsOnEntry.QUALTYPE is FM | 13 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2002 or later where QualificationsOnEntry.QUALTYPE is FS | 14 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2002 or later where QualificationsOnEntry.QUALTYPE is V | 15 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2003 or later where QualificationsOnEntry.QUALTYPE is B | 17 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2003 or later where QualificationsOnEntry.QUALTYPE is BE | 18 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2008 or later where QualificationsOnEntry.QUALTYPE is OC (for Certificate) | 19 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2008 or later where QualificationsOnEntry.QUALTYPE is OD (for Diploma) | 20 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2003 or later where QualificationsOnEntry.QUALTYPE is OE (for extended diploma) | 21 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2004 or later where QualificationsOnEntry.QUALTYPE is CO | 22 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2005 or later where QualificationsOnEntry.QUALTYPE is WB | 23 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2006 or later where QualificationsOnEntry.QUALTYPE is AD | 24 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be 2007 or later where QualificationsOnEntry.QUALTYPE is DA | 25 |

QualificationsOnEntry | QUALYEAR | Warning | QualificationsOnEntry.QUALYEAR should be less than or equal to Instance.COMDATE year | 26 |

QualificationsOnEntry | QUALYEAR | Error | Where Student.BIRTHDTE is not null QualificationsOnEntry.QUALYEAR should be greater than (Student.BIRTHDTE + 13) year | 27 |

QualificationsOnEntry | QUALYEAR | Warning | Where Student.BIRTHDTE is not null and QualificationsOnEntry.QUALTYPE is not coded SS, QualificationsOnEntry.QUALYEAR should be greater than (Student.BIRTHDTE + 15) year | 28 |

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 | 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 | Error | Where exists Student.BIRTHDTE must be less than (Y1-14)-08-01 | 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 must be for an institution 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 | FNAMES | Error | Student.FNAMES must not exist where Student.SURNAME does not exist | 4 |

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 (INSTID 2001 is 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 code XL must have Instance.COMDATE before 2007-08-01 | 2 |

Student | NATION | Error | Student.NATION code XC must have Instance.COMDATE before 2007-08-01 unless (EntryProfile entity exists and EntryProfile.UCASAPPID exists) or EntryProfile entity does not exist | 3 |

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 Instance.REDUCEDI =00, 01, 02 or 04 and (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 Instance.REDUCEDI =00 and (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 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X. | 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 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X | 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 | TTPCODE | Error | Where exists Student.TTPCODE must contain: a valid full postcode structure or a valid outward postcode structure | 5 |

Student | TTPCODE | Error | Student.TTPCODE must not be null when Student.TTACCOM = 1 | 6 |

Student | TTPCODE | Warning | Student.TTPCODE should not be null when Student.TTACCOM = 9 | 7 |

Student | TTPCODE | Warning | Where exists Student.TTPCODE should not equal EntryProfile.POSTCODE where Student.TTACCOM = 8 | 8 |

Student | UCASPERID | Error | Student.UCASPERID must exist where any EntryProfile.UCASAPPID exists and is a 4 character code | 2 |

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 | MODCOUNT | Error | StudentOnModule.MODCOUNT must exist for institutions in Wales unless Course.COURSEAIM begins with P, Q, R, S or X | 1 |

StudentOnModule | MODCOUNT | Error | StudentOnModule.MODCOUNT must not exist for institutions in England, Scotland and Northern Ireland | 2 |

StudentOnModule | MODID | Error | StudentOnModule.MODID must exist on Module.MODID | 1 |

StudentOnModule | MODID | Error | More than 2 occurrences of identical StudentOnModule.MODID for a single instance | 2 |

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 and StudentOnModule.MODSTAT not coded 4 | 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.