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 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):

  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.

Further Information

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License