Availability Request Detail

The Availability Request Detail entity provides data that enables you to create Dataviews and reports that can be used to review availability 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 availability requests are being approved or rejected in a timely manner and learn which employees are or are not regularly requesting availability changes. Use the columns in the Employee Details entity along with those in the Availability Request Detail entity to view data columns associated with the employee that is related to the availability request. Note that the selected time frame is used to bring up requests based on the dates included in the request, and not the date on which the request was submitted.

Data Granularity

Provides one row per availability segment.

Supported Dataview/RDO Type

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

Columns


Availability Request ID	System identifier of the availability request	AVAILABILITY_REQUEST_ID	String	No
Availability Request Creator Full Name	Full name of the user who created the availability request	AVAILABILITY_REQUEST_CREATOR_NAME	String	No
Availability Request Subtype Name	Name of the request subtype that is associated with the availability request	AVAILABILITY_REQUEST_SUBTYPE_NAME	String	No
Availability Request Subtype Description	Description of the request subtype that is associated with the availability request	AVAILABILITY_REQUEST_SUBTYPE_DESC	String	No
Availability Request Subtype Symbol	Symbol of the request subtype that is associated with the availability request	AVAILABILITY_REQUEST_SUBTYPE_SYMBOL	String	No
Availability Request Creation Date	Date and time when the user created the availability request	AVAILABILITY_REQUEST_CREATE_DATETIME	DateTime	No
Availability Request Status	Current status of the availability request at the time the Dataview or report data object is executed	AVAILABILITY_REQUEST_STATUS	String	No
Availability Request Approvers	Semicolon-separated list of the full names of the users who have approved or rejected the availability request. Approvers appear in order of the approval's apply dates and times from oldest to newest	AVAILABILITY_REQUEST_APPROVERS	String	No
Availability Request Start Date	Start date of the requested availability	AVAILABILITY_REQUEST_STARTDATE	Date	No
Availability Request End Date	End date of the requested availability	AVAILABILITY_REQUEST_ENDDATE	Date	No
Availability Request Item Date	Date of an availability request item	AVAILABILITY_REQUEST_ITEM_DATE	Date	No
Availability Request Item Segment Start Time	Start time of the availability segment	AVAILABILITY_REQUEST_ITEM_SEGMENT_STARTTIME	DateTime	No
Availability Request Item Segment End Time	End time of the availability segment	AVAILABILITY_REQUEST_ITEM_SEGMENT_ENDTIME	DateTime	No
Availability Request Item Segment Type	Type of the availability segment	AVAILABILITY_REQUEST_ITEM_SEGMENT_TYPE	String	No

Core Entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category	Activity	Work Unit	Work Group	Procedure Code

Relationship

One-to-One	One-to-Many