MT IPA: Getting Employee Audit History in IPA

 3 Replies
 1 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Quarantine
Basic Member
Posts: 24
Basic Member

    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
    Veteran Member
    Posts: 476
    Veteran Member
      I would think a DME Query to the table HRHISTORY, filtered by EFFECT_DATE and FLD_NBR and PRRATEHIST for pay rate
      Quarantine
      Basic Member
      Posts: 24
      Basic Member

        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
        Veteran Member
        Posts: 1127
        Veteran Member
          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