Salary Planning Proration Calculation Using Employee Hire Date

[erikwolfer]

We would like to know if it is possible to accurately calculate the proration % based on the Hire Date of the employee for our Salary Planning cycle. Our planning cycle dates are 1/1/2023 thru 12/31/2023. If employeeA is hired after 1/1/2023 the proration is working fine. If employeeB is hired prior to 1/1/2023, then the proration is calculating to a value greater than 100%. I have attached a screen shot of the salary Proration settings . Do we need to add a formula within the worksheet field to force the start date to default to 1/1/2023 when the employee Hire Date is earlier than 1/1/2023? Some additional history; in prior years we would manually load a custom field "Last Merit date" based on every employee's Hire Date. So basically for every employee with a Hire date earlier than the current year's cycle start date (1/1/2023 in this case), we just hard coded the Last Merit Date to 1/1/2023 and the proration would calculate as expected to 100%. For any employees hired after 1/1/2023, we simply populated the Last Merit Date field with the Hire Date. The business is asking if we can bypass the process of updating the Last Merit date field and just make use of the employee Hire date.

[erikwolfer]

Hi Xavier, appreciate the quick response. Looks like you are spot on regarding the value in the XML -

-<proration-calc useFor="salary">

-<date-proration-calc useHireDateAsStartDate="true" canExceedReviewPeriod="true" reviewEndDate="2023-12-31" reviewStartDate="2023-01-01">

<no-rounding/>

</date-proration-calc>

I will share this with our AMS partner and have them update it.

Thanks,

Erik Wolfer

[xavierlegarrec]

hi ewolfer

Could you please export the template xml from Plan Setup > Advanced Settings then check what is the value for the following tag : "canExceedReviewPeriod". It should be set to False if you want the proration to be capped at 100. A certified compensation consultant or even SAP support through a ticket can make that change pretty quickly for you (it is not available in Admin UI yet).

From: https://blogs.sap.com/2021/06/17/fte-and-proration-examples-in-compensation/

All the best

Xavier