ACA Hours Tracking - Import - File Layout and Data Mapping

The ACA Hours Tracking import file must be in one of the following formats:

.xml
.exml
.csv
.txt (tab-delimited format)
.unl

The following table shows the column names, descriptions, and destination database fields for the ACA Hours Tracking import file in .csv format.

Column	Name	Description	Destination Database Field (table.field)
A	Plan Status	The one-character code indicating the employee's health insurance benefit status. Valid values: Q = Qualified N = Non-qualified D = Declined	hrm_aca_hours.aca_status
B	Calendar	The four-character code that identifies the work calendar/schedule associated with the employee's job class.	hrm_aca_hours.cal_type
C	Check Number	The nine-character check or warrant number from the payroll system from which the hours were loaded.	hrm_aca_hours.check_no
D	Job Class	The four-character code that identifies the employee's job classification (e.g., teacher, administrator, custodian).	hrm_aca_hours.classify
E	Employee Number	The employee’s identification (ID) number.	hrm_aca_hours.empl_no
F	Employee Type	The one-character code indicating the employment type (e.g., "A" for Administrator, "S" for Substitute).	hrm_aca_hours.empl_type
G	End Date	The ending date of the pay period for which the ACA hours are being tracked.	hrm_aca_hours.end_date
H	Pay Group	The one-character code that identifies the employee's pay group and determines pay frequency and period dates.	hrm_aca_hours.group_x
I	Pay Code	The three-character earnings code that identifies the type of pay (e.g., regular pay, overtime, supplemental).	hrm_aca_hours.pay_code
J	Pay Run	The three-character payroll run code that identifies the pay cycle to which the hours are associated.	hrm_aca_hours.pay_run
K	Start Date	The beginning date of the pay period for which the ACA hours are being tracked.	hrm_aca_hours.start_date
L	Work Hours	The number of hours worked (or converted to hours using the Hours Conversion Table) for ACA tracking purposes.	hrm_aca_hours.work_hours