• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

Increment of Last Pay Rate Change

 3 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
psfunkytek
Basic Member Send Private Message
Posts: 13
Basic Member
3/25/2008 1:01 AM

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,

John Henley
Send Private Message
Posts: 3351
3/25/2008 12:04 PM
You would need to write some clever SQL (I'm assuming you're doing this in Crystal?) that would pull back the two most recent records from PRRATEHIST and compute the difference.
Thanks for using the LawsonGuru.com forums!
John
Sam Simpson
Veteran Member Send Private Message
Posts: 239
Veteran Member
3/25/2008 1:45 PM
Pay history is a bit tricky to get using crystal. In healthcare employees can bounce around different jobs and hence has different job codes, pay rates
etc. Position level determines which one is the primary vs secondary and so on. I have used 4gl to extract pay history from the following tables.
Sam Simpson
Veteran Member Send Private Message
Posts: 239
Veteran Member
3/25/2008 1:52 PM

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).