Prev
Next
Forums Lawson S3 HR/Payroll/Benefits

Effective Date & System Change Date

Sort:
You are not authorized to post a reply.
Author
Messages
MARIA O.
Basic Member
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
    Posts: 538
    Veteran Member
    1/27/2014 12:38 PM
      I believe you want to look in the HRHISTORY table.
      Margie Gyurisin
      Veteran Member
      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
        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.
          You are not authorized to post a reply.