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.

Data Granularity

Provides one row per self-schedule request item segment.

Supported Dataview/RDO Type

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

Columns

Self-schedule Request ID System identifier of the self-schedule request SELFSCHEDULE_REQUEST_ID String No
Self-schedule Request Creator Full Name Full name of the user who created the self-schedule request SELFSCHEDULE_REQUEST_CREATOR_NAME String No
Self-schedule Request Subtype Name Name of the request subtype that is associated with the self-schedule request SELFSCHEDULE_REQUEST_SUBTYPE_NAME String No
Self-schedule Request Subtype Description Description of the request subtype that is associated with the self-schedule request SELFSCHEDULE_REQUEST_SUBTYPE_DESC String No
Self-schedule Request Subtype Symbol Symbol of the request subtype that is associated with the self-schedule request SELFSCHEDULE_REQUEST_SUBTYPE_SYMBOL String No
Self-schedule Request Creation Date Date and time when the user created the self-schedule request SELFSCHEDULE_REQUEST_CREATE_DATETIME DateTime No
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 String No
Self-schedule Request Status Code Code of the current status of the self-schedule request SELFSCHEDULE_REQUEST_STATUS_CODE String No
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 String No
Self-schedule Request Item Start Date Start date and time of the requested shift SELFSCHEDULE_REQUEST_ITEM_START_DATETIME DateTime No
Self-schedule Request Item End Date End date and time of the requested shift SELFSCHEDULE_REQUEST_ITEM_END_DATETIME DateTime No
Self-schedule Request Item Duration Span in hours of the requested shift SELFSCHEDULE_REQUEST_ITEM_DURATION Number No
Self-schedule Request Item Segment Start Date Start date and time of the requested shift segment SELFSCHEDULE_REQUEST_ITEM_SEGMENT_START_DATETIME DateTime No
Self-schedule Request Item Segment End Date End date and time of the requested shift segment SELFSCHEDULE_REQUEST_ITEM_SEGMENT_END_DATETIME DateTime No
Self-schedule Request Item Segment Location Location that is associated with the requested shift segment SELFSCHEDULE_REQUEST_ITEM_LOCATION String No
Self-schedule Request Item Segment Job Job that is associated with the requested shift segment SELFSCHEDULE_REQUEST_ITEM_JOB String No
Self-schedule Request Item Segment Labor Category Labor category that is associated with the requested shift segment SELFSCHEDULE_REQUEST_ITEM_LABOR_CATEGORY String No
Self-schedule Request Item Segment Cost Center Cost center that is associated with the requested shift segment SELFSCHEDULE_REQUEST_ITEM_COST_CENTER String No
Self-schedule Request Item Segment Work Rule Work rule that is associated with the requested shift segment SELFSCHEDULE_REQUEST_ITEM_WORKRULE String No

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

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