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 Availabilityentity.

For more information on analyzing Availability audit data, see the Audit Availabilityentity.

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

Data granularity

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

Columns

Label

Key

Availability Segment End Time

SCHEDULE_AUDIT_DETAIL_AVAILABILITY_SEGMENT_END_TIME

Availability Segment Start Time

SCHEDULE_AUDIT_DETAIL_AVAILABILITY_SEGMENT_START_TIME

End Time

SCH_AVAILABILITY_SEGMENT_END_TIME

Start Time

SCH_AVAILABILITY_SEGMENT_START_TIME

Type

SCH_AVAILABILITY_TYPE

Core entity

Employee

Organization

Day

Organizational Job

Paycode

Labor Category

X

X

Relationship

One-to-One

One-to-Many

X