Field Audit Trail

The Field Audit Trail (FAT) makes it possible to track changes made to the database fields, when the changes were made, what the previous value was and which user made the change.

The FAT solution consists of the following components:

• FAT Server

  This standalone component runs on the same physical server as M3 BE and is part of the M3 Foundation delivery. One instance of the FAT Server can be installed for every M3 BE environment. It is not dependent on the running state of M3 BE. If the FAT Server is shut down for any reason, the auditing trail will continue to work as usual. However, the FAT Manager and 'Field Audit Trail. Display' (SES121) will stop functioning.

  The FAT Server is responsible for creating audits upon requests from the FAT Manager. It is also responsible for returning metadata on the audits as well as the data for field changes. The FAT Server uses a dedicated database schema in the M3 BE database where audit metadata is contained. The schema must be created manually for each M3 BE environment from LifeCycle Manager and configured in the file MOVEX.properties.

• FAT Manager

  This tool is used to create, modify, or view audits of M3 BE and is a part of M3 Foundation delivery. To run the FAT Manager, the FAT Server must be started. To save new or modified audits, the M3 BE environment must be stopped.

• The M3 BE programs, 'Field Audit Trail' (SES120) and 'Field Audit Trail. Display' (SES121).

  These programs request field data changes from the FAT Server. By clicking F9 on an audited field in any M3 BE program, you can display changes for the selected field.