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?
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.