ShiftTradesByShiftID: Horeko Shift Trades by Shift ID
read only REST
- Catalog:
Horeko - Schema:
ShiftTrade - Label: Shift Trades by Shift ID
Can only retrieve data.
API Source
- Endpoint:
/v4/shifttrades/{shiftId}/{shiftTradeId} - Operation:
get /v4/shifttrades/{shiftId}/{shiftTradeId}
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
shift |
`` | |||
shift |
`` |
Table Columns
The columns of the table ShiftTradesByShiftID 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 |
|---|---|---|---|---|---|
Request |
varchar2 |
Request Type | |||
Shift |
char |
itgen_horeko_shiftdata_approved | |||
Shift |
int32 |
itgen_horeko_shiftdata_approvedby | |||
Shift |
varchar2 |
itgen_horeko_shiftdata_approvedbyname | |||
Shift |
varchar2 |
itgen_horeko_shiftdata_defaultshift | |||
Shift |
int32 |
itgen_horeko_shiftdata_departmentid | |||
Shift |
varchar2 |
itgen_horeko_shiftdata_departmentname | |||
Shift |
varchar2 |
itgen_horeko_shiftdata_description | |||
Shift |
int32 |
itgen_horeko_shiftdata_employeeid | |||
Shift |
varchar2 |
itgen_horeko_shiftdata_fullname | |||
Shift |
char |
itgen_horeko_shiftdata_hardendtime | |||
Shift |
char |
itgen_horeko_shiftdata_hardstarttime | |||
Shift |
double |
itgen_horeko_shiftdata_hourlyrate | |||
Shift |
char |
itgen_horeko_shiftdata_ispublished | |||
Shift |
char |
itgen_horeko_shiftdata_isrecurrent | |||
Shift |
varchar2 |
itgen_horeko_shiftdata_teamname | |||
Shift |
char |
itgen_horeko_shifttradingdata_approved | |||
Shift |
int32 |
itgen_horeko_shifttradingdata_approvedbyid | |||
Shift |
int32 |
itgen_horeko_shifttradingdata_approvedcount | |||
Shift |
datetime |
itgen_horeko_shifttradingdata_datecreated | |||
Shift |
int32 |
itgen_horeko_shifttradingdata_disapprovedcount | |||
Shift |
varchar2 |
itgen_horeko_shifttradingdata_explanation | |||
Shift |
int32 |
itgen_horeko_shifttradingdata_id | |||
Shift |
varchar2 |
itgen_horeko_shifttradingdata_newassigneefullname | |||
Shift |
int32 |
itgen_horeko_shifttradingdata_newassigneeid | |||
Shift |
varchar2 |
itgen_horeko_shifttradingdata_oldassigneefullname | |||
Shift |
int32 |
itgen_horeko_shifttradingdata_oldassigneeid | |||
Shift |
int32 |
itgen_horeko_shifttradingdata_pendingcount | |||
Shift |
char |
itgen_horeko_shifttradingdata_requiredshift | |||
Shift |
char |
itgen_horeko_shifttradingdata_sendtomanager | |||
Shift |
datetime |
itgen_horeko_shifttradingdata_shiftend | |||
Shift |
int32 |
itgen_horeko_shifttradingdata_shiftid | |||
Shift |
datetime |
itgen_horeko_shifttradingdata_shiftstart |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: