Cover Request

The Cover Request entity provides data that enables you to create Dataviews and reports that can be used to review requests for coverage 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 requests for coverage are being approved or rejected in a timely manner, learn which employees are or are not regularly requesting other employees to cover their shifts, and see whether cover requests are being accepted or rejected by other employees. 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 cover request item segment and recipient.

Supported Dataview/RDO Type

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

Columns


Cover Request Item Segment End Date	End date and time of the shift segment for which coverage was requested	COVER_REQUEST_ITEM_SEGMENT_END_DATETIME	DateTime	No
Cover Request Actors	Names of the users who have approved or rejected the cover request	COVER_REQUEST_ACTORS	String	No
Cover Request Creation Date	Date and time when the user created the cover request	COVER_REQUEST_CREATE_DATETIME	DateTime	No
Cover Request Creator Name	Name of the user who created the cover request	COVER_REQUEST_CREATOR_NAME	String	No
Cover Request ID	System identifier of the cover request	COVER_REQUEST_ID	String	No
Cover Request Item Duration	Span in hours of the shift for which coverage was requested	COVER_REQUEST_ITEM_DURATION	Number	No
Cover Request Item End Date	End date and time of the shift for which coverage was requested	COVER_REQUEST_ITEM_END_DATETIME	DateTime	No
Cover Request Item Recipient Employee ID	Employee ID of the employee who received the cover request	COVER_REQUEST_ITEM_RECIPIENT_EMPLOYEEID	String	No
Cover Request Item Recipient Full Name	Full name of the employee who received the cover request	COVER_REQUEST_ITEM_RECIPENT_NAME	String	No
Cover Request Item Segment Cost Center	Cost center that is associated with the segment for which coverage was requested	COVER_REQUEST_ITEM_SEGMENT_COST_CENTER	String	No
Cover Request Item Segment Job	Job that is associated with the segment for which coverage was requested	COVER_REQUEST_ITEM_SEGMENT_JOB	String	No
Cover Request Item Segment Labor Category	Labor category that is associated with the segment for which coverage was requested	COVER_REQUEST_ITEM_SEGMENT_LABOR_CATEGORY	String	No
Cover Request Item Segment Location	Location that is associated with the shift segment for which coverage was requested	COVER_REQUEST_ITEM_SEGMENT_LOCATION	String	No
Cover Request Item Segment Start Date	Start date and time of the shift segment for which coverage was requested	COVER_REQUEST_ITEM_SEGMENT_START_DATETIME	DateTime	No
Cover Request Item Segment Work Rule	Work rule that is associated with the segment for which coverage was requested	COVER_REQUEST_ITEM_SEGMENT_WORKRULE	String	No
Cover Request Item Start Date	Start date and time of the shift for which coverage was requested	COVER_REQUEST_ITEM_START_DATETIME	DateTime	No
Cover Request Manager Comment & Notes	The comments and associated notes that have been applied to a cover request by a manager	COVER_REQUEST_MGR_COMMENTS_NOTES	String	No
Cover Request Original Item Duration	The hours of the original assigned shift	COVER_REQUEST_ORIGINAL_ITEM_DURATION	Number	No
Cover Request Original Item End Date	The end date and time of the original assigned shift	COVER_REQUEST_ORIGINAL_ITEM_END_DATE	DateTime	No
Cover Request Original Item ID	The system identifier of the original assigned shift	COVER_REQUEST_ORIGINAL_ITEM_ID	String	No
Cover Request Original Item Start Date	The start date and time of the original assigned shift	COVER_REQUEST_ORIGINAL_ITEM_START_DATE	DateTime	No
Cover Request Shift Market Indicator	Boolean indicator showing whether the cover request was offered to the Shift Market	COVER_REQUEST_MARKET_REQUEST	Boolean	No
Cover Request Status	Current status of the cover request. Note that if a request has been sent to multiple recipients, each recipient's version of the request may have a different status value	COVER_REQUEST_REQUEST_STATUS	String	No
Cover Request Status Code	Code of the current status of the cover request	COVER_REQUEST_STATUS_CODE	String	No
Cover Request Submission Type	The type of shift requested for coverage (Whole/Partial)	COVER_REQUEST_SUBMISSION_TYPE	String	No
Cover Request Subtype Description	Description of the request subtype that is associated with the cover request	COVER_REQUEST_SUBTYPE_DESC	String	No
Cover Request Subtype Name	Name of the request subtype that is associated with the cover request	COVER_REQUEST_SUBTYPE_NAME	String	No
Cover Request Symbol	Symbol of the request subtype that is associated with the cover request	COVER_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