• Search Forums
    Advanced Search
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Time in a position

 3 Replies
 0 Subscribed to this topic
 24 Subscribed to this forum
Sort:
Author
Messages
charliewilliam
Basic Member
Posts: 16
Basic Member
New Poster
New Poster
Congrats on posting!
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
New Poster
New Poster
Congrats on posting!
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
New Poster
New Poster
Congrats on posting!
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.