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.
Supported Dataview types
|
Employee Dataview |
Business Structure Dataview |
|---|---|
| X | X |
Data granularity
One row per employee per Availability action (add, edit, or delete).
Columns
The Audit Availability entity provides the following columns:
|
Label |
Key |
|---|---|
|
Revision GMT Date/Time |
Revision GMT Date Time |
|
Revision Local Date/Time |
Revision Local Date Time |
|
Revision Type |
Revision Type |
|
Revision User |
Revision User |
The Schedule Availability entity provides the following columns:
|
Label |
Key |
|---|---|
|
Availability Date |
SCHEDULE_AUDIT_DETAIL_AVAILABILITY_DATE |
|
Availability Version |
SCHEDULE_AUDIT_DETAIL_AVAILABILITY_VERSION |
|
Deleted Indicator |
SCHEDULE_AUDIT_DETAIL_AVAILABILITY_IS_DELETED |
|
System Generated Indicator |
SCHEDULE_AUDIT_DETAIL_AVAILABILITY_IS_GENERATED |
The Schedule Segment Availability entity provides the following 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 |
|
Availability Segment Type |
SCHEDULE_AUDIT_DETAIL_AVAILABILITY_SEGMENT_TYPE |
The Availability Type entity provides the following column:
|
Label |
Key |
|---|---|
|
Availability Type |
CORE_AVAILABILITY_TYPE_NAME |
Related entities
Core entity
| Employee | Organization | Day | Organizational Job | Paycode | Labor Category |
|---|---|---|---|---|---|
| X |
Relationship
|
One-to-One | One-to-Many |
|---|---|
| X |