Audit
Provides a change history of audited fields across modules. This view supports compliance tracking, troubleshooting, and record-level change review.
Table Specific Information
Select
When querying Audit, you can get Audit logs by specifying the Module name (this is required):
SELECT * FROM Audit WHERE Module = 'Contacts'
Allowed values for Module are: Accounts, KBDocuments, RevenueLineItems, Contacts, Opportunities, Leads
If you want to get Audit logs for a single Module Id, the Audit parent_id needs to be tied to the ID that belongs to the module, for instance:
SELECT * FROM Audit WHERE Module = 'Contacts' AND parent_id = '9d46a91c-43bf-11e8-a83c-0681183120c1'
Columns
| Name | Type | Description |
| Parent_Id | String | The unique identifier (Id) of the record that this audit entry is associated with. This field links the audit entry back to the original record for change tracking. |
| Date_Created | Datetime | The date and time when this audit record was created. This field supports historical tracking of changes within the system. |
| Created_By | String | The Id of the user who created this audit entry. This field identifies who initiated the change being recorded. |
| Created_By_Username | String | The username of the user who created this audit entry. This field provides a readable reference for the Created_By field. |
| Field_Name | String | The name of the field that is modified. This field identifies which specific data element is changed in the parent record. |
| Data_Type | String | The data type of the field that is modified, such as string, integer, boolean, or date. This field is used to interpret before and after values correctly. |
| Before_Value_String | String | The previous value of the modified field before the change occurs. This field supports auditing and rollback analysis. |
| After_Value_String | String | The new value of the modified field after the change occurs. This field shows the result of the modification. |
| Before | String | The prior stored value for the modified field, formatted for system use or internal processing. This field supports data comparison and integrity checks. |
| After | String | The current stored value for the modified field, formatted for system use or internal processing. This field supports consistent system-level representation. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Module | String | The name of the module that this audit entry is associated with. This field enables the system to group, filter, and report audit events by module context. |