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

The default file names for the Hours Tracking report are:

Detail:
- Excel: acahours_arpt<####_#####>.xlsx
- PDF: acahours_a_<#####>.pdf
- RPT: acahours_a.rpt
Summary:
- Excel: acahours_brpt<####_#####>.xlsx
- PDF: acahours_b_<#####>.pdf
- RPT: acahours_b.rpt

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

Column	Column Name	Description	Data Source or Valid Values
A	EMPLOYEE NUMBER	The unique identifier assigned to the employee in the system.	Retrieved from the Employee Number field on the ACA Hours Tracking page.
B	EMPLOYEE NAME	The full name of the employee, formatted as last name, first name middle name suffix.	The field value is retrieved from the Last Name, First Name, Middle Name, and Suffix fields on the Employee Information page.
C	EMPLOYEE TYPE	The code that classifies the employee's employment type (e.g., full-time, part-time, substitute).	Retrieved from the Employee Type field on the ACA Hours Tracking page.
D	EMPLOYEE TYPE DESCRIPTION	The descriptive text explaining the employee type code.	Retrieved from the Description field on the Employee Type Table page.
E	PAY RUN	The payroll run identifier indicating which pay period or pay cycle these hours correspond to.	Retrieved from the Pay Run field on the Check History page.
F	CHECK NUMBER	The check number or payment identifier associated with this hours entry.	Retrieved from the Check Number field on the Check History page.
G	PAY GROUP	The pay group code that determines the employee's payment schedule and processing rules.	Retrieved from the Pay Group field on the Pay Rates page.
H	JOB CLASS	The job classification code assigned to the employee for this hours entry.	Retrieved from the Job Class field on the Pay Rates page.
I	JOB CLASS TITLE	The descriptive title for the job classification.	Retrieved from the Title field on the Job Class Table page.
J	PAY CODE	The code identifying the type of payment or hours worked (e.g., regular hours, overtime).	Retrieved from the Pay Code field on the Pay Rates page.
K	PAY CODE TITLE	The descriptive title for the pay code.	Retrieved from the Title field on the Pay Code Table page.
L	CALENDAR	The calendar type code used to track the work period.	Retrieved from the Calendar field on the Pay Rates page.
M	CALENDAR DESCRIPTION	The descriptive text explaining the calendar type.	Retrieved from the Description field on the Calendar Table page.
N	START DATE	The beginning date of the work period for this hours entry.	Retrieved from the Start Date field on the ACA Hours Tracking page.
O	END DATE	The ending date of the work period for this hours entry.	Retrieved from the End Date field on the ACA Hours Tracking page.
P	WORK HOURS	The total number of hours worked during the specified period.	Retrieved from the Work Hours field on the ACA Hours Tracking page.
Q	PLAN STATUS	Indicates the employee's health insurance plan status for ACA compliance purposes.	Valid values: Q = Qualified Plan N = No Qualified Plan D = Declined Plan Calculated during the data load process based on the Benefit Status Table mapping. Retrieved from the Plan Status field on the ACA Hours Tracking page.