Pay Summary

The Pay Summary report uses the Pay Summary topic to display pay data for employees, such as how much employees earned and the pay category associated with the record.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Employee Number	Yes	A to Z
Employee Name		Ascending
Pay Date		Oldest to Newest
Location
Department
Job
Actual In
Actual Out
Authorized Manager
Authorized Employee
Pay Code
Pay Category
Normal
Other
Pay Amount

Custom Fields

Actual In

The Actual In custom field displays the start time of the pay summary report. It uses the following expression:

Cast(EmployeePaySummary.TimeStart as Time)

Actual Out

The Actual Out custom field displays the end time of the pay summary report. It uses the following expression:

Cast(EmployeePaySummary.TimeEnd as Time)

Authorized Manager

The Authorized Manager custom field indicates if manager authorized the record. It uses the following expression:

CASE
    WHEN EmployeePunch.ManagerAuthorized=1 THEN 'Yes'
    ELSE 'No'
END

Authorized Employee

The Authorized Employee custom field indicates if the employee authorized the record. It uses the following expression:

CASE
    WHEN EmployeePunch.EmployeeAuthorized=1 THEN 'Yes'
    ELSE 'No'
END

Normal

The Normal custom field displays pay summary hours where the Premium checkbox isn’t selected. It uses the following expression:

CASE
    WHEN EmployeePaySummary.IsPremium=0 THEN CAST(EmployeePaySummary.NetHours AS decimal(38, 3))
    WHEN EmployeePaySummary.IsPremium=1 THEN 0.0
END 

Other

The Other custom field displays pay summary hours where the Premium checkbox is selected. It uses the following expression:

CASE
    WHEN EmployeePaySummary.IsPremium=1 THEN CAST(EmployeePaySummary.NetHours AS decimal(38, 3))
    WHEN EmployeePaySummary.IsPremium=0 THEN 0.0
END 

Filters

The template includes the following filters: