Increment of Last Pay Rate Change

 3 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
psfunkytek
Basic Member
Posts: 13
Basic Member

    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
    Posts: 3353
      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
      Posts: 239
      Veteran Member
        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
        Posts: 239
        Veteran Member

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