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 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should be P, Q, U, F, X or 'Pass' where QualificationsOnEntry.QUALTYPE is K2, K3, K4. | 4 | (Warning) | Where exists QualificationsOnEntry.QUALGRADE should 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 or 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, P where QualificationsOnEntry.QUALTYPE is O6. | 49 | (Error) | Where exists QualificationsOnEntry.QUALGRADE must be D, M1, M2, P1, P2, 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 | (Error) | Where exists QualificationsOnEntry.QUALGRADE should be *, A*, 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 (i.e. no tariff score). | 56 | (Warning) | QualificationsOnEntry.QUALTYPE is AC and QualificationsOnEntry.QUALGRADE is A,B,C,D,E (i.e. has no tariff score). | 57 | (Warning) | QualificationsOnEntry.QUALGRADE should be D, F, M, P, Q, U or X where QualificationsOnEntry.QUALTYPE is AB. | 58 | (Error) | QualificationsOnEntry.QUALGRADE must be P, Q, U or X where QualificationsOnEntry.QUALTYPE is AG. | 59 | (Warning) | QualificationsOnEntry.QUALGRADE should be P, Q, U or X where QualificationsOnEntry.QUALTYPE is AQ. | 60 | (Error) | QualificationsOnEntry.QUALGRADE must be A, B, C, D, E, Q, U or X where QualificationsOnEntry.QUALTYPE is CC. | 61 | (Error) | QualificationsOnEntry.QUALGRADE must be A, B, C, D, E, Q, U or X where QualificationsOnEntry.QUALTYPE is CD. | 62 | (Error) | QualificationsOnEntry.QUALGRADE must be A, B, C, D, E, Q, U or X where QualificationsOnEntry.QUALTYPE is CE. | 63 | (Error) | QualificationsOnEntry.QUALGRADE must be D, F, M, P, Q, U or X where QualificationsOnEntry.QUALTYPE is D6. | 64 | (Error) | QualificationsOnEntry.QUALGRADE must be D, F, M, P, Q, U or X where QualificationsOnEntry.QUALTYPE is D7. | 65 | (Error) | QualificationsOnEntry.QUALGRADE must be D, F, M, P, Q, U or X where QualificationsOnEntry.QUALTYPE is D8. | 66 | (Error) | QualificationsOnEntry.QUALGRADE must be C, D, F, P, Q, U or X where QualificationsOnEntry.QUALTYPE is EA. | 67 | (Error) | QualificationsOnEntry.QUALGRADE must be D, F, P, Q, U or X where QualificationsOnEntry.QUALTYPE is EI. | 68 | (Error) | QualificationsOnEntry.QUALGRADE must be P, Q, U or X where QualificationsOnEntry.QUALTYPE is EQ. | 69 | (Error) | QualificationsOnEntry.QUALGRADE must be D, M, P, Q, U or X where QualificationsOnEntry.QUALTYPE is FR. | 70 | (Warning) | QualificationsOnEntry.QUALGRADE should be D, F, P, Q, U or X where QualificationsOnEntry.QUALTYPE is FY. | 71 | (Error) | QualificationsOnEntry.QUALGRADE must be D, M, P, Q, U or X where QualificationsOnEntry.QUALTYPE is PL. | 72 | (Error) | QualificationsOnEntry.QUALGRADE must be P, Q, U or X where QualificationsOnEntry.QUALTYPE is HL. |
|