UndecidedAndFutureRequestTeamsByRosterType: Horeko Undecided and Future Request Teams by Roster Type
read only REST
- Katalog:
Horeko - Schema:
Request - Label: Undecided and Future Request Teams by Roster Type
Es können nur Daten abgerufen werden.
API-Quelle
- Endpunkt:
/v4/requests/{rosterType}/{type}/{undecidedRequests}/{futureRequests} - Operation:
get /v4/requests/{rosterType}/{type}/{undecidedRequests}/{futureRequests}
Parameter
| Name | Datentyp | Required | Default | Documentation |
|---|---|---|---|---|
future |
`` | |||
roster |
`` | |||
type |
`` | |||
undecided |
`` |
Tabellenspalten
Die Spalten der Tabelle UndecidedAndFutureRequestTeamsByRosterType sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Approval |
varchar2 |
Genehmigungserklärung | |||
Approval |
varchar2 |
Genehmigungsstatus | |||
Approved |
varchar2 |
Genehmigt durch | |||
Approved |
char |
Genehmigt vom Manager | |||
Approved |
char |
Genehmigt vom Empfänger | |||
Approved |
int32 |
Genehmigungsnummer | |||
Author |
varchar2 |
Autor Vorname | |||
Author |
int32 |
Autor-ID | |||
Author |
varchar2 |
Autor Nachname | |||
Author |
varchar2 |
Autor mittlerer Name | |||
Comment |
varchar2 |
Comment | |||
Deleted |
char |
Deleted | |||
Disapproved |
int32 |
Ablehnungsnummer | |||
Employee_ |
varchar2 |
itgen_horeko_employee_employeenumber | |||
Employee_ |
varchar2 |
itgen_horeko_employee_firstname | |||
Employee_ |
varchar2 |
itgen_horeko_employee_fullname | |||
Employee_ |
int32 |
Mitarbeiter ID | |||
Employee_ |
varchar2 |
itgen_horeko_employee_imagepath | |||
Employee_ |
varchar2 |
itgen_horeko_employee_lastname | |||
Employee_ |
varchar2 |
itgen_horeko_employee_middlename | |||
Employee |
varchar2 |
Mitarbeiter-Status | |||
End |
datetime |
End | |||
First |
varchar2 |
Vorname | |||
Id |
int32 |
ID | |||
Last |
varchar2 |
Nachname | |||
Middle |
varchar2 |
Zweiter Name | |||
Pending |
int32 |
Ausstehende Nummer | |||
Reason |
varchar2 |
Reason | |||
Recurrence |
varchar2 |
Wiederholungsmeldung | |||
Recurrency |
varchar2 |
Beschreibung der Wiederkehr | |||
Recurrency |
datetime |
itgen_horeko_recurrencyenddate | |||
Recurrency |
varchar2 |
itgen_horeko_recurrencystring | |||
Request |
datetime |
Anfragedatum | |||
Request |
varchar2 |
Anfragetyp | |||
Send |
char |
An den Vorgesetzten senden | |||
Shift_ |
varchar2 |
itgen_horeko_shift_approvedby | |||
Shift_ |
int32 |
itgen_horeko_shift_breakmins | |||
Shift_ |
varchar2 |
itgen_horeko_shift_comments | |||
Shift_ |
datetime |
itgen_horeko_shift_datefrom | |||
Shift_ |
datetime |
itgen_horeko_shift_dateto | |||
Shift_ |
int32 |
itgen_horeko_shift_deltaend | |||
Shift_ |
int32 |
itgen_horeko_shift_deltastart | |||
Shift_ |
varchar2 |
itgen_horeko_shift_department_city | |||
Shift_ |
double |
itgen_horeko_shift_department_coordinates_latitude | |||
Shift_ |
double |
itgen_horeko_shift_department_coordinates_longitude | |||
Shift_ |
varchar2 |
itgen_horeko_shift_department_country | |||
Shift_ |
varchar2 |
itgen_horeko_shift_department_description | |||
Shift_ |
char |
itgen_horeko_shift_department_flexiblelocation | |||
Shift_ |
varchar2 |
itgen_horeko_shift_department_houseno | |||
Shift_ |
int32 |
itgen_horeko_shift_department_id | |||
Shift_ |
varchar2 |
itgen_horeko_shift_department_name | |||
Shift_ |
datetime |
itgen_horeko_shift_department_published | |||
Shift_ |
int32 |
itgen_horeko_shift_department_showorder | |||
Shift_ |
varchar2 |
itgen_horeko_shift_department_street | |||
Shift_ |
varchar2 |
itgen_horeko_shift_department_zipcode | |||
Shift_ |
varchar2 |
itgen_horeko_shift_description | |||
Shift_ |
int32 |
itgen_horeko_shift_employeeid | |||
Shift_ |
char |
itgen_horeko_shift_hardend | |||
Shift_ |
char |
itgen_horeko_shift_hardstart | |||
Shift_ |
char |
itgen_horeko_shift_isdecided | |||
Shift_ |
char |
itgen_horeko_shift_islocationflexible | |||
Shift_ |
char |
itgen_horeko_shift_ispublished | |||
Shift_ |
char |
itgen_horeko_shift_isstandby | |||
Shift_ |
varchar2 |
itgen_horeko_shift_location_city | |||
Shift_ |
double |
itgen_horeko_shift_location_coordinates_latitude | |||
Shift_ |
double |
itgen_horeko_shift_location_coordinates_longitude | |||
Shift_ |
varchar2 |
itgen_horeko_shift_location_country | |||
Shift_ |
varchar2 |
itgen_horeko_shift_location_description | |||
Shift_ |
int32 |
itgen_horeko_shift_location_id | |||
Shift_ |
varchar2 |
itgen_horeko_shift_location_name | |||
Shift_ |
varchar2 |
itgen_horeko_shift_location_number | |||
Shift_ |
varchar2 |
itgen_horeko_shift_location_phoneno | |||
Shift_ |
varchar2 |
itgen_horeko_shift_location_street | |||
Shift_ |
varchar2 |
itgen_horeko_shift_location_zipcode | |||
Shift_ |
varchar2 |
itgen_horeko_shift_name | |||
Shift_ |
int32 |
itgen_horeko_shift_shiftid | |||
Shift_ |
int32 |
itgen_horeko_shift_shiftpid | |||
Shift_ |
int32 |
itgen_horeko_shift_teamid | |||
Shift_ |
varchar2 |
itgen_horeko_shift_teamname | |||
Shift_ |
int32 |
itgen_horeko_shift_teamorder | |||
Shift |
varchar2 |
Schicht-Handels-ID | |||
Start |
datetime |
Start | |||
Status |
char |
Status | |||
TEXT |
int32 |
Text | |||
Type |
varchar2 |
Type | |||
Unavailability |
int32 |
Art der Nichtverfügbarkeit | |||
Unavailable |
int32 |
ID nicht verfügbar |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: