Table Auditing

This page displays the table name and description, and an Audit Enabled? setting for the table selected in the Table Auditing search page. This page was formerly called 'Data Dictionary'. Enabling table auditing will create a copy of a record or related item prior to any change or update, and store it in the audit table. If you want to use this copy in a report, make a custom view from the audit table.

For a few specific tables, you can also define custom fields.

Prerequisite

Table audit settings work with system preference audit settings - both must be enabled for audit capture.

Menu path: RME > System > Table Auditing (Search) > Table Auditing

Manage audit settings

• To enable auditing for a table, change the Audit enabled? field to Yes. This will only be applied if a system preference for auditing is enabled. Go to RME > System > System Preferences > System and set the Audit Settings. As a base, ensure that the Audit record create/update/delete setting is enabled. You can also choose other levels of audit settings.

• To disable auditing for a table, change the Audit enabled? to No. No copy of records or related items prior to changes or updates will be stored in the audit table.
If previously set to Yes, the audit table may have copied records before this setting was changed. The old copies can be used in a report via a custom view.

Audit Details toolbar option

The Audit Details option on the core record toolbar displays by default regardless of the audit setting in this page. When this toolbar option is clicked, details display about changes to the record or related item, including both who created it and when, and who last changed it and when.

Table Auditing

Manage audit settings

Audit Details toolbar option

Related topics