Combined Compensation Template-Different point-in-time Salaries for Merit and Bonus calculations

[RRKUMAR]

Hi

We are using a Combined Compensation template with for running the Merit and Bonus(Variable Pay) cycle. The requirement is to run the Merit review on the most current/latest salary and the Bonus(Variable Pay) calculation on a point-in-time salary i.e say on 31st December 20XX effective salary.

Can this requirement be met using the approach of creating a custom MDF field and pulling the Annual salary into that field and then possibly filtering the same using Integration center ( as of 31st December 20XX) and then using this amount in Employee History file for Bonus calculation whilst pulling the current salary from the standard Compensation Information portlet?

Or should we consider using an Earning Table to capture the salary effective 31st December 20XX.

Or this possible at all using a Combined Template?

Any advice or suggestions will are welcome.

Thanks in advance

R Kumar

[xavierlegarrec]

if you create an ALCF field and import the salary into it then paste the ID of that ALCF into the VP summary it will give you the salary of the last eligible assignment which for most people should be 12/31.

That would be an easier design than MDF.

All the best,

Xavier

[RRKUMAR]

Thanks Xavier. Are you essentially saying that whilst the solution proposed by Lesley is good to calculate the bonus based on point in time salary, but for displaying this point in time salary on the Bonus form, we should consider using an ALCF field instead of an MDF field and populate that MDF field via Integration Centre filtering logic?

Ritesh

[lesleyr]

Sounds like you need to use the "Point in time calculation" functionality where you can set to pull the salary as of 12/31 for bonuses.

This will just apply to your Variable Pay, your merit process will still act as expected with the current salary.

[RRKUMAR]

Thanks Lesley for sharing this.

We also want to show the 31st December 20XX salary on the variable Pay form/worksheet.

For that should we use an MDF object and get Integration centre fill the 31st December 20XX values into an MDF field and then map it to a custom field within the Variable Pay? Essentially the requirement is to see both the current salary and the 31st December 20XX salary on the respective forms for Merit and Variable Pay within a combined template.

Look forward to hearing your views.