Open Shift Request Status History

The Open Shift Request Status History entity allows a user to see the path that an open shift request 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 Open Shift Request Status History entity to view data columns associated with the employees that are related to the cover request.

Employee Dataview Business Structure Dataview
X  

One row per employee per request item per status change.

Label Description Key
Open Shift Request ID (Status History) System identifier of the open shift request. OPEN_SHIFT_REQUEST_HISTORY_ID
Open Shift Request Status Change Date Date and time when the user modified the status of the open shift request. OPEN_SHIFT_REQUEST_HISTORY_DATETIME
Open Shift Request Status Change User Name of the user who modified the status of the open shift request. OPEN_SHIFT_REQUEST_HISTORY_USER
Open Shift Request Changed From Status of the open shift request before the change was made by the user. OPEN_SHIFT_REQUEST_HISTORY_CHG_FROM
Open Shift Request Changed To Status of the open shift request after the change was made by the user. OPEN_SHIFT_REQUEST_HISTORY_CHG_TO

The Open Shift Request Status History entity does not have a relationship with the Open Shift Request 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 Open Shift Request Status History entity, the user cannot add columns from the Open Shift Request entity.

Employee Organization Day Organizational Job Paycode Labor Category Activity
X            
One-to-One One-to-Many
X