employee changes- HRHISTORY

Sort:
You are not authorized to post a reply.
Author
Messages
Chesca
Veteran Member
Posts: 490
Veteran Member

    I am writing a custom program and I need to determine if an employee had any FTE, Standard hours, annual hours, union code changes prior to a pay period being processed. HR told me to look in the PAEMPOS table but I don't see anything in there or a flag that can identify the exact field that was changed. I can see an effective date that could have been for status change, pay rate change, FTE, etc. Should I bee looking in HRHISTORY instead? 

    Margie Gyurisin
    Veteran Member
    Posts: 538
    Veteran Member
      You can find that data in the HRHISTORY file provided history is turned on for those fields on the HR10.
      Karen Ploof
      Veteran Member
      Posts: 118
      Veteran Member
        If the fields have not been flagged to log to history on HR10, you will need to sort the multiple records from PAEMPPOS in descending order and determine whether a field value has changed. Tedious but doable.

        And you should go to HR10 and check the History box so they'll log in the future :-)
        jaherb
        Veteran Member
        Posts: 164
        Veteran Member

          As already stated, you will need to look at the HRHISTORY table for changes like this.  Hopefully they have the flag on the HR10 form checked.  You will also need to know the field number for each of these fields....    FTE is # 56, Union is # 21 and Standard Hours is # 68.

          You are not authorized to post a reply.