ACA Hours Tracking - Load Data - Calendar Days

Use the Load (Calendar Days) page to specify the criteria for loading the report data.

This load process uses the job class calendar to calculate the number of days worked during the specified date range, then applies the Hours Conversion Table settings (with the Use Days Worked option selected) to convert days to hours for ACA reporting.

On the ACA Hours Tracking page, select Load (Calendar Days).
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 (Calendar Days) page.

Field	Description
Date From	The beginning date of the period for which to calculate days worked and create ACA hours records. This date must be within the current or prior month. When entered, the Date To field defaults to the last day of the same month.
Date To	The ending date of the period for which to calculate days worked and create ACA hours records. This date must be within the current or prior month and cannot be earlier than the Date From date. The system uses the date range to determine which employee pay rate records fall within the period.
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 Group	A filter to limit the load to include only pay rate records associated 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 pay rate 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 pay rate 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.
Select Only Active Pay Rates	Indicates whether to load hours only for pay rate records with an Active status. When unchecked, the process includes pay rates with all statuses (Active, Inactive, and Terminated). This ensures that only current employment assignments are typically processed for ACA tracking.