I'm sure you are aware that PeopleSoft has built in Field Level Auditing that allows you to track any adds, changes, or deletes to a specific field in a record.

 

This is good to use at times when you have a few fields that you need to track. But, what if you want to track changes to the entire record? In this case, you can use Record Level Auditing.

Implementing Record Level Audits

Record level audinting allows you to have separate audit tables dedicated to one database record. Follow the steps below to turn on record level auditing

Step one

Clone the record you wish to edit

Step two

Add the audit fields

AUDIT_OPRID

AUDIT_STAMP

AUDIT_ACTN

And make sure you check off the "system maintained" check mark on the record field properties

Step three

Delete fields that won’t be audited

Step Four

Remove all key structures

Step five

Save and build the record

Step six

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.