Skip to main content

HESA Student Record 2008/09

Back to C08051

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 01242 211144.