RetroPayments Calculation for Benefits in Oracle Payroll
Hello,
I have an requirement to calculate retro-payments for Benefits based on the below logic.This is for US Payroll:
Business Scenario:
1.Employee Joining date:01-Jan-2008
2.Dental Benefit Enroll ment Date: 01-Apr-2008.
3.Payroll:Monthly
4.Coverage Amount/Deduction Amount:50
This Dental Benefit is a deduction with category as Voluntary deductions.When the payroll for this employee is processed in the month of April that ie on 30-Apr-2008, the arrears for the dental element should be calculated as
the number of payroll periods missed*amount that i.e in this case the employee was eligible for this benefit right from Jan however he is enrolled in Benefit only in April,so the deduction amount from Jan-Apr that is 50*4 should be put in Arrears bucket.
I have an requirement to calculate retro-payments for Benefits based on the below logic.This is for US Payroll:
Business Scenario:
1.Employee Joining date:01-Jan-2008
2.Dental Benefit Enroll ment Date: 01-Apr-2008.
3.Payroll:Monthly
4.Coverage Amount/Deduction Amount:50
This Dental Benefit is a deduction with category as Voluntary deductions.When the payroll for this employee is processed in the month of April that ie on 30-Apr-2008, the arrears for the dental element should be calculated as
the number of payroll periods missed*amount that i.e in this case the employee was eligible for this benefit right from Jan however he is enrolled in Benefit only in April,so the deduction amount from Jan-Apr that is 50*4 should be put in Arrears bucket.
Tagged:
0