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.

Supported Dataview types

Employee Dataview	Business Structure Dataview
X	X

Data granularity

Provides one row per employee.

Columns

Note: The columns marked with an asterisk return data to reports only when selected using a parameter in BIRT Designer. When selected for a Dataview, they do not return data.

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

Related entities

Employee Dataview

Employee Details

Business Structure Dataview

Employee

Additional information

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

Core entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category
X	X	X

Relationship

One-to-One	One-to-Many
	X