Swap Request

The Swap Request entity provides data that enables you to create Dataviews and reports that can be used to review swap requests that are made by employees. This data allows you 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 swap requests are being approved or rejected in a timely manner, learn which employees are or are not regularly requesting other employees to swap their shifts, and see whether swap requests are being accepted or rejected by other employees.

Use the columns in the Employee Detailsentity along with those in the Swap Request entity to view data columns associated with the employee that is related to the swap request.

Note that the selected time frame is used to bring up requests based on either of the shift dates included in the request, and not the creation date of the request.

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

Data granularity

Provides one row per employee per swap shift request item segment and recipient.

Columns

Label

Description

Key

Swap Request Item Segment End Date

End date and time of the shift segment in the swap.

This field has been parameterized to return information about the offered or requested shift as determined by the user who submitted the request.

SWAP_REQUEST_ITEM_SEGMENT_END_DATETIME

Swap Request Actors

Semicolon-separated list of the full names of the users who have approved or rejected the swap request. Approvers appear in order of the approval's apply dates and times from oldest to newest.

SWAP_REQUEST_ACTORS

Swap Request Creation Date

Date and time when the user created the swap request.

SWAP_REQUEST_CREATE_DATETIME

Swap Request Creator Full Name

Full name of the user who created the swap request.

SWAP_REQUEST_CREATOR_NAME

Swap Request Employee Comment & Notes

Semicolon-separated list of comments and associated notes (in parentheses) that the employee has applied to the swap request. Comments appear in order of their apply dates and times from oldest to newest.

SWAP_REQUEST_EMP_COMMENTS_NOTES

Swap Request ID

System identifier of the swap request.

SWAP_REQUEST_ID

Swap Request Item Duration

Span in hours of the shift in the swap.

This field has been parameterized to return information about the offered or requested shift as determined by the user who submitted the request.

SWAP_REQUEST_ITEM_DURATION

Swap Request Item End Date

End date and time of the shift segment in the swap.

This field has been parameterized to return information about the offered or requested shift as determined by the user who submitted the request.

SWAP_REQUEST_ITEM_END_DATETIME

Swap Request Item Recipient Employee ID

Employee ID of the employee who received the swap request.

SWAP_REQUEST_ITEM_RECIPIENT_EMPLOYEEID

Swap Request Item Recipient Full Name

Full name of the employee who received the swap request.

SWAP_REQUEST_ITEM_RECIPIENT_NAME

Swap Request Item Segment Cost Center

Cost center that is associated with the shift segment in the swap.

This field has been parameterized to return information about the offered or requested shift as determined by the user who submitted the request.

SWAP_REQUEST_ITEM_COST_CENTER

Swap Request Item Segment Job

Job that is associated with the shift segment in the swap.

This field has been parameterized to return information about the offered or requested shift as determined by the user who submitted the request.

SWAP_REQUEST_ITEM_JOB

Swap Request Item Segment Labor Category

Labor category that is associated with the shift segment in the swap.

This field has been parameterized to return information about the offered or requested shift as determined by the user who submitted the request.

SWAP_REQUEST_ITEM_LABOR CATEGORY

Swap Request Item Segment Location

Location that is associated with the shift segment in the swap.

This field has been parameterized to return information about the offered or requested shift as determined by the user who submitted the request.

SWAP_REQUEST_ITEM_LOCATION

Swap Request Item Segment Start Date

Start date and time of the shift segment in the swap.

This field has been parameterized to return information about the offered or requested shift as determined by the user who submitted the request.

SWAP_REQUEST_ITEM_SEGMENT_START_DATETIME

Swap Request Item Segment Work Rule

Work rule that is associated with the shift segment in the swap.

This field has been parameterized to return information about the offered or requested shift as determined by the user who submitted the request.

SWAP_REQUEST_ITEM_WORKRULE

Swap Request Item Start Date

Start date and time of the shift segment in the swap.

This field has been parameterized to return information about the offered or requested shift as determined by the user who submitted the request.

SWAP_REQUEST_ITEM_START_DATETIME

Swap Request Manager Comment & Notes

Semicolon-separated list of comments and associated notes (in parentheses) that the manager has applied to the swap request. Comments appear in order of their apply dates and times from oldest to newest.

SWAP_REQUEST_MGR_COMMENTS_NOTES

Swap Request Status

Current status of the swap request at the time the Dataview or report data object is executed.

SWAP_REQUEST_STATUS

Swap Request Status Code

Code of the current status of the swap request.

SWAP_REQUEST_STATUS_CODE

Swap Request Subtype Description

Description of the request subtype that is associated with the swap request.

SWAP_REQUEST_SUBTYPE_DESC

Swap Request Subtype Name

Name of the request subtype that is associated with the swap request.

SWAP_REQUEST_SUBTYPE_NAME

Swap Request Subtype Symbol

Symbol of the request subtype that is associated with the swap request.

SWAP_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