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 Details entity 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 Paycode entity 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.

Data Granularity

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

Supported Dataview/RDO Type

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

Columns


Time-off Request Actors	Names of the users who have approved or rejected the time-off request	TIMEOFF_REQUEST_ACTORS	String	No
Time-off Request Creation Date	Date and time that the time-off request was created and submitted by the employee	TIMEOFF_REQUEST_CREATE_DATETIME	DateTime	No
Time-off Request Creator Full Name	Full name of the user who created the time-off request	TIMEOFF_REQUEST_CREATOR_NAME	String	No
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	String	No
Time-off Request ID	System identifier of the time-off request	TIMEOFF_REQUEST_ID	String	No
Time-off Request Item Duration	The hours or days of requested time-off	TIMEOFF_REQUEST_DURATION	Number	No
Time-off Request Item End Date	End date and time of the requested time-off items	TIMEOFF_REQUEST_END_DATETIME	DateTime	No
Time-off Request Item Start Date	Start date and time of the requested time-off items	TIMEOFF_REQUEST_START_DATETIME	DateTime	No
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	String	No
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	String	No
Time-off Request Status Code	Code representing the status of the time-off request	TIMEOFF_REQUEST_STATUS_CODE	String	No
Time-off Request Subtype Description	Description of the time-off request subtype	TIMEOFF_REQUEST_SUBTYPE_DSC	String	No
Time-off Request Subtype Name	Name of the request subtype that is associated with the time-off request	TIMEOFF_REQUEST_SUBTYPE_NAME	String	No
Time-off Request Subtype Symbol	Symbol of the time-off request subtype	TIMEOFF_REQUEST_SUBTYPE_SYMBOL	String	No
Time-off Request Symbolic Amount	Symbolic amount of the requested time-off	TIMEOFF_REQUEST_SYMBOLIC_AMOUNT	String	No

Additional Info

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	Work Unit	Work Group	Procedure Code

Relationship

One-to-One	One-to-Many