Time-Off Request

The Time-Off Request entity provides data columns for use in Employee Dataviews and reports to monitor and manage time-off requests. The information returned in these columns includes the number of time-off-requests, the IDs of the employees making each request, and the request status (as a means to determine whether managers are approving or rejecting requests).

Use the columns in the Employee Detailsentity along with those in the Time-Off Request entity to view data columns associated with the employee that is related to the time-off request.

Use the columns in the Paycodeentity along with those in the Time-Off Request entity to view the pay code name and other attributes of the pay code that is associated with the time-off request.

Supported Dataview types

Employee Dataview

Business Structure Dataview

X

Data granularity

One row per employee, per time-off request item.

Columns

Label

Description

Key

Time-off Request Actors

Names of the users who have approved or rejected the time-off request

TIMEOFF_REQUEST_ACTORS

Time-off Request Creation Date

Date and time that the time-off request was created and submitted by the employee.

TIMEOFF_REQUEST_CREATE_DATETIME

Time-off Request Creator Full Name

Full name of the user who created the time-off request.

TIMEOFF_REQUEST_CREATOR_NAME

Time-off Request Employee Comments & Notes

List of the comments and associated notes that the employee has applied to the time-off request.

TIMEOFF_REQUEST_EMP_COMMENTS_NOTES

Time-off Request ID

System identifier of the time-off request.

TIMEOFF_REQUEST_ID

Time-off Request Item Duration

Number of hours or days of the requested time-off items.

TIMEOFF_REQUEST_END_DURATION

Time-off Request Item Duration

The hours or days of requested time-off

TIMEOFF_REQUEST_DURATION

Time-off Request Item End Date

End date and time of the requested time-off items.

TIMEOFF_REQUEST_END_DATETIME

Time-off Request Item Start Date

Start date and time of the requested time-off items.

TIMEOFF_REQUEST_START_DATETIME

Time-off Request Manager Comments & Notes

List of the comments and associated notes that a manager has applied to the time-off request.

TIMEOFF_REQUEST_MGR_COMMENTS_NOTES

Time-off Request Status

Current status of the time-off request: that is, the status of the request at the time that the Dataview or report is executed by a user.

TIMEOFF_REQUEST_STATUS

Time-off Request Status Code

Code representing the status of the time-off request.

TIMEOFF_REQUEST_STATUS_CODE

Time-off Request Subtype Description

Description of the time-off request subtype.

TIMEOFF_REQUEST_SUBTYPE_DSC

Time-off Request Subtype Name

Name of the request subtype that is associated with the time-off request.

TIMEOFF_REQUEST_SUBTYPE_NAME

Time-off Request Subtype Symbol

Symbol of the time-off request subtype.

TIMEOFF_REQUEST_SUBTYPE_SYMBOL

Time-off Request Symbolic Amount

Symbolic amount of the requested time-off.

TIMEOFF_REQUEST_SYMBOLIC_AMOUNT

Additional information

The Time-Off Request entity does not have a relationship with the Time-Off Request Status History entity because the entities provide the data at different levels of granularity. If the Column Relationship Rules are enabled and the user selects a column from the Time-Off Request entity, the user cannot add columns from the Time-Off Request Status History entity.

When a Dataview or report is executed for a selected time span, the Time-Off Request entity returns any request with dates that overlap that time span.

Core entity

Employee

Organization

Day

Organizational Job

Paycode

Labor Category

Activity

X

X

X

Relationship

One-to-One

One-to-Many

X