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

[crisdagosto]

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

[crisdagosto]

Just providing more info to the reason as to why I am having trouble using Off Cycle Event Batch - if I could find away to retrieve the correct Comp Info record when running the OCEB, then I am pretty sure my 'solution' for this issue would work.

As I said in my original question, we have business rules in place to calculate/derive the employee’s salary based on FTE and Pay Scale Level.

In my Off Cycle Event Batch rule, I need to check if the Salary stored in Comp Info is what it should be based on the Pay Scale Level assigned to the Job Info record.

I have created the Off Cycle Event Batch rule based on Job Information.

The idea is that the rule assigned to Off Cycle Event Batch will check if the Salary assigned in Comp Info needs to be updated based on the details of the Job Info record (FTE and Pay Scale Level). If the amount stored in Comp Info is not correct (because Forward Propagation updated the Job Info Pay Scale Level) then the rule will create a new Comp Info record; and then a rule assigned to on Save of Comp Info will create the correct Pay Component Recurring entry.

OCEB rule is executed > all future dated Job Info records are retrieved > OCEB rule reads the Job Info record and checks if the correspondent Comp Info has the correct Amount > if the correspondent Comp Info record does not have the correct Amount then new Comp Info record is created and rule on Save of Comp Info calculates the new Salary (in the OCEB rule one can only use one object; ie. the rule cannot have the updated of Comp Info and Pay Comp Recurring)

When the OCEB is executed, the Comp Info record that is retrieved is based on the day that the OCEB is running, not based on the Job Information Start Date.

E.g.

Employee’s Job Info records:

.. 10 Jan 2022 to 22 Apr 2022 – FTE = 0.5

.. 23 Apr 2022 to 31 Dec 9999 – FTE = 1

Employee’s Comp Info records:

.. 10 Jan 2022 to 22 Apr 2022 – Salary = $50

.. 23 Apr 2022 to 31 Dec 9999– Salary = $100

When OCEB runs and retrieves the Job Info record that starts on 23 Apr 2022, it retrieves the Comp Info data from the record 10 Jan 2022 to 22 Apr 2022 (because OCEB is using the OCEB’s execution date). I need to be able to retrieve the Comp Info record that starts of 23 Apr 2022/

I am not sure if the reason why I can't do that is because I am using OCEB...?

How can I update the rule assigned to OCEB so it retrieves the correct Comp Info record?

As I am limited to use Job Info in the OCEB, the rule uses Job Info > Employment Details > Pay Component Recurring where Pay Component = Salary (1001).

Any amazing ideas would be much appreciated! Sorry for the long post - this issue is driving me crazy!

[Rahul4]

Hi Christina,

This could be achieved through enabling For "Enable Forward Propagation for Compensation Information " from Company System and Logo Setting.

but i have concern while searching for it i saw your article,

If a employee has 2 pay components X & Y in compensation say from 1st March'23, but if user does a back dated salary change let say 1st Feb'23 and only Pay Component X was available in before 1st March'23 records.

after change in back dated salary information, only X pay component get updated for future records with new value (amount) but not the Y Pay component.