Audit Records


If you are creating an audit record, there are normally three fields that need to go at the start of the audit record (remember to use the AUDIT_ prefix). These three fields will uniquely identify your audit data. They are (in the order they should be put on the audit record):

  1. AUDIT_OPRID
  2. AUDIT_STAMP
  3. AUDIT_ACTN

The audit stamp field is a date/time field. However in order for it to be correctly populated, make sure that you set it to Auto-Update so that it is automatically set to the correct date/time stamp.

If you are using the same audit record for multiple records then add the field AUDIT_RECNAME. Ensure that this is system maintained and this will tell you which record the audit action relates to.


Revision #1
Created Thu, Jul 18, 2019 6:00 PM by PeopleSoft Wiki
Updated Thu, Jul 18, 2019 6:01 PM by PeopleSoft Wiki