Pay Summary by Location and Employee

The Pay Summary by Location and Employee report is a variation of the Pay Summary report. This variation uses the Pay Summary topic to display pay data for employees, such as how much employees earned, overtime hours, and other pay categories. Information is organized by the employees’ assigned location, and then by employee. Administrators and managers can use this report to validate and audit employees’ pay and time for each location and employee.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Location	Yes	Ascending
Name Number	Yes	A to Z
Pay Date		Oldest to Newest
Department
Job
Scheduled In
Scheduled Out
Actual In
Actual Out
Pay Code
Pay Category
Normal			Column total: Sum
Other			Column total: Sum
Pay Amount			Column total: Sum

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)

Normal

The Normal custom field displays the 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 the 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: