• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

Identifying missing HRHISTORY records

 6 Replies
 1 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
TheDude
Basic Member Send Private Message
Posts: 7
Basic Member
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
Veteran Member Send Private Message
Posts: 538
Veteran Member
7/14/2016 6:25 PM
It depends. I would think whether or not HRHISTORY is updated depends on your HR10 set up.
TheDude
Basic Member Send Private Message
Posts: 7
Basic Member
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
Veteran Member Send Private Message
Posts: 89
Veteran Member
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
Veteran Member Send Private Message
Posts: 89
Veteran Member
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
Basic Member Send Private Message
Posts: 7
Basic Member
7/20/2016 12:08 PM
Thank you'll for the input!
Chuck Parker
New Member Send Private Message
Posts: 1
New Member
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.