Skip to main content

HESA Student record 2011/12

Back to C11051

HESA Student record 2011/12

Summary of business rules


return to index

Version 1.3 Produced 2012-07-31

The business rules below have been updated for 2011/12. Please see Revision history for changes to the validation rules.

Entity Field Name Status Rule Number
Course Error CourseSubject entity must exist for all courses at institutions in Scotland or Northern Ireland. 1
Course Error CourseSubject entity must exist for all courses at institutions in England or Wales where (any Instance.FESTUMK = 2 or 3 or Course.FEQAIMC = '66666666' or Course.TTCID = F) 2
Course BITTM Error Course.BITTM must exist for institutions in Wales, Northern Ireland or Scotland where Course.TTCID = 1 or 2 and Course.REDUCEDC = 00, 01 or 04. 1
Course BITTM Error Course.BITTM must not exist for institutions in Wales, Northern Ireland or Scotland where Course.TTCID does not = 1 or 2 . 2
Course BITTM Error Course.BITTM must not exist for institutions in England. 3
Course BITTM Error For institutions in Wales Course.BITTM must not be coded 0 where Course.TTCID = 1 and any associated CourseSubject.SBJCA = Q560. 4
Course CLSDCRS Error Course.CLSDCRS must exist for institutions in England where Course.REDUCEDC = 00. 1
Course CLSDCRS Error Course.CLSDCRS must not exist for institutions not in England. 2
Course COLLORG Error Course.COLLORG must exist for institutions in England where Course.REDUCEDC = 00 except where Course.COURSEAIM = D00, D01, D90, L00, L80, L90, L91. 1
Course COLLORG Error Course.COLLORG must not exist for institutions not in England. 2
Course COURSEAIM Error Course.COURSEAIM cannot be coded H16, I16, M16, M26 or M86 where the first 2 characters of CourseSubject.SBJCA are 'D1' or 'D2' and Institution.UKPRN not = 10006842, 10007154, 10007779, 10007786, 10007788, 10007790 or 10007794. 1
Course COURSEAIM Error Course.COURSEAIM cannot be coded H16, I16, M16, M26 or M86 where the first character of CourseSubject.SBJCA is 'A' and Institution.UKPRN not = 10000886, 10003270, 10003645, 10005343, 10006840, 10006842, 10007141, 10007143, 10007149, 10007154, 10007157, 10007158, 10007161, 10007163, 10007167, 10007767, 10007774, 10007775, 10007782, 10007783, 10007784, 10007785, 10007786, 10007788, 10007789, 10007790, 10007792, 10007794, 10007795, 10007796, 10007798, 10007799, 10007801, 10007803, 10007806, 10007814, 10007852 or 10007855. 2
Course COURSEAIM Error Course.COURSEAIM must be coded H71, M71, H11, I11 or I71 for institutions in England and Wales where Course.TTCID = 1. 3
Course COURSEAIM Error Course.COURSEAIM must be coded H71 or M71 for institutions in England where Course.TTCID = 8. 4
Course COURSEAIM Error Institutions in England, Scotland and Northern Ireland cannot use codes X41 - X46. 5
Course COURSEAIM Error Institutions in Scotland cannot use code X00. 6
Course COURSEAIM Warning Course.COURSEAIM should be coded D00, D01, E00, L00, M00, M01, M10, M11, L80, H50, H60, M50, H80, M80, M70, L80, H70, I70, H72, I72, M72, H61, H81, I61, J20, C20, I60, I80, I81, J80, C90, H90, I90, J90, D90, E90, L90 or M90 where (Course.TTCID = 5 and Course.MSFUND = 07) or where (Course.TTCID = 5 and any Instance.FUNDCODE = 7). 7
Course COURSEAIM Error Course.COURSEAIM cannot be coded M02 for institutions in Northern Ireland, Scotland or Wales 8
Course COURSEAIM Error Where Course.REGBODY = 08, Course.COURSEAIM must be coded M00, M10, M16, M41, M50, M76, M80, M86, M90, H00, H16, H50, H61, H76, C20 or (H80 where Institution.UKPRN = 10006840 only) or (J26 where Institution.UKPRN = 10007773 or 10007156 only). 9
Course COURSEAIM Error Course.COURSEAIM must be coded H99 where Course.TTCID = F. 10
Course FEQAIMC Error Course.FEQAIMC must exist for institutions in England or Wales where any Instance.FESTUMK = 1,3 or 4. 1
Course FEQAIMC Error Course.FEQAIMC must not exist for institutions in Northern Ireland or Scotland. 4
Course FEQAIMC Warning Course.FEQAIMC should not be coded '66666666' where Course.MSFUND = 05 or 06. 5
Course MSFUND Error Course.MSFUND must exist where Course.REDUCEDC = 00, 01, 02 or 04. 1
Course MSFUND Error Course.MSFUND must not be coded 01 where Course.COURSEAIM begins P, Q, R, S or X. 4
Course MSFUND Error Course.MSFUND must not be coded 02 or 07 where Course.COURSEAIM begins P, Q, R, S or X. 5
Course MSFUND Error Course.MSFUND must not be coded 01 where Course.TTCID is coded 1, 8 or F. 6
Course MSFUND Error Course.MSFUND must not be coded 05 or 06 where any Instance.FESTUMK is coded 2. 7
Course MSFUND Error Course.MSFUND must be coded 07 for institutions in England where Course.TTCID = 1, 8 or F. 10
Course MSFUND Error For institutions in Wales Course.MSFUND must not be coded 01, 03, 04, 05, 07, 12 or 14. 11
Course MSFUND Error For institutions in England Course.MSFUND must not be coded 02, 03, 04, 06, 13 or 14. 12
Course MSFUND Error For institutions in Northern Ireland Course.MSFUND must not be coded 01, 02, 03, 05, 06, 07, 11, 12, 13 or 14. 13
Course MSFUND Error For institutions in Scotland Course.MSFUND must not be coded 01, 02, 04, 05, 06, 07, 11, 12 or 13. 14
Course MSFUND Warning For institutions in England Course.MSFUND should not be coded 05 or 06 where Course.COURSEAIM begins with D, E, L, M, H, I, J or C. 15
Course MSFUND Warning For institutions in Wales Course.MSFUND should not be coded 05 or 06 where Course.COURSEAIM begins with D, E, L, M, H, I or J. 16
Course NHSBURSARY Error Course.NHSBURSARY must exist for all courses at institutions in England, Northern Ireland and Wales where Course.REDUCEDC = 00. 1
Course NHSBURSARY Error Course.NHSBURSARY must not exist for institutions in Scotland. 2
Course NHSBURSARY Warning Course.NHSBURSARY should not be coded 1 or 2 where the first character of CourseSubject.SBJCA is not A or B, or the first 2 characters of CourseSubject.SBJCA are not L5. 3
Course NHSBURSARY Warning Course.NHSBURSARY is coded 0 where all occurrences of CourseSubject have the first character of CourseSubject.SBJCA equal to A or B, or the first 2 characters of CourseSubject.SBJCA are equal to L5. 4
Course REDUCEDC Error Course.REDUCEDC cannot = 01 or 02 for institutions in England where any Instance.FESTUMK = 1. 2
Course REDUCEDC Error Course.REDUCEDC cannot = 02 for institution in Wales where any Instance.FESTUMK = 1. 3
Course REDUCEDC Error If Course.REDUCEDC = 01, the institution must be in England, Scotland or Northern Ireland. 4
Course REDUCEDC Error If Course.REDUCEDC = 02, the institution must be in England or Wales. 5
Course REDUCEDC Error Course.REDUCEDC code 02 must have a Course.COURSEAIM beginning with P, Q, R, S or X. 7
Course REDUCEDC Error Course.REDUCEDC must be coded 00, 04 or 07 where Course.TTCID = F. 9
Course REDUCEDC Error Course.REDUCEDC must not be coded 07 at institutions in Northern Ireland, Scotland or Wales. 10
Course REGBODY Error Course.REGBODY must exist where Course.COURSEAIM = M16, M26, M76, M86, H16, H76, I16, I76, J26 or J76 and Course.REDUCEDC = 00 or 01. 1
Course REGBODY Warning Course.REGBODY should only be coded 08 when Institution.UKPRN = 10000291, 10000824, 10000886, 10000961, 10000975, 10001143, 10001282, 10001478, 10001726, 10001883, 10002718, 10003614, 10003645, 10003678, 10003861, 10003956, 10003957, 10004048, 10004078, 10004180, 10004351, 10004797, 10004930, 10005553, 10005790, 10006022, 10006299, 10006566, 10006840, 10007137, 10007138, 10007139, 10007140, 10007141, 10007143, 10007144, 10007145, 10007146, 10007147, 10007148, 10007149, 10007150, 10007151, 10007152, 10007154, 10007155, 10007156, 10007157, 10007158, 10007159, 10007160, 10007161, 10007163, 10007164, 10007165, 10007166, 10007167, 10007767, 10007768, 10007760, 10007773, 10007785, 10007786, 10007789, 10007791, 10007795, 10007796, 10007798, 10007801, 10007802, 10007806, 10007823, 10007842, 10007848, 10007850, 10007851 or 10014001. 2
Course REGBODY Error Course.REGBODY must not be coded 04 unless Instance.MODE = 63 or 64. 3
Course SKEOS Error Course.SKEOS must exist for courses at institutions in England where Course.REDUCEDC=07 or Course.TTCID = F. 1
Course SKEOS Error Course.SKEOS must not exist for institutions in Northern Ireland, Scotland or Wales. 2
Course SKEOS Error Course.SKEOS must not exist for courses at institutions in England where Course.TTCID not equal to F. 3
Course SKEUNITS Error Course.SKEUNITS must exist for courses at institutions in England where Course.REDUCEDC=07 or Course.TTCID = F. 1
Course SKEUNITS Error Course.SKEUNITS must not exist for institutions in Northern Ireland, Scotland or Wales. 2
Course SKEUNITS Warning Course.SKEUNITS should be coded in the range 1 - 18. 3
Course SKEUNITS Error Course.SKEUNITS must not exist for courses at institutions in England where Course.TTCID not equal to F. 4
Course TQSSEC Error Course.TQSSEC must exist for institutions in Scotland or Northern Ireland where Course.TTCID = 1 or 2 and Course.REDUCEDC = 00. 1
Course TQSSEC Error Course.TQSSEC must be coded 1 or 2 for institutions in Scotland or Northern Ireland where Course.TTCID = 1. 2
Course TQSSEC Error Course.TQSSEC must be coded 3 or 4 for institutions in Scotland or Northern Ireland where Course.TTCID = 2. 3
Course TQSSEC Error Course.TQSSEC must not exist for institutions in Scotland or Northern Ireland where Course.TTCID = 0 or 5. 4
Course TQSSEC Error Course.TQSSEC must not exist for institutions in England or Wales. 5
Course TQSSUB Error Course.TQSSUB must exist for institutions in Scotland where Course.TQSSEC = 2 and Course.REDUCEDC = 00. 1
Course TQSSUB Error When one or more instances of Course.TQSSUB exists, one and only one instance's attribute Main must be set to "1". 2
Course TQSSUB Error Course.TQSSUB must not exist for institutions in England, Northern Ireland or Wales. 3
Course TQSSUB Error Course.TQSSUB must not exist for institutions in Scotland where Course.TQSSEC not = 2. 4
Course TTCID Error Course.TTCID must exist where Course.REDUCEDC = 00, 01, 04 or 07 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X. 1
Course TTCID Error Course.TTCID codes 8, 9, D and F must be for an institution in England. 2
Course TTCID Error Course.TTCID must be coded 1 for institutions in Wales where Course.COURSEAIM = H11 or I11. 3
Course TTCID Error If English institution and Course.TTCID is coded 1 or 8 Institution.UKPRN must be 10000291, 10000571, 10000712, 10000886, 10000961, 10001143, 10001282, 10002718, 10003614, 10003645, 10003678, 10003861, 10003863, 10003956, 10003957, 10004048, 10004078, 10004113, 10004180, 10004206, 10004351, 10004797, 10004930, 10005790, 10006299, 10006840, 10007137, 10007138, 10007139, 10007140, 10007143, 10007144, 10007145, 10007146, 10007147, 10007148, 10007149, 10007152, 10007154, 10007155, 10007157, 10007158, 10007159, 10007163, 10007164, 10007166, 10007167, 10007713, 10007766, 10007767, 10007773, 10007774, 10007776, 10007786, 10007787, 10007788, 10007789, 10007792, 10007795, 10007796, 10007798, 10007799, 10007801, 10007802, 10007806, 10007811, 10007816, 10007823, 10007832, 10007842, 10007843, 10007848, 10007850 or 10007851 4
Course TTCID Error Course.TTCID must not be coded 1 or 8 by institutions in England or Northern Ireland where Instance.FUNDLEV is coded 11 or 21. 6
Course TTCID Error Course.TTCID must not be coded 0 where Course.COURSEAIM is coded M71 or H71. 7
Course TTCID Error Course.TTCID must be coded 9 where Course.COURSEAIM = M02 8
Course TTCID Error Course.TTCID must be coded 2 where Course.COURSEAIM = M79, H79, I79, C77, C78, P77 or P78 9
Course TTCID Error For institutions in England, Course.TTCID must be coded 1, 2 or 8 where Instance.SPECFEE = 6. 10
Course TTCID Error For institutions in England, Course.TTCID must be coded F where Course.REDUCEDC = 07. 13
Course TTCID Error For institutions in England, Course.TTCID must be coded F where any Instance.REDUCEDI = 07. 14
Course TTCID Error Where Course.TTCID = F, Institution.UKPRN must be 10000291, 10000571, 10000886, 10000961, 10001143, 10002718, 10003863, 10003956, 10003957, 10004048, 10004113, 10004180, 10004206, 10004351, 10004797, 10004930, 10005790, 10006299, 10006840, 10007137, 10007139, 10007140, 10007144, 10007145, 10007146, 10007147, 10007149, 10007152, 10007155, 10007158, 10007159, 10007163, 10007164, 10007166, 10007767, 10007773, 10007776, 10007789, 10007798, 10007799, 10007801, 10007802, 10007806, 10007823, 10007832, 10007842, 10007843 or 10007848 16
Course TTCID Error For institutions in England and Northern Ireland, Course.TTCID must not be coded 0 where Course.COURSEAIM = I11 or H11 17
Course TTCID Error Where Course.TTCID = F and Course.CTITLE begins SKEPLUS, Institution.UKPRN must be 10000886, 10000961, 10001143, 10003956, 10003957, 10004113, 10004351, 10004797, 10005790, 10007137, 10007139, 10007140, 10007144, 10007146, 10007147, 10007164, 10007166, 10007773, 10007801, 10007802, 10007806, 10007823, 10007832 or 10007842 18
CourseSubject ITTSUBJECT Error At least one CourseSubject.ITTSUBJECT must exist where Institutions in England and Course.TTCID = 1 or 8 and any Instance.ITTPHSC is anything other than 31 or 49. 1
CourseSubject ITTSUBJECT Error CourseSubject.ITTSUBJECT must not exist for institutions not in England. 2
CourseSubject ITTSUBJECT Error CourseSubject.ITTSUBJECT must not exist where Institutions in England and Course.TTCID = 0. 3
CourseSubject SBJCA Error The second character of CourseSubject.SBJCA cannot be 0 where any Instance.RCSTDNT = 01 - 09. 1
CourseSubject SBJCA Error CourseSubject.SBJCA must be coded C100, C600, F100, F300, G100, G500, L230, L390, L700, P390, Q300, Q560, R100, R200, R300, R400, R500, V100, V600, W200, W300, W400, W500, W900, X900, X120, X121 or Y000 where Course.TTCID = 1 or 8 and Instance.ITTPHSC = 15 - 19, 51 - 53, 61 - 65 or 71 - 77. 2
CourseSubject SBJCA Error CourseSubject.SBJCA cannot be coded X120 where Course.TTCID = 1 or 8 and (Instance.ITTPHSC = 15 - 19, 51 - 53, 61 - 65, or 71 - 77 and Instance.COMDATE before 01-Sep-2002). 3
CourseSubject SBJCA Error CourseSubject.SBJCA must be coded C000, C100, C110, C600, C800, D600, F000, F100, F110, F300, F310, G100, G500, G510, H700, H900, J420, L230, L390, L510, L700, L900, N100, N190, N870, P300, P390, Q300, Q560, Q800, R100, R200, R300, R400, R500, R700, R900, V100, V600, W200, W210, W300, W400, W500, W900 or W990 where Course.TTCID = 1 or 8 and Instance.ITTPHSC = 24 - 26, 54 - 57, or 78 - 81. 4
CourseSubject SBJCA Error For institutions in England, one, and only one, CourseSubject.SBJCA must be coded F000 where any CourseSubject.SBJCA = C000 and Course.TTCID = 1 or 8 and Instance.ITTPHSC = 24 -26, 54 - 57, or 78 - 81. 5
CourseSubject SBJCA Warning If CourseSubject.SBJCA begins with B82 for institutions in England and Course.COURSEAIM ends with '16' then CourseSubject.SBJCA should be coded B821 or B822. 6
CourseSubject SBJCA Warning If CourseSubject.SBJCA begins with B7 for institutions in England and Course.COURSEAIM ends with '16' then CourseSubject.SBJCA should be coded B720, B730, B740, B750, B760 or B761. 7
CourseSubject SBJCA Error The first character of CourseSubject.SBJCA must be 'D' where Course.COURSEAIM is coded H16, I16, M16, M26 or M86 and Course.REGBODY = 14. 8
CourseSubject SBJCA Error The first character of CourseSubject.SBJCA must be 'A' or CourseSubject.SBJCA must equal B750, where Course.COURSEAIM is coded H16, I16, M16, M26 or M86 and Course.REGBODY = 02. 9
CourseSubject SBJCA Error CourseSubject.SBJCA cannot be coded X110, X120, X121 or X122 for institutions in Scotland or Northern Ireland where Course.TTCID = 1 or 8 and QualificationsAwarded.TQGSEC = 2. 10
CourseSubject SBJCA Error CourseSubject.SBJCA cannot be coded X130, X131, X132, X140, X141, X142, X150 or X151 for institutions in Scotland or Northern Ireland where Course.TTCID = 1 or 8 and QualificationsAwarded.TQGSEC = 1 11
CourseSubject SBJCA Error CourseSubject.SBJCA must be unique for each Course entity 13
CourseSubject SBJCA Error For institutions in England, one, and only one, CourseSubject.SBJCA must be coded C000 where any CourseSubject.SBJCA = F000 and Course.TTCID = 1 or 8 and Instance.ITTPHSC = 24 -26, 54 - 57, or 78 - 81. 14
CourseSubject SBJCA Error For institutions in England where Course.TTCID = 1 or 8 and Instance.ITTPHSC = 24 - 26, 54 - 57, or 78 - 81, CourseSubject.SBJCA codes C110, F110 and F310 must always be used together as a triplet. 15
CourseSubject SBJCA Error For institutions in England CourseSubject.SBJCA codes C100, F100 and F300 can only be used together where Course.TTCID = 1 or 8 and Instance.ITTPHSC = 15 - 19, 51 - 53 or 71 -77. 16
CourseSubject SBJCA Error CourseSubject.SBJCA must be coded B700, B760, B761, B790, L300, L310, L400, L410, L500, L510, L520, L530, L540, L560 or L590 where Course.REGBODY = 08 17
CourseSubject SBJCA Error Where Course.SKEOS is coded 1 at least one occurrence of CourseSubject.SBJCA must begin with R. 20
CourseSubject SBJCA Error For institutions in Scotland CourseSubject.SBJCA must not be coded A300 where any other occurrence of CourseSubject.SBJCA = A100. 21
CourseSubject SBJCA Error For institutions in Scotland CourseSubject.SBJCA must not be coded A400 where any other occurrence of CourseSubject.SBJCA = A200. 22
CourseSubject SBJCA Error For institutions in Scotland CourseSubject.SBJCA must not be coded D200, D210, D220 or D290 where any other occurrence of CourseSubject.SBJCA = D100 or D190. 23
CourseSubject SBJCA Error CourseSubject.SBJCA must be coded C000, F100, F300, G100, G500, R900, V600, W200 or W300 where Course.TTCID = F. 24
CourseSubject SBJCA Error CourseSubject.SBJCA must be coded F100, F300, or G100 where Course.TTCID = F and Course.CTITLE begins SKEPLUS 25
CourseSubject SBJPCNT Error For each Course entity the sum of CourseSubject.SBJPCNT must equal 100. 1
CourseSubject SBJPCNT Error All CourseSubject.SBJPCNT must be coded '50' where any CourseSubject.SBJCA = F000 or C000 and Course.TTCID = 1 or 8 and any Instance.ITTPHSC = 24 -26, 51 - 57, or 78 - 81. 2
CourseSubject SBJPCNT Error CourseSubject.SBJPCNT must contain '33, 34, 50, 67 or 100 for institutions in Scotland. 3
EntryProfile Warning There are more than 30 occurrences of QualificationsOnEntry for an instance. 1
EntryProfile ACCESS Error EntryProfile.ACCESS must exist for institutions in Scotland where (EntryProfile.QUALENT2 = 44 or 45) or (EntryProfile.QUALENT3 = X00 or X01) 1
EntryProfile ACCESS Error EntryProfile.ACCESS must not exist for institutions in England, Northern Ireland or Wales. 2
EntryProfile ARTICLN Error EntryProfile.ARTICLN must exist for institutions in Scotland where EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM and Course.COURSEAIM = M22, M26, H00, H11,H16, H18, H22, H23, H24, I00, I11 or I16 and Instance.COMDATE is after 2007-07-31 and corresponding Instance.REDUCEDI = 00 or 04 1
EntryProfile ARTICLN Error EntryProfile.ARTICLN must not exist for institutions in England, Northern Ireland or Wales. 2
EntryProfile DOMICILE Error EntryProfile.DOMICILE code XC must have an Instance.COMDATE before 2007-08-01 or EntryProfile.UCASAPPID must exist. 1
EntryProfile DOMICILE Error EntryProfile.DOMICILE code XL must have an Instance.COMDATE before 2007-08-01. 2
EntryProfile DOMICILE Error EntryProfile.DOMICILE must not be coded ZZ (unknown) when corresponding Instance.FEEELIG = 1. 3
EntryProfile DOMICILE Error For institutions in Northern Ireland, EntryProfile.DOMICILE must not be coded XK where Course.COURSEAIM begins D, E, L, M, H, I, J, C and Instance.COMDATE > Y1-07-31. 4
EntryProfile DOMICILE Error EntryProfile.DOMICILE must not be coded AN where Instance.COMDATE > 2011-07-31. 5
EntryProfile MARSTAT Error EntryProfile.MARSTAT must exist for institutions in Northern Ireland where EntryProfile.DOMICILE = XG and corresponding Instance.REDUCEDI = 00 or 04. 1
EntryProfile MARSTAT Error EntryProfile.MARSTAT must not exist for institutions in England, Scotland or Wales. 2
EntryProfile NEWENT Warning EntryProfile.NEWENT should not be coded B or C if (EntryProfile.QUALENT2 is 01, 02, 03, 04, 05, 10, 11, 16, 23, 24, 25, 28, 29, 30, 15, 21, 22 or 27) or (EntryProfile.QUALENT3 begins with D, M, H, J or C (excluding HZZ)) 3
EntryProfile NIDEPEND Error EntryProfile.NIDEPEND must exist for institutions in Northern Ireland where EntryProfile.DOMICILE = XG and corresponding Instance.REDUCEDI = 00 or 04. 1
EntryProfile NIDEPEND Error EntryProfile.NIDEPEND must not exist for institutions in England, Scotland or Wales. 2
EntryProfile PARED Error EntryProfile.PARED must exist for institutions in England or Scotland where EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM and Course.COURSEAIM = M22, M26, H00, H11, H16, H18, H22, H23, I00, I11, I16, J10, J16, J20, J26, J30, C20 or C30 and Instance.COMDATE is after 31-Jul-2007 and corresponding Instance.REDUCEDI = 00 or 04. 1
EntryProfile PARED Error EntryProfile.PARED must exist for institutions in Wales or Northern Ireland where EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM and Course.COURSEAIM = M22, M26, H00, H11, H16, H18, H22, H23, I00, I11, I16, J10, J16, J20, J26, J30, C20 or C30 and Instance.COMDATE is after 31-Jul-2008 and corresponding Instance.REDUCEDI = 00 or 04 and EntryProfile.UCASAPPID exists. 3
EntryProfile PGCECLSS Error EntryProfile.PGCECLSS must exist where Course.COURSEAIM = M71 or H71 and corresponding Instance.REDUCEDI = 00 or 04. 1
EntryProfile PGCESBJ Error EntryProfile.PGCESBJ must exist where Course.COURSEAIM = M71 or H71 and corresponding Instance.REDUCEDI = 00 or 04. 1
EntryProfile PGCESBJ Error Where EntryProfile.PGCESBJ = 9998 or 9999, there must be only one occurrence of EntryProfile.PGCESBJ. 2
EntryProfile POSTCODE Error EntryProfile.POSTCODE must exist where EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM and corresponding Instance.REDUCEDI = 00, 01, 04 or 07. 1
EntryProfile POSTCODE Error EntryProfile.POSTCODE must not be null except when ReasonForNull = 1. 2
EntryProfile POSTCODE Error EntryProfile.POSTCODE must be null when ReasonForNull = 1. 3
EntryProfile POSTCODE Error EntryProfile.POSTCODE must not exist where EntryProfile.DOMICILE is not in (XF, XG, XH, XI, XK, XL, GG, JE or IM). 4
EntryProfile POSTCODE Error Where exists EntryProfile.POSTCODE must contain: a valid full postcode structure or a valid outward postcode structure. 5
EntryProfile PREVINST Error EntryProfile.PREVINST must exist where EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM and Course.COURSEAIM = M22, M26, H00, H11, H16, H18, H22, H23, I00, I11, I16, J10, J16, J20, J26, J30, C20 or C30 and corresponding Instance.REDUCEDI = 00 or 04. 1
EntryProfile PREVINST Error Where EntryProfile.PREVINST begins 'H' and is followed by 4 numbers it must be coded H9999 or begin H0. 2
EntryProfile QUALENT2 Error EntryProfile.QUALENT2 must exist where corresponding Instance.REDUCEDI = 00, 01, or 04 and Instance.COMDATE < 2010-08-01 and EntryProfile.QUALENT3 does not exist. 1
EntryProfile QUALENT2 Error EntryProfile.QUALENT2 cannot be coded 99 where QualificationsOnEntry entity exists. 2
EntryProfile QUALENT2 Error EntryProfile.QUALENT2 cannot be coded 99 where EntryProfile.WELBACC = 1. 3
EntryProfile QUALENT2 Error EntryProfile.QUALENT2 must be 01-45 where EntryProfile.ACCESS exists. 4
EntryProfile QUALENT2 Error EntryProfile.QUALENT2 must not exist where EntryProfile.QUALENT3 exists or corresponding Instance.COMDATE > 2010-07-31 5
EntryProfile QUALENT3 Error EntryProfile.QUALENT3 must exist where corresponding Instance.REDUCEDI = 00, 01 or 04 and Instance.COMDATE > 2010-07-31. 1
EntryProfile QUALENT3 Error EntryProfile.QUALENT3 must not exist where EntryProfile.QUALENT2 exists and corresponding Instance.COMDATE < 2010-08-01. 2
EntryProfile QUALENT3 Error EntryProfile.QUALENT3 cannot be coded X06 where QualificationsOnEntry entity exists. 3
EntryProfile QUALENT3 Error EntryProfile.QUALENT3 cannot be coded X06 where EntryProfile.WELBACC = 1. 4
EntryProfile QUALENT3 Error Where EntryProfile.ACCESS exists EntryProfile.QUALENT3 must be coded X00 or X01 or begin with P, C, J, H, M or D. 5
EntryProfile RELIGION Error EntryProfile.RELIGION must exist for institutions in Northern Ireland where EntryProfile.DOMICILE = XG and corresponding Instance.REDUCEDI = 00 or 04. 1
EntryProfile RELIGION Error EntryProfile.RELIGION must not exist for institutions in England, Scotland or Wales. 2
EntryProfile SEC Error EntryProfile.SEC must exist where EntryProfile.UCASAPPID exists and Course.COURSEAIM begins H, I, J or C or is M22, M26 and EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM. 1
EntryProfile SOC2000 Error EntryProfile.SOC2000 must exist where EntryProfile.UCASAPPID exists and Course.COURSEAIM begins H, I, J or C or is M22 or M26 and EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM. 1
EntryProfile UCASAPPID Error EntryProfile.UCASAPPID must pass the checksum test as applied to Student.HUSID where it is nine characters long and (digits 1-8 are not in ranges 06000999 to 06009996 inclusive or 06690999 to 06692257 inclusive). 2
EntryProfile UCASAPPID Error Where EntryProfile.UCASAPPID digits 1-8 are in ranges (06000999 to 06009996 inclusive or 06690999 to 06692257 inclusive), this field must pass either the checksum test as applied to Student.HUSID or the 'incorrectly calculated checksum' test, details of which are in the student circular: http://www.hesa.ac.uk/circulars/student/2006/06_04.html. 3
EntryProfile UCASAPPID Error Where EntryProfile.UCASAPPID exists it must be nine characters long where Student.UCASPERID does not exist. 4
EntryProfile UCASAPPID Error EntryProfile.UCASAPPID must not contain all zeros. 5
EntryProfile UCASAPPID Warning EntryProfile.UCASAPPID should be four characters long where Student.UCASPERID exists. 6
EntryProfile UCASAPPID Error EntryProfile.UCASAPPID must be four characters long when Instance.COMDATE > 2011-07-31 7
EntryProfile WELBACC Error EntryProfile.WELBACC must exist for institutions in Wales where EntryProfile.DOMICILE = XI and Course.COURSEAIM begins H, I , J, C and corresponding Instance.COMDATE is greater than 2005-07-31 and corresponding Instance.REDUCEDI = 00 or 04. 1
EntryProfile YRLLINST Error EntryProfile.YRLLINST must exist for institutions in Scotland where EntryProfile.ARTICLN = 1, 2, 3 or 4. 1
EntryProfile YRLLINST Error EntryProfile.YRLLINST must not exist for institutions in England, Northern Ireland or Wales. 2
Instance Error EntryProfile entity must exist where corresponding Instance.COMDATE is in the current reporting year. 1
Instance Error QualificationsAwarded entity must exist where Instance.ENDDATE is not null and Instance.RSNEND = 01 and Instance.REDUCEDI = 00, 01 or 04, unless Course.COURSEAIM ends with 99. 1
Instance Error QualificationsAwarded entity must only occur once where Instance.FESTUMK is coded 1 or 4. 3
Instance Error StudentOnModule entity must exist where Instance.STULOAD is greater than 0 and Instance.REDUCEDI = 00 or 01. 1
Instance Error There must be at least one occurrence of StudentOnModule entity with StudentOnModule.MODSTAT not equal to 4 where Instance.STULOAD is greater than 0 and Instance.REDUCEDI = 00 or 01. 2
Instance Error RAEData entity must exist where Course.COURSEAIM = L00, L80, L90 or L99 or begins with D and corresponding Instance.REDUCEDI = 00. 1
Instance Error RAEData entity must not exist unless (Course.COURSEAIM = L00, L80, L90 or L99 or Course.COURSEAIM begins with D). 2
Instance ADDSUPCT Error Instance.ADDSUPCT must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00. 1
Instance ADDSUPCT Error Instance.ADDSUPCT must not exist for institutions not in England. 2
Instance ADDSUPCT Error Instance.ADDSUPCT must not exist for institutions in England where Instance.FESTUMK = 2. 3
Instance BRIDGE Error Instance.BRIDGE must exist where Instance.REDUCEDI = 00 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X. 1
Instance BRIDGE Error Instance.BRIDGE code 1 must have Course.COURSEAIM = H16, I16, M16, M26, M86, H11, I11, H00, I00, H23, H24, J16, J30, C90, H90, I90 or J90. 2
Instance COMDATE Error Instance.COMDATE must not be less than 1971-02-01. 2
Instance COMDATE Error Instance.COMDATE must be less than Y2-08-01. 4
Instance COURSEID Error This entry must exist in Course.COURSEID. 1
Instance CSTAT Error Instance.CSTAT must exist for institutions in England or Wales where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00, 01 or 02. 1
Instance CSTAT Error Instance.CSTAT must not exist for institutions in Northern Ireland or Scotland. 2
Instance CSTAT Error Instance.CSTAT must not exist for institutions in England or Wales where Instance.FESTUMK = 2. 3
Instance CSTAT Error Instance.CSTAT must be coded 1 where Instance.PROGRESS is coded 9. 4
Instance CSTAT Error Instance.CSTAT must be coded 4 where Instance.PROGRESS is coded W. 5
Instance DESTIN Error Instance.DESTIN must not exist for institutions in England, Northern Ireland or Scotland. 2
Instance DESTIN Error Instance.DESTIN must not exist for institutions in Wales where Instance.FESTUMK = 2. 3
Instance DESTOCM Error Instance.DESTOCM must exist for institutions in England, Wales and Northern Ireland where Instance.REDUCEDI = 00 and (Instance.EXCHANGE = 7, B, C, D or E or Instance.LOCSDY = F, G or S). 1
Instance DESTOCM Error Instance.DESTOCM must not exist for institutions in Scotland. 2
Instance DESTOCM Error Instance.DESTOCM must not be coded AN where Instance.COMDATE > 2011-07-31. 3
Instance DHFUND Error Instance.DHFUND must exist for institutions in England where Course.MSFUND = 31 and Instance.REDUCEDI = 00 or 01. 1
Instance DHFUND Warning Instance.DHFUND should be coded 998 for institutions in England where CourseSubject.SBJCA = A300 or A400 and Course.MSFUND = 31 and Course.COURSEAIM = H16 or I16. 3
Instance DHFUND Warning Instance.DHFUND should not be coded 998 for institutions in England where Course.MSFUND = 31 unless CourseSubject.SBJCA begins 'L5'. 7
Instance DHFUND Error Instance.DHFUND must not exist for institutions not in England. 8
Instance DHFUND Error Instance.DHFUND must not exist for institutions in England where Course.MSFUND not = 31. 9
Instance DHFUND Error Instance.DHFUND codes LWF01 - LWF27 must have an Instance.COMDATE before 1 August 2006. 10
Instance DHREGREF Error Instance.DHREGREF must exist where Course.COURSEAIM = M16, M26, M76, M86, H16, H76, I16, I76, J26 or J76 and Course.REGBODY = 06 or 07 and Instance.REDUCEDI = 00 or 01. 1
Instance DISALL Error Instance.DISALL must exist where Student.DISABLE = 02 - 96 and Instance.REDUCEDI = 00 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X. 1
Instance DISALL Error Instance.DISALL code 4 must have a Course.COURSEAIM beginning with D, E, L, M, H, I, J or C. 2
Instance DISALL Warning Instance.DISALL should not exist where Student.DISABLE = 00, 97, 98 or 99. 3
Instance DISALL Error Instance.DISALL cannot be coded 4 where (EntryProfile.DOMICILE exists and is not coded GG, JE, XL, XK, IM, XF, XI, XH, XG). 4
Instance DISUPFAC Error Instance.DISUPFAC must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00. 1
Instance DISUPFAC Error Instance.DISUPFAC must not exist for institutions not in England. 2
Instance DISUPFAC Error Instance.DISUPFAC must not exist for institutions in England where Instance.FESTUMK = 2. 3
Instance ELIDISUP Error Instance.ELIDISUP must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00. 1
Instance ELIDISUP Error Instance.ELIDISUP must not exist for institutions not in England. 2
Instance ELIDISUP Error Instance.ELIDISUP must not exist for institutions in England where Instance.FESTUMK = 2. 3
Instance ELIGENFD Error Instance.ELIGENFD must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00. 1
Instance ELIGENFD Error Instance.ELIGENFD must not exist for institutions not in England. 2
Instance ELIGENFD Error Instance.ELIGENFD must not exist for institutions in England where Instance.FESTUMK = 2. 3
Instance EMPROLE Error Instance.EMPROLE must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 or 02. 1
Instance EMPROLE Error Instance.EMPROLE codes 1 - 5 must be for an institution in Wales. 2
Instance EMPROLE Error Instance.EMPROLE codes 6 - 8 must be for an institution in England. 3
Instance EMPROLE Error Instance.EMPROLE must not exist for institutions in Northern Ireland or Scotland. 4
Instance EMPROLE Error Instance.EMPROLE must not exist for institutions in England or Wales where Instance.FESTUMK = 2. 5
Instance ENDDATE Error Instance.ENDDATE must not be null where Instance.RSNEND exists. 1
Instance ENDDATE Error Instance.ENDDATE must not be null where Instance.CSTAT = 2, 3 or 4. 2
Instance ENDDATE Error Instance.ENDDATE must be null where Instance.CSTAT = 1. 3
Instance ENDDATE Error Where exists Instance.ENDDATE must be less than Y2-08-01. 4
Instance ENDDATE Error If Instance.MODE is not equal to 63 or 64, then Instance.ENDDATE (where exists) must be greater than Y1-07-31. 5
Instance ENDDATE Error If Instance.MODE = 63 or 64, then Instance.ENDDATE (where exists) must be greater than (Y2-6)-07-31. 6
Instance ENDDATE Error Instance.ENDDATE (where exists) must be greater than or equal to Instance.COMDATE (where exists) unless (Instance.MODE = 63 or 64 and Instance.ENDDATE = Y0-08-01). 7
Instance ENDDATE Error Instance.ENDDATE must be null with ReasonForNull=9 where Instance.RSNEND does not exist and Instance.REDUCEDI = 00, 01, 02, 04 or 07. 9
Instance ENDDATE Error Instance.ENDDATE must not be null except when ReasonForNull=9. 10
Instance ENDDATE Error Instance.ENDDATE must not be null where Instance.MODE = 63 or 64 and Course.TTCID = F. 11
Instance EXCHANGE Error Instance.EXCHANGE must exist where Instance.REDUCEDI = 00 or 03 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X. 1
Instance EXCHANGE Error Instance.EXCHANGE must be coded B, C, D or E when Instance.SPECFEE = 3. 2
Instance EXCHANGE Error Instance.EXCHANGE must be coded 0, 7, B, C, D, E or Y where Instance.LOCSDY = F or G. 3
Instance EXCHANGE Warning Instance.EXCHANGE should not be coded 0 where Instance.LOCSDY = F or G. 4
Instance EXCHANGE Error Instance.EXCHANGE must not be coded 0, 7, B, C, D, E or Y where Course.COURSEAIM code ends with 91. 5
Instance EXCHANGE Error Instance.EXCHANGE must be coded 0 or Z where Instance.LOCSDY = S 6
Instance FEEELIG Error Instance.FEEELIG must exist where Instance.REDUCEDI = 00 or 01 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X. 1
Instance FEEELIG Error Instance.FEEELIG must be coded 1 where Instance.FUNDCODE = 1 for institutions in England and Northern Ireland. 2
Instance FEEELIG Error Instance.FEEELIG must not be coded 2 where Instance.FUNDCODE is coded 1 or 4. 3
Instance FEEELIG Error Instance.FEEELIG must not be coded 3 where Instance.FUNDCODE is coded 1 or 4 for institutions in England and Northern Ireland. 4
Instance FEEELIG Error Instance.FEEELIG must be coded 2 where (EntryProfile.DOMICILE exists and is coded IM, XL, GG or JE) and Instance.FESTUMK not coded 1 or 3. 5
Instance FESTUMK Error Instance.FESTUMK must exist for institutions in England and Wales unless Instance.REDUCEDI = 07. 1
Instance FESTUMK Error Instance.FESTUMK code 2 must not have Course.MSFUND = 05 or 06. 2
Instance FESTUMK Error Instance.FESTUMK must be coded 1 or 4 where Course.COURSEAIM begins P, Q, R, S or X. 3
Instance FESTUMK Error Instance.FESTUMK must be coded 2 or 3 where Course.COURSEAIM begins D, E, L, M, H, I, J or C. 4
Instance FESTUMK Error Instance.FESTUMK must not exist for institutions in Northern Ireland or Scotland. 5
Instance FRANPART Error Instance.FRANPART must not exist for institutions in England, Northern Ireland or Scotland. 2
Instance FRANPART Error Instance.FRANPART must not exist for institutions in Wales where Instance.FESTUMK = 2. 3
Instance FROUTARR Error Instance.FROUTARR must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00. 1
Instance FROUTARR Error Instance.FROUTARR must not exist for institutions not in England. 2
Instance FROUTARR Error Instance.FROUTARR must not exist for institutions in England where Instance.FESTUMK = 2. 3
Instance FTEMETHOD Error Instance.FTEMETHOD must exist for institutions in Scotland where Instance.REDUCEDI = 00, 01 or 03. 1
Instance FTEMETHOD Error Instance.FTEMETHOD must not exist for institutions in England, Northern Ireland or Wales. 2
Instance FUNDCODE Error Instance.FUNDCODE must be coded 1 where Instance.FESTUMK = 1 or 3. 1
Instance FUNDCODE Error Instance.FUNDCODE cannot be 1 where Instance.FESTUMK = 4. 2
Instance FUNDCODE Error Instance.FUNDCODE must exist where Instance.REDUCEDI = 00 or 01. 3
Instance FUNDCODE Error Instance.FUNDCODE cannot be coded 1 by institutions in England, Wales or Northern Ireland where Course.MSFUND = 13 or 31 and Course.COURSEAIM = H16, I16, M16, M86, H11, I11, H00, I00, H22, M22, M26, H23 or H24. 4
Instance FUNDCODE Error Instance.FUNDCODE cannot be coded 4 or 5 by institutions in Scotland or Wales. 5
Instance FUNDCODE Error Instance.FUNDCODE cannot be coded 7 by institutions in Scotland, Wales or Northern Ireland. 6
Instance FUNDCODE Error Instance.FUNDCODE code 7 must have Course.TTCID = 1, 5, 8, 9, D or F 7
Instance FUNDCODE Error Instance.FUNDCODE code 7 must not have Instance.ITTPHSC = 31. 8
Instance FUNDCODE Error For English institutions Instance.FUNDCODE codes 1 or 4 must not have Course.TTCID = 1, 8, 9, D or F. 9
Instance FUNDCODE Error Instance.FUNDCODE cannot be coded 3 by institutions in England, Wales or Northern Ireland. 10
Instance FUNDCODE Warning Instance.FUNDCODE should not be coded 5 or 7 where Course.MSFUND = 01 or 02. 11
Instance FUNDCODE Warning Instance.FUNDCODE codes 1 or 4 should not have Course.MSFUND = 07, 13 or 31. 12
Instance FUNDCODE Error Instance.FUNDCODE must not be coded 1 where Course.CLSDCRS = 1. 13
Instance FUNDCODE Warning Instance.FUNDCODE should not be coded 1 by institutions in England, Wales or Northern Ireland where (EntryProfile.DOMICILE exists and is not in (XK, XL, GG, JE, IM, XF, XI, XH, XG, AT, BE, XA, CZ, DK, FI, FR, DE, GI, GR, HU, IE, IT, LU, MT, NL, PL, PT, ES, SE, ZZ, EE, LV, LT, SI, SK, RO, BG)) . 14
Instance FUNDCODE Error Instance.FUNDCODE must not be coded 2 or 3 where Instance.LOCSDY = 9. 15
Instance FUNDCODE Warning Instance.FUNDCODE should not be coded 1 where Instance.FUNDLEV = 20 or 21 and (EntryProfile.QUALENT2 = 01, 02, 05, 14, 15 or EntryProfile.QUALENT3 begins with D or M (excluding M41, M44 and M71)). 16
Instance FUNDCODE Warning Instance.FUNDCODE should not be coded 1 where Instance.FUNDLEV = 10 or 11 and Course.COURSEAIM begins D, E, L, M, H or I and (EntryProfile.QUALENT2 is coded 01, 02, 05, 14, 15, 03, 04, 10,11, 12, 13, 16 or EntryProfile.QUALENT3 begins with D, M, H or is equal to JUK) 17
Instance FUNDCODE Warning Instance.FUNDCODE should not be coded 1 where Instance.FUNDLEV = 10 or 11 and Course.COURSEAIM begins J (excluding J10, J16) C, P, Q, R, S, X and (EntryProfile.QUALENT2 is coded 01, 02, 05, 14, 15, 03, 04, 10,11, 12, 13, 16, 31, 24, 25 or EntryProfile.QUALENT3 begins with D, M, H, J) 19
Instance FUNDCODE Error Instance.FUNDCODE must not be coded 1 or 4 where Instance.QTS = 3 and Course.TTCID = 5. 20
Instance FUNDCODE Error Instance.FUNDCODE code 7 must not have Instance.ITTPHSC = 49 unless Course.TTCID = F. 21
Instance FUNDCODE Error Instance.FUNDCODE must not be coded 1 where Instance.EXCHANGE = Z. 22
Instance FUNDCODE Error Where Instance.FUNDCODE is coded 4 then Instance.MODE must equal 63 or 64. 23
Instance FUNDCOMP Error Instance.FUNDCOMP must exist for institutions in England, Wales and Northern Ireland where Instance.REDUCEDI = 00 or 01. 1
Instance FUNDCOMP Error Instance.FUNDCOMP must not exist for institutions in Scotland. 2
Instance FUNDCOMP Error Instance.FUNDCOMP cannot be coded 3 where Instance.RSNEND is coded 01 - 11, 98 or 99. 3
Instance FUNDCOMP Error Where Instance.FUNDCOMP is 4, the institution must be in Wales and Instance.MODE must be 01, 02, 23, 24, 25, 52 or 53 and Course.COURSEAIM must not begin with D, L, P, Q, R, S or X 4
Instance FUNDLEV Error Instance.FUNDLEV must exist for institutions in England or Northern Ireland where Instance.REDUCEDI = 00 or 01. 1
Instance FUNDLEV Warning Instance.FUNDLEV should be coded 30, 31 or 99 by institutions in England or Northern Ireland where Course.COURSEAIM begins D or L. 2
Instance FUNDLEV Warning Instance.FUNDLEV should be coded 20, 21 or 99 by institutions in England or Northern Ireland where Course.COURSEAIM begins E or M (excluding M22, M26) or equals H50, H60, H61, H71, H78, H81, H88, I60, I61 and I81. 3
Instance FUNDLEV Warning Instance.FUNDLEV should be coded 10, 11 or 99 by institutions in England or Northern Ireland where Course.COURSEAIM begins H or I or equals M22 or M26. This rule is not applied when the Course.COURSEAIM is one of the following H50, H60, H61, H71, H78, H81, H88, I60, I61 and I81. 4
Instance FUNDLEV Error Instance.FUNDLEV must not exist for institutions in Scotland or Wales. 5
Instance FUNDLEV Error Instance.FUNDLEV must not be coded 10 or 11 by institutions in England or Northern Ireland where Course.COURSEAIM = D00, D01, E00. 6
Instance FUNDLEV Error Instance.FUNDLEV must not be coded 30 or 31 by institutions in England or Northern Ireland where Course.COURSEAIM = E00, E90 or begins M, H, I. 7
Instance FUNDLEV Error Instance.FUNDLEV must be coded 10, 11 or 99 by institutions in England or Northern Ireland where Course.COURSEAIM begins J, C. 8
Instance FUNDLEV Error Instance.FUNDLEV must be coded 20, 21 or 99 by institutions in England or Northern Ireland where Course.COURSEAIM = H61, I61 and Instance.FUNDCODE =1. 9
Instance FUNDLEV Warning Instance.FUNDLEV should not be coded 10 or 11 by institutions in England or Northern Ireland where Course.COURSEAIM begins M and is not M22 or M26. 10
Instance FUNDLEV Error For institutions in England, Instance.FUNDLEV must not be coded 11, 21 or 31 where Instance.MODE = 23 or 24 and Instance.LOCSDY = D or E. 11
Instance GLHRS Error Instance.GLHRS must exist for institutions in England or Wales where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00 or 02. 1
Instance GLHRS Error Instance.GLHRS must not exist for institutions in Northern Ireland or Scotland. 2
Instance GLHRS Error Instance.GLHRS must not exist for institutions in England or Wales where Instance.FESTUMK = 2. 3
Instance GLHRS Error Where Instance.GLHRS = 0, Course.COURSEAIM must be coded X41 - X46 (Welsh for Adults) 4
Instance GOVINIT Error Instance.GOVINIT must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00. 1
Instance GOVINIT Error Instance.GOVINIT must not exist for institutions not in England. 2
Instance GOVINIT Error Instance.GOVINIT must not exist for institutions in England where Instance.FESTUMK = 2. 3
Instance IMPRATE Error Instance.IMPRATE must exist for institutions in England where Instance.FESTUMK = 1,3 or 4 and Course.MSFUND = 86, 87, 88, AA, AB, AC or AD and Instance.REDUCEDI = 00. 1
Instance IMPRATE Error Instance.IMPRATE must not exist for institutions not in England. 2
Instance IMPRATE Error Instance.IMPRATE must not exist for institutions in England where Instance.FESTUMK = 2. 3
Instance INITIATIVES Error Instance.INITIATIVES must not exist for institutions in Northern Ireland or Scotland. 1
Instance INITIATIVES Error Where Instance.INITIATIVES is coded 3, 4 or 5 Institution.UKPRN must be 10000291, 10003861, 10006299, 10007138, 10007145, 10007150, 10007801 or 10007851. 2
Instance INITIATIVES Error Where there are two occurrences of Instance.INITIATIVES they must not be identical. 5
Instance INITIATIVES Error For institutions in England Instance.INITIATIVES must be coded 1 - 5 or B. 6
Instance INITIATIVES Error For institutions in Wales Instance.INITIATIVES must be coded 7. 7
Instance INITIATIVES Error Where Instance.INITIATIVES is coded 7 Institution.UKPRN must be 10007793 or 10007853. 8
Instance INITIATIVES Error Where Instance.INITIATIVES is coded B, Instance.COMDATE must be later than Y1-07-31 and Course.COURSEAIM must begin with H, I, J or C or equal M22 or M26. 9
Instance INSTCAMP Error Instance.INSTCAMP must exist and contain a valid full postcode structure or a valid outward postcode structure for institutions in Wales where Course.COURSEAIM is coded X41 to X46. 1
Instance ITTPHSC Error Instance.ITTPHSC must exist for institutions in England or Wales where Course.TTCID = 1, 2, 8 or F and Course.REDUCEDC = 00, 01, 04 or 07. 1
Instance ITTPHSC Error Instance.ITTPHSC codes 15 - 26 must have Course.TTCID = 1 or 8 and Instance.COMDATE (where exists) before 2002-08-01. 2
Instance ITTPHSC Error Instance.ITTPHSC codes 61 to 65 must be for an institution in Wales and have Instance.COMDATE > 2002-07-31. 3
Instance ITTPHSC Error Instance.ITTPHSC codes 71 - 81 must be for an institution in England where Instance.COMDATE (where exists) is after 2007-07-31. 4
Instance ITTPHSC Error Where Instance.ITTPHSC codes 53-57 are used and institution in Wales and Course.TTCID = 1 or 8, Instance.COMDATE (where it exists) must be after 2002-07-31. 5
Instance ITTPHSC Error Instance.ITTPHSC code 31 must have Course.TTCID = 2. 6
Instance ITTPHSC Error Instance.ITTPHSC must not exist for institutions in Northern Ireland or Scotland. 7
Instance ITTPHSC Error Instance.ITTPHSC must not exist for institutions in England or Wales where Course.TTCID = 0. 8
Instance ITTPHSC Error Where Instance.ITTPHSC codes 51-57 are used and institution in England and Course.TTCID = 1 or 8, Instance.COMDATE (where it exists) must be between 2002-08-01 and 2007-07-31. 9
Instance ITTPHSC Error Instance.ITTPHSC codes 51 and 52 must not be used by institutions in Wales. 10
Instance ITTPHSC Error Where Instance.ITTPHSC is coded 72 Instance.COMDATE must be before 2010-08-01. 12
Instance ITTPHSC Error Instance.ITTPHSC code 49 must have Course.TTCID = 2. 13
Instance ITTPHSC Error Instance.ITTPHSC must be coded in the range 71 - 81 where Course.TTCID = F 17
Instance ITTSCHMS Error Instance.ITTSCHMS must exist where the institution is in England or Wales and Course.TTCID = 1 or 2 and Instance.REDUCEDI = 00, 01 or 04 1
Instance ITTSCHMS Error Instance.ITTSCHMS must not exist for institutions in Northern Ireland or Scotland. 2
Instance ITTSCHMS Error Instance.ITTSCHMS must not exist where the institution is in England or Wales and Course.TTCID = 0. 3
Instance ITTSCHMS Error Instance.ITTSCHMS codes 1 or 3 must have an Instance.COMDATE earlier than 2007-08-01. 4
Instance ITTSCHMS Error Instance.ITTSCHMS code 6 must have Instance.ITTPHSC coded 72 - 77, and CourseSubject.SBJCA = R100, R200, R300 or R400. 5
Instance LEARNDIF Error Instance.LEARNDIF must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00. 1
Instance LEARNDIF Error Instance.LEARNDIF must not exist for institutions not in England. 2
Instance LEARNDIF Error Instance.LEARNDIF must not exist for institutions in England where Instance.FESTUMK = 2. 3
Instance LOADYRA Error Instance.LOADYRA must exist where Institution.INSTAPP is coded 1 and Instance.TYPEYR = 2, 3, 4 or 5 and Instance.REDUCEDI is not equal to '04' and Course.COURSEAIM does not begin D, L, P, Q, R, S, X. 1
Instance LOADYRA Error Instance.LOADYRA must not exist where Institution.INSTAPP is coded 0. 2
Instance LOADYRA Error Instance.LOADYRA must not exist for institutions in Scotland and Wales. 3
Instance LOADYRB Error Instance.LOADYRB must exist where Institution.INSTAPP is coded 1 and Instance.TYPEYR = 2, 3, 4 or 5 and Instance.REDUCEDI is not equal to '04' and Course.COURSEAIM does not begin D, L, P, Q, R, S, X. 1
Instance LOADYRB Error Instance.LOADYRB must not exist where Institution.INSTAPP is coded 0. 2
Instance LOADYRB Error Instance.LOADYRB must not exist for institutions in Scotland and Wales. 3
Instance LOCSDY Error Instance.LOCSDY must exist where Instance.REDUCEDI = 00 or 01. 1
Instance LOCSDY Error Instance.LOCSDY codes A - C, H - R must have Instance.FESTUMK = 1, 3 or 4 and the institution must be in England or Wales. 2
Instance LOCSDY Warning Instance.LOCSDY should be coded D or F where Instance.SPECFEE = 2 or 3. 3
Instance LOCSDY Error Instance.LOCSDY must not be coded D, E, or F where Instance.MODE is coded 01 and the institution is in England or Wales. 4
Instance LOCSDY Error Instance.LOCSDY must be coded F where Instance.MODE 52 or 53 and the institution is in England. 5
Instance LOCSDY Warning Instance.LOCSDY should not be coded D, E, F or G where Instance.MODE is coded 63 or 64. 6
Instance LOCSDY Error Instance.LOCSDY must be coded D, E, F or G where Instance.EXCHANGE is coded 7, B, C, D or E. 7
Instance LOCSDY Error Instance.LOCSDY must be coded D, E, F or G where Instance.SPECFEE = 1. 8
Instance LOCSDY Error Instance.LOCSDY must be coded D, E, F, G or X where Instance.EXCHANGE = Y. 9
Instance LOCSDY Error Instance.LOCSDY must be coded S or X where Instance.EXCHANGE = Z. 10
Instance LOCSDY Error Instance.LOCSDY must be coded S where both Instance.COMDATE and Instance.ENDDATE are in the current reporting year and Instance.RSNEND = 01 or 98 and Instance.EXCHANGE = Z. 11
Instance LOCSDY Error Instance.LOCSDY must be coded D, E or X where Instance.MODE = 23, 24 or 25. 12
Instance MCDATE Error Instance.MCDATE must exist for institutions in England or Northern Ireland and Course.COURSEAIM begins D, E, L or M (excluding M22, M26) and Instance.REDUCEDI = 00 or 04. 1
Instance MCDATE Error Instance.MCDATE must not be null except when ReasonForNull = 9. 2
Instance MCDATE Error Instance.MCDATE must be null when ReasonForNull = 9. 3
Instance MCDATE Error Where Instance.MCDATE is not null, it must be < Y1-08-02 for institutions in England and Northern Ireland where Course.COURSEAIM begins D, E, L or M (excluding M22, M26) and Instance.MODE = 63 or 64. 4
Instance MCDATE Error Instance.MCDATE must not exist for institutions in Scotland or Wales. 5
Instance MCDATE Error Where exists and is not null Instance.MCDATE must be later than Y1-07-31 unless Instance.MODE = 63 or 64. 6
Instance MCDATE Error Where exists and is not null Instance.MCDATE must be earlier than Y2-08-01. 7
Instance MCDATE Error Instance.MCDATE must not be null when Instance.MODE = 73 or 74. For further information please see the documentation in the coding manual - Further guidance on reporting Instance.MCDATE and Instance.MODE. 8
Instance MCDATE Error Where exists and not null Instance.MCDATE must be earlier than Instance.ENDDATE 9
Instance MODE Error Instance.MODE codes 12 - 14 and 32 - 37 must not be used by institutions in Scotland and Northern Ireland 1
Instance MODE Error Instance.MODE cannot be coded 63 or 64 where Instance.COMDATE is in the current reporting period (i.e. on/after 01-Aug-Y1). 2
Instance MODE Error Instance.MODE must be coded 01, 02, 31, 63, 64, 73 or 74 by institutions in England or Wales where Course.TTCID = 1 or 8. 3
Instance MODE Error Instance.MODE must be coded 12, 13, 14, 32, 33, 34, 35, 36, 37, 63, 64, 65, 67, 66, 68 or 69 by institutions in England or Wales where Instance.FESTUMK = 1 or 4. 4
Instance MODE Error Instance.MODE must not be coded 01 or 02 where Instance.FESTUMK is coded 1 or 4. 5
Instance MODE Error Instance.MODE cannot be coded 01 where Instance.REDUCEDI = 01. 6
Instance MODE Error Instance.MODE cannot be coded 01 by institutions in Scotland where Instance.YEARLGTH is completed but less than 24. 7
Instance MODE Error Instance.MODE cannot be coded 01 by institutions in England, Scotland or Northern Ireland where Instance.UNITLGTH = 3 and Instance.SPLENGTH = 01 to 23. 8
Instance MODE Error Instance.MODE cannot be coded 01 by institutions in England, Scotland or Northern Ireland where Instance.UNITLGTH = 2 and Instance.SPLENGTH = 01 to 05. 9
Instance MODE Error Instance.MODE cannot be coded 12, 13, 14, 32, 33, 34, 35, 36, 37, 65, 66, 67, 68 or 69 where Instance.FESTUMK = 2. 10
Instance MODE Error Institutions in Scotland cannot use code 31. 11
Instance MODE Error Institutions in England, Scotland and Northern Ireland cannot use code 67. 12
Instance MODE Error Institutions in Scotland and Northern Ireland cannot use codes 65, 66, 68 and 69. 13
Instance MODE Error When Instance.MODE codes 73 and 74 are used the institution must be in England and Course.COURSEAIM must begin with D, E, L or M (excluding M22, M26). 14
Instance MODE Error Instance.MODE must be coded 52 or 53 where Instance.LOCSDY is coded F and the institution is in England or Scotland. 15
Instance MODE Warning If Instance.SPECFEE = 1, then Instance.MODE should be coded 23 or 24 or 25. 16
Instance MODE Warning If Instance.SPECFEE = 2 or 3, then Instance.MODE should be coded 23, 52 or 53. 17
Instance MODE Error Instance.MODE must be coded 01, 02 or 25 for institutions in Wales where Instance.SPECFEE is coded 4 or 5. 18
Instance MODE Error Instance.MODE must be coded 02 or 25 for institutions in England, Scotland and Northern Ireland where Instance.SPECFEE is coded 4 or 5. 19
Instance MODE Error Instance.MODE must not be coded 23, 24 or 25 where Course.COURSEAIM is H16, I16, M16, M26 or M86 and the first character of CourseSubject.SBJCA is 'A' . 20
Instance MODE Error For institutions in England, Instance.MODE must be coded 31, 64 or 74 where Instance.SPECFEE = 6. 21
Instance MODE Error Instance.MODE must not be coded 01, 23 or 24 where Course.TTCID = F. 22
Instance MODE Error Instance.MODE must be coded 63 or 64 where all corresponding StudentOnModule.MODSTAT for that instance are coded 4. 23
Instance MODE Error Instance.MODE must not be coded 01, 23 or 24 where Instance.COMDATE > Y2-02-13 and Instance.ENDDATE is null and Instance.TYPEYR = 1. 24
Instance MODE Error Instance.MODE must not be coded 38 or 39 where the institution is in England, Northern Ireland or Wales. 25
Instance MSTUFEE Error Instance.MSTUFEE must exist where Instance.REDUCEDI = 00, 01 or 02. 1
Instance MSTUFEE Error Instance.MSTUFEE cannot be coded 07 where Instance.MODE = 01, 12, 23, 24 or > 39, 2
Instance MSTUFEE Error Instance.MSTUFEE code 96 must have Instance.FESTUMK = 1 or 4. 3
Instance MSTUFEE Error Instance.MSTUFEE cannot be coded 07 where Instance.MODE = 02, 13 or 25, Instance.UNITLGTH = 3 and Instance.SPLENGTH > 23. 4
Instance MSTUFEE Error Instance.MSTUFEE cannot be coded 07 where Instance.MODE = 02, 13 or 25, Instance.UNITLGTH = 2 and Instance.SPLENGTH > 05. 5
Instance MSTUFEE Error Instance.MSTUFEE must be coded 98 where Instance.EXCHANGE is coded 2, 8, 9 or A. 6
Instance MSTUFEE Error Instance.MSTUFEE must not be 71 where Instance.MODE is less than 40. 7
Instance MSTUFEE Warning Instance.MSTUFEE should not be coded 02, 03, 52 or 53 where (EntryProfile.DOMICILE exists and is coded XG). 8
Instance MSTUFEE Warning Instance.MSTUFEE should not be coded 02, 04, 52 or 54 where EntryProfile.DOMICILE exists and is coded XH. 9
Instance MSTUFEE Warning Instance.MSTUFEE should not be coded 03, 04, 53 or 54 where (EntryProfile.DOMICILE exists and is coded XF or XI). 10
Instance MSTUFEE Warning For institutions in Northern Ireland Instance.MSTUFEE should not be coded 11, 12, 13, 14, 15, 17, or 18. 11
Instance NHSEMP Error Instance.NHSEMP must exist for institutions in England where Course.COURSEAIM = M76, H76, I76 or J76 and Instance.REDUCEDI = 00 or 01. 1
Instance NHSEMP Error Instance.NHSEMP must not exist for institutions not in England. 3
Instance NONPAY Error Instance.NONPAY must not exist for institutions not in England. 2
Instance NONPAY Error Instance.NONPAY must not exist for institutions in England where Instance.FESTUMK = 2. 3
Instance NOTACT Error Instance.NOTACT must be 1 where Instance.MODE is 73 or 74 2
Instance NOUNTACH Error Instance.NOUNTACH must exist for institutions in England and Wales where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00. 1
Instance NOUNTACH Error Instance.NOUNTACH must not exist for institutions not in England and Wales. 2
Instance NOUNTACH Error Instance.NOUNTACH must not exist for institutions in England and Wales where Instance.FESTUMK = 2. 3
Instance NOUNTACH Error For institutions in Wales Instance.NOUNTACH must be coded 99 where Instance.NUMUNITS = 99. 4
Instance NUMHUS Error All Instance.NUMHUS for a Student.HUSID must be unique. 1
Instance NUMUNITS Error Instance.NUMUNITS must exist for institutions in England or Wales where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00. 1
Instance NUMUNITS Error Instance.NUMUNITS must not exist for institutions in Northern Ireland or Scotland. 2
Instance NUMUNITS Error Instance.NUMUNITS must not exist for institutions in England or Wales where Instance.FESTUMK = 2. 3
Instance NUMUNITS Error Instance.NUMUNITS must be greater than or equal to the value in Instance.NOUNTACH where Instance.PROGRESS is coded 6 and Instance.NUMUNITS is not coded 98 or 99. 4
Instance NUMUNITS Error For institutions in Wales Instance.NUMUNITS must be greater than zero and less than the value in Instance.NOUNTACH where Instance.PROGRESS is coded 7 and Instance.NUMUNITS is not coded 98 or 99. 5
Instance NUMUNITS Error For institutions in Wales Instance.NUMUNITS must be coded 0, 98 or 99 where Instance.PROGRESS is coded 8. 6
Instance NUMUNITS Error For institutions in Wales Instance.NUMUNITS must be coded 99 where Instance.NOUNTACH = 99. 7
Instance PHDSUB Error Instance.PHDSUB must exist where Instance.RCSTDNT is not 99 and Course.COURSEAIM = D00 or D01 and Instance.REDUCEDI = 00 or 04. 1
Instance PHDSUB Error Where Instance.PHDSUB exists then Course.COURSEAIM must = D00 or D01. 2
Instance PHDSUB Error Instance.PHDSUB must not be null except when ReasonForNull = 9. 3
Instance PHDSUB Error Instance.PHDSUB must be null when ReasonForNull = 9. 4
Instance PHDSUB Error Instance.PHDSUB must not be greater than Y2-07-31. 5
Instance PHDSUB Warning Where Instance.PHDSUB exists it should not be earlier than (Y1-2)-08-01 when Instance.MODE is not 63 or 64. 6
Instance PHDSUB Warning Where Instance.PHDSUB exists it should not be earlier than (Instance.COMDATE + 24 months) 7
Instance PHDSUB Error Instance.PHDSUB must not be earlier than Instance.COMDATE. 8
Instance PHDSUB Error Instance.PHDSUB must not be null with ReasonForNull = 9 when Instance.RCSTDNT is not 99 and Instance.REDUCEDI = 00 or 04, and at least one corresponding QualificationsAwarded.QUAL = D00 or D01. 9
Instance PHDSUB Warning Instance.PHDSUB is null where Instance.RCSTDNT is not equal to 99 and Instance.REDUCEDI = 00 or 04 and Course.COURSEAIM = D00 or D01 and Instance.MODE = 01, 02, 43, 63 or 73 and QualificationsAwarded does not exist and Instance.COMDATE is earlier than (Y2-5)-08-01. The Research Councils expect a full-time PhD student to submit their thesis within 5 years. 10
Instance PHDSUB Warning Instance.PHDSUB is null where Instance.RCSTDNT is not equal to 99 and Instance.REDUCEDI = 00 or 04 and Course.COURSEAIM = D00 or D01 and Instance.MODE = 31, 38, 39, 44, 64 or 74 and QualificationsAwarded does not exist and Instance.COMDATE is earlier than (Y2-10)-08-01. The Research Councils expect a part-time PhD student to submit their thesis within 10 years. 11
Instance PHDSUB Error Where Instance.PHDSUB exists and is not null it must be earlier than Instance.ENDDATE where Instance.RSNEND = 01. 12
Instance PROGRESS Error Instance.PROGRESS must exist for institutions in England or Wales where Instance.FESTUMK = 1,3 or 4 and Instance.REDUCEDI = 00 or 02. 1
Instance PROGRESS Error Instance.PROGRESS cannot be coded A, B, C or D by institutions in Wales. 2
Instance PROGRESS Error Instance.PROGRESS cannot be coded W or 6 by institutions in England. 3
Instance PROGRESS Error Instance.PROGRESS must be coded 9 where Instance.CSTAT = 1. 4
Instance PROGRESS Error Instance.PROGRESS cannot be coded 9 where Instance.CSTAT is coded 2, 3 or 4. 5
Instance PROGRESS Error Instance.PROGRESS must not exist for institutions in Northern Ireland or Scotland. 6
Instance PROGRESS Error Instance.PROGRESS must not exist for institutions in England or Wales where Instance.FESTUMK = 2. 7
Instance PROGRESS Error Instance.PROGRESS must be coded A, B or 7 for institutions in England where Instance.RSNEND is coded 01. 8
Instance PROGRESS Error Instance.PROGRESS must be coded 6 or 7 for institutions in Wales where Instance.RSNEND is coded 01. 9
Instance PROGRESS Error Instance.PROGRESS must be coded W where Instance.CSTAT = 4. 10
Instance QTS Error Instance.QTS must exist for institutions in England and Northern Ireland where Course.TTCID = 5 and Instance.REDUCEDI = 00, 01 or 04. 1
Instance QTS Error Instance.QTS cannot be coded 4 where (EntryProfile.QUALENT2 is coded 03 or 10) or EntryProfile.QUALENT3 is coded H11. 2
Instance QTS Error Instance.QTS cannot be coded 3 where (EntryProfile.QUALENT2 is coded 04, 37 - 98) or EntryProfile.QUALENT3 begins with P, Q, R or X (excluding X06). 3
Instance QTS Error Instance.QTS must not exist for institutions in Scotland or Wales. 4
Instance QTS Error Instance.QTS must not exist for institutions in England and Northern Ireland where Course.TTCID not = 5. 5
Instance QTS Warning Instance.QTS should not be coded 4 where EntryProfile.QUALENT3 is coded M71 or H71. 6
Instance RCSTDNT Error Instance.RCSTDNT must exist where Course.COURSEAIM begins D, E, L or M (excluding M22, M26) and Instance.REDUCEDI = 00 or 04. 1
Instance RCSTDNT Error Instance.RCSTDNT must not be coded 09. 2
Instance RECFEE Error Instance.RECFEE must exist for institutions in England where Instance.FESTUMK = 1, 3 or 4 and Instance.REDUCEDI = 00. 1
Instance RECFEE Error Instance.RECFEE must not exist for institutions in Northern Ireland or Scotland. 2
Instance RECFEE Error Instance.RECFEE must not exist for institutions in England and Wales where Instance.FESTUMK = 2. 3
Instance REDUCEDI Error Instance.REDUCEDI cannot = 01 or 02 for institutions in England where Instance.FESTUMK = 1. 1
Instance REDUCEDI Error Instance.REDUCEDI code 01 must be for an institution in England, Scotland or Northern Ireland. 2
Instance REDUCEDI Error Instance.REDUCEDI code 01 must have Instance.STULOAD less than or equal to 010.0. 3
Instance REDUCEDI Error Instance.REDUCEDI cannot = 02 for institutions in Wales where Instance.FESTUMK = 1. 4
Instance REDUCEDI Error Instance.REDUCEDI code 02 must have Course.MSFUND = 73-79, 83 or 85-89 and Instance.GLHRS less than 120. 5
Instance REDUCEDI Error Instance.REDUCEDI code 02 must have a Course.COURSEAIM beginning with P, Q, R, S or X. 6
Instance REDUCEDI Error Instance.REDUCEDI code 03 must have Instance.EXCHANGE = 2, 4, 8, 9 or A. 7
Instance REDUCEDI Error Instance.REDUCEDI code 04 must have Instance.MODE = 63 or 64. 8
Instance REDUCEDI Error Instance.REDUCEDI must be coded 00, 04 or 07 where Course.TTCID = F 10
Instance REDUCEDI Error Instance.REDUCEDI must be not be coded 07 at institutions in Northern Ireland, Scotland or Wales. 11
Instance RSNEND Error Instance.RSNEND must exist where Instance.ENDDATE is not null and Instance.REDUCEDI = 00, 01, 02, 04 or 07. 1
Instance RSNEND Error Instance.RSNEND must not exist where Instance.FUNDCOMP = 3. 2
Instance RSNEND Warning Instance.RSNEND should exist where QualificationsAwarded.QUAL exists. 3
Instance RSNEND Error Instance.RSNEND must be coded 01 where Instance.PROGRESS is coded A or B. 4
Instance RSNEND Error Instance.RSNEND must be coded 01 where Instance.PROGRESS is coded 6. 5
Instance SKEITT Error Instance.SKEITT must exist for institutions in England where (Course.REDUCEDC=07 or Course.TTCID = F) and Course.CTITLE does not begin SKEPLUS 1
Instance SKEITT Error Instance.SKEITT must not exist for institutions in Northern Ireland, Scotland or Wales. 2
Instance SKEITT Error Instance.SKEITT must not exist for institutions in England where Course.TTCID not equal to F. 4
Instance SKEITT Error Instance.SKEITT must not be coded 99999999 5
Instance SPECFEE Error Instance.SPECFEE must exist where Instance.REDUCEDI = 00 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X. 1
Instance SPECFEE Error For institutions in England, Northern Ireland and Wales if Instance.SPECFEE = 4 or 5 then Instance.ENDDATE must not be blank. 9
Instance SPECFEE Error Instance.SPECFEE must be coded 9 where Course.COURSEAIM = D00, D01 or D90. 10
Instance SPECFEE Warning For institutions in Scotland if Instance.SPECFEE = 4 or 5 then Instance.ENDDATE should not be blank. 11
Instance SPECFEE Error For institutions in England, Instance.SPECFEE must be coded 6 or 9 where Instance.MODE = 31 and Course.TTCID = 1 or 8. 12
Instance SPECFEE Error For institutions in England, Instance.SPECFEE cannot be coded 6 when Instance.COMDATE > 2010-08-31. 13
Instance SPECFEE Warning Instance.SPECFEE should be coded 9 when Instance.FUNDLEV = 30 or 31. 14
Instance SPLENGTH Error Instance.SPLENGTH must exist where Instance.REDUCEDI = 00, 01 or 02. 1
Instance SPLENGTH Error Where exists Instance.SPLENGTH must not be coded 99 by institutions in England where Instance.FESTUMK is coded 1 or 3. 2
Instance SPLENGTH Error Where exists Instance.SPLENGTH cannot be greater than 09 where Instance.MODE not equal to 63 or 64 and Instance.UNITLGTH =1. 3
Instance SPLENGTH Error Where exists Instance.SPLENGTH cannot be greater than 72 where Instance.MODE = 01, 02, 23, 24 or 25 and Instance.UNITLGTH = 2. 4
Instance SPLENGTH Error Instance.SPLENGTH must not be null except when ReasonForNull = 9. 5
Instance SPLENGTH Error Instance.SPLENGTH must be null when ReasonForNull = 9. 6
Instance ST13 Error Instance.ST13 must exist where the institution is in Wales and Instance.FESTUMK = 1 or 3 and Instance.REDUCEDI = 00. 1
Instance ST13 Error Instance.ST13 must not exist for institutions in England, Northern Ireland or Scotland. 2
Instance ST13 Error Instance.ST13 must not exist for institutions in Wales where Instance.FESTUMK = 2. 3
Instance STULOAD Error Instance.STULOAD must exist where Instance.REDUCEDI = 00, 01, 02 or 03. 1
Instance STULOAD Error Instance.STULOAD must be 0 where Instance.MODE = 63 or 64. 2
Instance STULOAD Error For institutions in Scotland, Instance.STULOAD must not be 0 where Instance.MODE = 01, 02, 23, 24, 25, 31, 52 or 53 and Instance.TYPEYR = 1 , unless Instance.LOCSDY = S. 3
Instance STULOAD Warning Instance.STULOAD should not be 0 where Course.COURSEAIM begins D or L and Instance.MODE = 01 or 02 and Instance.YEARSTU = 01, 02 or 03. 4
Instance STULOAD Warning Where Instance.REDUCEDI = 00 or 01 and Instance.MODE not equal to 63 or 64, Instance.STULOAD +100.0 is less than sum of Module.FTE for the student instance where StudentOnModule.MODSTAT not equal to 4: check modules linked to this instance. 5
Instance STULOAD Error Where Instance.REDUCEDI = 00 or 01, Instance.STULOAD must not be greater than 0 where sum of Module.FTE for the student instance is 0. 6
Instance STULOAD Error For institutions in England, Northern Ireland and Wales, Instance.STULOAD must not be 0 where Instance.MODE = 01, 02, 23, 24, 25, 31, 43, 44, 52, 53, 73 or 74, unless Instance.LOCSDY = S or Instance.EXCHANGE is coded 2, 4, 8, 9 or A. 7
Instance STULOAD Error For institutions in England, Instance.STULOAD must not be greater than 10.0 where Course.COURSEAIM begins D, E, L or M (excluding M22, M26) and Instance.MODE = 43 or 44 and ( Instance.MCDATE is null or is equal to Y1-08-01) 8
Instance STULOAD Error For institutions in Scotland, Instance.STULOAD must not be 0 where Instance.FTEMETHOD = 1 and Instance.MODE not equal to 51, 63, 64 and Instance.EXCHANGE not equal to 2, 4, 8, 9, A and Instance.LOCSDY not equal to S 9
Instance STULOAD Error For institutions in Scotland, Instance.STULOAD must not be 0 where Instance.FTEMETHOD = 2 and Instance.COMDATE > Y1-07-31 and Instance.MODE not equal to 51, 63, 64 and Instance.EXCHANGE not equal to 2, 4, 8, 9, A and Instance.LOCSDY not equal to S 10
Instance STULOAD Error For institutions in England and Northern Ireland Instance.STULOAD must equal the sum of Instance.LOADYRA + Instance.LOADYRB 11
Instance STULOAD Warning For institutions in England, Northern Ireland and Wales, Instance.STULOAD should be less than 100 where Instance.TYPEYR is not equal to 1 and Instance.COMDATE > Y1-07-31 12
Instance STULOAD Warning For institutions in England, Northern Ireland and Wales, Instance.STULOAD should be less than 100 where Instance.TYPEYR is not equal to 1 and Instance.ENDDATE > Y1-07-31 13
Instance TREFNO Error Instance.TREFNO must exist for institutions in England or Wales where the corresponding (QualificationsAwarded.OUTCOME = 1 and QualificationsAwarded.QUAL = H11 or I11) and Course.TTCID = 1 or 8 and Instance.REDUCEDI = 00 or 04. 1
Instance TREFNO Error Instance.TREFNO must not exist for institutions in Northern Ireland. 2
Instance TREFNO Warning Instance.TREFNO should exist for institutions in England or Wales where the corresponding (QualificationsAwarded.OUTCOME = 1 and QualificationsAwarded.QUAL = M71 or H71) and Course.TTCID = 1 or 8 and Instance.REDUCEDI = 00 or 04. 3
Instance TREFNO Error Instance.TREFNO must exist for institutions in Scotland where QualificationsAwarded.QUAL = H11 or I11 and Course.TTCID = 1 or 8 and Instance.REDUCEDI = 00 or 04. 4
Instance TREFNO Warning Instance.TREFNO should exist for institutions in Scotland where QualificationsAwarded.QUAL = M71 or H71 and Course.TTCID = 1 or 8 and Instance.REDUCEDI = 00 or 04. 5
Instance TYPEYR Error Instance.TYPEYR must exist where Instance.REDUCEDI = 00 or 01 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X. 1
Instance TYPEYR Error Instance.TYPEYR must be coded 1 or 2 by institutions in Scotland or Wales. 2
Instance TYPEYR Warning Instance.TYPEYR should not be coded 1 where Instance.FUNDCOMP = 3 unless the student is on a sandwich placement spanning a reporting year, but the normal programme of study is a standard year. 3
Instance TYPEYR Error Instance.TYPEYR must be coded 1 where Instance.COMDATE is greater than or equal to 1 August of the reporting period and Instance.ENDDATE (if not null) is less than or equal to 31 July of the reporting period and Instance.FUNDCOMP =1 and Instance.RSNEND = 01 or 98. 4
Instance TYPEYR Error Instance.TYPEYR must be coded 1 where Instance.COMDATE in range 01 August - 31 December (regardless of year) and Instance.ENDDATE in range 01 January - 31 July (regardless of year) and Instance.RSNEND is coded 01 or 98. 5
Instance TYPEYR Warning Instance.TYPEYR should not be coded 1 where Instance.FUNDLEV = 11, 21 or 31 and anniversary of Instance.COMDATE in academic year > 20 September and Instance.MODE = 01. 6
Instance TYPEYR Warning Instance.TYPEYR should not normally be coded 1 where Course.COURSEAIM begins D or L. 7
Instance UNITLGTH Error Instance.UNITLGTH must exist where Instance.REDUCEDI = 00, 01 or 02. 1
Instance UNITLGTH Error Instance.UNITLGTH cannot be coded 5 by institutions in England where Instance.FESTUMK = 1 or 3. 2
Instance UNITLGTH Error Instance.UNITLGTH code 9 must have Instance.SPLENGTH ReasonForNull = 9 3
Instance UNITLGTH Error Instance.UNITLGTH must be coded 9 where Instance.SPLENGTH ReasonForNull = 9 4
Instance YEARLGTH Error Instance.YEARLGTH must exist for institutions in Wales and Scotland where Instance.REDUCEDI = 00 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X. 1
Instance YEARLGTH Error Instance.YEARLGTH must be NULL and ReasonForNull = 9 where Instance.LOCSDY = D or F. 2
Instance YEARLGTH Error Instance.YEARLGTH must not exist for institutions in England or Northern Ireland. 3
Instance YEARPRG Error Instance.YEARPRG must exist where Instance.REDUCEDI = 00 or 01 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X. 1
Instance YEARPRG Warning Instance.YEARPRG code 0 should have Course.COURSEAIM beginning with H or I. 2
Instance YEARPRG Warning Instance.YEARPRG should be less than or equal to Instance.SPLENGTH where Instance.UNITLGTH = 1 and Instance.MODE < 40 and Instance.YEARPRG is not coded 99. 3
Instance YEARSTU Error Instance.YEARSTU must exist where Instance.REDUCEDI = 00 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X. 1
Instance YEARSTU Error Instance.YEARSTU value cannot be greater than the difference in years between 31 July of the reporting period and the 01 August before Instance.COMDATE. 2
Instance YEARSTU Error Instance.YEARSTU must not equal 1 where Instance.TYPEYR = 1 and Instance.COMDATE < Y1-08-01 and Instance.MODE is not equal to 63 or 64 3
Institution INSTAPP Error Institution.INSTAPP must exist for institutions in England. 1
Institution INSTAPP Error Institution.INSTAPP must not exist for institutions in Scotland and Wales. 2
Institution INSTAPP Error Institution.INSTAPP must exist for institutions in Northern Ireland where Instance.REDUCEDI = 00, 01, 03 or 04. 3
Module CRDTPTS Error Module.CRDTPTS must be coded 999 where Module.CRDTSCM = 9. 1
Module CRDTPTS Warning Module.CRDTPTS should be coded 999 where English or Northern Irish institution and Module.CRDTSCM = 7 or 8. 3
Module CRDTPTS Warning Module.CRDTPTS should contain a value greater than 0. 4
Module CRDTSCM Error Module.CRDTSCM cannot be coded 2 for institutions in England, Wales or Northern Ireland. 2
Module FTE Warning Module.FTE should contain a value greater than 0. 1
Module LEVLPTS Error Module.LEVLPTS must exist where Module.CRDTPTS does not = 999. 1
Module LEVLPTS Error Module.LEVLPTS codes D or E must be for an institution in Scotland. 2
Module MODLANG Error Module.MODLANG must exist for institutions in Wales, Scotland or Northern Ireland. 1
Module MODLANG Error Module.MODLANG must be 1 ,2 or 3 where any StudentOnModule.LANGPCNT is greater than 0. 2
Module MODLANG Error Module.MODLANG must not exist for institutions in England. 3
Module PCOLAB Error Module.PCOLAB must be greater than 0 where Module.TINST exists. 1
Module TINST Error Module.TINST must exist where Module.PCOLAB is greater than 0. 1
Module TINST Error Module.TINST must not exist where Module.PCOLAB is 0. 3
Module TINST Error Module.TINST must not be coded 4001 for institutions in England. 4
Module TINST Warning Module.TINST should not be coded 4003 or 4004 for institutions in England. 5
Module TINST Error Module.TINST must not equal Institution.UKPRN 6
ModuleSubject MODSBJP Error Sum across all occurrences of ModuleSubject.MODSBJP for a module must be between 99 and 101. 1
QualificationsAwarded CLASS Error QualificationsAwarded.CLASS must exist where QualificationsAwarded.QUAL = M22, M26, H00, H11, H16, H18, H22, H23, H24, H50, I00, I11, I16. 1
QualificationsAwarded CLASS Error QualificationsAwarded.CLASS code 04 must have Institution.UKPRN = 10007788. 2
QualificationsAwarded CLASS Error QualificationsAwarded.CLASS must be coded 01 - 11 where QualificationsAwarded.QUAL = H00, H11, H16, H18, H22, H23, H24, H50, I00, I11, I16. 3
QualificationsAwarded CLASS Error For institutions in England or Wales QualificationsAwarded.CLASS codes 51 - 90 must have QualificationsAwarded.QUAL beginning with P, Q, R, S or X. 4
QualificationsAwarded CLASS Error QualificationsAwarded.CLASS must be coded 07 - 11 where QualificationsAwarded.QUAL = I00, I11 or I16. 5
QualificationsAwarded CLASS Warning QualificationsAwarded.CLASS must exist where QualificationsAwarded.QUAL begins C, P, Q, R, S or X and Instance.FESTUMK is coded 1 or 3. 6
QualificationsAwarded CLASS Error QualificationsAwarded.CLASS must be coded 01 - 14 where QualificationsAwarded.QUAL = M22 or M26. 7
QualificationsAwarded OUTCOME Error QualificationsAwarded.OUTCOME codes 6 - 8, A and B must be for an institution in England. 1
QualificationsAwarded OUTCOME Error QualificationsAwarded.OUTCOME code C must be for an institution in Wales. 2
QualificationsAwarded OUTCOME Error QualificationsAwarded.OUTCOME must exist for institutions in England or Wales where Course.TTCID = 1 or 8. 3
QualificationsAwarded OUTCOME Error QualificationsAwarded.OUTCOME must not exist for institutions in Northern Ireland or Scotland. 4
QualificationsAwarded OUTCOME Error QualificationsAwarded.OUTCOME must not exist for institutions in England or Wales where Course.TTCID = 0. 5
QualificationsAwarded QUAL Error QualificationsAwarded.QUAL cannot be coded H16, I16, M16, M26 or M86 where the first two characters of CourseSubject.SBJCA = D1 or D2 and Institution.UKPRN does not equal 10007154, 10007786, 10007788, 10006842, 10007779, 10007790 or 10007794. 2
QualificationsAwarded QUAL Error QualificationsAwarded.QUAL cannot be coded H16, I16, M16, M26 or M86 where the first character of CourseSubject.SBJCA = A and Institution.UKPRN does not equal 10000886, 10007801, 10006840, 10007785, 10007786, 10007788, 10007143, 10007789, 10007792, 10007149, 10007767, 10007795, 10007796, 10006842, 10003270, 10003645, 10007775, 10007782, 10007784, 10007799, 10007154, 10007774, 10007157, 10007158, 10007806, 10007163, 10007167, 10007790, 10007794, 10007783, 10007803, 10007814, 10007852, 10007855, 10005343, 10007798, 10007141 or 10007161 3
QualificationsAwarded QUAL Error QualificationsAwarded.QUAL cannot be coded X00 where Scottish institution. 5
QualificationsAwarded QUAL Error QualificationsAwarded.QUAL must be coded M22, M26, H00, H11, H16, H18, H22, H23, H24, H50, I00, I11, I16, M86 where QualificationsAwarded.CLASS is coded 01 - 11. 6
QualificationsAwarded QUAL Error QualificationsAwarded.QUAL cannot begin D, E, L, M, H, I, J or C where Course.COURSEAIM begins P, Q, R, S or X. 7
QualificationsAwarded QUAL Warning QualificationsAwarded.QUAL should not begin D, E, L or M (excluding M22, M26) where Course.COURSEAIM begins H, I, J or C. 8
QualificationsAwarded QUAL Warning QualificationsAwarded.QUAL should not begin H or I where Course.COURSEAIM begins J or C. 9
QualificationsAwarded QUAL Error QualificationsAwarded.QUAL must be coded H90 where Course.TTCID = F 10
QualificationsAwarded QUAL Error QualificationsAwarded.QUAL must not be coded H71 or M71 where Course.TTCID = 0. 11
QualificationsAwarded TQGSEC Error QualificationsAwarded.TQGSEC must be coded 3 or 4 by institutions in Scotland or Northern Ireland where Course.TTCID = 2. 2
QualificationsAwarded TQGSEC Error QualificationsAwarded.TQGSEC must be coded 1 or 2 by institutions in Scotland or Northern Ireland where Course.TTCID = 1 or 2 and QualificationsAwarded.QUAL = H71, M71, H11 or I11. 3
QualificationsAwarded TQGSEC Error QualificationsAwarded.TQGSEC must not exist for institutions in Scotland or Northern Ireland where Course.TTCID = 0 or 5. 4
QualificationsAwarded TQGSEC Error QualificationsAwarded.TQGSEC must not exist for institutions in England or Wales. 5
QualificationsAwarded TQGSUB Error QualificationsAwarded.TQGSUB must exist for institutions in Scotland where QualificationsAwarded.TQGSEC = 2. 1
QualificationsAwarded TQGSUB Error QualificationsAwarded.TQGSUB must not exist for institutions in England, Wales or Northern Ireland. 2
QualificationsAwarded TQGSUB Warning QualificationsAwarded.TQGSUB should not be coded 360 by institutions in Scotland where QualificationsAwarded.TQGSEC = 2. 4
QualificationsAwarded TQGSUB Error When one or more instances of QualificationsAwarded.TQGSUB exists, one and only one instance's attribute Main must be set to "1". 5
QualificationsOnEntry QUALSBJ Warning QualificationsOnEntry.QUALSBJ code 'U01' (unknown subject) used more than once so may not be counted in the tariff score. 6
QualificationsOnEntry QUALSBJ Error QualificationsOnEntry.QUALSBJ must be coded 'WBA' where QualificationsOnEntry.QUALTYPE = 'WB'. 7
QualificationsOnEntry QUALSBJ Error QualificationsOnEntry.QUALSBJ must be coded 'T33' where QualificationsOnEntry.QUALTYPE = IE 8
QualificationsOnEntry QUALSBJ Error QualificationsOnEntry.QUALSBJ must be coded 'B29' where QualificationsOnEntry.QUALTYPE = ID 9
QualificationsOnEntry QUALTYPE Error QualificationsOnEntry.QUALTYPE = IE must only occur once. 1
QualificationsOnEntry QUALTYPE Error QualificationsOnEntry.QUALTYPE = WB must only occur once. 2
QualificationsOnEntry QUALTYPE Error There must be at least one occurrence of QualificationsOnEntry.QUALTYPE = LD where Instance.INITIATIVES = B. 3
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 1951 or later where QualificationsOnEntry.QUALTYPE is A. 1
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 1986 or later where QualificationsOnEntry.QUALTYPE is SS. 2
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 1987 or later where QualificationsOnEntry.QUALTYPE is A1 or AS. 3
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2000 or later where QualificationsOnEntry.QUALTYPE is H. 4
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2000 or later where QualificationsOnEntry.QUALTYPE is HK or IK. 5
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2000 or later where QualificationsOnEntry.QUALTYPE is I2. 6
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2000 or later where QualificationsOnEntry.QUALTYPE is K2, K3, K4. 7
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2001 or later where QualificationsOnEntry.QUALTYPE is CA or AC. 8
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2001 or later where QualificationsOnEntry.QUALTYPE is FA. 9
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2001 or later where QualificationsOnEntry.QUALTYPE is V1. 10
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2001or later where QualificationsOnEntry.QUALTYPE is AH. 11
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2002 or later where QualificationsOnEntry.QUALTYPE is AE. 12
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2002 or later where QualificationsOnEntry.QUALTYPE is FM. 13
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2002 or later where QualificationsOnEntry.QUALTYPE is FS. 14
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2002 or later where QualificationsOnEntry.QUALTYPE is V. 15
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2003 or later where QualificationsOnEntry.QUALTYPE is B. 17
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2003 or later where QualificationsOnEntry.QUALTYPE is BE. 18
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2008 or later where QualificationsOnEntry.QUALTYPE is OC (for Certificate). 19
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2008 or later where QualificationsOnEntry.QUALTYPE is OD (for Diploma). 20
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2003 or later where QualificationsOnEntry.QUALTYPE is OE (for extended diploma). 21
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2004 or later where QualificationsOnEntry.QUALTYPE is CO. 22
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2005 or later where QualificationsOnEntry.QUALTYPE is WB. 23
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2006 or later where QualificationsOnEntry.QUALTYPE is AD. 24
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be 2007 or later where QualificationsOnEntry.QUALTYPE is DA. 25
QualificationsOnEntry QUALYEAR Warning QualificationsOnEntry.QUALYEAR should be less than or equal to Instance.COMDATE year. 26
QualificationsOnEntry QUALYEAR Error Where Student.BIRTHDTE is not null and QualificationsOnEntry.QUALTYPE not coded M6, M7, M8, 6M, 7M or 8M, QualificationsOnEntry.QUALYEAR should be greater than (Student.BIRTHDTE + 13) years. 27
QualificationsOnEntry QUALYEAR Warning For institutions in England, Northern Ireland and Wales, where Student.BIRTHDTE is not null and QualificationsOnEntry.QUALTYPE is not coded M6, M7, M8, 6M, 7M, 8M or SS, QualificationsOnEntry.QUALYEAR should be greater than (Student.BIRTHDTE + 15) year 28
RAEData UOAPCNT Error For each Instance in which it occurs the sum of RAEData.UOAPCNT must equal 100. 1
Student BIRTHDTE Error Where exists Student.BIRTHDTE cannot be before (Y1-99)-08-01. 1
Student BIRTHDTE Warning Where exists Student.BIRTHDTE should be less than (Y1-20)-08-01 where Course.COURSEAIM = M71 or H71. 3
Student BIRTHDTE Warning Where exists Student.BIRTHDTE should be less than (Y1-17)-08-01 where Course.COURSEAIM = H11 or I11. 4
Student BIRTHDTE Warning Where exists Student.BIRTHDTE should be greater than (Y1-70)-07-31. 5
Student BIRTHDTE Error Where exists Student.BIRTHDTE must be less than (Y1-14)-08-01. 6
Student BIRTHDTE Error Student.BIRTHDTE must not be null except when ReasonForNull = 1. 8
Student BIRTHDTE Error Student.BIRTHDTE must be null when ReasonForNull = 1. 9
Student BIRTHDTE Error Where exists Student.BIRTHDTE must be < Y1-08-01 10
Student DISABLE Error Student.DISABLE must exist where any Instance.REDUCEDI = 00, 01 or 07. 1
Student DISABLE Warning Student.DISABLE should be coded 02-96 where Instance.DISALL exists. 2
Student DISABLE Error Student.DISABLE must not be coded 02, 03, 04, 05, 06, 07, 10, 11, 97, 98 or 99 where any Instance.COMDATE > 2010-07-31 3
Student ETHNIC Error Student.ETHNIC code 14 must be for an institution in Northern Ireland. 1
Student ETHNIC Error Student.ETHNIC must exist where (EntryProfile.DOMICILE exists and is coded XF, XG, XH, XI, XK, XL, GG, JE or IM) and Instance.REDUCEDI = 00, 01 or 07. 2
Student FNAMES Error Student.FNAMES must exist where any Instance.REDUCEDI = 00, 01 or 04. 1
Student FNAMES Error Student.FNAMES must not be null except when ReasonForNull = 9. 2
Student FNAMES Error Student.FNAMES must be null when ReasonForNull = 9. 3
Student FNAMES Error Student.FNAMES must not exist where Student.SURNAME does not exist. 4
Student HUSID Error Student.HUSID must not contain all zeros. 1
Student HUSID Error If characters 1-4 are not 0000 then chars 3-6 of Student.HUSID must be a valid INSTID plus 1000. 2
Student HUSID Error Student.HUSID must pass the checksum test given in the coding manual. 3
Student HUSID Error If characters 1-4 of Student.HUSID are not 0000 then characters 3-6 of Student.HUSID must not be 3001 when Instance.COMDATE is after 2007-07-31 (INSTID 2001 is invalid). 4
Student NATION Error Student.NATION must exist for institutions in England, Wales or Scotland where any Instance.REDUCEDI = 00 or 03 and Instance.COMDATE is on or after 2007-08-01. 1
Student NATION Error Student.NATION code XL must have Instance.COMDATE before 2007-08-01. 2
Student NATION Error Student.NATION code XC must have Instance.COMDATE before 2007-08-01 unless (EntryProfile entity exists and EntryProfile.UCASAPPID exists) or EntryProfile entity does not exist. 3
Student NATIOND Error Student.NATIOND must exist for institutions in Wales where any (EntryProfile.DOMICILE exists and is coded XI) and the corresponding Instance.REDUCEDI = 00 or 02 1
Student NATIOND Error Student.NATIOND must not exist for institutions in England, Northern Ireland or Scotland. 2
Student NATIOND Error Where there are two occurrences of Student.NATIOND they must not be identical. 3
Student NATIOND Error Where Student.NATIOND is coded R or U there must be only one occurrence of Student.NATIOND 4
Student SCN Error Student.SCN must pass the checksum test as shown in the coding manual. 1
Student SCN Error Student.SCN must exist where Instance.REDUCEDI = 00, 01, 02 or 04 and (EntryProfile.DOMICILE exists and is coded XH) and EntryProfile.UCASAPPID exists and Course.COURSEAIM begins H, I, J, C, P, Q, R or S. 2
Student SCN Error Student.SCN must exist for institutions in Scotland where Instance.REDUCEDI = 00 and (EntryProfile.DOMICILE exists and is coded XH) and Course.COURSEAIM begins H, I, J, C, P, Q, R or S. 3
Student SCN Error Student.SCN must not be null except when ReasonForNull = 1. 4
Student SCN Error Student.SCN must be null when ReasonForNull = 1. 5
Student SDEPEND Error Student.SDEPEND must exist for all students at institutions in Scotland where any Instance.REDUCEDI = 00 1
Student SDEPEND Error Student.SDEPEND must not exist for institutions in England, Northern Ireland or Wales. 2
Student SURNAME Error Student.SURNAME must exist where any Instance.REDUCEDI = 00, 01 or 04. 1
Student TTACCOM Error Student.TTACCOM must exist where a student has at least one instance where Instance.MODE = 01, 02, 23, 24 or 25 and Instance.REDUCEDI = 00 and Instance.LOCSDY not equal to S. 1
Student TTACCOM Warning Student.TTACCOM should not be coded 6 where Instance.LOCSDY = X. 2
Student TTPCODE Error Student.TTPCODE must exist where any Instance.LOCSDY does not equal 6, 9, D, F or S and the corresponding Instance.REDUCEDI = 00 or 07 unless institution in Wales and Course.COURSEAIM begins with P, Q, R, S or X. 1
Student TTPCODE Error Where exists Student.TTPCODE must not equal EntryProfile.POSTCODE where Student.TTACCOM = 1 or 9 and Course.COURSEAIM begins with H, I, J, C, P, Q, R, S or X or is M22 or M26. 2
Student TTPCODE Error Student.TTPCODE must not be null except when ReasonForNull = 1. 3
Student TTPCODE Error Student.TTPCODE must be null when ReasonForNull = 1. 4
Student TTPCODE Error Where exists Student.TTPCODE must contain: a valid full postcode structure or a valid outward postcode structure. 5
Student TTPCODE Error Student.TTPCODE must not be null when Student.TTACCOM = 1. 6
Student TTPCODE Warning Student.TTPCODE should not be null when Student.TTACCOM = 9. 7
Student TTPCODE Warning Where exists Student.TTPCODE should not equal EntryProfile.POSTCODE where Student.TTACCOM = 8. 8
Student UCASPERID Error Student.UCASPERID must exist where any EntryProfile.UCASAPPID exists and is a 4 character code. 2
Student ULN Error Student.ULN must pass the checksum test. 1
Student ULN Warning Student.ULN should not be the same as Student.UCASPERID 2
Student WELSSP Error Student.WELSSP must exist for institutions in Wales where any (EntryProfile.DOMICILE exists and is coded XI) and the corresponding Instance.REDUCEDI = 00 or 02. 1
Student WELSSP Error Student.WELSSP must not exist for institutions in England, Northern Ireland or Scotland. 2
StudentOnModule LANGPCNT Error StudentOnModule.LANGPCNT must exist for institutions in Scotland, Wales or Northern Ireland. 1
StudentOnModule LANGPCNT Error StudentOnModule.LANGPCNT must not exist for institutions in England. 2
StudentOnModule MODCOUNT Error StudentOnModule.MODCOUNT must exist for institutions in Wales unless Course.COURSEAIM begins with P, Q, R, S or X. 1
StudentOnModule MODCOUNT Error StudentOnModule.MODCOUNT must not exist for institutions in England, Scotland and Northern Ireland. 2
StudentOnModule MODID Error StudentOnModule.MODID must exist on Module.MODID 1
StudentOnModule MODID Error No more than 2 occurrences of identical StudentOnModule.MODID must exist for a single instance. 2
StudentOnModule MODID Warning There are 2 occurrences of identical StudentOnModule.MODID for a single instance. An instance should not be linked to the same module more than once in cases where a student is simply re-sitting examinations or assessment. 3
StudentOnModule MODOUT Error Institution in Wales cannot use StudentOnModule.MODOUT code 7. 1
StudentOnModule MODOUT Error StudentOnModule.MODOUT must be coded 6 where Welsh institution and StudentOnModule.MODSTAT = 3. 2
StudentOnModule MODOUT Error Institution not in Wales cannot use StudentOnModule.MODOUT code 3. 3
StudentOnModule MODOUT Error Institutions in Scotland or Wales cannot use StudentOnModule.MODOUT code C. 4
StudentOnModule MODOUT Error Where StudentOnModule.MODOUT = 3 and Course.COURSEAIM begins D, L, M, H, I, J or C, Instance.MODE must be coded 01, 23, 24, 52 or 53. 5
StudentOnModule MODSTAT Error StudentOnModule.MODSTAT cannot be coded 5 where institution is in Wales. 1
StudentOnModule MODYR Error StudentOnModule.MODYR must exist where Institution.INSTAPP =1 and Instance.TYPEYR = 2, 3, 4 or 5 and StudentOnModule.MODSTAT not coded 4 1
StudentOnModule MODYR Error StudentOnModule.MODYR must not exist where Institution.INSTAPP =0. 2
StudentOnModule MODYR Error StudentOnModule.MODYR must not exist for institutions in Scotland and Wales. 3

Contact Liaison by email or on 01242 211144.