Skip to main content

Student record 2013/14

Back to C13051

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