PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 06/11/2020 8:58 PM by  David Williams
MT IPA: Getting Employee Audit History in IPA
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Quarantine
Developer
Private
Basic Member
(27 points)
Basic Member
Posts:13


Send Message:

--
06/08/2020 9:43 AM

    How do you get employee audit records into IPA if you are on MT? We need to check each employee if he was full time at any point in the year to check if he is eligible for benefits. What is the best way to get all employee audit records for a particular employee in IPA for things like relationshipstatus, payrate , hourly or  salary or SSN for a full year.

    I am not looking at as of date  values . i am looking for all  audit records in a calendar year for an employee for particular fields.

    Ragu Raghavan
    Private
    Private
    Veteran Member
    (1117 points)
    Veteran Member
    Posts:389


    Send Message:

    --
    06/08/2020 12:09 PM
    I would think a DME Query to the table HRHISTORY, filtered by EFFECT_DATE and FLD_NBR and PRRATEHIST for pay rate
    Quarantine
    Developer
    Private
    Basic Member
    (27 points)
    Basic Member
    Posts:13


    Send Message:

    --
    06/11/2020 11:39 AM

    PRRATEHIST is S3 . I am looking at Workassignment.payrate and similar such fields. Even otherwise employee status etc would be maintained in GHR.

    David Williams
    Private
    Private
    Veteran Member
    (3301 points)
    Veteran Member
    Posts:1111


    Send Message:

    --
    06/11/2020 8:58 PM
    Check the user guides for enabling the EmployeeTransactionHistory and EmployeeFieldHistory business classes in GHR. You have to select the fields (or all) that you want tracked and set up the system to refresh on a schedule.
    David Williams
    You are not authorized to post a reply.