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

Effective Date & System Change Date

 3 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
MARIA O.
Basic Member Send Private Message
Posts: 9
Basic Member
1/24/2014 5:55 PM
I want to select records for a Crystal report based on change date, if personnel actions were not used.  I saw a previous post that indicated the effective date on HR11 is field 267.  I want to display the two fields on a Crystal report.  Does anyone know if they are in the EMPLOYEE table, or are they maintained in the HRHISTORY table?  Thank you.
Margie Gyurisin
Veteran Member Send Private Message
Posts: 538
Veteran Member
1/27/2014 12:38 PM
I believe you want to look in the HRHISTORY table.
Margie Gyurisin
Veteran Member Send Private Message
Posts: 538
Veteran Member
1/27/2014 12:39 PM
That same data can most likely be queried via HR65 and reported via HR70 or HR170.
MARIA O.
Basic Member Send Private Message
Posts: 9
Basic Member
1/27/2014 7:39 PM
Thanks.  I went with the system change date in the HRHISTORY table and got the desired results.