Scheduled Shift

The Scheduled Shift entity provides the scheduled shift details for an employee. Using the Scheduled Shift entity, a manager can view employees' scheduled shift start time and end time and determine if the scheduled shift was posted or generated.

Data Granularity

Provides one row per employee per scheduled shift. When no segment-specific columns have been added to the Dataview or report from the Schedule Shift entity, the individual Comments column and Notes column can be used. In that case, granularity will be one row per comment/note combination assigned to the shift.

Supported Dataview/RDO Type

Employee Business Structure Employee - Time Series Business Structure - Time Series Work Unit Work Unit - Time Series

Columns
Comments Comment added to the shift SCH_SHIFT_COMMENTS String No
Comments and Notes Combined list of comments and notes in a single column SCH_SHIFT_COMMENTS_AND_NOTES String No
Label SCH_SHIFT_LABEL String No
Locked Shift Indicator Locked Shift Indicator SCH_SHIFT_IS_LOCKED Boolean No
Notes Note attached to the comment SCH_SHIFT_NOTES String No
On Call Indicator SCH_SHIFT_IS_ON_CALL Boolean No
Posted Shift Indicator SCH_SHIFT_IS_POSTED Boolean No
Shift End Date SCH_SHIFT_END_DATE Date No
Shift Start Date SCH_SHIFT_START_DATE Date No
System Generated Shift Indicator SCH_SHIFT_IS_GENERATED Boolean No

Related Entities

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many