invantive documentation
Invantive Support ForumsLog In / Sign Up

TodaysShiftsByStatus: Horeko Todays Shifts by Status

read only REST

  • Catalog: Horeko
  • Schema: Clocking
  • Label: Todays Shifts by Status

Can only retrieve data.

API Source

  • Endpoint: /v4/clock/getTodaysSchedule
  • Operation: get /v4/clock/getTodaysSchedule

Parameters

Name Data Type Required Default Documentation
departementId ``
status `` Values: 0, 1, 2, 3, 4.
teamId ``

Table Columns

The columns of the table TodaysShiftsByStatus 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
Break int32 Break
ClockedHourId int32 Clocked Hour ID
ClockedTime varchar2 Clocked Time
ClockingShiftEnd datetime Clocking Shift End
ClockingShiftStart datetime Clocking Shift Start
DepartmentId int32 Department ID
DepartmentIsFlexible char Department is Flexible
DepartmentName varchar2 Department Name
EmployeeFullName varchar2 Employee Full Name
EmployeeId int32 Employee ID
EmployeeImagePath varchar2 Employee Image Path
EventName varchar2 Event Name
From datetime From
Id int32 ID
Status int32 Status
TeamId int32 Team ID
TeamName varchar2 Team Name
To datetime To
TotalBreaksTime varchar2 itgen_horeko_totalbreakstime
WorkedTimeExcludingBreaks varchar2 Worked Time Excluding Breaks

Release Notes

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