Tables and modules created by an archive rule

The first time you activate an archive rule, it performs the following actions:

  • Creates the archive table in the database. The archive table has the same name as the primary table with an "ar_" prefix. For example, if you archive the Incident [incident] table, then the archive table is [ar_incident].
  • Converts multiple joined tables into a single flat-file archive table. The archive table no longer consists of a base and extended tables.
  • Converts reference field values (values set by references to records in other tables) into string values. The archive record contains the display value of the reference field at the time of the archive.
  • Adds a module to the Archive Tables list in the System Archiving application. The module name is a combination of the word "Archive" plus the display name for the archived table. For example, the archive module for the Attachment [sys_attachments] table is Archive Attachment. Click the module name to view records in the archive table.
  • Creates a list of the archive table using the default list view.
  • Creates a form for the archive table using the default form view. The form excludes any dot-walking fields such as Caller ID.Email.
  • Creates an activity formatter and variable formatter if they exist for the table being archived.
Figure 1. Conversion of Multiple Joined Tables into a Flat Archive Table