I've been asked to create a report that give employees previous rate of pay, current rate of pay and the date of last increase. The two latter parts are easy, but the first part is a bit more tricky. We don't have any "common" increase dates and so I can't pull the prior salary based on dates.
Since I cannot find a field where Lawson stores the % of the last increase, the "max" row in the payratehist, pactionhist, hrhistory etc. pulls the date of last increase along with the current salary.
Does anyone know a way around this?
Thx,
Oopss... my finger is faster than my thoughts..here are the sequence of tables used for the report:
EMPLOYEE --> PAEMPPOS --> JOBCODE --> PRRATEHIST --> PERSACTHST(to get the reason).