How to get previous salary information in Fast Formula
Summary:
Using Compensation Default and Override FF can i get prior salary information?
Content (required):
I know that DBI CMP_ASSIGNMENT_SALARY...... has the current salary information for the current assignment. I'm trying to default a proration % in the FF and I need to see not just the current salary but prior salaries as well.
For example an employee got a Merit raise say 2/1/20. On 5/1/20 the employee got a promotion salary change. On 7/1/20 the employee got a market adjustment. Some how I need to get to each salary change since 2/1/20 and determine a proration % based on the type of salary change. The goal is all employees will have a proration % of 1.00 unless the employee is new hire/rehire or promotion/demotion. Can this be achieved via Contexts? or?