Sample FF for Bonus calculation in Workforce compensation
Summary
Sample FF for Bonus calculation in Workforce compensationContent
Hello experts,
Could you please share any sample FF / DBI to be used for bonus calculation requirement as mentioned below?
I am referring to DBIs from Doc ID 2491310.1
Requirement:
Bonus should be calculated based on number of days the employee is into each salary record (in Manage Salary page) and Job ID in Compensation cycle (1/1- 12/31).
Ex: Emp has Salary records as below
Dates Salary Amount
1/1/2019 - 3/31/2019 $100,000
4/1/2019 - 7/31/2019 $105,000
8/1/2019 - 12/37/4712 $120,000
Assignment records Job
7/1/2018 - 7/31/2019 J1
8/1/2019 - 12/31/4712 J2
Bonus amount calculation should be like
1/1/2019 -3/31/2019 10000 * ( 90 (no.of days) /365) * 10% ( for J1)
4/1/2019 - 7/31/2019 105000 * ( 122 /365) * 10 % (for J1)
Tagged:
0