Skip to Content
0
Jan 12, 2022 at 03:19 AM

How to update employee's salary when Forward Propagation happens in Job Info?

596 Views

Happy New Year!!

My customer uses FTE and Pay Scale Level to ‘derive’ the employee’s salary – we are using business rules assigned in Job Info to ‘derive/calculate’ the employee’s salary and it works without issues.

If there is a future dated record for the employee, and a Pay Scale Level change occurs, the Forward Propagation updates the future dated Job Info record but the Compensation Information details does not get updated (because Forward Propagation does not trigger business rules).

E.g.

Pay Scale Level A = $100

Pay Scale Level B = $120

Employee’s Job Info records:

.. 12 Jan 2022 – FTE = 0.5 – Pay Scale Level = A

.. 20 Mar 2022 – FTE = 1 – Pay Scale Level = A

Employee’s Comp Info records:

.. 12 Jan 2022 – Salary = $50

.. 20 Mar 2022 – Salary = $100

Take Action is executed with Start Date = 20 Jan 2022 and the Pay Scale Level is now changed to B – this is how the records look after the Take Action:

Employee’s Job Info records:

.. 12 Jan 2022 – FTE = 0.5 – Pay Scale Level = A

.. 20 Jan 2022 – FTE = 0.5 – Pay Scale Level B

.. 20 Mar 2022 – FTE = 1 – Pay Scale Level = B (Forward Propagation updates the Pay Scale Level of the future dated record)

Employee’s Comp Info records:

.. 12 Jan 2022 – Salary = $50

.. 20 Jan 2022 – Salary = $60

.. 20 Mar 2022 – Salary = $100 -à this is now incorrect – the salary as of 20 Mar 2022 should be $120

Is there a technical solution to address this scenario? I am aware that the customer could execute the ‘Adjust Employees’ Compensation to Tariff Changes’ prior to running Payroll, but I am seeking better solutions for this please? This scenario is very common for my customer!

Am I missing any specific configuration to address this scenario?

I am trying a few different options using Off Cycle Event Batch (OCEB) but have not come up with a ‘perfect’ result yet.

Thanks in advance for any help you can provide!

Kind regards

Cristiana