Record Level Auditing

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.

转载于:https://www.cnblogs.com/GoDevil/archive/2009/01/09/1372631.html