HESA Student record 2011/12
HESA Student record 2011/12Summary of business rules |
return to index |
Version 1.3 Produced 2012-07-31
The business rules below have been updated for 2011/12. Please see Revision history for changes to the validation rules.
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' or Course.TTCID = F) | 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 = 1 or 2 . | 2 |
Course | BITTM | Error | Course.BITTM must not exist for institutions in England. | 3 |
Course | BITTM | Error | For institutions in Wales Course.BITTM must not be coded 0 where Course.TTCID = 1 and any associated CourseSubject.SBJCA = Q560. | 4 |
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 Course.COURSEAIM = D00, D01, 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, M26 or M86 where the first 2 characters of CourseSubject.SBJCA are 'D1' or 'D2' and Institution.UKPRN not = 10006842, 10007154, 10007779, 10007786, 10007788, 10007790 or 10007794. | 1 |
Course | COURSEAIM | Error | Course.COURSEAIM cannot be coded H16, I16, M16, M26 or M86 where the first character of CourseSubject.SBJCA is 'A' and Institution.UKPRN not = 10000886, 10003270, 10003645, 10005343, 10006840, 10006842, 10007141, 10007143, 10007149, 10007154, 10007157, 10007158, 10007161, 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 - X46. | 5 |
Course | COURSEAIM | Error | Institutions in Scotland cannot use code X00. | 6 |
Course | COURSEAIM | Warning | Course.COURSEAIM should be coded D00, D01, 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 | COURSEAIM | Error | Course.COURSEAIM cannot be coded M02 for institutions in Northern Ireland, Scotland or Wales | 8 |
Course | COURSEAIM | Error | Where Course.REGBODY = 08, Course.COURSEAIM must be coded M00, M10, M16, M41, M50, M76, M80, M86, M90, H00, H16, H50, H61, H76, C20 or (H80 where Institution.UKPRN = 10006840 only) or (J26 where Institution.UKPRN = 10007773 or 10007156 only). | 9 |
Course | COURSEAIM | Error | Course.COURSEAIM must be coded H99 where Course.TTCID = F. | 10 |
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, 8 or F. | 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, 8 or F. | 10 |
Course | MSFUND | Error | For institutions in Wales Course.MSFUND must not be coded 01, 03, 04, 05, 07, 12 or 14. | 11 |
Course | MSFUND | Error | For institutions in England Course.MSFUND must not be coded 02, 03, 04, 06, 13 or 14. | 12 |
Course | MSFUND | Error | For institutions in Northern Ireland Course.MSFUND must not be coded 01, 02, 03, 05, 06, 07, 11, 12, 13 or 14. | 13 |
Course | MSFUND | Error | For institutions in Scotland Course.MSFUND must not be coded 01, 02, 04, 05, 06, 07, 11, 12 or 13. | 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 | NHSBURSARY | Error | Course.NHSBURSARY must exist for all courses at institutions in England, Northern Ireland and Wales where Course.REDUCEDC = 00. | 1 |
Course | NHSBURSARY | Error | Course.NHSBURSARY must not exist for institutions in Scotland. | 2 |
Course | NHSBURSARY | Warning | Course.NHSBURSARY should not be coded 1 or 2 where the first character of CourseSubject.SBJCA is not A or B, or the first 2 characters of CourseSubject.SBJCA are not L5. | 3 |
Course | NHSBURSARY | Warning | Course.NHSBURSARY is coded 0 where all occurrences of CourseSubject have the first character of CourseSubject.SBJCA equal to A or B, or the first 2 characters of CourseSubject.SBJCA are equal to L5. | 4 |
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 institution 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 | REDUCEDC | Error | Course.REDUCEDC must be coded 00, 04 or 07 where Course.TTCID = F. | 9 |
Course | REDUCEDC | Error | Course.REDUCEDC must not be coded 07 at institutions in Northern Ireland, Scotland or Wales. | 10 |
Course | REGBODY | Error | Course.REGBODY must exist where Course.COURSEAIM = M16, M26, M76, M86, H16, H76, I16, I76, J26 or J76 and Course.REDUCEDC = 00 or 01. | 1 |
Course | REGBODY | Warning | Course.REGBODY should only be coded 08 when Institution.UKPRN = 10000291, 10000824, 10000886, 10000961, 10000975, 10001143, 10001282, 10001478, 10001726, 10001883, 10002718, 10003614, 10003645, 10003678, 10003861, 10003956, 10003957, 10004048, 10004078, 10004180, 10004351, 10004797, 10004930, 10005553, 10005790, 10006022, 10006299, 10006566, 10006840, 10007137, 10007138, 10007139, 10007140, 10007141, 10007143, 10007144, 10007145, 10007146, 10007147, 10007148, 10007149, 10007150, 10007151, 10007152, 10007154, 10007155, 10007156, 10007157, 10007158, 10007159, 10007160, 10007161, 10007163, 10007164, 10007165, 10007166, 10007167, 10007767, 10007768, 10007760, 10007773, 10007785, 10007786, 10007789, 10007791, 10007795, 10007796, 10007798, 10007801, 10007802, 10007806, 10007823, 10007842, 10007848, 10007850, 10007851 or 10014001. | 2 |
Course | REGBODY | Error | Course.REGBODY must not be coded 04 unless Instance.MODE = 63 or 64. | 3 |
Course | SKEOS | Error | Course.SKEOS must exist for courses at institutions in England where Course.REDUCEDC=07 or Course.TTCID = F. | 1 |
Course | SKEOS | Error | Course.SKEOS must not exist for institutions in Northern Ireland, Scotland or Wales. | 2 |
Course | SKEOS | Error | Course.SKEOS must not exist for courses at institutions in England where Course.TTCID not equal to F. | 3 |
Course | SKEUNITS | Error | Course.SKEUNITS must exist for courses at institutions in England where Course.REDUCEDC=07 or Course.TTCID = F. | 1 |
Course | SKEUNITS | Error | Course.SKEUNITS must not exist for institutions in Northern Ireland, Scotland or Wales. | 2 |
Course | SKEUNITS | Warning | Course.SKEUNITS should be coded in the range 1 - 18. | 3 |
Course | SKEUNITS | Error | Course.SKEUNITS must not exist for courses at institutions in England where Course.TTCID not equal to F. | 4 |
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, 04 or 07 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X. | 1 |
Course | TTCID | Error | Course.TTCID codes 8, 9, D and F 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 M71 or H71. | 7 |
Course | TTCID | Error | Course.TTCID must be coded 9 where Course.COURSEAIM = M02 | 8 |
Course | TTCID | Error | Course.TTCID must be coded 2 where Course.COURSEAIM = M79, H79, I79, C77, C78, P77 or P78 | 9 |
Course | TTCID | Error | For institutions in England, Course.TTCID must be coded 1, 2 or 8 where Instance.SPECFEE = 6. | 10 |
Course | TTCID | Error | For institutions in England, Course.TTCID must be coded F where Course.REDUCEDC = 07. | 13 |
Course | TTCID | Error | For institutions in England, Course.TTCID must be coded F where any Instance.REDUCEDI = 07. | 14 |
Course | TTCID | Error | Where Course.TTCID = F, Institution.UKPRN must be 10000291, 10000571, 10000886, 10000961, 10001143, 10002718, 10003863, 10003956, 10003957, 10004048, 10004113, 10004180, 10004206, 10004351, 10004797, 10004930, 10005790, 10006299, 10006840, 10007137, 10007139, 10007140, 10007144, 10007145, 10007146, 10007147, 10007149, 10007152, 10007155, 10007158, 10007159, 10007163, 10007164, 10007166, 10007767, 10007773, 10007776, 10007789, 10007798, 10007799, 10007801, 10007802, 10007806, 10007823, 10007832, 10007842, 10007843 or 10007848 | 16 |
Course | TTCID | Error | For institutions in England and Northern Ireland, Course.TTCID must not be coded 0 where Course.COURSEAIM = I11 or H11 | 17 |
Course | TTCID | Error | Where Course.TTCID = F and Course.CTITLE begins SKEPLUS, Institution.UKPRN must be 10000886, 10000961, 10001143, 10003956, 10003957, 10004113, 10004351, 10004797, 10005790, 10007137, 10007139, 10007140, 10007144, 10007146, 10007147, 10007164, 10007166, 10007773, 10007801, 10007802, 10007806, 10007823, 10007832 or 10007842 | 18 |
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 Institutions 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, X121 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 01-Sep-2002). | 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 - 81. | 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 - 81. | 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, M26 or M86 and Course.REGBODY = 14. | 8 |
CourseSubject | SBJCA | Error | The first character of CourseSubject.SBJCA must be 'A' or CourseSubject.SBJCA must equal B750, where Course.COURSEAIM is coded H16, I16, M16, M26 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 | 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 - 81. | 14 |
CourseSubject | SBJCA | Error | For institutions in England where Course.TTCID = 1 or 8 and Instance.ITTPHSC = 24 - 26, 54 - 57, or 78 - 81, CourseSubject.SBJCA codes C110, F110 and F310 must always be used together as a triplet. | 15 |
CourseSubject | SBJCA | Error | For institutions in England CourseSubject.SBJCA codes C100, F100 and F300 can only be used together where Course.TTCID = 1 or 8 and Instance.ITTPHSC = 15 - 19, 51 - 53 or 71 -77. | 16 |
CourseSubject | SBJCA | Error | CourseSubject.SBJCA must be coded B700, B760, B761, B790, L300, L310, L400, L410, L500, L510, L520, L530, L540, L560 or L590 where Course.REGBODY = 08 | 17 |
CourseSubject | SBJCA | Error | Where Course.SKEOS is coded 1 at least one occurrence of CourseSubject.SBJCA must begin with R. | 20 |
CourseSubject | SBJCA | Error | For institutions in Scotland CourseSubject.SBJCA must not be coded A300 where any other occurrence of CourseSubject.SBJCA = A100. | 21 |
CourseSubject | SBJCA | Error | For institutions in Scotland CourseSubject.SBJCA must not be coded A400 where any other occurrence of CourseSubject.SBJCA = A200. | 22 |
CourseSubject | SBJCA | Error | For institutions in Scotland CourseSubject.SBJCA must not be coded D200, D210, D220 or D290 where any other occurrence of CourseSubject.SBJCA = D100 or D190. | 23 |
CourseSubject | SBJCA | Error | CourseSubject.SBJCA must be coded C000, F100, F300, G100, G500, R900, V600, W200 or W300 where Course.TTCID = F. | 24 |
CourseSubject | SBJCA | Error | CourseSubject.SBJCA must be coded F100, F300, or G100 where Course.TTCID = F and Course.CTITLE begins SKEPLUS | 25 |
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 - 81. | 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) or (EntryProfile.QUALENT3 = X00 or X01) | 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, M26, H00, H11,H16, H18, H22, H23, H24, I00, I11 or I16 and Instance.COMDATE is after 2007-07-31 and corresponding Instance.REDUCEDI = 00 or 04 | 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 | DOMICILE | Error | EntryProfile.DOMICILE must not be coded ZZ (unknown) when corresponding Instance.FEEELIG = 1. | 3 |
EntryProfile | DOMICILE | Error | For institutions in Northern Ireland, EntryProfile.DOMICILE must not be coded XK where Course.COURSEAIM begins D, E, L, M, H, I, J, C and Instance.COMDATE > Y1-07-31. | 4 |
EntryProfile | DOMICILE | Error | EntryProfile.DOMICILE must not be coded AN where Instance.COMDATE > 2011-07-31. | 5 |
EntryProfile | MARSTAT | Error | EntryProfile.MARSTAT must exist for institutions in Northern Ireland where EntryProfile.DOMICILE = XG and corresponding Instance.REDUCEDI = 00 or 04. | 1 |
EntryProfile | MARSTAT | Error | EntryProfile.MARSTAT must not exist for institutions in England, Scotland or Wales. | 2 |
EntryProfile | NEWENT | Warning | EntryProfile.NEWENT should not be coded B or C if (EntryProfile.QUALENT2 is 01, 02, 03, 04, 05, 10, 11, 16, 23, 24, 25, 28, 29, 30, 15, 21, 22 or 27) or (EntryProfile.QUALENT3 begins with D, M, H, J or C (excluding HZZ)) | 3 |
EntryProfile | NIDEPEND | Error | EntryProfile.NIDEPEND must exist for institutions in Northern Ireland where EntryProfile.DOMICILE = XG and corresponding Instance.REDUCEDI = 00 or 04. | 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, M26, H00, H11, H16, H18, H22, H23, I00, I11, I16, J10, J16, J20, J26, J30, C20 or C30 and Instance.COMDATE is after 31-Jul-2007 and corresponding Instance.REDUCEDI = 00 or 04. | 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, M26, H00, H11, H16, H18, H22, H23, I00, I11, I16, J10, J16, J20, J26, J30, C20 or C30 and Instance.COMDATE is after 31-Jul-2008 and corresponding Instance.REDUCEDI = 00 or 04 and EntryProfile.UCASAPPID exists. | 3 |
EntryProfile | PGCECLSS | Error | EntryProfile.PGCECLSS must exist where Course.COURSEAIM = M71 or H71 and corresponding Instance.REDUCEDI = 00 or 04. | 1 |
EntryProfile | PGCESBJ | Error | EntryProfile.PGCESBJ must exist where Course.COURSEAIM = M71 or H71 and corresponding Instance.REDUCEDI = 00 or 04. | 1 |
EntryProfile | PGCESBJ | Error | Where EntryProfile.PGCESBJ = 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, 01, 04 or 07. | 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, M26, H00, H11, H16, H18, H22, H23, I00, I11, I16, J10, J16, J20, J26, J30, C20 or C30 and corresponding Instance.REDUCEDI = 00 or 04. | 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, 01, or 04 and Instance.COMDATE < 2010-08-01 and EntryProfile.QUALENT3 does not exist. | 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 not exist where EntryProfile.QUALENT3 exists or corresponding Instance.COMDATE > 2010-07-31 | 5 |
EntryProfile | QUALENT3 | Error | EntryProfile.QUALENT3 must exist where corresponding Instance.REDUCEDI = 00, 01 or 04 and Instance.COMDATE > 2010-07-31. | 1 |
EntryProfile | QUALENT3 | Error | EntryProfile.QUALENT3 must not exist where EntryProfile.QUALENT2 exists and corresponding Instance.COMDATE < 2010-08-01. | 2 |
EntryProfile | QUALENT3 | Error | EntryProfile.QUALENT3 cannot be coded X06 where QualificationsOnEntry entity exists. | 3 |
EntryProfile | QUALENT3 | Error | EntryProfile.QUALENT3 cannot be coded X06 where EntryProfile.WELBACC = 1. | 4 |
EntryProfile | QUALENT3 | Error | Where EntryProfile.ACCESS exists EntryProfile.QUALENT3 must be coded X00 or X01 or begin with P, C, J, H, M or D. | 5 |
EntryProfile | RELIGION | Error | EntryProfile.RELIGION must exist for institutions in Northern Ireland where EntryProfile.DOMICILE = XG and corresponding Instance.REDUCEDI = 00 or 04. | 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, M26 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 or M26 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 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 the student circular: http://www.hesa.ac.uk/circulars/student/2006/06_04.html. | 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 zeros. | 5 |
EntryProfile | UCASAPPID | Warning | EntryProfile.UCASAPPID should be four characters long where Student.UCASPERID exists. | 6 |
EntryProfile | UCASAPPID | Error | EntryProfile.UCASAPPID must be four characters long when Instance.COMDATE > 2011-07-31 | 7 |
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 or 04. | 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 entity 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 only occur 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 | There must be at least one occurrence of StudentOnModule entity with StudentOnModule.MODSTAT not equal to 4 where Instance.STULOAD is greater than 0 and Instance.REDUCEDI = 00 or 01. | 2 | |
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, M26, M86, H11, I11, H00, I00, H23, H24, J16, J30, C90, H90, I90 or J90. | 2 |
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 | CSTAT | Error | Instance.CSTAT must be coded 4 where Instance.PROGRESS is coded W. | 5 |
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 = 7, B, C, D or E or Instance.LOCSDY = F, G or S). | 1 |
Instance | DESTOCM | Error | Instance.DESTOCM must not exist for institutions in Scotland. | 2 |
Instance | DESTOCM | Error | Instance.DESTOCM must not be coded AN where Instance.COMDATE > 2011-07-31. | 3 |
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 1 August 2006. | 10 |
Instance | DHREGREF | Error | Instance.DHREGREF must exist where Course.COURSEAIM = M16, M26, 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 | Warning | Instance.DISALL should not exist where Student.DISABLE = 00, 97, 98 or 99. | 3 |
Instance | DISALL | Error | Instance.DISALL cannot 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, 04 or 07. | 9 |
Instance | ENDDATE | Error | Instance.ENDDATE must not be null except when ReasonForNull=9. | 10 |
Instance | ENDDATE | Error | Instance.ENDDATE must not be null where Instance.MODE = 63 or 64 and Course.TTCID = F. | 11 |
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 B, C, D or E when Instance.SPECFEE = 3. | 2 |
Instance | EXCHANGE | Error | Instance.EXCHANGE must be coded 0, 7, B, C, D, E or Y 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 | EXCHANGE | Error | Instance.EXCHANGE must not be coded 0, 7, B, C, D, E or Y where Course.COURSEAIM code ends with 91. | 5 |
Instance | EXCHANGE | Error | Instance.EXCHANGE must be coded 0 or Z where Instance.LOCSDY = S | 6 |
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 unless Instance.REDUCEDI = 07. | 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 = 13 or 31 and Course.COURSEAIM = H16, I16, M16, M86, H11, I11, H00, I00, H22, M22, M26, 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, D or F | 7 |
Instance | FUNDCODE | Error | Instance.FUNDCODE code 7 must not have Instance.ITTPHSC = 31. | 8 |
Instance | FUNDCODE | Error | For English institutions Instance.FUNDCODE codes 1 or 4 must not have Course.TTCID = 1, 8, 9, D or F. | 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, 13 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 or EntryProfile.QUALENT3 begins with D or M (excluding M41, M44 and M71)). | 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, 16 or EntryProfile.QUALENT3 begins with D, M, H or is equal to JUK) | 17 |
Instance | FUNDCODE | Warning | Instance.FUNDCODE should not be coded 1 where Instance.FUNDLEV = 10 or 11 and Course.COURSEAIM begins J (excluding J10, J16) 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, 25 or EntryProfile.QUALENT3 begins with D, M, H, J) | 19 |
Instance | FUNDCODE | Error | Instance.FUNDCODE must not be coded 1 or 4 where Instance.QTS = 3 and Course.TTCID = 5. | 20 |
Instance | FUNDCODE | Error | Instance.FUNDCODE code 7 must not have Instance.ITTPHSC = 49 unless Course.TTCID = F. | 21 |
Instance | FUNDCODE | Error | Instance.FUNDCODE must not be coded 1 where Instance.EXCHANGE = Z. | 22 |
Instance | FUNDCODE | Error | Where Instance.FUNDCODE is coded 4 then Instance.MODE must equal 63 or 64. | 23 |
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 (excluding M22, M26) 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 or M26. This rule is not applied when the 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, D01, 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 or M26. | 10 |
Instance | FUNDLEV | Error | For institutions in England, Instance.FUNDLEV must not be coded 11, 21 or 31 where Instance.MODE = 23 or 24 and Instance.LOCSDY = D or E. | 11 |
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 | GLHRS | Error | Where Instance.GLHRS = 0, Course.COURSEAIM must be coded X41 - X46 (Welsh for Adults) | 4 |
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 | INITIATIVES | Error | Instance.INITIATIVES must not exist for institutions in Northern Ireland or Scotland. | 1 |
Instance | INITIATIVES | Error | Where Instance.INITIATIVES is coded 3, 4 or 5 Institution.UKPRN must be 10000291, 10003861, 10006299, 10007138, 10007145, 10007150, 10007801 or 10007851. | 2 |
Instance | INITIATIVES | Error | Where there are two occurrences of Instance.INITIATIVES they must not be identical. | 5 |
Instance | INITIATIVES | Error | For institutions in England Instance.INITIATIVES must be coded 1 - 5 or B. | 6 |
Instance | INITIATIVES | Error | For institutions in Wales Instance.INITIATIVES must be coded 7. | 7 |
Instance | INITIATIVES | Error | Where Instance.INITIATIVES is coded 7 Institution.UKPRN must be 10007793 or 10007853. | 8 |
Instance | INITIATIVES | Error | Where Instance.INITIATIVES is coded B, Instance.COMDATE must be later than Y1-07-31 and Course.COURSEAIM must begin with H, I, J or C or equal M22 or M26. | 9 |
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, 8 or F and Course.REDUCEDC = 00, 01, 04 or 07. | 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 and have Instance.COMDATE > 2002-07-31. | 3 |
Instance | ITTPHSC | Error | Instance.ITTPHSC codes 71 - 81 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 code 31 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 | Error | Instance.ITTPHSC codes 51 and 52 must not be used by institutions in Wales. | 10 |
Instance | ITTPHSC | Error | Where Instance.ITTPHSC is coded 72 Instance.COMDATE must be before 2010-08-01. | 12 |
Instance | ITTPHSC | Error | Instance.ITTPHSC code 49 must have Course.TTCID = 2. | 13 |
Instance | ITTPHSC | Error | Instance.ITTPHSC must be coded in the range 71 - 81 where Course.TTCID = F | 17 |
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 | ITTSCHMS | Error | Instance.ITTSCHMS code 6 must have Instance.ITTPHSC coded 72 - 77, and CourseSubject.SBJCA = R100, R200, R300 or R400. | 5 |
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 Instance.REDUCEDI is not equal to '04' 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 Instance.REDUCEDI is not equal to '04' 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 D or 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 7, B, C, D or E. | 7 |
Instance | LOCSDY | Error | Instance.LOCSDY must be coded D, E, F or G where Instance.SPECFEE = 1. | 8 |
Instance | LOCSDY | Error | Instance.LOCSDY must be coded D, E, F, G or X where Instance.EXCHANGE = Y. | 9 |
Instance | LOCSDY | Error | Instance.LOCSDY must be coded S or X where Instance.EXCHANGE = Z. | 10 |
Instance | LOCSDY | Error | Instance.LOCSDY must be coded S where both Instance.COMDATE and Instance.ENDDATE are in the current reporting year and Instance.RSNEND = 01 or 98 and Instance.EXCHANGE = Z. | 11 |
Instance | LOCSDY | Error | Instance.LOCSDY must be coded D, E or X where Instance.MODE = 23, 24 or 25. | 12 |
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, M26) and Instance.REDUCEDI = 00 or 04. | 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-02 for institutions in England and Northern Ireland where Course.COURSEAIM begins D, E, L or M (excluding M22, M26) 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 | MCDATE | Error | Where exists and is not null Instance.MCDATE must be earlier than Y2-08-01. | 7 |
Instance | MCDATE | Error | Instance.MCDATE must not be null when Instance.MODE = 73 or 74. For further information please see the documentation in the coding manual - Further guidance on reporting Instance.MCDATE and Instance.MODE. | 8 |
Instance | MCDATE | Error | Where exists and not null Instance.MCDATE must be earlier than Instance.ENDDATE | 9 |
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 codes 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, M26). | 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 23, 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, M26 or M86 and the first character of CourseSubject.SBJCA is 'A' . | 20 |
Instance | MODE | Error | For institutions in England, Instance.MODE must be coded 31, 64 or 74 where Instance.SPECFEE = 6. | 21 |
Instance | MODE | Error | Instance.MODE must not be coded 01, 23 or 24 where Course.TTCID = F. | 22 |
Instance | MODE | Error | Instance.MODE must be coded 63 or 64 where all corresponding StudentOnModule.MODSTAT for that instance are coded 4. | 23 |
Instance | MODE | Error | Instance.MODE must not be coded 01, 23 or 24 where Instance.COMDATE > Y2-02-13 and Instance.ENDDATE is null and Instance.TYPEYR = 1. | 24 |
Instance | MODE | Error | Instance.MODE must not be coded 38 or 39 where the institution is in England, Northern Ireland or Wales. | 25 |
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 > 23. | 4 |
Instance | MSTUFEE | Error | Instance.MSTUFEE cannot be coded 07 where Instance.MODE = 02, 13 or 25, Instance.UNITLGTH = 2 and Instance.SPLENGTH > 05. | 5 |
Instance | MSTUFEE | Error | Instance.MSTUFEE must be coded 98 where Instance.EXCHANGE is coded 2, 8, 9 or A. | 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 or 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 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 | NOUNTACH | Error | For institutions in Wales Instance.NOUNTACH must be coded 99 where Instance.NUMUNITS = 99. | 4 |
Instance | NUMHUS | Error | All Instance.NUMHUS for a Student.HUSID must be unique. | 1 |
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 | NUMUNITS | Error | Instance.NUMUNITS must be greater than or equal to the value in Instance.NOUNTACH where Instance.PROGRESS is coded 6 and Instance.NUMUNITS is not coded 98 or 99. | 4 |
Instance | NUMUNITS | Error | For institutions in Wales Instance.NUMUNITS must be greater than zero and less than the value in Instance.NOUNTACH where Instance.PROGRESS is coded 7 and Instance.NUMUNITS is not coded 98 or 99. | 5 |
Instance | NUMUNITS | Error | For institutions in Wales Instance.NUMUNITS must be coded 0, 98 or 99 where Instance.PROGRESS is coded 8. | 6 |
Instance | NUMUNITS | Error | For institutions in Wales Instance.NUMUNITS must be coded 99 where Instance.NOUNTACH = 99. | 7 |
Instance | PHDSUB | Error | Instance.PHDSUB must exist where Instance.RCSTDNT is not 99 and Course.COURSEAIM = D00 or D01 and Instance.REDUCEDI = 00 or 04. | 1 |
Instance | PHDSUB | Error | Where Instance.PHDSUB exists then Course.COURSEAIM must = D00 or D01. | 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 | PHDSUB | Error | Instance.PHDSUB must not be null with ReasonForNull = 9 when Instance.RCSTDNT is not 99 and Instance.REDUCEDI = 00 or 04, and at least one corresponding QualificationsAwarded.QUAL = D00 or D01. | 9 |
Instance | PHDSUB | Warning | Instance.PHDSUB is null where Instance.RCSTDNT is not equal to 99 and Instance.REDUCEDI = 00 or 04 and Course.COURSEAIM = D00 or D01 and Instance.MODE = 01, 02, 43, 63 or 73 and QualificationsAwarded does not exist and Instance.COMDATE is earlier than (Y2-5)-08-01. The Research Councils expect a full-time PhD student to submit their thesis within 5 years. | 10 |
Instance | PHDSUB | Warning | Instance.PHDSUB is null where Instance.RCSTDNT is not equal to 99 and Instance.REDUCEDI = 00 or 04 and Course.COURSEAIM = D00 or D01 and Instance.MODE = 31, 38, 39, 44, 64 or 74 and QualificationsAwarded does not exist and Instance.COMDATE is earlier than (Y2-10)-08-01. The Research Councils expect a part-time PhD student to submit their thesis within 10 years. | 11 |
Instance | PHDSUB | Error | Where Instance.PHDSUB exists and is not null it must be earlier than Instance.ENDDATE where Instance.RSNEND = 01. | 12 |
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 | PROGRESS | Error | Instance.PROGRESS must be coded W where Instance.CSTAT = 4. | 10 |
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 is coded 03 or 10) or EntryProfile.QUALENT3 is coded H11. | 2 |
Instance | QTS | Error | Instance.QTS cannot be coded 3 where (EntryProfile.QUALENT2 is coded 04, 37 - 98) or EntryProfile.QUALENT3 begins with P, Q, R or X (excluding X06). | 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 | QTS | Warning | Instance.QTS should not be coded 4 where EntryProfile.QUALENT3 is coded M71 or H71. | 6 |
Instance | RCSTDNT | Error | Instance.RCSTDNT must exist where Course.COURSEAIM begins D, E, L or M (excluding M22, M26) and Instance.REDUCEDI = 00 or 04. | 1 |
Instance | RCSTDNT | Error | Instance.RCSTDNT must not be coded 09. | 2 |
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 = 2, 4, 8, 9 or A. | 7 |
Instance | REDUCEDI | Error | Instance.REDUCEDI code 04 must have Instance.MODE = 63 or 64. | 8 |
Instance | REDUCEDI | Error | Instance.REDUCEDI must be coded 00, 04 or 07 where Course.TTCID = F | 10 |
Instance | REDUCEDI | Error | Instance.REDUCEDI must be not be coded 07 at institutions in Northern Ireland, Scotland or Wales. | 11 |
Instance | RSNEND | Error | Instance.RSNEND must exist where Instance.ENDDATE is not null and Instance.REDUCEDI = 00, 01, 02, 04 or 07. | 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 | SKEITT | Error | Instance.SKEITT must exist for institutions in England where (Course.REDUCEDC=07 or Course.TTCID = F) and Course.CTITLE does not begin SKEPLUS | 1 |
Instance | SKEITT | Error | Instance.SKEITT must not exist for institutions in Northern Ireland, Scotland or Wales. | 2 |
Instance | SKEITT | Error | Instance.SKEITT must not exist for institutions in England where Course.TTCID not equal to F. | 4 |
Instance | SKEITT | Error | Instance.SKEITT must not be coded 99999999 | 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, D01 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 | SPECFEE | Error | For institutions in England, Instance.SPECFEE must be coded 6 or 9 where Instance.MODE = 31 and Course.TTCID = 1 or 8. | 12 |
Instance | SPECFEE | Error | For institutions in England, Instance.SPECFEE cannot be coded 6 when Instance.COMDATE > 2010-08-31. | 13 |
Instance | SPECFEE | Warning | Instance.SPECFEE should be coded 9 when Instance.FUNDLEV = 30 or 31. | 14 |
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 not equal to 63 or 64 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 | For institutions in Scotland, Instance.STULOAD must not be 0 where Instance.MODE = 01, 02, 23, 24, 25, 31, 52 or 53 and Instance.TYPEYR = 1 , unless Instance.LOCSDY = S. | 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 Instance.REDUCEDI = 00 or 01 and Instance.MODE not equal to 63 or 64, Instance.STULOAD +100.0 is less than sum of Module.FTE for the student instance where StudentOnModule.MODSTAT not equal to 4: check modules linked to this instance. | 5 |
Instance | STULOAD | Error | Where Instance.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 | STULOAD | Error | For institutions in England, Northern Ireland and Wales, Instance.STULOAD must not be 0 where Instance.MODE = 01, 02, 23, 24, 25, 31, 43, 44, 52, 53, 73 or 74, unless Instance.LOCSDY = S or Instance.EXCHANGE is coded 2, 4, 8, 9 or A. | 7 |
Instance | STULOAD | Error | For institutions in England, Instance.STULOAD must not be greater than 10.0 where Course.COURSEAIM begins D, E, L or M (excluding M22, M26) and Instance.MODE = 43 or 44 and ( Instance.MCDATE is null or is equal to Y1-08-01) | 8 |
Instance | STULOAD | Error | For institutions in Scotland, Instance.STULOAD must not be 0 where Instance.FTEMETHOD = 1 and Instance.MODE not equal to 51, 63, 64 and Instance.EXCHANGE not equal to 2, 4, 8, 9, A and Instance.LOCSDY not equal to S | 9 |
Instance | STULOAD | Error | For institutions in Scotland, Instance.STULOAD must not be 0 where Instance.FTEMETHOD = 2 and Instance.COMDATE > Y1-07-31 and Instance.MODE not equal to 51, 63, 64 and Instance.EXCHANGE not equal to 2, 4, 8, 9, A and Instance.LOCSDY not equal to S | 10 |
Instance | STULOAD | Error | For institutions in England and Northern Ireland Instance.STULOAD must equal the sum of Instance.LOADYRA + Instance.LOADYRB | 11 |
Instance | STULOAD | Warning | For institutions in England, Northern Ireland and Wales, Instance.STULOAD should be less than 100 where Instance.TYPEYR is not equal to 1 and Instance.COMDATE > Y1-07-31 | 12 |
Instance | STULOAD | Warning | For institutions in England, Northern Ireland and Wales, Instance.STULOAD should be less than 100 where Instance.TYPEYR is not equal to 1 and Instance.ENDDATE > Y1-07-31 | 13 |
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 unless the student is on a sandwich placement spanning a reporting year, but the normal programme of study is a standard year. | 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 and Instance.RSNEND = 01 or 98. | 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 normally 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 < 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 value cannot be greater than the difference in years between 31 July of the reporting period and the 01 August before Instance.COMDATE. | 2 |
Instance | YEARSTU | Error | Instance.YEARSTU must not equal 1 where Instance.TYPEYR = 1 and Instance.COMDATE < Y1-08-01 and Instance.MODE is not equal to 63 or 64 | 3 |
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 | 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 2 for institutions in England, Wales or Northern Ireland. | 2 |
Module | FTE | Warning | Module.FTE should contain a value greater than 0. | 1 |
Module | LEVLPTS | Error | Module.LEVLPTS must exist where Module.CRDTPTS does not = 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 any StudentOnModule.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 |
Module | TINST | Error | Module.TINST must not equal Institution.UKPRN | 6 |
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, M26, 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 = 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 | CLASS | Error | QualificationsAwarded.CLASS must be coded 01 - 14 where QualificationsAwarded.QUAL = M22 or M26. | 7 |
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, M26 or M86 where the first two characters of CourseSubject.SBJCA = D1 or D2 and Institution.UKPRN does not equal 10007154, 10007786, 10007788, 10006842, 10007779, 10007790 or 10007794. | 2 |
QualificationsAwarded | QUAL | Error | QualificationsAwarded.QUAL cannot be coded H16, I16, M16, M26 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, 10007798, 10007141 or 10007161 | 3 |
QualificationsAwarded | QUAL | Error | QualificationsAwarded.QUAL cannot be coded X00 where Scottish institution. | 5 |
QualificationsAwarded | QUAL | Error | QualificationsAwarded.QUAL must be coded M22, M26, 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, M26) 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 | QUAL | Error | QualificationsAwarded.QUAL must be coded H90 where Course.TTCID = F | 10 |
QualificationsAwarded | QUAL | Error | QualificationsAwarded.QUAL must not be coded H71 or M71 where Course.TTCID = 0. | 11 |
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 | 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 | QUALSBJ | Error | QualificationsOnEntry.QUALSBJ must be coded 'T33' where QualificationsOnEntry.QUALTYPE = IE | 8 |
QualificationsOnEntry | QUALSBJ | Error | QualificationsOnEntry.QUALSBJ must be coded 'B29' where QualificationsOnEntry.QUALTYPE = ID | 9 |
QualificationsOnEntry | QUALTYPE | Error | QualificationsOnEntry.QUALTYPE = IE must only occur once. | 1 |
QualificationsOnEntry | QUALTYPE | Error | QualificationsOnEntry.QUALTYPE = WB must only occur once. | 2 |
QualificationsOnEntry | QUALTYPE | Error | There must be at least one occurrence of QualificationsOnEntry.QUALTYPE = LD where Instance.INITIATIVES = B. | 3 |
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 2001or 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 and QualificationsOnEntry.QUALTYPE not coded M6, M7, M8, 6M, 7M or 8M, QualificationsOnEntry.QUALYEAR should be greater than (Student.BIRTHDTE + 13) years. | 27 |
QualificationsOnEntry | QUALYEAR | Warning | For institutions in England, Northern Ireland and Wales, where Student.BIRTHDTE is not null and QualificationsOnEntry.QUALTYPE is not coded M6, M7, M8, 6M, 7M, 8M or 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 (Y1-99)-08-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 | BIRTHDTE | Error | Where exists Student.BIRTHDTE must be < Y1-08-01 | 10 |
Student | DISABLE | Error | Student.DISABLE must exist where any Instance.REDUCEDI = 00, 01 or 07. | 1 |
Student | DISABLE | Warning | Student.DISABLE should be coded 02-96 where Instance.DISALL exists. | 2 |
Student | DISABLE | Error | Student.DISABLE must not be coded 02, 03, 04, 05, 06, 07, 10, 11, 97, 98 or 99 where any Instance.COMDATE > 2010-07-31 | 3 |
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 or IM) and Instance.REDUCEDI = 00, 01 or 07. | 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 | NATIOND | Error | Where there are two occurrences of Student.NATIOND they must not be identical. | 3 |
Student | NATIOND | Error | Where Student.NATIOND is coded R or U there must be only one occurrence of Student.NATIOND | 4 |
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 a student has at least one instance where Instance.MODE = 01, 02, 23, 24 or 25 and Instance.REDUCEDI = 00 and Instance.LOCSDY not equal to S. | 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, F or S and the corresponding Instance.REDUCEDI = 00 or 07 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 and Course.COURSEAIM begins with H, I, J, C, P, Q, R, S or X or is M22 or M26. | 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 | ULN | Warning | Student.ULN should not be the same as Student.UCASPERID | 2 |
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 | LANGPCNT | Error | StudentOnModule.LANGPCNT must exist for institutions in Scotland, Wales or Northern Ireland. | 1 |
StudentOnModule | LANGPCNT | Error | StudentOnModule.LANGPCNT must not exist for institutions in England. | 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 | No more than 2 occurrences of identical StudentOnModule.MODID must exist for a single instance. | 2 |
StudentOnModule | MODID | Warning | There are 2 occurrences of identical StudentOnModule.MODID for a single instance. An instance should not be linked to the same module more than once in cases where a student is simply re-sitting examinations or assessment. | 3 |
StudentOnModule | MODOUT | Error | Institution 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 | Institution not in Wales cannot use StudentOnModule.MODOUT code 3. | 3 |
StudentOnModule | MODOUT | Error | Institutions in Scotland or Wales cannot use StudentOnModule.MODOUT code C. | 4 |
StudentOnModule | MODOUT | Error | Where StudentOnModule.MODOUT = 3 and Course.COURSEAIM begins D, L, M, H, I, J or C, Instance.MODE must be coded 01, 23, 24, 52 or 53. | 5 |
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.