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 Send Private Message
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 Send Private Message
Posts: 477
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 Send Private Message
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 Send Private Message
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