ACA Hours Tracking - File Layout and Data Mapping - Audit Report

The default file names for the Audit report are:

Excel: ACAAUDIT3rpt<####_#####>.xlsx
PDF: ACAAUDIT3_<#####>.pdf
RPT: ACAAUDIT3.rpt

The following table shows the columns, column names, descriptions, and data sources or valid values for the Audit report’s .xlsx file format.

Column	Column Name	Description	Data Source or Valid Values
A	EMPLOYEE	The unique employee number for the employee whose ACA hours record was modified.	Retrieved from the Employee Number field on the ACA Hours Tracking page.
B	NAME	The employee's full name in last name, first name format.	Retrieved from the Last Name and First Name fields on the Employee Information page.
C	JOB CLASS	The four-character job classification code associated with the ACA hours record that was changed.	Retrieved from the Job Class field on the ACA Hours Tracking page.
D	PAY CODE	The three-character pay/earnings code associated with the ACA hours record that was changed.	Retrieved from the Pay Code field on the ACA Hours Tracking page.
E	START DATE	The start date of the pay period for the modified ACA hours record.	Retrieved from the Start Date field on the ACA Hours Tracking page.
F	CHECK NO	The check or warrant number associated with the ACA hours record that was changed.	Retrieved from the Check Number field on the ACA Hours Tracking page.
G	OPERATOR	The user login ID/name of the person who made the change to the ACA hours record.	Retrieved from the system user login ID of the person who is currently logged in and making changes on the ACA Hours Tracking page.
H	REASON	The type of change that was made.	Valid values: ADD = Record was manually added CHANGE = Existing record was updated DELETE = Record was deleted IMPORT = Record was imported from an external file LOAD = Record was loaded from the check history or calendar days System-generated based on the action performed on the ACA Hours Tracking page.
I	DATE CHANGE	The date when the change was made to the ACA hours record.	System-generated date automatically captured when a change is saved on the ACA Hours Tracking page.
J	TIME CHANGE	The time of day when the change was made.	System-generated time automatically captured when a change is saved on the ACA Hours Tracking page.
K	FIELD	The specific field name within the ACA hours record that was modified (e.g., "work_hours", "aca_status", "pay_code").	System-generated field name identifying which specific field was modified on the ACA Hours Tracking page.
L	OLD VALUE	The original data value in the field before the change.	System-captured original value of the field before the change was made on the ACA Hours Tracking page.
M	NEW VALUE	The new data value that was entered or updated in the field after the change was made.	Retrieved from the modified field value after the change is saved on the ACA Hours Tracking page.