cancel
Showing results for 
Search instead for 
Did you mean: 

Reduce the number of lines in Variable Pay History File

RRKUMAR
Explorer
0 Kudos
342

Hi

We are building a Variable Pay solution that pulls a host of data from Job Information and Compensation Information from EC and builts the Variable Pay Background element. This then creates the Variable Pay History file.

We have noticed that due to data changes in Job Information and also Compensation information, a number of line items are being created in the Variable Pay History file, some of these fields are informational only and not necessary contribute to the calculation of Annual Incentive(Bonus). This in turn is contributing to data/information overload in the Assignment/details view.

Tried looking up the following blog written by Xavier Le Garrec on it and performed the steps but it did not have the desired effect.

  • #2 – Know how to control the number of records that show in employee history by using the Merge criteria in the varPayEmpHist background element.

Would like to understand how can we resolve this situation. Should we completely drop the information only fields from the Variable Pay Background element and then the no changes for these objects/fields will result in additional lines in VP History file or is there any approach that can work.

Please note that our solution is being built using a custom formula that takes into account the salary as of 31st Dec only for all bonus schemes throughout the calendar year. Normal salary changes happen during the mid-year and then as the "Salary" field has changed it itself automatically generates two undesired line items.

We can consider dropping the "Salary" field completely from VP Background element as the calculation is being done on "31st Dec Salary" field which is being pulled from an independent MDF field in Compensation information.

Any help or suggestions are most welcome.

Thanks

R Kumar

Accepted Solutions (1)

Accepted Solutions (1)

pmacgovern
Product and Topic Expert
Product and Topic Expert

The history file should ideally contain only fields that contribute to the bonus calculation, but a few extra information fields are expected. However, any change to these fields will trigger a new line of employee history. The Salary field sounds like a prime candidate for elimination.

I am not sure what help you are after, as it sounds like you understand the cause of the problem and what to do about it. There is no secret hidden trick, unfortunately.

Answers (1)

Answers (1)

Fernando_Silva
Participant
0 Kudos

Hi! I would either remove the Salary field from the variable pay MDF or review the merge flag settings for the Salary field. Remember that the merge MDF property works kinda backwards: it must be false for the module not to create a new row whenever changes in the mapped field are detected.

RRKUMAR
Explorer
0 Kudos

Thanks Fernando!