Open Shift Request

The Open Shift Request entity provides data that enables you to create Dataviews and reports that can be used to review open shift requests that are made by employees to determine the number of requests, which employees are making the requests, and the status of the requests. Given this information managers can better ensure that open shift requests are being approved or rejected in a timely manner, learn which employees are or are not regularly requesting open shifts, and see whether open shifts are remaining unfilled. Use the columns in the Employee Details entity along with those in the Open Shift Request entity to view data columns associated with the employee that is related to the open shift request.

Data Granularity

Provides one row per employee per requested open shift segment.

Supported Dataview/RDO Type

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

Columns


Open Shift Request Actors	Names of the users who have approved or rejected the open shift request	OPEN_SHIFT_REQUEST_ACTORS	String	No
Open Shift Request Creation Date	Date and time when the user created the open shift request	OPEN_SHIFT_REQUEST_CREATE_DATETIME	DateTime	No
Open Shift Request Creator Full Name	Full name of the user who created the open shift request	OPEN_SHIFT_REQUEST_CREATOR_NAME	String	No
Open Shift Request Duration	Span in hours of the requested open shift	OPEN_SHIFT_REQUEST_DURATION	Number	No
Open Shift Request ID	System identifier of the open shift request	OPEN_SHIFT_REQUEST_ID	String	No
Open Shift Request ID (Status History)	The system identifier of an open shift request	OPEN_SHIFT_REQUEST_HISTORY_ID	Number	No
Open Shift Request Item End Date	End date and time of the requested open shift	OPEN_SHIFT_REQUEST_END_DATETIME	DateTime	No
Open Shift Request Item Segment Cost Center	Cost center that is associated with the requested open shift segment	OPEN_SHIFT_REQUEST_SEGMENT_COST_CENTER	String	No
Open Shift Request Item Segment End Date	End date and time of the requested open shift segments	OPEN_SHIFT_REQUEST_SEGMENT_END_DATETIME	DateTime	No
Open Shift Request Item Segment Job	Job that is associated with the requested open shift segment	OPEN_SHIFT_REQUEST_SEGMENT_JOB	String	No
Open Shift Request Item Segment Labor Category	Labor category that is associated with the requested open shift segment	OPEN_SHIFT_REQUEST_SEGMENT_LABOR_CATEGORY	String	No
Open Shift Request Item Segment Location	Location path that is associated with the requested open shift segment	OPEN_SHIFT_REQUEST_SEGMENT_LOCATION	String	No
Open Shift Request Item Segment Start Date	Start date and time of the requested open shift segments	OPEN_SHIFT_REQUEST_SEGMENT_START_DATETIME	DateTime	No
Open Shift Request Item Segment Work Rule	The work rule associated with the requested open shift segment	OPEN_SHIFT_REQUEST_SEGMENT_WORKRULE	String	No
Open Shift Request Item Start Date	Start date and time of the requested open shift	OPEN_SHIFT_REQUEST_START_DATETIME	DateTime	No
Open Shift Request Manager Comment & Notes	The comments and associated notes that have been applied to a open shift request by a manager	OPEN_SHIFT_REQUEST_MGR_COMMENTS_NOTES	String	No
Open Shift Request Original Item Duration	The hours of the original open shift	OPEN_SHIFT_REQUEST_ORIGINAL_ITEM_DURATION	Number	No
Open Shift Request Original Item End Date	The end date and time of the original open shift	OPEN_SHIFT_REQUEST_ORIGINAL_ITEM_END_DATE	DateTime	No
Open Shift Request Original Item ID	The system identifier of the original open shift	OPEN_SHIFT_REQUEST_ORIGINAL_ITEM_ID	String	No
Open Shift Request Original Item Start Date	The start date and time of the original open shift	OPEN_SHIFT_REQUEST_ORIGINAL_ITEM_START_DATE	DateTime	No
Open Shift Request Status	Current status of the open shift request	OPEN_SHIFT_REQUEST_STATUS	String	No
Open Shift Request Status Change Date	The date and time the status of an open shift request was modified by a user	OPEN_SHIFT_REQUEST_HISTORY_DATETIME	DateTime	No
Open Shift Request Status Change User	The name of the user that modified the status of an open shift request	OPEN_SHIFT_REQUEST_HISTORY_USER	String	No
Open Shift Request Status Changed From	The status of an open shift request prior to the change by a user	OPEN_SHIFT_REQUEST_HISTORY_CHG_FROM	String	No
Open Shift Request Status Changed To	The status of an open shift request after the change by a user	OPEN_SHIFT_REQUEST_HISTORY_CHG_TO	String	No
Open Shift Request Status Code	Code of the current status of the open shift request	OPEN_SHIFT_REQUEST_STATUS_CODE	String	No
Open Shift Request Submission Type	The type of shift requested (Whole/Partial)	OPEN_SHIFT_REQUEST_SUBMISSION_TYPE	String	No
Open Shift Request Subtype Description	Description of the request subtype of the open shift request	OPEN_SHIFT_REQUEST_SUBTYPE_DSC	String	No
Open Shift Request Subtype Name	Name of the request subtype of the open shift request	OPEN_SHIFT_REQUEST_SUBTYPE_NAME	String	No
Open Shift Request Subtype Symbol	Symbol of the request subtype of the open shift request	OPEN_SHIFT_REQUEST_SUBTYPE_SYMBOL	String	No

Core Entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category	Activity	Work Unit	Work Group	Procedure Code

Relationship

Core Entity	Relationship
Employee	One to Many
Organizational Job	One to One