Availability Request Status History
The Availability Request Status History entity allows a user to see the path that a request for availability has taken through the approval process, such as who has changed the status of a request and when that status was changed.
Use the columns in the Employee Details entity along with those in the Availability Request Status History entity to view data columns associated with the employee that is related to the availability request.
Supported Dataview types
| Employee Dataview | Business Structure Dataview |
|---|---|
| X |
Data granularity
One row per employee per request item per status change.
Columns
| Label | Description | Key |
|---|---|---|
| Status Changed | Date and time of the availability request change. | SCH_AVAILABILITY_REQUEST_STATUS_HISTORY_DATETIME |
| Status Change Made By | Name of the person who made the availability request change. | SCH_AVAILABILITY_REQUEST_STATUS_HISTORY_PERSON_NAME |
| Status Changed From | Status of the availability request before the change was made by the user. | SCH_AVAILABILITY_REQUEST_STATUS_HISTORY_FROM_STATUS |
| Status Changed To | Status of the availability request after the change was made by the user. | SCH_AVAILABILITY_REQUEST_STATUS_HISTORY_TO_STATUS |
Additional information
The Availability Request Status History entity does not have a relationship with the Availability Request Detail entity because the entities provide the data at different levels of granularity. If the Column Relationship Rules are enabled and the user selects a column from the Availability Request Status History entity, the user cannot add columns from the Availability Request Detail entity.
Core entity
| Employee | Organization | Day | Organizational Job | Paycode | Labor Category | Activity |
|---|---|---|---|---|---|---|
| X |
Relationship
| One-to-One | One-to-Many |
|---|---|
| X |