ACA Hours Tracking - Load Data - Check History
Use the Load (Check History) page to specify the criteria for loading the report data.
This load process retrieves hours from payroll check history, applies the Hours Conversion Table settings (using the "Load Hours Per Unit" field) to convert units into hours if necessary, determines the employee's plan status from the Benefit Status Table, and creates corresponding records in the ACA Hours Tracking table for compliance reporting.
On the ACA Hours Tracking page, select Load (Check History).
Refer to the Field descriptions and enter or select the required load criteria.
Select Accept.
Select a Destination for the ACA Hours Load Exceptions log file:
Select File to create the file in .rpt format. The default file name is acaload_log.rpt. You can change the default file name.
Select Screen to download the file in .pdf format. The default file name is acaload_log_<#####>.pdf.
Select Excel to download the file in .xls format. Select the required Excel Options. The default file name is acaload_logrpt<####_#####>.xlsx.
Select OK.
Download the .rpt file from the View Files page.
Save the .pdf or .xls file.
For more information about the Print option, refer to Print Reports.
Navigate to the file location.
Inspect the file. Refer to Maintain data and update it as necessary.
Repeat these steps until no errors are encountered and all required data is loaded.
Field descriptions
The following table describes the fields on the Load (Check History) page.
Field | Description |
|---|---|
Employee Number | A filter to limit the load to a specific employee. Leave this field blank to process all employees. Select the Lookup icon to search for and select an employee number. |
Pay Run | A filter to limit the load to include only check history records from a specific payroll run code (e.g., "REG", "SUP"). Leave this field blank to process all pay runs. |
Check Date | The check issue date or date range to filter which payroll checks to load from the check history. This determines which pay period(s) will be processed to create ACA hours records. |
Check Number | A filter to limit the load to a specific check or warrant number. Leave this field blank to process all check numbers. This is useful when you need to reload hours for a specific paycheck. |
Pay Group | A filter to limit the load to include only check history records with a specific pay group code. Leave this field blank to process all pay groups. |
Pay Code | A filter to limit the load to include only check history records with a specific pay/earnings code. Leave this field blank to process all pay codes. The values in the drop-down list are retrieved from the Pay Codes page. |
Job Class | A filter to limit the load to include only the check history records for a specific job classification. Leave this field blank to process all job classes. The values in the drop-down list are retrieved from the Job Class page. |