| Business rules | | 1 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be Band 1 or Band 2 where QualificationsOnEntry.QUALTYPE is SS | | 2 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be D, M, U, Q, X, 'Distinction', 'Merit' where QualificationsOnEntry.QUALTYPE is AE | | 3 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be P, Q, U, F, X or 'Pass' where QualificationsOnEntry.QUALTYPE is K2, K3 or K4 | | 4 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be a*, A*, A, A1, A2, B, B3, B4, C, C5, C6, D7, F, X, U, Q where QualificationsOnEntry.QUALTYPE is I2 | | 5 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be A, A1, A2, B, B3, B4, C, C5, C6, D, D7, F, X, U, Q where QualificationsOnEntry.QUALTYPE is AH | | 6 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be a*, A*, A, A1, A2, A3, A4, A5, B, B3, B4, B6, B7, C, C5, C6, C8, C9, D, D7, F, X, U, Q where QualificationsOnEntry.QUALTYPE is H | | 7 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be A, B, C, D, E where QualificationsOnEntry.QUALTYPE is CA | | 8 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be A, B, C, D, E (can all be followed by #, d, m or p), N, Q, U, U#, X, X# where QualificationsOnEntry.QUALTYPE is A | | 9 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be A, B, C, D, E (can all be followed by #, d, m or p), Q, U, U#, X, X# where QualificationsOnEntry.QUALTYPE is A1 or AS | | 10 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be A, B, C, D, E, Q, U, U#, X where QualificationsOnEntry.QUALTYPE is FM | | 11 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be A, B, C, D, E, U, X, Q where QualificationsOnEntry.QUALTYPE is FS | | 13 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be A, B, C, D, E, U, X, Q (can all be followed by #) where QualificationsOnEntry.QUALTYPE is V | | 14 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be A, B, C, D, E, U, X, Q (can all be followed by #) where QualificationsOnEntry.QUALTYPE is V1 | | 15 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be A1, A2, B1, B2, B3, C1, C2, C3, D1, D2, D3, E, F where QualificationsOnEntry.QUALTYPE is IL | | 16 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be A1, A2, B1, B2, B3, C1, C2, C3, D1, D2, D3, E, F where QualificationsOnEntry.QUALTYPE is IO | | 17 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be AA, AB, BB, BC, CC, CD, DD, DE, EE, U, UU, X, XX, Q, QQ (can also contain all combinations involving # for example AA#, A#B#) where QualificationsOnEntry.QUALTYPE is AD | | 18 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be AA, AB, BB, BC, CC, CD, DD, DE, EE, U, UU, X, XX, Q, QQ (can also contain all combinations involving # for example AA#, A#B#) where QualificationsOnEntry.QUALTYPE is DA | | 19 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be AA, AB, BB, BC, CC, CD,DD, DE, EE, U, X, Q, UU, XX, QQ (can also contain all combinations involving # for example B#C#, DE#) where QualificationsOnEntry.QUALTYPE is V2 | | 20 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be AA, BB, CC, DD, EE, A, B, C, D, E where QualificationsOnEntry.QUALTYPE is AC | | 21 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be D, M, P, F where QualificationsOnEntry.QUALTYPE is 6M, 7M, 8M, M6, M7, M8 | | 22 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be P, F where QualificationsOnEntry.QUALTYPE is OC (for Certificate) | | 23 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be D, M, P, DD, DM, MM, MP, PP, DDD, DDM, DMM, MMM, MMP, MPP, PPP, X, Q, U where QualificationsOnEntry.QUALTYPE is B | | 24 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be D, M, P, DD, DM, MM, MP, PP, DDD, DDM, DMM, MMM, MMP, MPP, PPP, X, Q, U where QualificationsOnEntry.QUALTYPE is BE | | 25 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be P, F where QualificationsOnEntry.QUALTYPE is OD (for Diploma) | | 26 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be D1, D2, M1, M2, M3, P1, P2, P3 where QualificationsOnEntry.QUALTYPE is OE (for extended diploma) | | 27 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be P where QualificationsOnEntry.QUALTYPE is HK or IK | | 28 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be P, F, X, Q, U where QualificationsOnEntry.QUALTYPE is WB | | 30 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be P, M, D, Distinction, Merit or Pass where QualificationsOnEntry.QUALTYPE is FA | | 32 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be A, B, C, D, E (can all be followed by #, d, m, p, u) where QualificationsOnEntry.QUALTYPE is SP | | 33 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be A, B, C, D, E, F, M, P, Q, U, X where QualificationsOnEntry.QUALTYPE is AI | | 34 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be A*, a* where QualificationsOnEntry.QUALTYPE is I1 | | 35 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be P, X, U, Q where QualificationsOnEntry.QUALTYPE is ND or NC | | 36 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be A1, A2, B3, B4, C5, C6, D7, F, P, X, Q, U where QualificationsOnEntry.QUALTYPE is SW | | 37 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be H1, H2, H3, H4, H5, H6, H7, HN, HP where QualificationsOnEntry.QUALTYPE is IB | | 38 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be A, B, C, D, E, N, P where QualificationsOnEntry.QUALTYPE is IC | | 39 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be 0, 1, 2, 3, +1, +2, +3, FC, N, P, X, Q, U where QualificationsOnEntry.QUALTYPE is ID | | 40 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be a 2-digit number in the range 16 - 45, X, Q, U, or 0 [zero] where QualificationsOnEntry.QUALTYPE is IE | | 41 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be B, D, F, P, W, X, Q, U where QualificationsOnEntry.QUALTYPE is IF | | 42 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be S1, S2, S3, S4, S5, S6, S7, SN, SP where QualificationsOnEntry.QUALTYPE is IS | | 43 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be EA, EB, EC, ED, EE, EN, EP where QualificationsOnEntry.QUALTYPE is IX | | 44 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be P, F, Q, X, U where QualificationsOnEntry.QUALTYPE is K1 | | 45 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be P, F, Pass or Fail where QualificationsOnEntry.QUALTYPE is CO | | 46 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be A, B, C, D, E, U, Q, X where QualificationsOnEntry.QUALTYPE is FD | | 47 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be S, 1, 2, 3, U, X, Q where QualificationsOnEntry.QUALTYPE is ST | | 48 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be D, M or P where QualificationsOnEntry.QUALTYPE is O6 | | 49 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be D, M1, M2, P1, P2 or P3 where QualificationsOnEntry.QUALTYPE is OT | | 50 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be AA, AB, BB, BC, CC, CD,DD, DE, EE, U, X, Q, UU, XX, QQ where QualificationsOnEntry.QUALTYPE is 9U | | 51 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be A, B, C, D, E, Q, U, X where QualificationsOnEntry.QUALTYPE is EP | | 52 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be A, B, C, D, E, S, Q, U, X where QualificationsOnEntry.QUALTYPE is H1 | | 53 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be A, B, C, D, E, S, Q, U, X where QualificationsOnEntry.QUALTYPE is H2 | | 54 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be D, M, P, Q, U, X where QualificationsOnEntry.QUALTYPE is H3 | | 55 | (Warning) | QualificationsOnEntry.QUALTYPE is IE and QualificationsOnEntry.QUALGRADE is less than 24 (ie. no tariff score) | | 56 | (Warning) | QualificationsOnEntry.QUALTYPE is AC and QualificationsOnEntry.QUALGRADE is A, B, C, D or E (ie. no tariff score) |
|
