ACA - Payroll Based Journal

Ad Hoc Reporting Guide

Version
R2025.2.1
ft:lastEdition
2025-12-01
ACA - Payroll Based Journal

The ACA - Payroll Based Journal report uses the ACA - WFM with Pay Codes topic to display employee and staffing information, such as hire date, job title code, and hours worked for job title code on date. You can use this report to support Section 6106 of the Affordable Care Act.

Fields

Fields included in the report template
Field Name Group by Sort Order Totals
Employee ID   Ascending  
Hire Date      
Termination Date      
Pay Type Code      
Work Day Date      
Hours     Column total: Sum
Job Title Code      

Filters

This template includes the following filters:

Report filters.

You can configure the filters for this report as follows:

  • Effective Start: Enter the first date of records to include in the report.
  • Effective End: Enter the last date of records to include in the report.
  • Work Day Date: Report results include records where the Work Day Date is between the Effective Start and End dates that you enter.
  • Net Hours Employee Pay Summary: Report doesn’t include records that have zero net hours.
  • Pay Code Name: Select pay codes in the drop-down list to exclude from the report.
  • Labor Metrics Type 0 Name: Select labor metrics names to include in the report.