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.

Employee Dataview Business Structure Dataview
X X

Provides one row per employee.

Label Description Key
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
Contributing Hours in Span* Number of hours that the schedule event contributes towards a given span. SCH_SCHEDULE_EVENT_COVERAGE_SPAN_CONTRIBUTING_HOURS
Cost Center   SCH_SCHEDULE_EVENT_SEGMENT_COST_CENTER
Date   SCH_SCHEDULE_EVENT_CALENDAR_DATE
End Date Time   SCH_SCHEDULE_EVENT_END_DATE
Event Type   SCH_SCHEDULE_EVENT_TYPE
Index   SCH_SCHEDULE_EVENT_INDEX
Job   SCH_SCHEDULE_EVENT_ORG_JOB
Job Transfer Indicator   SCH_SCHEDULE_EVENT_IS_TRANSFER_ORG_JOB
Label   SCH_SCHEDULE_EVENT_SHIFT_LABEL
Labor Categories   SCH_SCHEDULE_EVENT_SEGMENT_LABOR_CATEGORIES
Labor Category   SCH_SCHEDULE_EVENT_LABOR_ACCOUNT
Labor Category Transfer Indicator   SCH_SCHEDULE_EVENT_IS_TRANSFER_LABOR_ACCOUNT
Locked Shift Indicator Locked Shift Indicator SCH_SCHEDULE_EVENT_SHIFT_IS_LOCKED
On Call Indicator On Call Indicator SCH_SCHEDULE_EVENT_IS_ONCALL
Open Shift Indicator   SCH_SCHEDULE_EVENT_IS_OPEN
Overlapping Span Date* Dare of the span where the schedule event overlaps. SCH_SCHEDULE_EVENT_COVERAGE_SPAN_DATE
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
Overlapping Span Type* Type of span where the schedule event overlaps. SCH_SCHEDULE_EVENT_COVERAGE_SPAN_TYPE
Posted Indicator   SCH_SCHEDULE_EVENT_IS_POSTED
Primary Cost Center   SCH_SCHEDULE_EVENT_SEGMENT_PRIMARY_COST_CENTER
Primary Job   SCH_SCHEDULE_EVENT_PRIMARY_ORG_JOB
Primary Labor Categories   SCH_SCHEDULE_EVENT_SEGMENT_PRIMARY_LABOR_CATEGORIES
Primary Labor Category   SCH_SCHEDULE_EVENT_PRIMARY_LABOR_ACCOUNT
Primary Work Rule   SCH_SCHEDULE_EVENT_SEGMENT_PRIMARY_WORK_RULE
Schedule Event ID   SCH_SCHEDULE_EVENT_ID
Schedule Event Parent ID   SCH_SCHEDULE_EVENT_PARENT_ID
Shift End Date Time   SCH_SCHEDULE_EVENT_SHIFT_END_DATETIME
Shift Segment Type   SCH_SCHEDULE_EVENT_SEGMENT_TYPE
Shift Start Date Time   SCH_SCHEDULE_EVENT_SHIFT_START_DATETIME
Start Date Time   SCH_SCHEDULE_EVENT_START_DATE
System Generated Indicator   SCH_SCHEDULE_EVENT_IS_GENERATED
Transfer Cost Center Indicator   SCH_SCHEDULE_EVENT_SEGMENT_IS_TRANSFER_COST_CENTER
Transfer Labor Categories Indicator   SCH_SCHEDULE_EVENT_SEGMENT_IS_TRANSFER_LABOR_CATEGORIES
Transfer String   SCH_SCHEDULE_EVENT_SEGMENT_TRANSFER_STRING

Transferred Worked Rule

   SCH_SCHEDULE_EVENT_SEGMENT_IS_TRANSFER_WORK_RULE
Underlined Indicator   SCH_SCHEDULE_EVENT_IS_UNDERLINED
User Entered Cost Center Indicator   SCH_SCHEDULE_EVENT_SEGMENT_IS_USER_ENTERED_COST_CENTER
User Entered Job Indicator   SCH_SCHEDULE_EVENT_IS_USER_ENTERED_ORG_JOB
User Entered Labor Categories   SCH_SCHEDULE_EVENT_SEGMENT_USER_ENTERED_LABOR_CATEGORIES
User Entered Labor Category   SCH_SCHEDULE_EVENT_USER_ENTERED_LABOR_ACCOUNT
User Entered Labor Category Indicator   SCH_SCHEDULE_EVENT_IS_USER_ENTERED_LABOR_ACCOUNT
User Entered Work Rule   SCH_SCHEDULE_EVENT_SEGMENT_IS_USER_ENTERED_WORK_RULE
Work Rule   SCH_SCHEDULE_EVENT_SEGMENT_WORK_RULE

Employee Dataview

Business Structure Dataview

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

Employee Organization Day Organizational Job Paycode Labor Category
X X X      
One-to-One One-to-Many
  X