Audit Trail

The Audit Trail keeps track of changes to the records in Training Manager. This log was implemented in version 1.0.1176, and it is turned on by default. Actions taken before the audit trail was implemented were not logged. It can only be turned off by a person in the "System Administrator" role. To turn the audit trail logging feature on or off, click the "Options" button on the Report tab, and then select the "Audit Trail" tab.

To view the Audit Trail, select the Audit Trail report on the main "Reports" tab. Use the date filters located below the report list to limit the time frame of the report, or filter by Source, Action, Record Type, or Person who made the change using the filter fields located above the report preview area.

You may also export the raw audit trail log data using the menu option Tools --> Export.

Field Name

Description

Timestamp

The date/time when the record was changed displayed in local time.

Source

The source of the change.

•	Data Entry: Changes made using the Training Manager data entry forms.

•	Import: Changes made using the Training Manager import process.

•	System Update: Changes made by a system update.

Action

The type of action which was taken.

•	Add New: A new record was added to the database.

•	Update: An existing record was updated in the database.

•	Delete: A record in the database was deleted.

•	Turn ON: The audit trail log was turned on.

•	Turn OFF: The audit trail log was turned off.

Record Type

The type of record which was modified.

•	Course: A master course record.

•	Class Session: A class session record.

•	Personnel: A master personnel record.

•	Assignment: An assignment record.

•	Audit Trail

Record Description

A brief description of the record to identify it.

Change Details

A description of the changes to the record such as:

•	Initial values for new records.

•	Changed values for updated records.

•	Deleted values for deleted records.

Personnel

The name and number of the person who changed the record.

The audit trail records changes to the underlying database tables. As such, it's possible that a single change in the Training Manager user interface may result in several entries in the audit trail. For example, if you delete 1 master course record in Training Manager, the audit trail will include an entry for that course deletion as well as entries for all related records which have been deleted or updated as a result of deleting a master record. Similarly, if you delete a personnel record, you will also see entries which show that the person has been removed from any class sessions they may have been enrolled in.

Note: due to the large size, the "Notes" field is not included in the audit trail.