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.

Data Granularity

One row per employee per request item per status change.

Supported Dataview/RDO Type

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

Columns
Open Shift Request ID (Status History) System identifier of the open shift request OPEN_SHIFT_REQUEST_HISTORY_ID Number No
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 DateTime No
Open Shift Request Status Change User Name of the user who modified the status of the open shift request OPEN_SHIFT_REQUEST_HISTORY_USER String No
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 String No
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 String No

Related Entities

Additional Info

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.

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many