Audit [sysaudit] Table

The Audit table retains comprehensive historical data for all records indefinitely, allowing administrators to track all audited record changes over time. However, as the volume of audit records grows, querying this table directly becomes inefficient.

History Set [syshistoryset] and History [syshistoryline] Tables

• The History Set table identifies specific records from audited tables that have historical data, while the History table stores the actual field value changes.
• These tables hold a recent subset of history relevant to records for which users have created or requested history, rather than the complete audit history.
• History Sets include additional data such as journal field entries made during record creation, showing them with the same timestamp and creator as the record itself.
• To manage storage, History Sets are automatically cleaned if not updated within 30 days, and the system uses table rotation among four History tables every seven days, ensuring a maximum retention period of 21 days.
• If older historical data is needed, it can be regenerated from the Audit table.
• The user interface accesses History Set data for displaying history, providing the same data view as Audit records but in a more efficient format.

Key Outcomes

• Administrators can rely on the Audit table for complete, long-term historical tracking.
• Users benefit from faster and more efficient access to recent history via History Sets and History tables.
• Data retention policies ensure optimal system performance while preserving the ability to regenerate older history if required.