(v1) .Audit v2020.1

To open the 'Audit' grid navigate to Admin > Audit.

The Audit system keeps a record of all changes to PCR-360 data tables. Any changes to the data tables are recorded in the Audit system and can be tracked from the "History Reports" available throughout the application the audit data can be searched using the Audit grid.

Using this Grid, an Admin can track time stamps, Users, and IP Addresses as they relate to any change in data on any record in the database. Any time a record is changed there is an entry detailing the change. This can help an Admin track who when and what was changed in the database. Additionally, if records are deleted accidentally, this Grid has an option to restore the records one at a time. 

Note: An Event to cleanup records from the Audit Process can be scheduled. This process will remove unnecessary records from both database tables. This process removes all but the oldest duplicate record based on each PRIMARY_KEY.

Restore

The button allows a User to restore a deleted record on an individual case by case basis. This is useful for repairing the database in the event of a malicious attack or an accidental deletion event.

In order to Restore a record, several things must be true.

• The Action must be 'Delete'. Filtering the Action column for deleted records will make finding the right record easier.
• Parent tables must be Restored before Child tables can be Restored. What this means, for example, is that an Action must be Restored before the associated Charges, Labor, Contacts, etc. can be Restored on the Action.
• Once an item is Restored, it will remain on the grid for History Reporting purposes.

1. Locate the record(s) to be 'Restored'
2. Select the record by single clicking to highlight.
3. Click the button.
4. The record will be removed from the Audit grid and a system message will display indicating that the record was restored.

Any Restored records will appear in the grid as a Yes value in the Restored column.