Schedule Events

The Schedule Events entity provides information related to three different types of schedule events:

  • Scheduled Paycode Edit
  • Shift
  • Shift Segment
It provides all schedule-related events for an employee in the selected time period.

Data Granularity

Provides one row per employee per schedule event.

Supported Dataview/RDO Type

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

Columns

Comments and Notes Combined list of comments and notes in a single column, including those for open shift segments SCH_SCHEDULE_EVENT_COMMENTS_AND_NOTES String No
Contributing Hours in Span Number of hours that the schedule event contributes towards a given span SCH_SCHEDULE_EVENT_COVERAGE_SPAN_CONTRIBUTING_HOURS Number No
Cost Center SCH_SCHEDULE_EVENT_SEGMENT_COST_CENTER String No
Date SCH_SCHEDULE_EVENT_CALENDAR_DATE Date No
End Date Time SCH_SCHEDULE_EVENT_END_DATE Date No
Event Type SCH_SCHEDULE_EVENT_TYPE String No
Index SCH_SCHEDULE_EVENT_INDEX Number No
Job SCH_SCHEDULE_EVENT_ORG_JOB String No
Job Transfer Indicator SCH_SCHEDULE_EVENT_IS_TRANSFER_ORG_JOB Boolean No
Label SCH_SCHEDULE_EVENT_SHIFT_LABEL String No
Labor Categories SCH_SCHEDULE_EVENT_SEGMENT_LABOR_CATEGORIES String No
Labor Category SCH_SCHEDULE_EVENT_LABOR_ACCOUNT String No
Labor Category Transfer Indicator SCH_SCHEDULE_EVENT_IS_TRANSFER_LABOR_ACCOUNT Boolean No
Locked Shift Indicator Locked Shift Indicator SCH_SCHEDULE_EVENT_SHIFT_IS_LOCKED Boolean No
On Call Indicator On Call Indicator SCH_SCHEDULE_EVENT_IS_ONCALL Boolean No
Open Shift Indicator SCH_SCHEDULE_EVENT_IS_OPEN Boolean No
Overlapping Span Date Date of the span where the schedule event overlaps SCH_SCHEDULE_EVENT_COVERAGE_SPAN_DATE Date No
Overlapping Span Name Name of the span to which a scheduled shift, scheduled shift segment, scheduled paycode edit, or open shift belongs. All the event types in Schedule Events entity can use this column for an association to the span name SCH_SCHEDULE_EVENT_COVERAGE_SPAN_NAME String No
Overlapping Span Type Type of span where the schedule event overlaps SCH_SCHEDULE_EVENT_COVERAGE_SPAN_TYPE String No
Posted Indicator SCH_SCHEDULE_EVENT_IS_POSTED Boolean No
Primary Cost Center SCH_SCHEDULE_EVENT_SEGMENT_PRIMARY_COST_CENTER String No
Primary Job SCH_SCHEDULE_EVENT_PRIMARY_ORG_JOB String No
Primary Labor Categories SCH_SCHEDULE_EVENT_SEGMENT_PRIMARY_LABOR_CATEGORIES String No
Primary Labor Category SCH_SCHEDULE_EVENT_PRIMARY_LABOR_ACCOUNT String No
Primary Work Rule SCH_SCHEDULE_EVENT_SEGMENT_PRIMARY_WORK_RULE String No
Schedule Event ID SCH_SCHEDULE_EVENT_ID String No
Schedule Event Parent ID SCH_SCHEDULE_EVENT_PARENT_ID String No
Shift End Date Time SCH_SCHEDULE_EVENT_SHIFT_END_DATETIME DateTime No
Shift Segment Type SCH_SCHEDULE_EVENT_SEGMENT_TYPE String No
Shift Start Date Time SCH_SCHEDULE_EVENT_SHIFT_START_DATETIME DateTime No
Start Date Time SCH_SCHEDULE_EVENT_START_DATE DateTime No
System Generated Indicator SCH_SCHEDULE_EVENT_IS_GENERATED Boolean No
Transfer Cost Center Indicator SCH_SCHEDULE_EVENT_SEGMENT_IS_TRANSFER_COST_CENTER Boolean No
Transfer Labor Categories Indicator SCH_SCHEDULE_EVENT_SEGMENT_IS_TRANSFER_LABOR_CATEGORIES Boolean No
Transfer String SCH_SCHEDULE_EVENT_SEGMENT_TRANSFER_STRING String No
Transferred Worked Rule SCH_SCHEDULE_EVENT_SEGMENT_IS_TRANSFER_WORK_RULE Boolean No
Underlined Indicator SCH_SCHEDULE_EVENT_IS_UNDERLINED Boolean No
User Entered Cost Center Indicator SCH_SCHEDULE_EVENT_SEGMENT_IS_USER_ENTERED_COST_CENTER Boolean No
User Entered Job Indicator SCH_SCHEDULE_EVENT_IS_USER_ENTERED_ORG_JOB Boolean No
User Entered Labor Categories SCH_SCHEDULE_EVENT_SEGMENT_USER_ENTERED_LABOR_CATEGORIES String No
User Entered Labor Category SCH_SCHEDULE_EVENT_USER_ENTERED_LABOR_ACCOUNT String No
User Entered Labor Category Indicator SCH_SCHEDULE_EVENT_IS_USER_ENTERED_LABOR_ACCOUNT Boolean No
User Entered Work Rule SCH_SCHEDULE_EVENT_SEGMENT_IS_USER_ENTERED_WORK_RULE Boolean No
Work Rule SCH_SCHEDULE_EVENT_SEGMENT_WORK_RULE String No

Additional Info

Use the Index data column to analyze the sequence of scheduled events for an employee in a schedule period.

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many