Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

Time in a position

Sort:
You are not authorized to post a reply.
Author
Messages
charliewilliam
Basic Member
Posts: 16
Basic Member
7/19/2010 1:56 PM
    Hi All,

    I have a request to calculate the length of time an employee has been in his/her position. I need to consider promotions, demotions, new hires. I am not sure which table(s) to start with...

    Could someone point me in the right direction?

    Thanks in advance,

    CW
    mark.cook
    Veteran Member
    Posts: 444
    Veteran Member
    7/19/2010 3:25 PM
      Do you use personel actions to process these transactions? If so you can use the PERSACTHIST table to pull out those actions with dates of the transactions.
      charliewilliam
      Basic Member
      Posts: 16
      Basic Member
      7/19/2010 3:39 PM
        Yes, Personel Actions are used to process these transactions. I did look at PERSACTHIST but didn't see how just a change in the jobcode can be pulled. Can you suggest a formula?

        CW
        Ruma Malhotra
        Veteran Member
        Posts: 412
        Veteran Member
        7/19/2010 3:52 PM
          To look at a change in any field that is processed by a personnel action and to know what the before image and after image to a field is you will have to look at 2 tables which are PERSACTHST and HRHSITORY. There is a field number field in HRHISTORY that refers to the actual field that was changed. The same can be seen on PA54 or HR54 to kno what field number is the actual field referring to in the HRHISTORY table.
          You are not authorized to post a reply.