---
title: "UndecidedAndFutureRequestTeamsByRosterType (Horeko)"
description: "Undecided and Future Request Teams by Roster Type"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/horeko/Horeko.Request.UndecidedAndFutureRequestTeamsByRosterType
original: https://documentation.invantive.eu/en/datamodels/horeko/Horeko.Request.UndecidedAndFutureRequestTeamsByRosterType
updated: 2025-06-11T11:15:01Z
license: https://documentation.invantive.eu/en/
---

# UndecidedAndFutureRequestTeamsByRosterType: Horeko Undecided and Future Request Teams by Roster Type

`read only` `REST`

- Catalog: `Horeko`
- Schema: `Request`
- Label: Undecided and Future Request Teams by Roster Type

Can only retrieve data.

## API Source

- Endpoint: `/v4/requests/{rosterType}/{type}/{undecidedRequests}/{futureRequests}`
- Operation: `get /v4/requests/{rosterType}/{type}/{undecidedRequests}/{futureRequests}`

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `futureRequests` | `` | [x] |  |  |
| `rosterType` | `` | [x] |  |  |
| `type` | `` | [x] |  |  |
| `undecidedRequests` | `` | [x] |  |  |

## Table Columns

The columns of the table `UndecidedAndFutureRequestTeamsByRosterType` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ApprovalExplanation` | `varchar2` | Approval Explanation | [ ] |  |  |
| `ApprovalStatus` | `varchar2` | Approval Status | [ ] |  |  |
| `ApprovedBy` | `varchar2` | Approved by | [ ] |  |  |
| `ApprovedByManager` | `char` | Approved by Manager | [ ] |  |  |
| `ApprovedByRecipient` | `char` | Approved by Recipient | [ ] |  |  |
| `ApprovedNum` | `int32` | Approved Number | [ ] |  |  |
| `AuthorFirstName` | `varchar2` | Author First Name | [ ] |  |  |
| `AuthorId` | `int32` | Author ID | [ ] |  |  |
| `AuthorLastName` | `varchar2` | Author Last Name | [ ] |  |  |
| `AuthorMiddleName` | `varchar2` | Author Middle Name | [ ] |  |  |
| `Comment` | `varchar2` | Comment | [ ] |  |  |
| `Deleted` | `char` | Deleted | [ ] |  |  |
| `DisapprovedNum` | `int32` | Disapproved Number | [ ] |  |  |
| `Employee_EmployeeNumber` | `varchar2` | itgen_horeko_employee_employeenumber | [ ] |  |  |
| `Employee_FirstName` | `varchar2` | itgen_horeko_employee_firstname | [ ] |  |  |
| `Employee_FullName` | `varchar2` | itgen_horeko_employee_fullname | [ ] |  |  |
| `Employee_Id` | `int32` | Employee ID | [ ] |  |  |
| `Employee_ImagePath` | `varchar2` | itgen_horeko_employee_imagepath | [ ] |  |  |
| `Employee_LastName` | `varchar2` | itgen_horeko_employee_lastname | [ ] |  |  |
| `Employee_MiddleName` | `varchar2` | itgen_horeko_employee_middlename | [ ] |  |  |
| `EmployeeStatus` | `varchar2` | Employee Status | [ ] |  |  |
| `End` | `datetime` | End | [ ] |  |  |
| `FirstName` | `varchar2` | First Name | [ ] |  |  |
| `Id` | `int32` | ID | [ ] |  |  |
| `LastName` | `varchar2` | Last Name | [ ] |  |  |
| `MiddleName` | `varchar2` | Middle Name | [ ] |  |  |
| `PendingNum` | `int32` | Pending Number | [ ] |  |  |
| `Reason` | `varchar2` | Reason | [ ] |  |  |
| `RecurrenceMessage` | `varchar2` | Recurrence Message | [ ] |  |  |
| `RecurrencyDescription` | `varchar2` | Recurrency Description | [ ] |  |  |
| `RecurrencyEndDate` | `datetime` | itgen_horeko_recurrencyenddate | [ ] |  |  |
| `RecurrencyString` | `varchar2` | itgen_horeko_recurrencystring | [ ] |  |  |
| `RequestDate` | `datetime` | Request Date | [ ] |  |  |
| `RequestType` | `varchar2` | Request Type | [ ] |  |  |
| `SendToManager` | `char` | Send to Manager | [ ] |  |  |
| `Shift_ApprovedBy` | `varchar2` | itgen_horeko_shift_approvedby | [ ] |  |  |
| `Shift_BreakMins` | `int32` | itgen_horeko_shift_breakmins | [ ] |  |  |
| `Shift_Comments` | `varchar2` | itgen_horeko_shift_comments | [ ] |  |  |
| `Shift_DateFrom` | `datetime` | itgen_horeko_shift_datefrom | [ ] |  |  |
| `Shift_DateTo` | `datetime` | itgen_horeko_shift_dateto | [ ] |  |  |
| `Shift_DeltaEnd` | `int32` | itgen_horeko_shift_deltaend | [ ] |  |  |
| `Shift_DeltaStart` | `int32` | itgen_horeko_shift_deltastart | [ ] |  |  |
| `Shift_Department_City` | `varchar2` | itgen_horeko_shift_department_city | [ ] |  |  |
| `Shift_Department_Coordinates_Latitude` | `double` | itgen_horeko_shift_department_coordinates_latitude | [ ] |  |  |
| `Shift_Department_Coordinates_Longitude` | `double` | itgen_horeko_shift_department_coordinates_longitude | [ ] |  |  |
| `Shift_Department_Country` | `varchar2` | itgen_horeko_shift_department_country | [ ] |  |  |
| `Shift_Department_Description` | `varchar2` | itgen_horeko_shift_department_description | [ ] |  |  |
| `Shift_Department_FlexibleLocation` | `char` | itgen_horeko_shift_department_flexiblelocation | [ ] |  |  |
| `Shift_Department_HouseNo` | `varchar2` | itgen_horeko_shift_department_houseno | [ ] |  |  |
| `Shift_Department_Id` | `int32` | itgen_horeko_shift_department_id | [ ] |  |  |
| `Shift_Department_Name` | `varchar2` | itgen_horeko_shift_department_name | [ ] |  |  |
| `Shift_Department_Published` | `datetime` | itgen_horeko_shift_department_published | [ ] |  |  |
| `Shift_Department_ShowOrder` | `int32` | itgen_horeko_shift_department_showorder | [ ] |  |  |
| `Shift_Department_Street` | `varchar2` | itgen_horeko_shift_department_street | [ ] |  |  |
| `Shift_Department_ZipCode` | `varchar2` | itgen_horeko_shift_department_zipcode | [ ] |  |  |
| `Shift_Description` | `varchar2` | itgen_horeko_shift_description | [ ] |  |  |
| `Shift_EmployeeId` | `int32` | itgen_horeko_shift_employeeid | [ ] |  |  |
| `Shift_HardEnd` | `char` | itgen_horeko_shift_hardend | [ ] |  |  |
| `Shift_HardStart` | `char` | itgen_horeko_shift_hardstart | [ ] |  |  |
| `Shift_IsDecided` | `char` | itgen_horeko_shift_isdecided | [ ] |  |  |
| `Shift_IsLocationFlexible` | `char` | itgen_horeko_shift_islocationflexible | [ ] |  |  |
| `Shift_IsPublished` | `char` | itgen_horeko_shift_ispublished | [ ] |  |  |
| `Shift_IsStandBy` | `char` | itgen_horeko_shift_isstandby | [ ] |  |  |
| `Shift_Location_City` | `varchar2` | itgen_horeko_shift_location_city | [ ] |  |  |
| `Shift_Location_Coordinates_Latitude` | `double` | itgen_horeko_shift_location_coordinates_latitude | [ ] |  |  |
| `Shift_Location_Coordinates_Longitude` | `double` | itgen_horeko_shift_location_coordinates_longitude | [ ] |  |  |
| `Shift_Location_Country` | `varchar2` | itgen_horeko_shift_location_country | [ ] |  |  |
| `Shift_Location_Description` | `varchar2` | itgen_horeko_shift_location_description | [ ] |  |  |
| `Shift_Location_Id` | `int32` | itgen_horeko_shift_location_id | [ ] |  |  |
| `Shift_Location_Name` | `varchar2` | itgen_horeko_shift_location_name | [ ] |  |  |
| `Shift_Location_Number` | `varchar2` | itgen_horeko_shift_location_number | [ ] |  |  |
| `Shift_Location_PhoneNo` | `varchar2` | itgen_horeko_shift_location_phoneno | [ ] |  |  |
| `Shift_Location_Street` | `varchar2` | itgen_horeko_shift_location_street | [ ] |  |  |
| `Shift_Location_ZipCode` | `varchar2` | itgen_horeko_shift_location_zipcode | [ ] |  |  |
| `Shift_Name` | `varchar2` | itgen_horeko_shift_name | [ ] |  |  |
| `Shift_ShiftId` | `int32` | itgen_horeko_shift_shiftid | [ ] |  |  |
| `Shift_ShiftPid` | `int32` | itgen_horeko_shift_shiftpid | [ ] |  |  |
| `Shift_TeamId` | `int32` | itgen_horeko_shift_teamid | [ ] |  |  |
| `Shift_TeamName` | `varchar2` | itgen_horeko_shift_teamname | [ ] |  |  |
| `Shift_TeamOrder` | `int32` | itgen_horeko_shift_teamorder | [ ] |  |  |
| `ShiftTradingId` | `varchar2` | Shift Trading ID | [ ] |  |  |
| `Start` | `datetime` | Start | [ ] |  |  |
| `Status` | `char` | Status | [ ] |  |  |
| `TEXT` | `int32` | Text | [ ] |  |  |
| `Type` | `varchar2` | Type | [ ] |  |  |
| `UnavailabilityType` | `int32` | Unavailability Type | [ ] |  |  |
| `UnavailableId` | `int32` | Unavailable ID | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Horeko](/en/release-notes/drivers?driver=horeko)

