The Employee Time Entry report uses the Employee Time Entry topic to show a summary of employee time entries and worked time. It includes details such as the times that employees clocked in and out for work, and exceptions associated with the time entries.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Employee Number | Yes | A to Z | |
| Employee Name | Ascending | ||
| Shift Date | A to Z | ||
| Start Shift | Oldest to Newest | ||
| Start Meal | |||
| End Meal | |||
| Start Meal | |||
| End Meal | |||
| Start Meal | |||
| End Meal | |||
| Start Meal | |||
| End Meal | |||
| End Shift | |||
| Total Hours | |||
| Hours Paid | |||
| Exceptions |
Custom Fields
Shift Date
The Shift Date custom field shows the shift date. It uses the following expression:
convert(varchar(10),EmployeePunchCustom.EPShiftIn,101)
Start Shift
The Start Shift custom field shows the shift start time. It uses the following expression:
EmployeePunchCustom.EPShiftIn
Start Meal
The Start Meal custom field shows the start time of the first meal. It uses the following expression:
EmployeePunchCustom.MealIn
End Meal
The End Meal custom field shows the end time of the first meal. It uses the following expression:
EmployeePunchCustom.MealOut
Start Meal
The Start Meal custom field shows the start time of the second meal. It uses the following expression:
EmployeePunchCustom.MealIn2
End Meal
The End Meal custom field shows the end time of the second meal. It uses the following expression:
EmployeePunchCustom.MealOut2
Start Meal
The Start Meal custom field shows the start time of the third meal. It uses the following expression:
EmployeePunchCustom.MealIn3
End Meal
The End Meal custom field shows the end time of the third meal. It uses the following expression:
EmployeePunchCustom.MealOut3
Start Meal
The Start Meal custom field shows the start time of the fourth meal. It uses the following expression:
EmployeePunchCustom.MealIn4
End Meal
The End Meal custom field shows the end time of the fourth meal. It uses the following expression:
EmployeePunchCustom.MealOut4
End Shift
The End Shift custom field shows the shift end time. It uses the following expression:
EmployeePunchCustom.EPShiftOut
Total Hours
The Total Hours custom field shows the total hours worked. It uses the following expression:
CASE
WHEN EmployeePunchCustom.TotalHours IS NULL THEN ''
ELSE right('00' + cast(cast(EmployeePunchCustom.TotalHours AS int) AS varchar), 2) + ':' + right('00' + cast(cast((cast(EmployeePunchCustom.TotalHours AS numeric(4, 2))*60 - cast(EmployeePunchCustom.TotalHours AS int)*60) AS numeric(2, 0)) AS varchar), 2)
END
Hours Paid
The Hours Paid custom field displays the total hours paid. It uses the following expression:
CASE
WHEN EmployeePunchCustom.PaidHours IS NULL THEN ''
ELSE right('00' + cast(cast(EmployeePunchCustom.PaidHours AS int) AS varchar), 2) + ':' + right('00' + cast(cast((cast(EmployeePunchCustom.PaidHours AS numeric(4, 2))*60 - cast(EmployeePunchCustom.PaidHours AS int)*60) AS numeric(2, 0)) AS varchar), 2)
END
Filters
The template includes the following filters: