Identifying missing HRHISTORY records

Prev Go to previous topic

Go to next topic

Last Post 8/2/2016 2:35 PM by Chuck Parker

6 Replies

1 Subscribed to this topic

225 Subscribed to this forum

Sort:


You are not authorized to post a reply.

Author

Messages

TheDude
Payroll IS Analyst
Private

(15 points)
Basic Member
Posts:7

Send Message:

7/14/2016 5:35 PM
Just an FYI I'm new to the HR module, I primarily work with CM,PA,PR,LP. I'm trying to identify any discrepancies between HRHISTORY and PA54 regarding a particular user field. Doesn't PERSACTHST table flow directly to the HRHISTORY table? Any ideas what tables, etc. may be the best way to narrow down any variances? Thanks for any help!

Margie Gyurisin
Private
Private

(1434 points)
Veteran Member
Posts:538

Send Message:

7/14/2016 6:25 PM
It depends. I would think whether or not HRHISTORY is updated depends on your HR10 set up.

TheDude
Payroll IS Analyst
Private

(15 points)
Basic Member
Posts:7

Send Message:

7/14/2016 7:46 PM
I checked HR10 and was unable to locate user field settings. We do however have the history flag set in HR04.4 for that specific alphanumeric field in question.

The.Sam.Groves
Programmer Analyst
St Lukes Hospital

(265 points)
Veteran Member
Posts:89

Send Message:

7/14/2016 8:09 PM
If you are looking for user fields in HRHistory, remember that the field key is actually the 'real' key + 2000. So if you are looking for a user field with a field key of 96 - it'll be stored as 2096 in HRHistory.

The.Sam.Groves
Programmer Analyst
St Lukes Hospital

(265 points)
Veteran Member
Posts:89

Send Message:

7/14/2016 8:14 PM
Also, I'm sure you are aware of this, but PersActHst ties to HRHistory via the obj_id in the first which links to act_obj_id in the second (i.e. every tracked change caused by the action stored in PersActHst will be have the obj_id of that action stored in act_obj_id in its row in HRHistory)

TheDude
Payroll IS Analyst
Private

(15 points)
Basic Member
Posts:7

Send Message:

Chuck Parker
Private
Private

(3 points)
New Member
Posts:1

Send Message:

8/2/2016 2:35 PM
If the user field is changed with a PA52 action it will populate both PersActHst and HRHistory but if the changed is done on HR11 it will only populate HRHistory. Assuming history tracking is flagged on HR10.

You are not authorized to post a reply.