Logging
The ASPC's solution automatically records a full audit
trail for all changes made to the system. This audit trail records the
person id, time and terminal (URL) of the user and the details of the
fields and records changed. This audit trail is recorded in tables that
have insert and select permissions ONLY. This will record the fact that
a user changed a field from X->Y and then Y->X . A nightly
process walks through the audit system building a picture of the
database record by record, each record must match exactly, else an
exception report is generated.
For example, you can view a history of changes
made to a particular task by clicking on the "Log" Tab, when editing you are
editing a task.