Also see our powerpoint presentation on the audit trail.
We use the term "Audit Trail" to describe a separate database table that contains a history of records added, changed and deleted from the database being tracked.
In H2OS, there are currently 2 databases where audit trails are implemented, the customer database and the job tickets database.
H2OS's audit trail lets you view the history of changes made to customer records and job tickets. This feature can also be used to restore records to earlier points in time, should you ever need to do so.
The complete history of changes made to a given customer record can be viewed by clicking the History tab page:
An example from a test machine:
Clicking on a row in the history page grid will bring up the Audit Trail Explorer containing a list of fields changed by the selected change, and the values of the fields changed before and after the change.
In this example, on 3/21/07, the operator changed values in the INSTNOTES, ADDRLINE and EMAILTEST fields (you can hover your mouse over a field on this screen for tooltips containing descriptions for each field).
The Audit Trail for your customer database can also be viewed by selecting Librarian -> Database Maintenance -> Browse the audit trail.
The audit trail browse display looks like this (this is test data)
Notes:
1. This display uses the H2OS standard BROWSE screen. As such you can
click the box in the upper left hand corner of
the display to cause it to automatically adjust column widths
double-click column headers to sort columns (up and down by double-clicking 2x).
scroll the display to view additional fields.
search for records for a specific name by entering
the name (or part thereof) in the NAME entry field at the bottom of the
form.
2. The display is read-only. (requires admin auth to unlock).
The page contains controls to browse an audit trail (either the customer or job tickets database). it also contains controls to restore the customer or job tickets database from data stored in the audit trail.
