Schedule Availability

The Schedule Availability entity provides the version number and the date for which the availability is defined for employees. It returns the start and end times of the schedule segment for which availability is defined. The entity also provides audit information related to added, edited or deleted availability. For more information on analyzing Availability audit data, please see the Audit Availability entity.

Use the Schedule Availability entity with the Schedule Segment Availabilityentity for reporting and analysis. The Segment Start Time, Segment End Time, and Availability Type data columns exist only in the Schedule Segment Availability entity.

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

Columns

Label

Key

Availability Date

SCHEDULE_AUDIT_DETAIL_AVAILABILITY_DATE

Availability Version

SCHEDULE_AUDIT_DETAIL_AVAILABILITY_VERSION

Date

SCH_AVAILABILITY_DATE

Deleted Indicator

SCH_AVAILABILITY_IS_DELETED

Deleted Indicator

SCHEDULE_AUDIT_DETAIL_AVAILABILITY_IS_DELETED

System Generated Indicator

SCH_AVAILABILITY_IS_GENERATED

System Generated Indicator

SCHEDULE_AUDIT_DETAIL_AVAILABILITY_IS_GENERATED

Version

SCH_AVAILABILITY_VERSION

Core entity

Employee

Organization

Day

Organizational Job

Paycode

Labor Category

X

X

Relationship

One-to-One

One-to-Many

X