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