The Employee Time Entry Audit Report shows audit data for time entries. The report includes details such as time entry start and end times for employees, the times when the time entries were modified, and more.
Role feature access: Report Library > Time & Attendance > Time Entries > Employee Time Entry Audit Report
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Location Name | Yes | Ascending | |
| Employee Display Name | Yes | Ascending | |
| Time Entry Start | Oldest to Newest | ||
| Employee Time Entry Time Start | |||
| Time Entry End | |||
| Time Start Raw | |||
| Time End Raw | |||
| Employee Time Entry Is Deleted | |||
| Employee Time Entry Audit Time Start | |||
| Employee Time Entry Audit Time End | |||
| Employee Time Entry Audit Last Modified Timestamp | Oldest to Newest | ||
| Application User Employee Login Id | |||
| Last Modified By Employee | |||
| Time Entry Id | |||
| Employee Time Entry Audit Manager Comment | |||
| Employee Time Entry Audit Operation | |||
| Change Type |
Custom Fields
Time Entry Start
The Time Entry Start custom field shows the start time of the time entry and uses the following expression:
EmployeePunch.TimeStart
Time Entry End
The Time Entry End custom field shows the end time of the time entry and uses the following expression:
EmployeePunch.TimeEnd
Time Entry Id
The Time Entry Id custom field shows the time entry’s ID and uses the following expression:
EmployeePunch.PunchId
Change Type
The Change Type custom field shows the type of change to the time entry record and uses the following expression:
case when EmployeePunchAudit.operation = 2 then 'Inserted' when EmployeePunchAudit.operation = 1 then 'Deleted' when EmployeePunchAudit.TimeEnd is null and ( select top 1 epa.timeend from employeepunchaudit epa where epa.punchid = EmployeePunch.PunchId and epa.lastmodifiedtimestamp = (select max(epa2.lastmodifiedtimestamp) from employeepunchaudit epa2 where epa2.punchid = EmployeePunch.PunchId and epa2.lastmodifiedtimestamp < EmployeePunchAudit.LastModifiedTimestamp)) is null then ( case when EmployeePunchAudit.TimeStart = ( select top 1 epa.timestart from employeepunchaudit epa where epa.punchid = EmployeePunch.PunchId and epa.lastmodifiedtimestamp = (select max(epa2.lastmodifiedtimestamp) from employeepunchaudit epa2 where epa2.punchid = EmployeePunch.PunchId and epa2.lastmodifiedtimestamp < EmployeePunchAudit.LastModifiedTimestamp)) then '' when EmployeePunchAudit.TimeStart is null and ( select top 1 epa.timestart from employeepunchaudit epa where epa.punchid = EmployeePunch.PunchId and epa.lastmodifiedtimestamp = (select max(epa2.lastmodifiedtimestamp) from employeepunchaudit epa2 where epa2.punchid = EmployeePunch.PunchId and epa2.lastmodifiedtimestamp < EmployeePunchAudit.LastModifiedTimestamp)) is null then '' else 'Modified' end ) when EmployeePunchAudit.TimeEnd = ( select top 1 epa.timeend from employeepunchaudit epa where epa.punchid = EmployeePunch.PunchId and epa.lastmodifiedtimestamp = (select max(epa2.lastmodifiedtimestamp) from employeepunchaudit epa2 where epa2.punchid = EmployeePunch.PunchId and epa2.lastmodifiedtimestamp < EmployeePunchAudit.LastModifiedTimestamp)) then ( case when EmployeePunchAudit.TimeStart = ( select top 1 epa.timestart from employeepunchaudit epa where epa.punchid = EmployeePunch.PunchId and epa.lastmodifiedtimestamp = (select max(epa2.lastmodifiedtimestamp) from employeepunchaudit epa2 where epa2.punchid = EmployeePunch.PunchId and epa2.lastmodifiedtimestamp < EmployeePunchAudit.LastModifiedTimestamp)) then '' when EmployeePunchAudit.TimeStart is null and ( select top 1 epa.timestart from employeepunchaudit epa where epa.punchid = EmployeePunch.PunchId and epa.lastmodifiedtimestamp = (select max(epa2.lastmodifiedtimestamp) from employeepunchaudit epa2 where epa2.punchid = EmployeePunch.PunchId and epa2.lastmodifiedtimestamp < EmployeePunchAudit.LastModifiedTimestamp)) is null then '' else 'Modified' end ) when EmployeePunchAudit.operation = 4 then 'Modified' else '' endFilters
The template includes the following filters: