PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 07/25/2017 10:06 AM by  Karen Ploof
HR06 (Job Code) Changes
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Kelly H
Private
Gordon Food Service
Veteran Member
(361 points)
Veteran Member
Posts:163


Send Message:

--
07/25/2017 9:05 AM

    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
    Private
    Private
    Veteran Member
    (317 points)
    Veteran Member
    Posts:113


    Send Message:

    --
    07/25/2017 10:06 AM
    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"));
    You are not authorized to post a reply.