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) |
|