PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 8/2/2016 2:35 PM by  Chuck Parker
Identifying missing HRHISTORY records
 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
Basic Member
(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
    Veteran Member
    (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
    Basic Member
    (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
    Veteran Member
    (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
    Veteran Member
    (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
    Basic Member
    (15 points)
    Basic Member
    Posts:7


    Send Message:

    --
    7/20/2016 12:08 PM
    Thank you'll for the input!
    Chuck Parker
    Private
    Private
    New Member
    (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.