SYS Report: Audit History Log

Overview

The Audit History Logs Report is accessed from the System - Reports menu. This report contains the change history for all windows that have been enabled by TEAM for enhanced auditing and logging. You can search and review all additions, modifications, and deletions made by users in these windows.

Encryption

Encryption and decryption logic is used for sensitive fields. When data is sent to Azure encrypted and then it is decrypted when it is returned to WinTeam.

Note:  There is a security feature called Cannot View Sensitive Fields under the SYS Report Audit History Logs screen in the SYS ALLsecurity group you can use to hide the content of these sensitive fields from users. For encrypted fields, the user sees asterisks or fully decrypted information depending on their security permissions. By default, users with SYS ALL access can view sensitive fields unless you select this security feature.

This following fields are currently encrypted (other fields may be added later):

Setup and Security

Before you can use the audit logging feature you must do the following:

1. In the SYS Defaults and Tier Parameters window, in the Security section, select the Enable audit logging check box.
   
2. In the Security Groups window, under the SYS ALL security group, assign the SYS Report Audit History Logs screen to users who should have security access to the Audit History Logs Report.
   

Using the Audit History Log

Important:  Information is logged in the system in real-time, however, the information is synced to this report hourly so there can be up to an hour delay before you can see all information in the report.

1. Select the window you want to review from the drop down list in the Log Source field. After TEAM enables a window for enhanced auditing and logging, it will display in this list.

Note:  
You can filter by Federal/State when the PAY: Garnishment Mapping window is selected as the Log Source and you can filter by Location when the following windows are selected as the Log Source:
By Job Location:
• GL: Budgets
• PS: Bill Codes By Job
• PS: Billing Review and Edit
• PS: Post Setup
• PS: Predictability Review and Edit
By Employee Location:
• PAY: Employee Master File
• PAY: Permanent Timecards
• PAY: Review Checks
• PS: Experience
2. Select or enter the date range to review in the From Date and To Date fields. Both dates default to the current date. Click the Reset button to remove your entries in these fields and return the default current date.

Note:  There is no limit to the date range you can enter. When there are a lot of records to display, the results are paginated and you can set the number of records per page to 50, 100, 150 or 200. All of the rows can still be exported to Excel.

3. Use the record filter to select a specific record to review. The record filter that displays is dependent on which Log Source you selected.
4. In the Changed By field, you can select a specific user to only see records changed by that user.
5. Click the Get Audit Logs button. The records are returned in a grid that has a header record and details records.

6. The first two columns are based on the Log Source you selected (ID, Employee Number, Employee Name, Company, User Name, etc.) The following columns are the same for all log sources:
   

   Source—The name of the window or grid that was edited.

   Action—The action taken by the user which can be Record Added, Record Modified, or Record Deleted.

   Log Date—The date and time the record was edited.

   Changed By—The user name of the person who made the change.

7. There may be only one or multiple detail records for each header record. Each detail record contains the following information:
   

   Record Changed—The ID or description of the record. Double-click on this field to open the record details.

   Field—The database name for the field edited (the same as in the Advanced Filter.)

   Old Value—The original value for the field. This fields is blank when a new record is added.

   New Value—The new value for the field. This field is blank when a record is deleted.

Examples

Exporting the Report to Excel

When the report is exported to Excel, a new row is created for every field changed–it does not have the same format in Excel that it has on the window. Based on the layout of the window, some columns may be blank in the Excel file. In the following example, there is a single header row and multiple details records for each field value changed.

In Excel, each field value changed is on its own line (last 5 columns), including the header information (first 6 columns). This format allows you to filter the information based on each column.

Note:  Detail-row information is not exported from the PAY: Tax Validation and Assignment window because it is embedded as part of the window.