Audit Availability

The ability to create Dataviews and reports that provide detailed audit information related to the adding, editing, or deleting of the availability of employees requires the use of data columns from four different entities in the Data Dictionary: Audit Availability, Schedule Availability, Schedule Segment Availability, and Availability Type. This family of data columns provide the data necessary to understand who added, edited, or deleted an employee's availability and the type of action taken by the user (Insert, Update, or Delete). The Schedule Availability data columns provide a unique identifier for the availability version, the date to which the availability applies, and indicators that identify the availability as system-generated and deleted. The Schedule Segment Availability data columns provide the start and end times of the schedule segment to which the availability applies. The Availability Type data column provides the type of availability related to a specific schedule segment (Available, Unavailable, Preferred, or Preferred Time Off). All data columns can be used together in a Dataview, but it is necessary to disable the Column Relationship Rules. This will allow you to create a Dataview that provides key audit information related to availability.

Data Granularity

One row per employee per Availability action (add, edit, or delete).

Supported Dataview/RDO Type

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

Columns

The Audit Availability entity provides the following columns:

Revision GMT Date/Time RevisionGMTDateTime DateTime No
Revision Local Date/Time Revision Local Date/Time DateTime No
Revision Type Revision Type String No
Revision User Revision User String No

The Schedule Availability entity provides the following columns:

Availability Date SCHEDULE_AUDIT_DETAIL_AVAILABILITY_DATE Date No
Availability Version SCHEDULE_AUDIT_DETAIL_AVAILABILITY_VERSION String No
Deleted Indicator SCHEDULE_AUDIT_DETAIL_AVAILABILITY_IS_DELETED Boolean No
System Generated Indicator SCHEDULE_AUDIT_DETAIL_AVAILABILITY_IS_GENERATED Boolean No

The Schedule Segment Availability entity provides the following columns:

Availability Segment End Time SCHEDULE_AUDIT_DETAIL_AVAILABILITY_SEGMENT_END_TIME DateTime No
Availability Segment Start Time SCHEDULE_AUDIT_DETAIL_AVAILABILITY_SEGMENT_START_TIME DateTime No

The Availability Type entity provides the following columns:

Availability Type CORE_AVAILABILITY_TYPE_NAME String No

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many