Audit/History tables
Several tables are used in conjunction together to create history logs, populate the activity log and provide content for journal fields in email notifications.
| Table | Notes |
|---|---|
| sys_audit | Static log from which history and activity logs are generated |
| sys_history_line* | Generated from the sys_audit table. Each entry represents a single change to a single field. |
| sys_history_set* | One entry represents a collection of sys_history_line entries for a single record. Aka this is the parent record for sys_history_line(s). |
| sys_journal_field | Table were journal entries are stored. This is the table used in email notifications that include content from journal fields. For example, if you include comments in an email notification, it comes from this table. |
*Generates when a record is accessed. If deleted, will regenerate next time the record or history of the record is accessed. Records are automatically removed 30 days after they are last accessed (via table cleanup).
Use the HistoryWalk API to access/manipulate the history tables via API.
