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):
AUDIT_OPRIDAUDIT_STAMPAUDIT_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.
No Comments