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 Detailsentity 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.

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

Data granularity

Provides one row per employee per requested open shift segment.

Columns

Label

Description

Key

Open Shift Request Actors

Names of the users who have approved or rejected the open shift request.

OPEN_SHIFT_REQUEST_ACTORS

Open Shift Request Creation Date

Date and time when the user created the open shift request.

OPEN_SHIFT_REQUEST_CREATE_DATETIME

Open Shift Request Creator Full Name

Full name of the user who created the open shift request.

OPEN_SHIFT_REQUEST_CREATOR_NAME

Open Shift Request Duration

Span in hours of the requested open shift.

OPEN_SHIFT_REQUEST_DURATION

Open Shift Request ID

System identifier of the open shift request.

OPEN_SHIFT_REQUEST_ID

Open Shift Request ID (Status History)

The system identifier of an open shift request

OPEN_SHIFT_REQUEST_HISTORY_ID

Open Shift Request Item End Date

End date and time of the requested open shift.

OPEN_SHIFT_REQUEST_END_DATETIME

Open Shift Request Item Segment Cost Center

Cost center that is associated with the requested open shift segment.

OPEN_SHIFT_REQUEST_SEGMENT_COST_CENTER

Open Shift Request Item Segment End Date

End date and time of the requested open shift segments.

OPEN_SHIFT_REQUEST_SEGMENT_END_DATETIME

Open Shift Request Item Segment Job

Job that is associated with the requested open shift segment.

OPEN_SHIFT_REQUEST_SEGMENT_JOB

Open Shift Request Item Segment Labor Category

Labor category that is associated with the requested open shift segment.

OPEN_SHIFT_REQUEST_SEGMENT_LABOR_CATEGORY

Open Shift Request Item Segment Location

Location path that is associated with the requested open shift segment.

OPEN_SHIFT_REQUEST_SEGMENT_LOCATION

Open Shift Request Item Segment Start Date

Start date and time of the requested open shift segments.

OPEN_SHIFT_REQUEST_SEGMENT_START_DATETIME

Open Shift Request Item Segment Work Rule

The work rule associated with the requested open shift segment

OPEN_SHIFT_REQUEST_SEGMENT_WORKRULE

Open Shift Request Item Start Date

Start date and time of the requested open shift.

OPEN_SHIFT_REQUEST_START_DATETIME

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

Open Shift Request Original Item Duration

The hours of the original open shift

OPEN_SHIFT_REQUEST_ORIGINAL_ITEM_DURATION

Open Shift Request Original Item End Date

The end date and time of the original open shift

OPEN_SHIFT_REQUEST_ORIGINAL_ITEM_END_DATE

Open Shift Request Original Item ID

The system identifier of the original open shift

OPEN_SHIFT_REQUEST_ORIGINAL_ITEM_ID

Open Shift Request Original Item Start Date

The start date and time of the original open shift

OPEN_SHIFT_REQUEST_ORIGINAL_ITEM_START_DATE

Open Shift Request Status

Current status of the open shift request.

OPEN_SHIFT_REQUEST_STATUS

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

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

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

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

Open Shift Request Status Code

Code of the current status of the open shift request.

OPEN_SHIFT_REQUEST_STATUS_CODE

Open Shift Request Submission Type

The type of shift requested (Whole/Partial)

OPEN_SHIFT_REQUEST_SUBMISSION_TYPE

Open Shift Request Subtype Description

Description of the request subtype of the open shift request.

OPEN_SHIFT_REQUEST_SUBTYPE_DSC

Open Shift Request Subtype Name

Name of the request subtype of the open shift request.

OPEN_SHIFT_REQUEST_SUBTYPE_NAME

Open Shift Request Subtype Symbol

Symbol of the request subtype of the open shift request.

OPEN_SHIFT_REQUEST_SUBTYPE_SYMBOL

Core entity

Employee

Organization

Day

Organizational Job

Paycode

Labor Category

Activity

X

X

Relationship

Core entity

Relationship

Employee

One-to-Many

Organizational Job

One-to-One