Employee Overtime Entries

The Employee Overtime Entries report shows employee timesheet overtime entries. This report helps improve workforce planning, cost control, and compliance management by showing key insights on overtime.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Employee Number
Employee Display Name
Employment Status Name
Shift Date
Shift Day Name
Employee Pay Summary Time Start
Employee Pay Summary Time End
Pay Code Name
Pay Category Name
Pay Category Group Name
Minute Duration
Employee Pay Summary Net Hours
Employee Pay Summary Rate
Pay Amount
Pay Group Name
Location Name
Site
Department Name
Job Assignment name
Manager On Shift Date

Custom Fields

Shift Date

The Shift Date custom field shows the date of the clock in. It uses the following expression:

CAST(EmployeePunch.TimeStart AS DATE)

Role authorization access: Access to Employee Timesheet Data (Can Read)

Shift Day Name

The Shift Day Name custom field shows the day name of the shift date (for example, Monday). It uses the following expression:

DATENAME(dw, EmployeePunch.TimeStart)

Role authorization access: Access to Employee Timesheet Data (Can Read)

Manager On Shift Date

The Manager On Shift Date custom field shows the manager on the shift date according to Management Assignments. It uses the following expression:

(select string_agg(e.DisplayName, ' / ') from employeemanager em join employee e on em.ManagerId = e.EmployeeId where em.employeeid = employee.employeeid and effectivestart <= CAST(EmployeePunch.TimeStart AS DATE) and coalesce(effectiveend, '2050-01-01') >= CAST(EmployeePunch.TimeStart AS DATE))

Role authorization access: Management Assignment (Can Read)

Filters

The template includes the following filters: