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 |
Related Entities
Core Entity
Employee | Organization | Day | Organizational Job | Paycode | Labor Category | Activity | Work Unit | Work Group | Procedure Code |
---|---|---|---|---|---|---|---|---|---|
Relationship
One-to-One | One-to-Many |
---|---|