HR06 (Job Code) Changes

Author
Messages
Kelly H
Veteran Member
Posts: 167
Veteran Member

    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
    Posts: 118
    Veteran Member
      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"));
      ---