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

HR06 (Job Code) Changes

 1 Replies
 1 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Kelly H
Veteran Member Send Private Message
Posts: 167
Veteran Member
7/25/2017 1:05 PM

How do you determine that a change has occurred on the HR06?  We have to do a changes only file to our ATS and cannot determine how to identify when a change has occurred on the Job Code (HR06).  

 

Our comp team currently does not change the effective date when they make a change to the job code, including inactivating it.  

Karen Ploof
Veteran Member Send Private Message
Posts: 118
Veteran Member
7/25/2017 2:06 PM
Assuming you've flagged the HR10 record for topic "JC" to log to history, changes are in the HRHISTORY file. Join it to the PADICT file on field number and select topic = "JC". Here's the SQL code from my microsoft access query.

Hope it helps. Karen

SELECT LPROD_HRHISTORY.DATE_STAMP, LPROD_PADICT.TOPIC, LPROD_HRHISTORY.COMPANY, LPROD_HRHISTORY.OBJ_ID, LPROD_HRHISTORY.FLD_NBR, LPROD_PADICT.ITEM_NAME, LPROD_HRHISTORY.BEG_DATE
FROM LPROD_HRHISTORY INNER JOIN LPROD_PADICT ON LPROD_HRHISTORY.FLD_NBR = LPROD_PADICT.FLD_NBR
WHERE (((LPROD_HRHISTORY.DATE_STAMP)>#7/1/2017#) AND ((LPROD_PADICT.TOPIC)="JC"));