ACA - Payroll with Earning Codes

The ACA - Payroll with Earning Codes report uses the ACA - Payroll with Earning Codes topic to display average work hours based on the earning hours data from the Payroll feature and earning codes and measurement period start and end dates entered at report run time.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Employee Number
Employee Display Name
Original Hire Date
Hire Date
Employment Status Name
Job Assignment Name
Location Name
Total Hours			Column Total: Sum
Average Daily Hours
Average Weekly Hours
Average Monthly Hours

Custom Fields

Average Daily Hours

The Average Daily Hours custom field displays the average daily hours. It uses the following expression:

CAST(SUM(PRPayRunEarningPermanent.Units / PPACACustom.DaysInMeasurementPeriod) AS DECIMAL(19, 3))

Average Weekly Hours

The Average Weekly Hours custom field displays the average weekly hours. It uses the following expression:

CAST(SUM(PRPayRunEarningPermanent.Units /  PPACACustom.WeeksInMeasurementPeriod) AS DECIMAL(19, 3))

Average Monthly Hours

The Average Monthly Hours custom field displays the average monthly hours. It uses the following expression:

CAST(SUM(PRPayRunEarningPermanent.Units /  PPACACustom.MonthsInMeasurementPeriod) AS DECIMAL(19, 3))

Filters

This template includes the following filters: