Understanding when audit records are moved between tables

Audit records are initially stored in the MAP_EVENT table. Records in this table can be accessed through the Administration Tools Event Viewer. Records are only stored in this table for a short amount of time before being moved to the MAP_EVENT_AUDIT table.

You can control the timing of events through the following tables:

Table	Field	Specifies
MVF_TS_MODULE_CONFIG	MAP_EVENT_DAYS	The number of days current audit records are kept in the MAP_EVENT table. By default, records are kept one day.
MVF_TS_CONFIG	CLEAN_MAP_EVENT	How often event records are moved from the MAP_EVENT table to the MAP_EVENT_AUDIT table. By default, expired records are moved every day beginning at 2 A.M.

Audit record workflow

1. At the specified times, MVF Task Scheduler moves all records to the MAP_EVENT_AUDIT table except those whose date_time_created falls within the start of the current day minus MAP_EVENT_DAYS.

   For example, if MAP_EVENT_DAYS is 1 and today is Thursday, all records except those from Wednesday and Thursday are moved to the MAP_EVENT_AUDIT table.

2. When MVF Task Scheduler has finished transferring records from the MAP_EVENT table to the MAP_EVENT_AUDIT table, an event is recorded in the MAP_EVENT tab table with an event_type of EVENTS_MOVED.