How to Implement Record level Audit in Peoplesoft
Record level auditing allows you to have separate audit tables dedicated to one database record.
Below are the steps to turn on record level auditing
1) Clone the record you wish to edit
2) Add the audit fields: (Key Fields)
AUDIT_OPRID
AUDIT_STAMP
AUDIT_ACTN
And make sure you check off the "system maintained" check mark on the record field properties
3) Delete fields that won’t be audited
4) Remove all key structures
5) Save and build the record
6) Link the base record to the audit record
Open- original record definition
Now all of your changes for that record will be tracked in the new audit record you just created.
Posts
