We do know about the option of integrating EC Salary Matrix with Compensation to generate Compa-Ratio. And then there is a possibility of a minor code change to make compensation module to calculate compa-ratio in a similar way as that of Employee Central for less than 1 FTE employees. But what happens when there is a business requirement to have default values when all attributes are unavailable. Will Employee central and compensation module work in a similar way? Let’s find that out.
Scenario 1: The Pay range table as shown below has all values maintained in the attributes and the Compa-Ratio works fine both in EC and Comp.
Pay Range Values:
All attribute values maintained in the Pay Range Table
EC Comp Ratio:
Correct Pay range getting picked up in EC
Compensation Form:
Correct Pay Range getting picked up in Compensation Form
Scenario 2: The Pay range table as shown below has some values missing in some of the attributes and a default value is maintained at the bottom. In such case, the compa-ratio in compensation form works fine and EC appears to pick up a random value. In this scenario, EC picks up the first possible choice by removing the last attribute and does not look for the default value maintained at the bottom of the table.
Pay Range Table
Few attribute values missing in the table
EC Compa Ratio:
EC picks up the first possible value of GR-08 and not the default value.
Compensation Form:
Compensation Form picks up the correct (default) value.
Scenario 3: The Pay range table as shown below has some values missing in some of the attributes and a default value is maintained at the top of the table. In such case, the compa-ratio in compensation form picks up random value while EC picks up the correct (default) value.
Pay Range Table:
Few attribute values missing in the table
EC Compa-Ratio:
EC now picks up the correct (default) value.
Compensation:
The form picks up random values.
Workaround Solutions:
- The best possible solution to manage the situation is to have all attribute values maintained in the Pay Range Table. Even, if we would like to manage the table with default values, we need to understand that every time we update the Pay range values, it is going to distort the order of the records, or a full purge is required in order to maintain the correct order in the Pay Ranges table.
- If it is practically not possible to maintain values for all possible combination, then it is preferred to have the salary range table maintained separately in Compensation (Action for All Plans) and calculate Compa-Ratio separately in EC and Compensation
- If the compa-ratio values are not required to be displayed in the Employee’s compensation information section, then the EC pay range values can be maintained with default values at bottom of the table and integrate it with the compensation Module.
If anyone else has any other possible solution to manage the situation, please share it in the comments section.