Compare info from previous result in WPBP ot new WPBP

[Natalia_Souza]

Hi Experts,

In my company, we use a PCR to calculate a complementary amount when there is a decrease in the base remuneration WT, for example, when an employee changes departments and the new department has a different remuneration base.

For example, an employee has a base remuneration of 1500 euros in IT0008. If they change to another position where the base remuneration is 1300 euros, the system will add WT 1010 with the difference of 200 euros to ensure the total remuneration remains the same.

Now, if there is a change in the base remuneration for this position (a promotion or a change in the salary within the same pay scale group/level), say from 1300 to 1400 euros, the additional payment in WT 1010 should be reduced by 75% of the increase. So, in this case, the employee’s new total remuneration would be:
                     1400    +    (200 - (0.75 * 100)) = 1525 euros.
New remuneration    +    (Adittional will be reduced by 75% of the increase, which is 100 euros). 

This PCR is already implemented, but the new requirement is to apply the reduction in the additional payment only when the salary increase is the result of a change in the pay scale group or level (IT0008 fields TRFGR or TRFST). If is it is not the case, the employee addtional payment will continue to be 200 euros. 

I have checked the table WPBP, but I’m struggling to find a way to compare the previous payroll WPBP info something like an "Old WPBP," to determine if the change is based on a change in pay scale groups/levels.

Could anyone guide me on how to implement this condition in the PCR or point me in the right direction to access and compare this information?

Thanks in advance for your help!

HCM Payroll 

[SteveBogner]

Hi Natalie - I don't think there is a standard operation that could be used to compare the previous WPBP and the current WPBP. You might have to create a custom operation to do this - it would compare the two tables and return a true/false to the variable key.