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

Popular posts from this blog

Section 15-Done

Section 16-Done

Section 13-Done