The ACA - Average Hours template uses the ACA - WFM with Pay Codes topic to display average work hours based on WFM net hours, pay codes, and measurement period start and end dates.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Employee Number | A to Z | ||
| Employee Name | Ascending | ||
| Hire Date | |||
| Rehire Date | |||
| Status | |||
| Job Assignment | |||
| Location | |||
| Net Hours | Column total: Sum | ||
| Avg Daily Hours | |||
| Avg Weekly Hours | |||
| Avg Monthly Hours |
Custom Fields
Avg Daily Hours
The Avg Daily Hours custom field displays the average daily hours. It uses the following expression:
CAST(SUM(EmployeePaySummaryNet.NetHours / PPACACustom.DaysInMeasurementPeriod) AS DECIMAL(19, 3))
Avg Weekly Hours
The Avg Weekly Hours custom field displays the average weekly hours. It uses the following expression:
CAST(SUM(EmployeePaySummaryNet.NetHours / PPACACustom.WeeksInMeasurementPeriod) AS DECIMAL(19, 3))
Avg Monthly Hours
The Avg Monthly Hours custom field displays the average monthly hours. It uses the following expression:
CAST(SUM(EmployeePaySummaryNet.NetHours / PPACACustom.MonthsInMeasurementPeriod) AS DECIMAL(19, 3))
Filters
The template includes the following filters: