Audit Tables

The audit tables track changes and deletions made to your data at the database level. When enabled, updates and deletions to every type of record are tracked by the database and stored separately for faster querying and reporting. From the Audit Tables page, you can quickly produce reports that list exactly which fields were changed, along with who made the change, and when it was made.

By default, audit tables are disabled, with the exception of tables that support features like the Constituent History and the Revenue History. You should determine which tables you want to audit and explicitly enable auditing for those tables. Select here to view the tables with audit enabled by default.

Note: You can create a “Table Statistics” ad-hoc query to show you the size of tables, including audit tables, in your database. You can use this information to help determine when to purge certain audit tables to free up disk space. You can also set up a “Delete audit data” global change process. The process can be configured to purge audit table data from over a certain period of time ago, such as audit table data from more than three years ago.