Title: Tracking Changes
Description: Tracking User ID, Date/Time, for Payroll
snbcchic1 - April 19, 2006 10:27 PM (GMT)
Where can I find an audit trail for Payroll changes? Examples include PR82, PR35.2, etc. I looked in the corresponding tables and could not find the information. Is this a "coming soon" feature? I would think it would be necessary for auditing...other than on the PRRATEHIST table.
cjmart - April 20, 2006 02:41 PM (GMT)
Check HRHISTORY. You'll need to reference PADICT/PADICT2 to decipher what item the field number (HRHISTORY.FLD_NBR) is referring to...
Milo - April 20, 2006 10:03 PM (GMT)
The audit trail in HRHISTORY doesn't appear "by magic" -- you have to turn it on field by field! This allows you to control how much tracking you want to deal with in HRHISTORY.
I'm not a payroll expert, so perhaps checking the Payroll User's Guide will direct you to the right place. I looked quickly and found HR04.1, which allows you to turn on history for various User Fields. I know that there's another screen which allows you to turn on history for all of the other fields mentioned in PADICT and PADICT2, but I don't remember which one it is. (Might be HR10.1 -- Data Item Attributes.)
cjmart - April 21, 2006 04:42 AM (GMT)
HR10.1 it is. There is a History drop-down that must be set to "Log Changes" to initiate a trail. If you want to check which data items you currently are recording historical changes on, you can look in PASCRTY (the db table for HR10.1) at the LOG_FLAG field. You can join this to PADICT (on fld_nbr and topic) to get the item description. Also in PADICT is the table prefix (ie EMP for EMPLOYEE), located in the DB_FILE field. I believe that the LOG_AVAIL_FLAG field will tell you if history even can be enabled for the data item, but you'll want to verify that. Combined with CTRL-SHIFT-O in Portal for the fields you want an audit trail on, this should give you the tools to 1) identify the table/fields you want an audit trail on 2) determine if history is (or even can be) enabled and 3) identify the field numbers for these fields in order to pull the trail from HRHISTORY.
This goes without saying, but setting the History flag does not work retroactively. Only changes made after selecting "Log Changes" will be available in history.
SAH - April 21, 2006 09:59 AM (GMT)
You can also query PRTIME and TIMERECORD, depending on where in the pay cycle you want to pull the information. We've used different combinations with PAYMASTR and PRDISRIB, and been moderately successful - good news is Lawson is adding additional tracking in 9.0 Unfortunately, your HR10 info won't help you here - B)
Good luck!