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 Availability entity 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 Availability entity.

Data Granularity

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

Supported Dataview/RDO Type

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

Columns
Availability Date SCHEDULE_AUDIT_DETAIL_AVAILABILITY_DATE Date No
Availability Version SCHEDULE_AUDIT_DETAIL_AVAILABILITY_VERSION String No
Date SCH_AVAILABILITY_DATE Date No
Deleted Indicator SCH_AVAILABILITY_IS_DELETED Boolean No
Deleted Indicator SCHEDULE_AUDIT_DETAIL_AVAILABILITY_IS_DELETED Boolean No
System Generated Indicator SCH_AVAILABILITY_IS_GENERATED Boolean No
System Generated Indicator SCHEDULE_AUDIT_DETAIL_AVAILABILITY_IS_GENERATED Boolean No
Version SCH_AVAILABILITY_VERSION String No

Related Entities

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many