Schedule Segment Availability

The Schedule Segment Availability entity provides information about an employee's availability for the different types of availability segments (Unavailable, Available, Preferred, and Preferred Time Off) for a selected date. Each employee's availability segment for a given time period has a start time and an end time. The entity also provides audit information related to added, edited, or deleted availability. Because the Schedule Availability entity provides the necessary date column, you should always use the Schedule Segment Availability entity together with the Schedule Availability entity. For more information on analyzing Availability audit data, see the Audit Availability entity.

Data Granularity

Provides one row per employee per availability segment type per day.

Supported Dataview/RDO Type

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

Columns

Availability Segment End Time SCHEDULE_AUDIT_DETAIL_AVAILABILITY_SEGMENT_END_TIME Time No
Availability Segment Start Time SCHEDULE_AUDIT_DETAIL_AVAILABILITY_SEGMENT_START_TIME Time No
End Time SCH_AVAILABILITY_SEGMENT_END_TIME Time No
Start Time SCH_AVAILABILITY_SEGMENT_START_TIME Time No
Type SCH_AVAILABILITY_TYPE String No

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many