Shifts Report Details

From your

Applies to ,

Overview

Use the Shifts report data to understand how managers and employees are interacting with their schedule. For example, you can:

  • See which OpenShifts aren’t being filled
  • Identify no shows (blank time entry)

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

  • Shifts assigned to archived employees are included in the report.

Field details

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

ColumnAccount ID
DescriptionAccount ID where the shift is scheduled.¹
ColumnAccount Name
DescriptionAccount name where the shift is scheduled.¹
ColumnSchedule ID
DescriptionInternal ID of the schedule.
ColumnSchedule Name
DescriptionName of the schedule.
ColumnShift ID
DescriptionInternal ID of the shift.
ColumnOpenShift Status
DescriptionIndicates if the shift is an OpenShift or an assigned shift.
ColumnOpenShift Count
DescriptionIf there is an OpenShift, this field indicates the number of OpenShifts available.
ColumnAssignee User ID
DescriptionInternal ID of the assigned employee.
ColumnAssignee Name
DescriptionName (last, first) of the assigned employee.
ColumnAssignee Employee ID
DescriptionEmployee ID of the assigned employee.
ColumnStart Time
DescriptionDate and time when the shift starts.
ColumnEnd Date
DescriptionDate when the shift ends.
ColumnEnd Time
DescriptionTime when the shift ends.
ColumnUnpaid Break Length
DescriptionLength of the shift’s unpaid break.
ColumnLength
DescriptionScheduled length of the shift, not including the unpaid break.
ColumnShift Position ID
DescriptionInternal ID of the shift’s position.
ColumnShift Position Name
DescriptionName of the shift’s position.
ColumnPosition ID
DescriptionInternal ID of the position worked.
ColumnPosition Name
DescriptionName of the position worked.
ColumnJob Site ID
DescriptionInternal ID for the shift’s job site.
ColumnJob Site Name
DescriptionName of the shift’s job site.
ColumnShift Notes
DescriptionNotes added to the shift.
ColumnCreated At
DescriptionDate and time when the shift was created.
ColumnCreator User ID
DescriptionInternal ID of the user that created the shift.
ColumnCreator Name
DescriptionName (last, first) of the user that created the shift.
ColumnPublished Status
DescriptionIndicates if the shift is published or unpublished.
ColumnPublished At
DescriptionDate and time when the shift was last published.
ColumnUpdated At
DescriptionDate and time when the shift was last edited.
ColumnLast Notified At
DescriptionDate and time when the assignee was last notified of the shift being published or updated.
ColumnConfirmed Status
DescriptionIndicates if the assigned employee has confirmed the shift.
ColumnConfirmed At
DescriptionDate and time when the assigned employee confirmed the shift.
ColumnAssignee Role
DescriptionRole of the assigned user.
ColumnAssignee Base Hourly Rate
DescriptionBase hourly rate of the assigned employee.
ColumnAssignee Position Rate
DescriptionHourly rate the employee earns when working the shift’s position.
ColumnHas Timeclock Entry
DescriptionIndicates if the assigned employee has clocked in or clocked out for this shift.
Column Description
Account ID Account ID where the shift is scheduled.¹
Account Name Account name where the shift is scheduled.¹
Schedule ID Internal ID of the schedule.
Schedule Name Name of the schedule.
Shift ID Internal ID of the shift.
OpenShift Status Indicates if the shift is an OpenShift or an assigned shift.
OpenShift Count If there is an OpenShift, this field indicates the number of OpenShifts available.
Assignee User ID Internal ID of the assigned employee.
Assignee Name Name (last, first) of the assigned employee.
Assignee Employee ID Employee ID of the assigned employee.
Start Time Date and time when the shift starts.
End Date Date when the shift ends.
End Time Time when the shift ends.
Unpaid Break Length Length of the shift’s unpaid break.
Length Scheduled length of the shift, not including the unpaid break.
Shift Position ID Internal ID of the shift’s position.
Shift Position Name Name of the shift’s position.
Position ID Internal ID of the position worked.
Position Name Name of the position worked.
Job Site ID Internal ID for the shift’s job site.
Job Site Name Name of the shift’s job site.
Shift Notes Notes added to the shift.
Created At Date and time when the shift was created.
Creator User ID Internal ID of the user that created the shift.
Creator Name Name (last, first) of the user that created the shift.
Published Status Indicates if the shift is published or unpublished.
Published At Date and time when the shift was last published.
Updated At Date and time when the shift was last edited.
Last Notified At Date and time when the assignee was last notified of the shift being published or updated.
Confirmed Status Indicates if the assigned employee has confirmed the shift.
Confirmed At Date and time when the assigned employee confirmed the shift.
Assignee Role Role of the assigned user.
Assignee Base Hourly Rate Base hourly rate of the assigned employee.
Assignee Position Rate Hourly rate the employee earns when working the shift’s position.
Has Timeclock Entry Indicates if the assigned employee has clocked in or clocked out for this shift.

¹May be a parent account or child account.

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