1. Home
  2. Reporting
  3. Report Types
  4. Time Entries Report Details

Time Entries Report Details

From your

Applies to ,

Overview

Use the Time Entries report to compare employees’ time entries to scheduled shifts as well as determine patterns of behavior that might contribute to attendance issues. You can also dig into more detailed clock in and clock out information not visible elsewhere in When I Work.

Reporting experience

The reporting experience within When I Work encompasses a few different types of reports and exports. Use the following links to explore each in more detail:

Custom Report Data Availability

The data available in the custom report is current as of the prior midnight in your account’s timezone. Any data from midnight until the current time will be reflected in the next day’s report.

Considerations

  • Time entries for archived employees are included in the report.

Field details

The following table includes details about each column in the Time Entries report.

Account ID
Account ID that the time entry belongs to.
Account Name
Account name that the time entry belongs to.
Time ID
Internal ID of the time entry.
Employee User ID
Internal ID of the time entry owner.
Employee Name
Name (last, first) of the time entry owner.
Employee ID
Employee ID of the time entry owner.
Employee Role
Role of the time entry owner.
Clock-In TIme
Time when the time entry owner clocked in.
Clock-In Date
Date when the time entry owner clocked in.
Clock-Out Time
Time when the time entry owner clocked out.
Clock-Out Date
Date when the time entry owner clocked out.
Break Count
Number of breaks recorded in the time entry.
Break Length
Combined length of all breaks recorded in the time entry (hours).
Length
Worked time, not including unpaid breaks (hours).
Employee Base Hourly Rate
Base hourly rate of the time entry owner.
Hourly Rate
Hourly rate the time entry owner earned when working the reported position.
manager Note
manager notes added to the time entry.
Schedule ID
Internal ID of the schedule where the time entry
Schedule Name
Name of the schedule where the time entry occurred.
Job Site ID
Internal ID of the job site where the time entry occurred.
Job Site Name
Name of the job site where the time entry occurred.
Created At
Date and time when the time entry was created.
Creator User ID
Internal ID of the user that created the time entry.
Creator Name
Name (last, first) of the user that created the time entry.
Is Approved
Indicates whether the time entry has been approved by a supervisor, manager, or admin.
Last Modified By User ID
Internal ID of the user that last modified the time entry.
Last Modified By Name
Name (last, first) of the user that last modified the time entry.
Shift ID
Internal ID of the shift associated with the time entry.
Shift Schedule ID
Internal ID of the schedule where the shift took place.
Shift Schedule Name
Name of the schedule where the shift took place.
Shift Start Date
Date when the shift starts.
Shift Start Time
Time when the shift starts.
Shift End Date
Date when the shift ends.
Shift End Time
Time when the shift ends.
Shift Break Length
Length of the shift’s unpaid break (hours).
Shift Length
Length of the shift, not included unpaid break (hours).
Shift Confirmed
Indicates whether the assigned employee has confirmed the shift.
Shift Created At
Date and time when the shift was created.
Shift Job Site ID
Internal ID for the shift’s job site.
Shift Job Site Name
Name of the shift’s job site.
Shift Last Updated At
Date and time when the shift was last edited.
Clock In ID
Internal ID for the time entry’s clock in.
Clock In IP Address
IP address recorded for the time entry’s clock in.
Clock In Latitude
Latitude recorded for the time entry’s clock in.
Clock In Longitude
Longitude recorded for the time entry’s clock in.
Clock In Method
Method used to clock in:

  • iOS: When I Work mobile app on iOS
  • Android: When I Work mobile app on Android
  • Terminal: iOS terminal app, Android terminal app, or computer that is locked as a time clock terminal
  • Computer: When I Work web app
  • General: When I Work API
Clock In Note
Note added with the time entry’s clock in.
Clock In Was Early
Indicated whether the clock in has an early attendance notice.
Clock In Was Late
Indicates whether the clock in has a late attendance notice.
Clock In Wrong Location
Indicates whether the clock in has a wrong location attendance notice.
Clock Out ID
Internal ID for the time entry’s clock out.
Clock Out IP Address
IP Address recorded for the time entry’s clock out.
Clock Out Latitude
Latitude recorded for the time entry’s clock out.
Clock Out Longitude
Longitude recorded for the time entry’s clock out.
Clock Out Method
Method used to clock out:

  • iOS: When I Work mobile app on iOS
  • Android: When I Work mobile app on Android
  • Terminal: iOS terminal app, Android terminal app, or computer that is locked as a time clock terminal
  • Computer: When I Work web app
  • General: When I Work API
Clock Out Note
Noted added to the time entry’s clock out.
Clock Out Was Early
Indicates whether the clock out has an early attendance notice.
Clock Out Was Late
Indicates whether the clock out has a late attendance notice.
Clock Out Wrong Location
Indicates whether the clock out has a late attendance notice.
Column Description
Account ID Account ID that the time entry belongs to.
Account Name Account name that the time entry belongs to.
Time ID Internal ID of the time entry.
Employee User ID Internal ID of the time entry owner.
Employee Name Name (last, first) of the time entry owner.
Employee ID Employee ID of the time entry owner.
Employee Role Role of the time entry owner.
Clock-In TIme Time when the time entry owner clocked in.
Clock-In Date Date when the time entry owner clocked in.
Clock-Out Time Time when the time entry owner clocked out.
Clock-Out Date Date when the time entry owner clocked out.
Break Count Number of breaks recorded in the time entry.
Break Length Combined length of all breaks recorded in the time entry (hours).
Length Worked time, not including unpaid breaks (hours).
Employee Base Hourly Rate Base hourly rate of the time entry owner.
Hourly Rate Hourly rate the time entry owner earned when working the reported position.
manager Note manager notes added to the time entry.
Schedule ID Internal ID of the schedule where the time entry
Schedule Name Name of the schedule where the time entry occurred.
Job Site ID Internal ID of the job site where the time entry occurred.
Job Site Name Name of the job site where the time entry occurred.
Created At Date and time when the time entry was created.
Creator User ID Internal ID of the user that created the time entry.
Creator Name Name (last, first) of the user that created the time entry.
Is Approved Indicates whether the time entry has been approved by a supervisor, manager, or admin.
Last Modified By User ID Internal ID of the user that last modified the time entry.
Last Modified By Name Name (last, first) of the user that last modified the time entry.
Shift ID Internal ID of the shift associated with the time entry.
Shift Schedule ID Internal ID of the schedule where the shift took place.
Shift Schedule Name Name of the schedule where the shift took place.
Shift Start Date Date when the shift starts.
Shift Start Time Time when the shift starts.
Shift End Date Date when the shift ends.
Shift End Time Time when the shift ends.
Shift Break Length Length of the shift’s unpaid break (hours).
Shift Length Length of the shift, not included unpaid break (hours).
Shift Confirmed Indicates whether the assigned employee has confirmed the shift.
Shift Created At Date and time when the shift was created.
Shift Job Site ID Internal ID for the shift’s job site.
Shift Job Site Name Name of the shift’s job site.
Shift Last Updated At Date and time when the shift was last edited.
Clock In ID Internal ID for the time entry’s clock in.
Clock In IP Address IP address recorded for the time entry’s clock in.
Clock In Latitude Latitude recorded for the time entry’s clock in.
Clock In Longitude Longitude recorded for the time entry’s clock in.
Clock In Method Method used to clock in:

  • iOS: When I Work mobile app on iOS
  • Android: When I Work mobile app on Android
  • Terminal: iOS terminal app, Android terminal app, or computer that is locked as a time clock terminal
  • Computer: When I Work web app
  • General: When I Work API
Clock In Note Note added with the time entry’s clock in.
Clock In Was Early Indicated whether the clock in has an early attendance notice.
Clock In Was Late Indicates whether the clock in has a late attendance notice.
Clock In Wrong Location Indicates whether the clock in has a wrong location attendance notice.
Clock Out ID Internal ID for the time entry’s clock out.
Clock Out IP Address IP Address recorded for the time entry’s clock out.
Clock Out Latitude Latitude recorded for the time entry’s clock out.
Clock Out Longitude Longitude recorded for the time entry’s clock out.
Clock Out Method Method used to clock out:

  • iOS: When I Work mobile app on iOS
  • Android: When I Work mobile app on Android
  • Terminal: iOS terminal app, Android terminal app, or computer that is locked as a time clock terminal
  • Computer: When I Work web app
  • General: When I Work API
Clock Out Note Noted added to the time entry’s clock out.
Clock Out Was Early Indicates whether the clock out has an early attendance notice.
Clock Out Was Late Indicates whether the clock out has a late attendance notice.
Clock Out Wrong Location Indicates whether the clock out has a late attendance notice.

 

Updated on May 18, 2022

Was this article helpful?

Related Articles

Still Need Help?

Open a ticket with our customer care team.

Submit a Ticket