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.
Supported Dataview types
| Employee Dataview | Business Structure Dataview |
|---|---|
| X |
Data granularity
Provides one row per availability segment.
Columns
| Label | Description | Key |
|---|---|---|
| Availability Request ID | System identifier of the availability request. | AVAILABILITY_REQUEST_ID |
| Availability Request Creator Full Name | Full name of the user who created the availability request. | AVAILABILITY_REQUEST_CREATOR_NAME |
| Availability Request Subtype Name | Name of the request subtype that is associated with the availability request. | AVAILABILITY_REQUEST_SUBTYPE_NAME |
| Availability Request Subtype Description | Description of the request subtype that is associated with the availability request. | AVAILABILITY_REQUEST_SUBTYPE_DESC |
| Availability Request Subtype Symbol | Symbol of the request subtype that is associated with the availability request. | AVAILABILITY_REQUEST_SUBTYPE_SYMBOL |
| Availability Request Creation Date | Date and time when the user created the availability request. | AVAILABILITY_REQUEST_CREATE_DATETIME |
| Availability Request Status | Current status of the availability request at the time the Dataview or report data object is executed. | AVAILABILITY_REQUEST_STATUS |
| 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 |
| Availability Request Start Date | Start date of the requested availability. | AVAILABILITY_REQUEST_STARTDATE |
| Availability Request End Date | End date of the requested availability. | AVAILABILITY_REQUEST_ENDDATE |
| Availability Request Item Date | Date of an availability request item. | AVAILABILITY_REQUEST_ITEM_DATE |
| Availability Request Item Segment Start Time | Start time of the availability segment. | AVAILABILITY_REQUEST_ITEM_SEGMENT_STARTTIME |
| Availability Request Item Segment End Time | End time of the availability segment. | AVAILABILITY_REQUEST_ITEM_SEGMENT_ENDTIME |
| Availability Request Item Segment Type | Type of the availability segment. | AVAILABILITY_REQUEST_ITEM_SEGMENT_TYPE |
Core entity
| Employee | Organization | Day | Organizational Job | Paycode | Labor Category | Activity |
|---|---|---|---|---|---|---|
| X |
Relationship
| One-to-One | One-to-Many |
|---|---|
| X |