Section 1
SELECT rules.*,
-- BBAction_c
DECODE(Rule_Number,
1, 'MAV_DIR_BB_ACTION_1000',
2, 'MAV_DIR_BB_ACTION_1003',
3, 'MAV_DIR_BB_ACTION_1001',
4, 'MAV_DIR_BB_ACTION_1003',
5, 'MAV_DIR_BB_ACTION_1003',
6, 'MAV_DIR_BB_ACTION_1003',
7, 'MAV_DIR_BB_ACTION_1003',
8, 'MAV_DIR_BB_ACTION_1003',
9, 'MAV_DIR_BB_ACTION_1003',
10, 'MAV_DIR_BB_ACTION_1003',
99, 'MAV_DIR_BB_ACTION_1002',
11, 'MAV_DIR_BB_ACTION_1002',
NULL
) AS "BBAction_c",
-- BBReasonCode_c
DECODE(Rule_Number,
1, 'MVA_DIR_BB_REASON_1018',
2, 'MVA_DIR_BB_REASON_1001',
3, 'MVA_DIR_BB_REASON_1018',
4, 'MVA_DIR_BB_REASON_1001',
5, 'MVA_DIR_BB_REASON_1001',
6, 'MVA_DIR_BB_REASON_1001',
7, 'MVA_DIR_BB_REASON_1001',
8, 'MVA_DIR_BB_REASON_1001',
9, 'MVA_DIR_BB_REASON_1001',
10, 'MVA_DIR_BB_REASON_1001',
99, 'MVA_DIR_BB_REASON_1001',
11, 'MVA_DIR_BB_REASON_1027',
NULL
) AS "BBReasonCode_c",
-- BBMPAComment_c
DECODE(Rule_Number,
1, 'Full BB is pre-approved by system as the rep is active sale rep within the defined threshold limits (BB % HR TI ≥ -5% and ≤ 5%). Pre-approved not applicable for Austria country.',
2, 'Full CED put on Hold by system as the rep is on LOA with positive or negative CED amount. PENDING analyst to review and action.',
3, 'Full CED is pre-approved by system as the rep is terminated within the defined threshold limits of CED amount (CED > 0 and ≤ 10 USD). Pre-approved not applicable for Austria country.',
4, 'Full CED put on Hold by system as the rep is terminated within the defined threshold limits of CED amount (CED > 0 and ≤ 10 USD). PENDING analyst to review and action.',
5, 'Full CED put on Hold by system as the rep is terminated within the defined threshold limits of CED amount (CED > 10 USD). PENDING analyst to review and action.',
6, 'Full CED put on Hold by system as the rep is terminated with negative CED amount. PENDING analyst to review and action. Payroll collection not applicable for Romania country.',
7, 'Full CED put on Hold by system as the rep is terminated with negative CED amount. PENDING analyst to review and action. Consider Payroll collection, if negative CED amount is final.',
8, 'Full CED put on Hold by system as the rep moved to non-sales role with positive CED amount. PENDING analyst to review and action.',
9, 'Full CED put on Hold by system as the rep moved to non-sales role with negative CED amount. PENDING analyst to review and action. Payroll collection not applicable for Romania country.',
10, 'Full CED put on Hold by system as the rep moved to non-sales role with negative CED amount. PENDING analyst to review and action. Consider Payroll collection if negative CED amount is final. Rep''s consent NEEDS to be attached for such case.',
11, 'Zero BB is pre-approved by system for active sale rep',
99, 'Full BB put on Hold by system as the rep is active sale rep OVER the defined pre-approved BB threshold limits (BB % HR TI ≥ -5% and ≤ 5%). PENDING analyst to review and action.',
NULL
) AS "BBMPAComment_c",
-- MPAReasonCode_c
DECODE(Rule_Number,
1, NULL,
3, NULL,
'MAV_DIR_MPA_CODE_1008'
) AS "MPAReasonCode_c",
-- MPAGenerated_c
DECODE(Rule_Number,
1, NULL,
2, (-1) * CED_c,
3, NULL,
4, (-1) * CED_c,
5, (-1) * CED_c,
6, (-1) * CED_c,
7, (-1) * CED_c,
8, (-1) * CED_c,
9, (-1) * CED_c,
10, (-1) * CED_c,
99, (-1) * BeginningBalance_c,
NULL
) AS "MPAGenerated_c",
-- ExpectedPaymentAmount_c
DECODE(Rule_Number,
1, NULL,
3, NULL,
99, TO_NUMBER(RULES.PTDEarnings_c),
0
) AS "ExpectedPaymentAmount_c",
-- MPAStatus_c
DECODE(Rule_Number,
1, NULL,
3, NULL,
'Auto approved'
) AS "MPAStatus_c",
-- RecoverableFlagV1_c
DECODE(Rule_Number,
1, NULL,
3, NULL,
'Y'
) AS "RecoverableFlagV1_c"
FROM (
Comments
Post a Comment