Student record 2013/14
Summary of business rules
Version 1.4 Produced 2014-08-28
The business rules below have been updated for 2013/14. Individual changes are listed in the Revision history against the field or entity upon which they appear.
Entity | Field or Entity Name | Status | Rule | Number |
---|---|---|---|---|
Course | CourseSubject | Error | CourseSubject entity must exist for all courses at institutions in Scotland or Northern Ireland. | 1 |
Course | CourseSubject | Error | CourseSubject entity must exist for all courses at institutions in England or Wales where (any Instance.FESTUMK = 2 or 3) or (any Instance.REDUCEDI = 08) or Course.FEQAIMC = '66666666' or Course.TTCID = F or Course.REDUCEDC = 09. | 2 |
Course | AWARDBOD | Error | Course.AWARDBOD must exist where (Course.COURSEAIM begins D, E, L, M, H, I, J or C and does not end with 99) and Course.REDUCEDC = 00, 01, 03 or 04. | 1 |
Course | AWARDBOD | Error | Where there is more than one occurrence of Course.AWARDBOD each value must be unique. | 2 |
Course | AWARDBOD | Error | Where Course.AWARDBOD = 1, Course.COURSEAIM must be coded J30 or C30. | 3 |
Course | AWARDBOD | Error | Where Course.AWARDBOD = 2, Course.COURSEAIM must be coded J30 or C30. | 4 |
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, H62, 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, H62, 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, 10007768, 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, G, H, L, M, N or P. | 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, M44, 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 | 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 = 06. | 5 |
Course | FEQAIMC | Error | Course.FEQAIMC must not be coded '66666666' for institutions in England. | 6 |
Course | MSFUND | Error | For institutions in Northern Ireland, Scotland and Wales, Course.MSFUND must exist where Course.REDUCEDC = 00, 01 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 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, 07, 12, 14, 37 or 38. | 11 |
Course | MSFUND | Error | For institutions in England Course.MSFUND must not be coded 02, 03, 04, 06, 13, 14 or 31. | 12 |
Course | MSFUND | Error | For institutions in Northern Ireland Course.MSFUND must not be coded 01, 02, 03, 06, 07, 11, 12, 13, 14, 37 or 38. | 13 |
Course | MSFUND | Error | For institutions in Scotland Course.MSFUND must not be coded 01, 02, 04, 06, 07, 11, 12, 13, 37 or 38. | 14 |
Course | MSFUND | Warning | For institutions in Wales Course.MSFUND should not be coded 06 where Course.COURSEAIM begins with D, E, L, M, H, I or J. | 16 |
Course | MSFUND | Error | For institutions in England, Course.MSFUND must exist where Course.REDUCEDC = 00, 01 or 04 and any linked instance has Instance.FESTUMK = 2. | 17 |
Course | MSFUND | Error | For institutions in England, Course.MSFUND must be coded 07, 81 or 91 where Course.TTCID = G, H, L, M, N or P. | 18 |
Course | REDUCEDC | Error | If Course.REDUCEDC = 01, the institution must be in England, Scotland or Northern Ireland. | 4 |
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 | REDUCEDC | Error | Where Course.REDUCEDC = 09, Institution.UKPRN must be 10000163, 10003331, 10005415, 10005470, 10007937, 10008289, 10020416, 10023454, 10031982, 10035638 or 10039956. | 11 |
Course | REGBODY | Error | Course.REGBODY must exist where Course.COURSEAIM = M16, M26, M76, M86, H16, H62, H76, I16, I76, J26 or J76 and Course.REDUCEDC = 00 or 01. | 1 |
Course | REGBODY | Error | Course.REGBODY must not be coded 30-35 or 40-55 where the institution is in Northern Ireland, Scotland or Wales. | 4 |
Course | REGBODY | Error | Course.REGBODY must not be coded 02 or 07 where the institution is in England. | 5 |
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, 07 or 09 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, F, G, H, L, M, N and P 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, 8, G, H, L, M, N or P, Institution.UKPRN must be 10000291, 10000571, 10000712, 10000886, 10000961, 10001143, 10001282, 10002718, 10003614, 10003645, 10003678, 10003861, 10003863, 10003956, 10003957, 10004048, 10004078, 10004113, 10004180, 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, 10007851 or 10037449. | 4 |
Course | TTCID | Error | Course.TTCID must not be coded 1, 8, G, H, L, M, N or P 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, 8, G, H, L, M, N or P 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 and Course.CTITLE does not begin SKEPLUS, Institution.UKPRN must be 10000571, 10000886, 10001143, 10003645, 10003956, 10004113, 10004180, 10006299, 10006840, 10007137, 10007139, 10007140, 10007143, 10007149, 10007154, 10007155, 10007159, 10007164, 10007166, 10007167, 10007766, 10007773, 10007774, 10007776, 10007786, 10007788, 10007789, 10007792, 10007798, 10007823, 10007843 or 10007850. | 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, 10001143, 10002718, 10003956, 10003957, 10004180, 10004797, 10005790, 10007144, 10007146, 10007147, 10007149, 10007158, 10007166, 10007766, 10007773, 10007796, 10007801, 10007802, 10007806, 10007811, 10007823 or 10007848. | 18 |
Course | TTCID | Error | Course.TTCID must be coded 0 where Institution.UKPRN = 10000163, 10003331, 10005415, 10005470, 10007937, 10008289, 10020416, 10023454, 10031982, 10035638 or 10039956. | 20 |
CourseSubject | ITTSUBJECT | Error | At least one CourseSubject.ITTSUBJECT must exist where institution is in England and Course.TTCID = 1, 8, G, H, L, M, N or P 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 - 08. | 1 |
CourseSubject | SBJCA | Error | CourseSubject.SBJCA must be coded C100, C600, F100, F300, G100, I200, L230, L390, L700, P390, Q300, Q560, R100, R200, R300, R400, R500, V100, V600, W200, W300, W400, W500, W900, X900, X120 or X121 where Course.TTCID = 1, 8, G, H, L, M, N or P and Instance.ITTPHSC = 51 - 53, 61 - 65 or 71 - 77. | 2 |
CourseSubject | SBJCA | Error | CourseSubject.SBJCA must be coded C100, C110, C600, C800, C900, D600, F100, F110, F300, F310, F390, F900, G100, H700, H900, I100, I200, I900, 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, 8, G, H, L, M, N or P and Instance.ITTPHSC = 54 - 57, or 78 - 81. | 4 |
CourseSubject | SBJCA | Error | For institutions in England, one, and only one, CourseSubject.SBJCA must be coded F900 where any CourseSubject.SBJCA = C900 and Course.TTCID = 1, 8, G, H, L, M, N or P and Instance.ITTPHSC = 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, H62, 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, H62, I16, M16, M26 or M86 and Course.REGBODY = 02 or 30-35. | 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 C900 where any CourseSubject.SBJCA = F900 and Course.TTCID = 1, 8, G, H, L, M, N or P and Instance.ITTPHSC = 54 - 57, or 78 - 81. | 14 |
CourseSubject | SBJCA | Error | For institutions in England where Course.TTCID = 1, 8, G, H, L, M, N or P and Instance.ITTPHSC = 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, 8, G, H, L, M, N or P and Instance.ITTPHSC = 51 - 53 or 71 -77) or Course.TTCID = 0 | 16 |
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 F100, F300, G100, I100, R900 or W200 where Course.TTCID = F. | 24 |
CourseSubject | SBJCA | Error | CourseSubject.SBJCA must be coded F100, F300, G100, I100, R900 or W200 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 | For institutions in England, all CourseSubject.SBJPCNT must be coded '50' where CourseSubject.SBJCA = F900 or C900 and Course.TTCID = 1, 8, G, H, L, M, N or P and any Instance.ITTPHSC = 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 | QualificationsOnEntry | 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, M28, H00, H11,H16, H18, H22, H23, 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 | CARELEAVER | Error | Where the institution is in England, EntryProfile.CARELEAVER must exist where ((Instance.REDUCEDI = 00 or 01) and (Instance.FUNDCODE = 1 or 7)) and Course.COURSEAIM begins with H, I, J, C (excluding H50, H60, H61, H62, H78, H81, I60, I61 or I81) and Instance.COMDATE > 2013-07-31 and (Instance.EXCHANGE = N, Y or Instance.EXCHANGE does not exist) and Course.TTCID is not equal to F. | 1 |
EntryProfile | CARELEAVER | Error | Where the institution is in England, EntryProfile.CARELEAVER must exist where Instance.REDUCEDI = 08 and Course.COURSEAIM begins with H, I, J, C or is M22, M26, M28, M71 or M88 (excluding H50, H60, H61, H62, H78, H81, I60, I61 or I81) and Course.MSFUND is not equal to 37. | 2 |
EntryProfile | CARELEAVER | Error | Where the institution is in England, EntryProfile.CARELEAVER must not exist where Instance.REDUCEDI = 09 or ((Course.COURSEAIM begins with D, E, L, M, P, Q, R or X or is equal to H50, H60, H61, H62, H78, H81, I60, I61 or I81) and Course.COURSEAIM does not equal M22, M26, M28, M71 or M88) or (Instance.FUNDCODE = 2, 3 or 5) or Instance.COMDATE < 2013-08-01. | 3 |
EntryProfile | CARELEAVER | Error | Where the institution is in Scotland, EntryProfile.CARELEAVER must exist where (Instance.REDUCEDI = 00, 01 or 04) and (EntryProfile.DOMICILE = XF, XG, XH, XI, XK) and (Course.COURSEAIM begins with H, I, J or C or is M22, M26, M28 or M88) and Instance.COMDATE > 2013-07-31. | 4 |
EntryProfile | CARELEAVER | Error | Where the institution is in Scotland, EntryProfile.CARELEAVER must not exist where (EntryProfile.DOMICILE not equal to XF, XG, XH, XI, XK) or (Course.COURSEAIM begins with D, E, L, M, P, Q, R or X (excluding M22, M26, M28 and M88)) or Instance.COMDATE < 2013-08-01). | 5 |
EntryProfile | CARELEAVER | Error | Where the institution is in Wales, EntryProfile.CARELEAVER must exist where (Instance.REDUCEDI = 00, 04) and EntryProfile.UCASAPPID exists and (Course.COURSEAIM begins with H, I, J or C or is M22, M26, M28, M71 or M88) and Instance.COMDATE > 2013-07-31. | 6 |
EntryProfile | CARELEAVER | Error | Where the institution is in Northern Ireland, EntryProfile.CARELEAVER must exist where (Instance.REDUCEDI = 00, 01 or 04) and EntryProfile.UCASAPPID exists and (Course.COURSEAIM begins with H, I, J, C or is M22, M26, M28, M71 or M88) and Instance.COMDATE > 2013-07-31. | 7 |
EntryProfile | CARELEAVER | Error | Where EntryProfile.CARELEAVER = 01 the institution must be in England. | 8 |
EntryProfile | CARELEAVER | Error | Where EntryProfile.CARELEAVER = 02 or 03 the institution must be in Scotland. | 9 |
EntryProfile | CARELEAVER | Error | Where EntryProfile.CARELEAVER = 98 the institution must be in England or Scotland. | 10 |
EntryProfile | CARELEAVER | Error | Where the institution is in England, EntryProfile.CARELEAVER must exist where ((Instance.REDUCEDI = 00 or 01) and (Instance.FUNDCODE = 1 or 7)) and Course.COURSEAIM = M22, M26, M28, M71 or M88 and Instance.COMDATE > 2013-07-31 and (Instance.EXCHANGE = N, Y or Instance.EXCHANGE does not exist). | 11 |
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 or Instance.REDUCEDI = 08. | 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 | 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, M28, 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, M28, 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, 07 or 08. | 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, M28, 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, 04 or 09 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 | QUALENT3 | Error | EntryProfile.QUALENT3 must not be coded P91 where Instance.COMDATE > 2012-07-31. | 6 |
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 or M28 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, M26 or M28 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: https://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 |
FinancialSupport | FINTYPE | Warning | FinancialSupport.FINTYPE should not be coded 03 where Student.TTACCOM = 2, 4, 5, 6 or 7. Please check it is correct that this student is in receipt of accommodation discounts when they are not living in University Halls or Residences | 1 |
Instance | EntryProfile | Error | EntryProfile entity must exist where corresponding Instance.COMDATE is in the current reporting year. | 1 |
Instance | QualificationsAwarded | 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 | QualificationsAwarded | Error | QualificationsAwarded entity must only occur once where Instance.FESTUMK is coded 1 or 4. | 3 |
Instance | QualificationsAwarded | Error | QualificationsAwarded entity must not exist where Instance.REDUCEDI = 08. | 4 |
Instance | StudentOnModule | Error | StudentOnModule entity must exist where Instance.STULOAD is greater than 0 and Instance.REDUCEDI = 00 or 01. | 1 |
Instance | StudentOnModule | 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 | REFData | Error | Instance.REFData must exist where Course.COURSEAIM = L00, L80, L90 or L99 or begins with D and the corresponding Instance.REDUCEDI = 00, 01 or 04. | 1 |
Instance | REFData | Error | Instance.REFData must not exist where Course.COURSEAIM = L91 or begins with E, M, H, I, J, C, P, Q, R, S or X. | 2 |
Instance | REFData | Warning | Where the Instance.REFData entity occurs more than once, there are multiple occurrences of the same Unit of Assessment (UOA) code in REFData.UOA2014 when just comparing the first two characters. Please check this is correct and that REF data has not been duplicated. | 3 |
Instance | REFData | Error | Where Instance.REFData exists, the sum of all occurrences of REFData.UOAPCNT must equal 100. | 4 |
Instance | LearnerEmploymentStatus | Error | For institutions in England LearnerEmploymentStatus entity must exist where Instance.REDUCEDI = 00 or 01 and ((Instance.FUNDMODEL = 35, 81 or 99 excluding where (LearningDeliveryFAM.LEARNDELFAMTYPE = SOF and LearningDeliveryFAM.LEARNDELFAMCODE = 108)) or (Instance.PROGTYPE = 02, 03, 10, 20, 21, 22 or 23) or ((Instance.FUNDMODEL = 25 or 82) and Instance.PLANLEARNHOURS + Instance.PLANEEPHOURS < 540)) | 1 |
Instance | LearnerEmploymentStatus | Error | LearnerEmploymentStatus entity must not exist for institutions in Northern Ireland, Scotland and Wales. | 2 |
Instance | LearnerEmploymentStatus | Error | LearnerEmploymentStatus entity must not exist for institutions in England where Instance.FESTUMK = 2 or Instance.FESTUMK does not exist. | 3 |
Instance | LearningDeliveryFAM | Error | LearningDeliveryFAM entity must exist where Instance.FUNDMODEL exists and is not equal to 99 and Instance.REDUCEDI = 00 or 01. | 1 |
Instance | LearningDeliveryFAM | Error | LearningDeliveryFAM entity must not exist for institutions in Northern Ireland, Scotland and Wales. | 2 |
Instance | LearningDeliveryFAM | Error | LearningDeliveryFAM entity must not exist for institutions in England where Instance.FESTUMK = 2 or Instance.FESTUMK does not exist. | 3 |
Instance | LearnerFAM | Error | LearnerFAM entity must not exist for institutions in Northern Ireland, Scotland and Wales. | 1 |
Instance | LearnerFAM | Error | LearnerFAM entity must not exist for institutions in England where Instance.FESTUMK = 2 or Instance.FESTUMK does not exist. | 2 |
Instance | FinancialSupport | Error | Instance.FinancialSupport must not exist where the institution is in Northern Ireland, Scotland or Wales | 1 |
Instance | FinancialSupport | Error | Instance.FinancialSupport must not exist where Instance.MODE = 63 or 64 | 2 |
Instance | FinancialSupport | Warning | For one instance where Course.TTCID = 0, 2, 5, 9, D or F, the sum of FinancialSupport.FINAMOUNT for all associated Instance.FinancialSupport entities is greater than 10,000. As this is a high total please check that the values for FinancialSupport.FINAMOUNT are correct. | 3 |
Instance | FinancialSupport | Error | For one instance where Course.TTCID = 0, 2, 5, 9, D or F, the sum of FinancialSupport.FINAMOUNT for all associated Instance.FinancialSupport entities is greater than 25,000. | 4 |
Instance | FinancialSupport | Error | Where the Instance.FinancialSupport entity occurs more than once for an instance each FinancialSupport.FINTYPE must be unique. | 5 |
Instance | FinancialSupport | Warning | Where the institution is in England, Instance.FinancialSupport exists where Instance.DISALL = 4. Please check that the Disabled Students Allowance has not been returned as Financial Support in error. | 6 |
Instance | FinancialSupport | Warning | For one instance where Course.TTCID = 1, 8, G, H, L, M, N or P, the sum of FinancialSupport.FINAMOUNT for all associated Instance.FinancialSupport entities is greater than 30,000. As this is a high total please check that the values for FinancialSupport.FINAMOUNT are correct. | 7 |
Instance | FinancialSupport | Error | For one instance where Course.TTCID = 1, 8, G, H, L, M, N or P, the sum of FinancialSupport.FINAMOUNT for all associated Instance.FinancialSupport entities is greater than 40,000. | 8 |
Instance | Mobility | Error | Instance.Mobility must exist where Instance.LOCSDY = T or U and Instance.MODE is not coded 43, 44, 63 or 64 and Instance.REDUCEDI = 00 or 01. | 1 |
Instance | Mobility | Error | Instance.Mobility must not exist where Instance.LOCSDY = 6, 9, C, D, E, H, J, K, S or Z or Instance.LOCSDY does not exist. | 2 |
Instance | Mobility | Error | Where Instance.MODE = 23 and Instance.TYPEYR = 1 and any associated Mobility.MOBSCHEME = 02 then all associated Mobility.MOBSCHEME must = 02. | 3 |
Instance | Mobility | Error | Where Instance.SPECFEE = 3 and Instance.MODE not equal to 63 or 64 there must be at least one associated Mobility entity with Mobility.MOBSCHEME = 03. | 4 |
Instance | ADDSUPCT | Warning | Instance.ADDSUPCT should exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 or 01. | 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 | AIMTYPE | Error | Instance.AIMTYPE must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 or 01. | 1 |
Instance | AIMTYPE | Error | Instance.AIMTYPE must not exist for institutions in Northern Ireland, Scotland and Wales. | 2 |
Instance | AIMTYPE | Error | Instance.AIMTYPE must not exist for institutions in England where Instance.FESTUMK = 2 or Instance.FESTUMK does not exist. | 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, 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 | COMDATE | Error | Instance.COMDATE must be later than Y1-07-31 where Instance.REDUCEDI = 08. | 5 |
Instance | COMDATE | Error | Instance.COMDATE must be later than 2013-07-31 where Course.TTCID = L, M, N or P. | 6 |
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 or 01. | 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 | CSTAT | Error | For institutions in England Instance.CSTAT must not be coded 4. | 6 |
Instance | CSTAT | Error | For institutions in Wales Instance.CSTAT must not be coded 6. | 7 |
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 | DHFUND | Error | Instance.DHFUND must exist for institutions in England where Course.MSFUND = 37 or 38 and Instance.REDUCEDI = 00 or 01. | 1 |
Instance | DHFUND | Warning | Instance.DHFUND should be coded 998 for institutions in England where any CourseSubject.SBJCA = A300 or A400 and Course.MSFUND = 37 or 38 and Course.COURSEAIM = H16 or I16. | 3 |
Instance | DHFUND | Warning | Instance.DHFUND should not be coded 998 for institutions in England where Course.MSFUND = 37 or 38 unless any CourseSubject.SBJCA begins 'L5' or (any CourseSubject.SBJCA = A300 or A400 and Course.COURSEAIM = H16 or I16). | 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 = 01 - 35 or 41 - 91 | 9 |
Instance | DHREGREF | Error | Instance.DHREGREF must exist where Course.COURSEAIM = M16, M26, M76, M86, H16, H62, H76, I16, I76, J26 or J76 and Course.REGBODY = 06, 07, 40 - 53 or 55 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 | ELQ | Error | Instance.ELQ must exist for institutions in England where Course.COURSEAIM begins E, M, H, I, J or C and Instance.FEEELIG = 1 and Instance.REDUCEDI = 00 or 01. | 1 |
Instance | ELQ | Error | Instance.ELQ must not exist for institutions in England where Course.COURSEAIM begins D, L, P, Q, R, S, or X or Instance.FEEELIG = 2 or 3. | 2 |
Instance | ELQ | Error | Instance.ELQ must not exist for institutions in Northern Ireland, Scotland or Wales. | 3 |
Instance | ELQ | Error | Instance.ELQ must not be coded 01 where Instance.DISALL = 4. | 4 |
Instance | ELQ | Error | Instance.ELQ must not be coded 01 where Course.REGBODY = 01, 06, 09, 10, 11, 14, 30, 42, 44, 46, 48, 49, 50, 52, 53, 54 or 55 and Course.COURSEAIM not equal to H76, I76, J76 or M76. | 5 |
Instance | ELQ | Error | Instance.ELQ must not be coded 01 where Course.COURSEAIM = H18, H78, H88, M28, M78 or M88 and Instance.MODE = 01 or 02. | 6 |
Instance | ELQ | Error | Instance.ELQ must not be coded 01 where Course.COURSEAIM = J10 or J16. | 7 |
Instance | ELQ | Error | Instance.ELQ must not be coded 01 where Course.TTCID = 5. | 8 |
Instance | EMPROLE | Error | Instance.EMPROLE must not exist for institutions in England, Northern Ireland or Scotland. | 4 |
Instance | EMPROLE | Error | Instance.EMPROLE must not exist for institutions in Wales where Instance.FESTUMK = 2 or where Instance.FESTUMK does not exist. | 5 |
Instance | ENDDATE | Error | Instance.ENDDATE must not be null where Instance.RSNEND exists or Instance.REDUCEDI = 08. | 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 | Where it is not null Instance.ENDDATE must be greater than or equal to Instance.COMDATE | 7 |
Instance | ENDDATE | Error | Instance.ENDDATE must be null with ReasonForNull=9 where Instance.RSNEND does not exist and Instance.REDUCEDI = 00, 01, 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, 03 or 09 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X. | 1 |
Instance | EXCHANGE | Error | Instance.EXCHANGE must not be coded N or Y where Course.COURSEAIM code ends with 91. | 5 |
Instance | EXCHANGE | Error | Instance.EXCHANGE must be coded N or Z where Instance.LOCSDY = S | 6 |
Instance | FEEELIG | Error | Instance.FEEELIG must exist where Instance.REDUCEDI = 00, 01 or 09 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. | 3 |
Instance | FEEELIG | Error | Instance.FEEELIG must not be coded 3 where Instance.FUNDCODE is coded 1 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 | FEEREGIME | Error | For institutions in England, Instance.FEEREGIME must exist where (Course.COURSEAIM begins with H, I, J or C or is M22, M26 or M28) and (Course.TTCID not equal to F) and (Instance.FEEELIG = 1 or 3) and (Instance.EXCHANGE = N, Y, Z or Instance.EXCHANGE does not exist) and (Instance.MODE = 01, 02, 23, 24, 25, 31, 43 or 44) and (Instance.REDUCEDI = 00 or 01). | 1 |
Instance | FEEREGIME | Error | For institutions in England, Instance.FEEREGIME must exist where (Course.COURSEAIM begins with E or M (excluding M22, M26, M28)) and (Instance.FEEELIG = 1 or 3) and (Instance.EXCHANGE = N, Y, Z or Instance.EXCHANGE does not exist) and (Instance.MODE = 01, 02, 23, 24, 25, 31, 73 or 74) and (Instance.REDUCEDI = 00 or 01). | 2 |
Instance | FEEREGIME | Error | For institutions in England, Instance.FEEREGIME must exist where (Course.COURSEAIM begins with E or M (excluding M22, M26, M28)) and (Instance.FEEELIG = 1 or 3) and (Instance.EXCHANGE = N, Y, Z or Instance.EXCHANGE does not exist) and (Instance.MODE = 43 or 44) and Instance.MCDATE is not null and (Instance.REDUCEDI = 00 or 01). | 3 |
Instance | FEEREGIME | Error | For institutions in England, Instance.FEEREGIME must not exist where (Course.COURSEAIM begins with D, L, P, Q, R, S or X) or (Course.TTCID = F) or (Instance.FEEELIG = 2) or (Instance.EXCHANGE = 4 or G) or (Instance.MODE = 51). | 4 |
Instance | FEEREGIME | Error | For institutions in Northern Ireland, Instance.FEEREGIME must exist where (Course.COURSEAIM begins with H, I, J or C or is M22, M26 or M28) and (Instance.FEEELIG = 1 or 3) and (Instance.EXCHANGE = N, Y, Z or Instance.EXCHANGE does not exist) and (Instance.MODE = 01, 02, 23, 24, 25 or 43) and (Instance.REDUCEDI = 00 or 01) and Instance.SSN does not exist. | 5 |
Instance | FEEREGIME | Error | For institutions in Northern Ireland, Instance.FEEREGIME must exist where (Course.COURSEAIM = M71 or M88) and (Instance.FEEELIG = 1 or 3) and (Instance.EXCHANGE = N, Y, Z or Instance.EXCHANGE does not exist) and (Instance.MODE = 01, 02, 23, 24, 25) and (Instance.REDUCEDI = 00 or 01) and Instance.SSN does not exist. | 6 |
Instance | FEEREGIME | Error | For institutions in Northern Ireland, Instance.FEEREGIME must exist where (Course.COURSEAIM = M71 or M88) and (Instance.FEEELIG = 1 or 3) and (Instance.EXCHANGE = N, Y, Z or Instance.EXCHANGE does not exist) and Instance.MODE = 43) and (Instance.REDUCEDI = 00 or 01) and Instance.MCDATE is not null and Instance.SSN does not exist. | 7 |
Instance | FEEREGIME | Error | For institutions in Northern Ireland, Instance.FEEREGIME must not exist where (Course.COURSEAIM begins with D, L, E, M, P, Q, R, S or X (excluding M22, M26, M28, M71, M88)) or (Instance.FEEELIG = 2) or (Instance.EXCHANGE = 4 or G) or (Instance.MODE = 31, 44, 51 or 64). | 8 |
Instance | FEEREGIME | Error | For institutions in Scotland, Instance.FEEREGIME must exist where (Course.COURSEAIM = M71, M88, M22, M26, M28, H00, H11, H16, H18, H22, H23, H50, I00, I11, I16, J20, J26, J30, C20 or C30) and (Instance.FEEELIG = 1 or 3) and (Instance.EXCHANGE = N or Instance.EXCHANGE does not exist) and (Instance.MODE = 01, 02, 23, 24, 25) and (Instance.REDUCEDI = 00 or 01) and Instance.SSN does not exist. | 9 |
Instance | FEEREGIME | Error | For institutions in Scotland, Instance.FEEREGIME must not exist where (Course.COURSEAIM begins with D, L, E, P, Q, R, S or X) or (Instance.FEEELIG = 2) or (Instance.EXCHANGE = 4, G, Y or Z) or (Instance.MODE = 38, 39, 43, 44, 51 or 64). | 10 |
Instance | FEEREGIME | Error | For institutions in Scotland, Instance.FEEREGIME must not exist where Course.COURSEAIM begins with M, H, I, J or C (excluding M71, M88, M22, M26, M28, H00, H11, H16, H18, H22, H23, H50, H88, I00, I11, I16, J20, J26, J30, C20, C30). | 11 |
Instance | FEEREGIME | Error | For institutions in Wales, Instance.FEEREGIME must exist where (Course.COURSEAIM = M22, M26, M28, M71, M88 or begins with H, I, J or C) and (Instance.FEEELIG = 1 or 3) and (Instance.EXCHANGE = N, Y, Z or Instance.EXCHANGE does not exist) and (Instance.MODE = 01, 02, 23, 24, 25 or 43) and Instance.REDUCEDI = 00 and Instance.SSN does not exist. | 12 |
Instance | FEEREGIME | Error | For institutions in Wales, Instance.FEEREGIME must not exist where (Course.COURSEAIM begins with D, L, E, M, P, Q, R, S or X (excluding M22, M26, M28, M71, M88) or (Instance.FEEELIG = 2) or (Instance.EXCHANGE = 4 or G) or (Instance.MODE = 31, 44, 51 or 64). | 13 |
Instance | FEEREGIME | Warning | For institutions in England or Wales, Instance.FEEREGIME should not be coded 10 where Instance.COMDATE is later than 2012-08-31. | 14 |
Instance | FEEREGIME | Error | For institutions in Wales, Instance.FEEREGIME must not be coded 20 where Instance.COMDATE is earlier than 2012-09-01. | 15 |
Instance | FEEREGIME | Warning | For institutions in England and Northern Ireland, Instance.FEEREGIME should not be coded 20 where Instance.COMDATE is earlier than 2012-09-01. | 16 |
Instance | FEEREGIME | Error | Where Instance.FEEREGIME = 30, Institution.UKPRN must be 10007787. | 17 |
Instance | FEOUTCOME | Error | For institutions in England, Instance.FEOUTCOME must not exist where Instance.CSTAT = 1. | 1 |
Instance | FEOUTCOME | Error | Instance.FEOUTCOME must not exist for institutions in Northern Ireland, Scotland and Wales. | 2 |
Instance | FEOUTCOME | Error | Instance.FEOUTCOME must not exist for institutions in England where Instance.FESTUMK = 2 or Instance.FESTUMK does not exist. | 3 |
Instance | FEOUTCOME | Error | Where it exists Instance.FEOUTCOME must be coded 1, 2, 6 or 7 for institutions in England where Instance.RSNEND is coded 01 and Instance.REDUCEDI = 00 or 01. | 4 |
Instance | FEOUTCOME | Error | Instance.FEOUTCOME must not be coded 1, 6 or 7 for institutions in England where Instance.CSTAT is coded 3 and Instance.REDUCEDI = 00 or 01. | 5 |
Instance | FESTUMK | Error | Instance.FESTUMK must exist for institutions in England and Wales where Instance.REDUCEDI = 00, 01, 03, 04. | 1 |
Instance | FESTUMK | Error | Instance.FESTUMK code 2 must not have Course.MSFUND = 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 | 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 | FUNDADJOTH | Error | Instance.FUNDADJOTH must not exist for institutions in Northern Ireland, Scotland or Wales. | 1 |
Instance | FUNDADJOTH | Error | For institutions in England Instance.FUNDADJOTH must not exist where Instance.FESTUMK = 2 or where Instance.FESTUMK does not exist. | 2 |
Instance | FUNDADJPRIOR | Error | Instance.FUNDADJPRIOR must not exist for institutions in Northern Ireland, Scotland or Wales. | 1 |
Instance | FUNDADJPRIOR | Error | For institutions in England Instance.FUNDADJPRIOR must not exist where Instance.FESTUMK = 2 or where Instance.FESTUMK does not exist. | 2 |
Instance | FUNDADJPRIOR | Error | Instance.FUNDADJPRIOR must not exist where Instance.FUNDMODEL = 10, 25, 70 or 82. | 3 |
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 | Where the institution is in Northern Ireland, Scotland or Wales, 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, 31, 37 or 38 and (Course.COURSEAIM = H16, I16, M16, M86, H11, I11, H00, I00, H22, M22, M26, H23 or H62 or Instance.INTERCALATE = 01). | 4 |
Instance | FUNDCODE | Error | Instance.FUNDCODE cannot be coded 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, F, G, H, L, M, N or P. | 7 |
Instance | FUNDCODE | Error | Instance.FUNDCODE code 7 must not have Instance.ITTPHSC = 31. | 8 |
Instance | FUNDCODE | Error | For English institutions Instance.FUNDCODE code 1 must not have Course.TTCID = 1, 8, 9, D, F, G, H, L, M, N or P. | 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 code 1 should not have Course.MSFUND = 07, 13, 31, 37 or 38. | 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, HR, 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 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 | Instance.FUNDCODE must be coded 2 or 7 where Course.TTCID = G, H, L, M, N or P | 24 |
Instance | FUNDCODE | Warning | Instance.FUNDCODE should be coded 1 where EntryProfile.ARTICLN = 5. | 25 |
Instance | FUNDCODE | Error | Instance.FUNDCODE must not be coded 1 where Instance.ELQ = 01 or 09. | 26 |
Instance | FUNDCODE | Error | Where the institution is in England, Instance.FUNDCODE must exist where Instance.REDUCEDI = 00 or 01 and (Instance.FESTUMK = 2 or 3 or Instance.FESTUMK does not exist). | 27 |
Instance | FUNDCODE | Error | For institutions in Scotland Instance.FUNDCODE must not be coded 1 where Instance.FEEREGIME = 20. | 28 |
Instance | FUNDCODE | Error | Instance.FUNDCODE must not be coded 5 where Instance.INITIATIVES = A. | 29 |
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 or 25 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 | Error | Instance.FUNDLEV must 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 and M28) or equals H50, H60, H61, H62, 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, M26 or M28. This rule is not applied when the Course.COURSEAIM is one of the following H50, H60, H61, H62, 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, H62, 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, M26 or M28. | 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, E, T or U. | 11 |
Instance | FUNDLEV | Error | For institutions in England or Northern Ireland, Instance.FUNDLEV must be coded 20, 21 or 99 where Course.COURSEAIM = M71 or H71. | 12 |
Instance | FUNDMODEL | Error | Instance.FUNDMODEL must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 or 01. | 1 |
Instance | FUNDMODEL | Error | Instance.FUNDMODEL must not exist for institutions in Northern Ireland, Scotland and Wales. | 2 |
Instance | FUNDMODEL | Error | Instance.FUNDMODEL must not exist for institutions in England where Instance.FESTUMK = 2 or Instance.FESTUMK does not exist. | 3 |
Instance | FUNDMODEL | Error | Instance.FUNDMODEL must be coded 35 or 81 where Instance.FUNDADJOTH exists. | 4 |
Instance | FWORKCODE | Error | For institutions in England, Instance.FWORKCODE must exist where Instance.PROGTYPE exists and Instance.REDUCEDI = 00 or 01. | 1 |
Instance | FWORKCODE | Error | Instance.FWORKCODE must not exist for institutions in Northern Ireland, Scotland and Wales. | 2 |
Instance | FWORKCODE | Error | Instance.FWORKCODE must not exist for institutions in England where Instance.FESTUMK = 2 or Instance.FESTUMK does not exist. | 3 |
Instance | GLHRS | Error | Instance.GLHRS must exist for institutions in Wales where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 or 01. | 1 |
Instance | GLHRS | Error | Instance.GLHRS must not exist for institutions in England, Northern Ireland or Scotland. | 2 |
Instance | GLHRS | Error | Instance.GLHRS must not exist for institutions in Wales where Instance.FESTUMK = 2 or Instance.FESTUMK does not exist. | 3 |
Instance | GLHRS | Error | Where Instance.GLHRS = 0, Course.COURSEAIM must be coded X41 - X46 (Welsh for Adults) | 4 |
Instance | GROSSFEE | Error | Instance.GROSSFEE must exist where (Instance.FEEREGIME = 20 and Instance.SSN does not exist) or Instance.FEEREGIME = 30. | 1 |
Instance | GROSSFEE | Error | Instance.GROSSFEE must not exist where Instance.FEEREGIME = 10 or Instance.FEEREGIME does not exist. | 2 |
Instance | GROSSFEE | Error | Instance.GROSSFEE must be greater than or equal to Instance.NETFEE | 3 |
Instance | GROSSFEE | Error | Instance.GROSSFEE must exist where Instance.NETFEE exists. | 4 |
Instance | GROSSFEE | Error | For institutions in Northern Ireland, Scotland and Wales, Instance.GROSSFEE must be less than or equal to 9000. | 5 |
Instance | GROSSFEE | Error | For institutions in England, Instance.GROSSFEE must be less than or equal to 9000 where Course.COURSEAIM begins H, I, J or C (excluding H50, H60, H61, H62, H78, H81, I60 and I61) or is M22, M26, M28, M71 or M88 and Instance.FUNDCODE = 1 or 7. | 6 |
Instance | GROSSFEE | Error | For institutions in England, Instance.GROSSFEE must be less than or equal to 4500 where Course.COURSEAIM begins H, I, J or C (excluding H50, H60, H61, H62, H78, H81, I60 and I61) or is M22, M26, M28, M71 or M88 and Instance.FUNDCODE = 1 or 7 and Instance.SPECFEE = 1, 2 or 4. | 7 |
Instance | GROSSFEE | Error | For institutions in England, Instance.GROSSFEE must be less than or equal to 40000 where (Course.COURSEAIM begins H, I, J or C or is M22, M26 or M28) and (any associated CourseSubject.SBJCA = A100, A200, A300, A400, D100, D190, D200, D210, D220 or D290) and (Instance.FUNDCODE not equal to 1). | 8 |
Instance | GROSSFEE | Error | For institutions in England, Instance.GROSSFEE must be less than or equal to 30000 where (Course.COURSEAIM begins H (excluding H71 and H88), I, J or C or is M22, M26 or M28) and (no associated CourseSubject.SBJCA = A100, A200, A300, A400, D100, D190, D200, D210, D220 or D290) and (Instance.FUNDCODE not equal to 1 or 7). | 9 |
Instance | GROSSFEE | Error | For institutions in England, Instance.GROSSFEE must be less than or equal to 24000 where Course.COURSEAIM = H71 or M71 and Instance.FUNDCODE is not equal to 1 or 7. | 10 |
Instance | GROSSFEE | Error | For institutions in England, Instance.GROSSFEE must be less than or equal to 34000 where Course.COURSEAIM = H88 or M88 and Instance.FUNDCODE is not equal to 1. | 11 |
Instance | GROSSFEE | Error | For institutions in England, Instance.GROSSFEE must be less than or equal to 50000 where Course.COURSEAIM = M11 and Instance.FUNDCODE = 1. | 12 |
Instance | GROSSFEE | Error | For institutions in England, Instance.GROSSFEE must be less than or equal to 60000 where Course.COURSEAIM = M11 and Instance.FUNDCODE not equal to 1. | 13 |
Instance | GROSSFEE | Error | For institutions in England, Instance.GROSSFEE must be less than or equal to 25000 where (Course.COURSEAIM begins E or M (excluding M11, M22, M26, M28, M71 and M88) or is H50, H60, H61, H62, H78, H81, I60 or I61) and Instance.FUNDCODE = 1, 5 or 7 | 14 |
Instance | GROSSFEE | Error | For institutions in England, Instance.GROSSFEE must be less than or equal to 30000 where (Course.COURSEAIM begins E or M (excluding M11, M22, M26, M28, M71 and M88) or is H50, H60, H61, H62, H78, H81, I60 or I61) and Instance.FUNDCODE not equal to 1, 5 or 7. | 15 |
Instance | INITIATIVES | Error | Instance.INITIATIVES must not exist for institutions in Northern Ireland or Scotland. | 1 |
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 2, A, B, C or D. | 6 |
Instance | INITIATIVES | Error | For institutions in Wales Instance.INITIATIVES must be coded 7, 8 or 9. | 7 |
Instance | INITIATIVES | Error | Where Instance.INITIATIVES is coded 7 Institution.UKPRN must be 10007773 or 10007793. | 8 |
Instance | INITIATIVES | Error | Where Instance.INITIATIVES is coded B, Instance.COMDATE must be later than 2011-07-31 and Course.COURSEAIM must begin with H, I, J or C or equal M22, M26 or M28. | 9 |
Instance | INITIATIVES | Error | Where Instance.INITIATIVES is coded A, Instance.FEEREGIME must equal 20 and Course.COURSEAIM must begin with H, I, J or C or equal M22, M26 or M28. | 10 |
Instance | INITIATIVES | Error | Where Instance.INITIATIVES is coded 8 Institution.UKPRN must not be 10007814 or 10007855. | 11 |
Instance | INITIATIVES | Error | Where Instance.INITIATIVES is coded 2, Institution.UKPRN must be 10000291, 10000571, 10000886, 10001143, 10001282, 10001726, 10004351, 10004930, 10005790, 10006299, 10006566, 10007144, 10007145, 10007147, 10007161, 10007759, 10007785, 10007796, 10007823, 10007848, 10007851 or 10040812. | 12 |
Instance | INITIATIVES | Error | Where Instance.INITIATIVES is coded C, Course.TTCID must be coded 1, 8, G, H, L, M, N or P. | 13 |
Instance | INITIATIVES | Error | Instances where Instance.INITIATIVES = D must have Course.TTCID = 1, 8, G, H, L, M, N or P and Instance.ITTPHSC must = 71 - 77 and an associated occurrence of CourseSubject.SBJCA = G100. | 14 |
Instance | INITIATIVES | Error | Where Instance.INITIATIVES = D, Institution.UKPRN must be 10007811, 10007823, 10007766, 10007138, 10007139, 10006840, 10007146, 10007802, 10007776 or 10007164. | 15 |
Instance | INITIATIVES | Error | Where Instance.INITIATIVES = A, Instance.FEEELIG must be coded 1. | 16 |
Instance | INITIATIVES | Error | Instance.INITIATIVES must not be coded A where Instance.FUNDLEV = 20 or 21 and Course.TTCID = 1, 8, G, H, L, M, N or P. | 17 |
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 | INTERCALATE | Warning | Where Instance.INTERCALATE = 01, Course.COURSEAIM should not begin J, C, P, Q, R, S or X . Please check this is correct as it is expected that students will intercalate to a course at first degree level or above. | 1 |
Instance | ITTPHSC | Error | Instance.ITTPHSC must exist for institutions in England or Wales where Course.TTCID = 1, 2, 8, F, G, H, L, M, N or P and Instance.REDUCEDI = 00, 01, 04 or 07. | 1 |
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, G, H, L, M, N or P. | 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 and Course.TTCID = 1, 2, 8, G, H, L, M, N or P and Instance.REDUCEDI = 00, 01 or 04 | 1 |
Instance | ITTSCHMS | Error | Instance.ITTSCHMS must not exist for institutions in Northern Ireland, Scotland or Wales | 2 |
Instance | ITTSCHMS | Error | Instance.ITTSCHMS must not exist where the institution is in England and Course.TTCID = 0. | 3 |
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 or 01. | 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 | LEARNPLANENDDATE | Error | Instance.LEARNPLANENDDATE must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 or 01. | 1 |
Instance | LEARNPLANENDDATE | Error | Instance.LEARNPLANENDDATE must not exist for institutions in Northern Ireland, Scotland and Wales. | 2 |
Instance | LEARNPLANENDDATE | Error | Instance.LEARNPLANENDDATE must not exist for institutions in England where Instance.FESTUMK = 2 or Instance.FESTUMK does not exist. | 3 |
Instance | LEARNPLANENDDATE | Error | Instance.LEARNPLANENDDATE must be greater than or equal to Instance.COMDATE. | 4 |
Instance | LOADYRA | Error | Instance.LOADYRA must exist where Institution.INSTAPP is coded 1 and Instance.TYPEYR = 2, 3, 4 or 5 and Instance.REDUCEDI = 00, 01 or 03 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 = 00, 01 or 03 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, 01 or 09. | 1 |
Instance | LOCSDY | Error | Instance.LOCSDY codes C, H, J and K must have Instance.FESTUMK = 1, 3 or 4 and the institution must be in Wales. | 2 |
Instance | LOCSDY | Warning | Instance.LOCSDY should be coded T where Instance.SPECFEE = 2 or 3. | 3 |
Instance | LOCSDY | Error | Instance.LOCSDY must not be coded D or E where Instance.MODE is coded 01 and the institution is in England or Wales. | 4 |
Instance | LOCSDY | Warning | Instance.LOCSDY should not be coded D, E, T or U where Instance.MODE is coded 63 or 64. | 6 |
Instance | LOCSDY | Error | Instance.LOCSDY must be coded D, E, T or U where Instance.SPECFEE = 1. | 8 |
Instance | LOCSDY | Error | Instance.LOCSDY must be coded T, U or Z where Instance.EXCHANGE = Y. | 9 |
Instance | LOCSDY | Error | Instance.LOCSDY must be coded S or Z 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, T, U or Z where Instance.MODE = 23, 24 or 25. | 12 |
Instance | LOCSDY | Error | Instance.LOCSDY must be coded D, E or Z where Instance.EXCHANGE = 4 or G. | 13 |
Instance | LOCSDY | Error | Where the institution is in England, Instance.LOCSDY must be coded Z where Instance.FESTUMK = 1 or 4. | 14 |
Instance | LOCSDY | Error | Instance.LOCSDY must not be coded U where the sum of all the associated Mobility.MOBDURA > 51 weeks. | 15 |
Instance | LOCSDY | Warning | Where Instance.LOCSDY = U, the sum of all the associated Mobility.MOBDURA should be less than or equal to 24 weeks. | 16 |
Instance | LOCSDY | Error | Where Instance.LOCSDY = T and Instance.MODE not equal to 43 or 44, the sum of all the associated Mobility.MOBDURA must be greater than or equal to 24 weeks. | 17 |
Instance | LOCSDY | Warning | Where Instance.LOCSDY = T, the sum of all the associated Mobility.MOBDURA is greater than 52 weeks. Please check the mobilities for this instance are genuinely spanning the HESA reporting years, and it is not that duration has been returned incorrectly for individual mobilities. | 18 |
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, M28) 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, M28) 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 | MCDATE | Error | Where it exists and is not null Instance.MCDATE must be later than Instance.COMDATE | 10 |
Instance | MODE | Error | Instance.MODE codes 12 - 14, 33 - 36, 65 and 99 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, 8, G, H, L, M, N or P. | 3 |
Instance | MODE | Error | Instance.MODE must be coded 12, 13, 14, 33, 34, 35, 36, 63, 64 and 65 by institutions in 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, 33, 34, 35, 36, 65 and 99 where Instance.FESTUMK = 2. | 10 |
Instance | MODE | Error | Institutions in Scotland cannot use code 31. | 11 |
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, M28). | 14 |
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 01 or 23. | 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, H62, 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 | MODE | Warning | Instance.MODE should not be coded 01, 02, 23, 24 or 25 where Course.TTCID = 5. | 26 |
Instance | MODE | Error | For institutions in England, Instance.MODE must be coded 63, 64 or 99 where Instance.FESTUMK = 1 or 4. | 27 |
Instance | MODE | Error | Where the institution is in England or Wales, Instance.MODE must not be coded 99 where Instance.FESTUMK = 3 or Instance.FESTUMK does not exist. | 28 |
Instance | MODE | Error | Instance.MODE must be coded 23 or 24 where any associated Mobility.MOBSCHEME = 02. | 29 |
Instance | MSTUFEE | Error | Instance.MSTUFEE must exist where Instance.REDUCEDI = 00 or 01. | 1 |
Instance | MSTUFEE | Error | Instance.MSTUFEE cannot be coded 07 where Instance.MODE = 01, 12, 23, 24 or 43-74. | 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 G. | 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 | MSTUFEE | Error | Instance.MSTUFEE must be coded 01, 02, 03, 04, 52, 53, 54 or 81 where Course.TTCID = G, H, L, M, N or P | 12 |
Instance | NETFEE | Error | Instance.NETFEE must exist where (Instance.FEEREGIME = 20 and Instance.SSN does not exist) or Instance.FEEREGIME = 30. | 1 |
Instance | NETFEE | Error | Instance.NETFEE must not exist where Instance.FEEREGIME = 10 or Instance.FEEREGIME does not exist. | 2 |
Instance | NETFEE | Error | Instance.NETFEE must exist where Instance.GROSSFEE exists. | 3 |
Instance | NETFEE | Error | For institutions in England and Northern Ireland, Instance.NETFEE must equal 0 where Instance.SPECFEE = 3. | 4 |
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 | 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 Wales where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00. | 1 |
Instance | NOUNTACH | Error | Instance.NOUNTACH must not exist for institutions in England, Northern Ireland or Scotland. | 2 |
Instance | NOUNTACH | Error | Instance.NOUNTACH must not exist for institutions in 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 Wales where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00. | 1 |
Instance | NUMUNITS | Error | Instance.NUMUNITS must not exist for institutions in England, Northern Ireland or Scotland. | 2 |
Instance | NUMUNITS | Error | Instance.NUMUNITS must not exist for institutions in 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 | PARTNERUKPRN | Error | Instance.PARTNERUKPRN must not exist for institutions in Northern Ireland, Scotland or Wales. | 1 |
Instance | PARTNERUKPRN | Error | Instance.PARTNERUKPRN must not exist for institutions in England where Instance.FESTUMK = 2 or Instance.FESTUMK does not exist. | 2 |
Instance | PARTNERUKPRN | Error | Instance.PARTNERUKPRN must not exist for institutions in England where Instance.FUNDMODEL = 25 or 82 or Instance.AIMTYPE = 1. | 3 |
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 Instance.RSNEND not equal to 04 or 05 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 | PHDSUB | Warning | Instance.PHDSUB should not be null with ReasonForNull = 9 where Instance.RCSTDNT is not equal to 99 and Instance.REDUCEDI = 00 or 04 and Instance.RSNEND = 04 or 05 and at least one corresponding QualificationsAwarded.QUAL = D00 or D01. | 13 |
Instance | PLANEEPHOURS | Error | For institutions in England, Instance.PLANEEPHOURS must exist where Instance.FESTUMK = 1, 3 or 4 and Instance.FUNDMODEL = 25 or 82 and Instance.REDUCEDI = 00 or 01. | 1 |
Instance | PLANEEPHOURS | Error | Instance.PLANEEPHOURS must not exist for institutions in Northern Ireland, Scotland or Wales. | 2 |
Instance | PLANEEPHOURS | Error | Instance.PLANEEPHOURS must not exist for institutions in England where Instance.FESTUMK = 2 or Instance.FESTUMK does not exist. | 3 |
Instance | PLANLEARNHOURS | Error | For institutions in England, Instance.PLANLEARNHOURS must exist where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 or 01 and (Instance.PROGTYPE = 15, 16, 17 or 18 or Instance.PROGTYPE does not exist ) and (Instance.FUNDMODEL = 10, 25, 81, 82, 99 or (Instance.FUNDMODEL = 35 and no occurrences of LearningDeliveryFAM.LEARNDELFAMTYPE = WPL)). | 1 |
Instance | PLANLEARNHOURS | Error | For institutions in England, Instance.PLANLEARNHOURS must not exist where Instance.FESTUMK = 2 or Instance.FESTUMK does not exist. | 2 |
Instance | PLANLEARNHOURS | Error | Instance.PLANLEARNHOURS must not exist for institutions in Northern Ireland, Scotland or Wales. | 3 |
Instance | PROGRESS | Error | Instance.PROGRESS must exist for institutions in Wales where Instance.FESTUMK = 1,3 or 4 and Instance.REDUCEDI = 00. | 1 |
Instance | PROGRESS | Error | Instance.PROGRESS must be coded 9 for institutions in Wales where Instance.CSTAT = 1. | 4 |
Instance | PROGRESS | Error | Instance.PROGRESS must not be coded 9 where Instance.CSTAT is coded 2, 3 or 4. | 5 |
Instance | PROGRESS | Error | Instance.PROGRESS must not exist for institutions in England, Northern Ireland or Scotland. | 6 |
Instance | PROGRESS | Error | Instance.PROGRESS must not exist for institutions in Wales where Instance.FESTUMK = 2. | 7 |
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 for institutions in Wales where Instance.CSTAT = 4. | 10 |
Instance | PROGTYPE | Error | For institutions in England Instance.PROGTYPE must exist where Instance.AIMTYPE = 1 or 3 and Instance.REDUCEDI = 00 or 01. | 1 |
Instance | PROGTYPE | Error | Instance.PROGTYPE must not exist for institutions in Northern Ireland, Scotland and Wales. | 2 |
Instance | PROGTYPE | Error | Instance.PROGTYPE must not exist for institutions in England where Instance.FESTUMK = 2 or Instance.FESTUMK does not exist. | 3 |
Instance | PWAYCODE | Error | Instance.PWAYCODE must exist for institutions in England where Instance.PROGTYPE = 02, 03, 10, 20, 21, 22 or 23 and Instance.REDUCEDI = 00 or 01. | 1 |
Instance | PWAYCODE | Error | Instance.PWAYCODE must not exist for institutions in Northern Ireland, Scotland and Wales | 2 |
Instance | PWAYCODE | Error | Instance.PWAYCODE must not exist for institutions in England where Instance.FESTUMK = 2 or Instance.FESTUMK does not exist. | 3 |
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, M28) and Instance.REDUCEDI = 00 or 04. | 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 code 03 must have Instance.EXCHANGE = 4 or G. | 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 | REDUCEDI | Error | Where Instance.REDUCEDI = 09, Institution.UKPRN must be 10000163, 10003331, 10005415, 10005470, 10007937, 10008289, 10020416, 10023454, 10031982, 10035638 or 10039956. | 12 |
Instance | RSNEND | Error | Instance.RSNEND must exist where Instance.ENDDATE is not null and Instance.REDUCEDI = 00, 01, 04, 07, 08 or 09. | 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 | RSNEND | Error | Instance.RSNEND must not be coded 01 or 98 where Instance.REDUCEDI = 08. | 6 |
Instance | RSNEND | Error | Instance.RSNEND must not be coded 04 where Institution.UKPRN = 10000163, 10003331, 10005415, 10005470, 10007937, 10008289, 10020416, 10023454, 10031982, 10035638 or 10039956 | 7 |
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 England or 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, 8, G, H, L, M, N or P. | 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 | SPECFEE | Error | For institutions in England, where Instance.SPECFEE = 0, 1, 2, 3, 4, 5 or 6, Course.COURSEAIM must be coded M71, M88, M22, M26, M28 or begin with H, I, J or C (excluding codes ending with 90, 91 or 99). | 15 |
Instance | SPLENGTH | Error | Instance.SPLENGTH must exist where Instance.REDUCEDI = 00, 01 or 09. | 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 | SSN | Error | Instance.SSN must not exist where (Course.COURSEAIM begins D, E, L, M (excluding M22, M26, M28, M71, M88), P, Q, R, S or X) or where (Course.COURSEAIM ends with 90 or 99). | 1 |
Instance | SSN | Error | Where the institution is in England, Northern Ireland or Wales, Instance.SSN must not exist where Instance.FEEELIG = 2 or 3. | 2 |
Instance | SSN | Error | Instance.SSN must pass the checksum test given in the coding manual. | 3 |
Instance | SSN | Error | Instance.SSN must exist where Instance.REDUCEDI = 08. | 4 |
Instance | STULOAD | Error | Instance.STULOAD must exist where Instance.REDUCEDI = 00, 01, 03 or 09 | 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, 38 or 39 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 and Course.COURSEAIM does not begin with D or L, Instance.STULOAD + 100.0 is less than sum of Module.FTE for the student instance where StudentOnModule.MODSTAT not equal to 4 and StudentOnModule.APEL not equal to 1 or 2: 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, 73 or 74, unless Instance.LOCSDY = S or Instance.EXCHANGE is coded 4 or G or Instance.REDUCEDI = 08. | 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, M28) 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 4 or G 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 4 or G 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, 8, G, H, L, M, N or P 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, 8, G, H, L, M, N or P 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, 01 or 09 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 | TYPEYR | Error | Instance.TYPEYR must not be coded 3 where Instance.COMDATE < Y1-08-01. | 8 |
Instance | TYPEYR | Error | Instance.TYPEYR must not be coded 4 or 5 where Instance.COMDATE > Y1-07-31. | 9 |
Instance | UNITLGTH | Error | Instance.UNITLGTH must exist where Instance.REDUCEDI = 00, 01 or 09. | 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 | WITHDRAWREASON | Error | For institutions in England Instance.WITHDRAWREASON must exist where Instance.CSTAT = 3 and Instance.REDUCEDI = 00 or 01 and Instance.FESTUMK = 1, 3 or 4. | 1 |
Instance | WITHDRAWREASON | Error | Instance.WITHDRAWREASON must not exist for institutions in Northern Ireland, Scotland and Wales. | 2 |
Instance | WITHDRAWREASON | Error | Instance.WITHDRAWREASON must not exist for institutions in England where Instance.FESTUMK = 2 or Instance.FESTUMK does not exist. | 3 |
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 T. | 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, 01 or 09 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.YEARPRG is not coded 99. | 3 |
Instance | YEARPRG | Error | Instance.YEARPRG must not equal 0 if (Instance.UNITLGTH = 1 and Instance.SPLENGTH = 1) or (Instance.UNITLGTH = 2 and Instance.SPLENGTH < 13) or (Instance.UNITLGTH = 3 and Instance.SPLENGTH < 53). | 4 |
Instance | YEARPRG | Warning | Where Instance.YEARPRG is not equal to 99 and Instance.UNITLGTH = 2, Instance.YEARPRG should be less than or equal to Instance.SPLENGTH divided by 12. | 5 |
Instance | YEARPRG | Error | For institutions in England, Northern Ireland or Wales, Instance.YEARPRG must not equal 99 where Instance.UNITLGTH = 1, 2, 3, 4 or 5 and Instance.MODE not equal to 63 or 64. | 6 |
Instance | YEARPRG | Error | For institutions in Scotland, Instance.YEARPRG must not equal 99 where Instance.UNITLGTH = 1, 2, 3, 4 or 5 and Instance.MODE not equal to 39, 63 or 64. | 7 |
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, 64, 73 or 74 | 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, 08 or 09. | 3 |
LearnerEmploymentStatus | EmploymentStatusMonitoring | Error | LearnerEmploymentStatus.EmploymentStatusMonitoring entity must exist where LearnerEmploymentStatus.EMPSTAT = 10, 11 or 12. | 1 |
LearnerEmploymentStatus | EMPID | Error | LearnerEmploymentStatus.EMPID must exist where LearnerEmploymentStatus.EMPSTAT = 10 and (Instance.PROGTYPE = 02, 03, 10, 20, 21, 22 or 23 or (Instance.FUNDMODEL = 35 and any associated LearningDeliveryFAM.LEARNDELFAMTYPE = WPL)) | 1 |
LearningDeliveryFAM | LEARNDELFAMFROM | Error | LearningDeliveryFAM.LEARNDELFAMFROM must exist where LearningDeliveryFAM.LEARNDELFAMTYPE = LSF or ALB | 1 |
LearningDeliveryFAM | LEARNDELFAMTO | Error | LearningDeliveryFAM.LEARNDELFAMTO must exist where LearningDeliveryFAM.LEARNDELFAMTYPE = LSF or ALB | 1 |
Mobility | MOBTYPE | Error | Where there is more than one occurrence of Mobility.MOBTYPE each value must be unique. | 1 |
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 | For institutions in Scotland or Wales, Module.CRDTPTS should contain a value greater than 0. | 4 |
Module | CRDTPTS | Warning | For institutions in England or Northern Ireland, Module.CRDTPTS should contain a value greater than 0 where Module.FTE > 0. | 5 |
Module | CRDTSCM | Error | Module.CRDTSCM cannot be coded 2 for institutions in England, Wales or Northern Ireland. | 2 |
Module | FRANIND | Error | Module.FRANIND must not exist where the institution is in England, Northern Ireland or Scotland | 1 |
Module | FRANIND | Error | Module.FRANIND must be coded 1 or 2 where Module.PCOLAB > 0. | 2 |
Module | FRANIND | Error | Module.FRANIND must be coded 3 where Module.PCOLAB = 0. | 3 |
Module | FTE | Warning | For institutions in Scotland and Wales, Module.FTE should contain a value greater than 0. | 1 |
Module | FTE | Warning | For institutions in England or Northern Ireland, Module.FTE should contain a value greater than 0 where Module.CRDTPTS is in the range 1 - 998. | 2 |
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 |
Module | TINST | Error | For institutions in England, Northern Ireland or Scotland, Module.TINST must contain a valid UKPRN where Module.MTITLE includes the word 'college'. | 7 |
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, M28, 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. | 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, M26 or M28. | 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, 8, G, H, L, M, N or P. | 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, H62, 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, H62, 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, 10007768, 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, M28, 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, M28) 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 | QUAL | Error | Where QualificationsAwarded.QUAL = D00 or D01, Course.COURSEAIM must begin with D or L. | 12 |
QualificationsAwarded | QUAL | Error | Where QualificationsAwarded.QUAL = H24, Instance.MODE must be coded 63 or 64. | 13 |
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, Y1, Y2, Y3, Y4, Y5, Y6, Y7, Y8, Y9, YA, YB, YC, YD or YF where Instance.INITIATIVES = B and Instance.COMDATE > Y1-07-31. | 3 |
QualificationsOnEntry | QUALTYPE | Warning | For institutions in England, where Instance.COMDATE > Y1-07-31 and EntryProfile.QUALENT3 = P50, there should be at least one occurrence of QualificationsOnEntry.QUALTYPE = A, AD, AN, AS, A1, DA, V, V1, V2 or 9U. | 4 |
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 |
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 | For institutions in Northern Ireland, Scotland or Wales, 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 08. | 2 |
Student | ETHNIC | Error | Student.ETHNIC codes 13 and 19 must be for an institution in Scotland. | 3 |
Student | ETHNIC | Error | For institutions in England, Student.ETHNIC must exist where (EntryProfile.DOMICILE exists and is coded XF, XG, XH, XI, XK, XL, GG, JE, IM or Course.TTCID = 1, 8, G, H, L, M, N, P) and Instance.REDUCEDI = 00, 01, 07 or 08. | 4 |
Student | FNAMES | Error | Student.FNAMES must exist where any Instance.REDUCEDI = 00, 01, 04 ,08 or 09. | 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. | 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 | RELBLF | Error | Where Student.RELBLF = 03 the institution must be in England or Wales. | 1 |
Student | RELBLF | Error | Where Student.RELBLF = 04 the institution must be in Scotland. | 2 |
Student | RELBLF | Error | Where Student.RELBLF = 05 or 09 the institution must be in Northern Ireland or Scotland. | 3 |
Student | RELBLF | Error | Where Student.RELBLF = 06, 07 or 08 the institution must be in Northern Ireland. | 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 (EntryProfile.DOMICILE exists and is coded XH) and EntryProfile.UCASAPPID exists and Course.COURSEAIM begins H, I, J, C, P, Q, R or S. | 2 |
Student | SCN | Error | Student.SCN must exist for institutions in Scotland where (EntryProfile.DOMICILE exists and is coded XH) and Course.COURSEAIM begins H, I, J, C, P, Q, R or S. | 3 |
Student | SCN | Error | Student.SCN must not be null except when ReasonForNull = 1. | 4 |
Student | SCN | Error | Student.SCN must be null when ReasonForNull = 1. | 5 |
Student | SDEPEND | Error | Student.SDEPEND must exist for all students at institutions in Scotland where any Instance.REDUCEDI = 00 | 1 |
Student | SDEPEND | Error | Student.SDEPEND must not exist for institutions in England, Northern Ireland or Wales. | 2 |
Student | SURNAME | Error | Student.SURNAME must exist where any Instance.REDUCEDI = 00, 01, 04, 08 or 09. | 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 = Z. | 2 |
Student | TTPCODE | Error | Student.TTPCODE must exist where any Instance.LOCSDY does not equal 6, 9, D, S or T 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, M26 or M28. | 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 | ULN | Error | Student.ULN must exist for institutions in England where any Instance.FESTUMK = 1 or 3. | 3 |
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. | 1 |
Student | WELSSP | Error | Student.WELSSP must not exist for institutions in England, Northern Ireland or Scotland. | 2 |
StudentOnModule | APEL | Error | StudentOnModule.APEL must exist for institutions in Wales | 1 |
StudentOnModule | APEL | Error | StudentOnModule.APEL 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 or 24. | 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.