Self-Schedule Request
The Self-Schedule Request entity provides data that enables you to create Dataviews and reports that can be used to review self-schedule requests that are made by employees. This data allows managers to determine the number of requests, which employees are or are not regularly self-scheduling, and how many shifts are being self-scheduled.
Use the columns in the Employee Details entity along with those in the Self Schedule Request entity to view data columns associated with the employee that is related to the self-schedule request.
Note that the selected time frame is used to bring up requests based on either of the shift dateincluded in the request, and not the date of the request.
Supported Dataview types
| Employee Dataview | Business Structure Dataview |
|---|---|
| X |
Data granularity
Provides one row per self-schedule request item segment.
Columns
| Label | Description | Key |
|---|---|---|
| Self-schedule Request Approvers | Semicolon-separated list of the full names of the users who have approved or rejected the self-schedule request. Approvers appear in order of the approval's apply dates and times from oldest to newest. | SELFSCHEDULE_REQUEST_APPROVERS |
| Self-schedule Request Creation Date | Date and time when the user created the self-schedule request. | SELFSCHEDULE_REQUEST_CREATE_DATETIME |
| Self-schedule Request Creator Full Name | Full name of the user who created the self-schedule request. | SELFSCHEDULE_REQUEST_CREATOR_NAME |
| Self-schedule Request ID | System identifier of the self-schedule request. | SELFSCHEDULE_REQUEST_ID |
| Self-schedule Request Item Segment Cost Center | Cost center that is associated with the requested shift segment. | SELFSCHEDULE_REQUEST_ITEM_COST_CENTER |
| Self-schedule Request Item Duration | Span in hours of the requested shift. | SELFSCHEDULE_REQUEST_ITEM_DURATION |
| Self-schedule Request Item End Date | End date and time of the requested shift. | SELFSCHEDULE_REQUEST_ITEM_END_DATETIME |
| Self-schedule Request Item Segment Job | Job that is associated with the requested shift segment. | SELFSCHEDULE_REQUEST_ITEM_JOB |
| Self-schedule Request Item Label | The label of the requested shift | SELFSCHEDULE_REQUEST_ITEM_LABEL |
| Self-schedule Request Item Segment Labor Category | Labor category that is associated with the requested shift segment. | SELFSCHEDULE_REQUEST_ITEM_LABOR_CATEGORY |
| Self-schedule Request Item Segment Location | Location that is associated with the requested shift segment. | SELFSCHEDULE_REQUEST_ITEM_LOCATION |
| Self-schedule Request Subtype Category | The category associated with submitted self-scheduling requests (Open Shift of Shift Template) | SELFSCHEDULE_REQUEST_ITEM_SCHEDULE_TYPE |
| Self-schedule Request Item Segment End Date | End date and time of the requested shift segment. | SELFSCHEDULE_REQUEST_ITEM_SEGMENT_END_DATETIME |
| Self-schedule Request Item Segment Start Date | Start date and time of the requested shift segment. | SELFSCHEDULE_REQUEST_ITEM_SEGMENT_START_DATETIME |
| Self-schedule Request Item Start Date | Start date and time of the requested shift. | SELFSCHEDULE_REQUEST_ITEM_START_DATETIME |
| Self-schedule Request Item Segment Work Rule | Work rule that is associated with the requested shift segment. | SELFSCHEDULE_REQUEST_ITEM_WORKRULE |
| Self-schedule Request Status | Current status of the self-schedule request at the time the Dataview or report data object is executed. | SELFSCHEDULE_REQUEST_STATUS |
| Self-schedule Request Status Code | Code of the current status of the self-schedule request. | SELFSCHEDULE_REQUEST_STATUS_CODE |
| Self-schedule Request Subtype Description | Description of the request subtype that is associated with the self-schedule request. | SELFSCHEDULE_REQUEST_SUBTYPE_DESC |
| Self-schedule Request Subtype Name | Name of the request subtype that is associated with the self-schedule request. | SELFSCHEDULE_REQUEST_SUBTYPE_NAME |
| Self-schedule Request Subtype Symbol | Symbol of the request subtype that is associated with the self-schedule request. | SELFSCHEDULE_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 |