Workforce Compensation - User defined columns - User Defined table
Content
My Client has the requirement to configure the custom configuration tables to load the business-specific information and use that data to perform the calculations and display it on the worksheets.
The table looks like this:
| Bonus Level | Type 1 | Type 2 | Type 3 | Total |
|---|---|---|---|---|
| First | 100 % | 0 % | 0% | 100 % |
| Second | 100% | 0% | 0% | 100 % |
| Third | 50% | 50% | 0% | 100 % |
| Fourth | 40% | 40% | 20% | 100 % |
| Fifth | 35% | 35% | 30% | 100 % |
| Sixth | 30% | 30% | 40% | 100 % |
| Seventh | 25% | 25% | 50% | 100 % |
| Business Unit | Allocation |
|---|---|
| Business Unit 1 | 100.6% |
| Business Unit 2 | 101.1% |
| Business Unit 3 | 78% |
| Business Unit 4 | 98% |
| Business Unit 5 | 20% |
Now, based on the combination of employees BU and the Bonus Level (DFF on Assignment page) I would have to look for the above tables and multiply the two values.
For instance, Employee is in "Business 1" and Bonus Level "First", now the calculation should be 100 %( from table 1 type 1) * 100.6%( from table 2 business unit1) and this information should be populated on the worksheets.
0