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 as described in the record naming conventions). These three fields will uniquely identify your audit data. They are (in the order they should be put on the audit record):
- AUDIT_OPRID
- AUDIT_STAMP
- 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.
Further Information
- Record Audit (PSAdmin)
- Fine-Grained Auditing in PeopleSoft (PeopleSoft DBA Blog)