TodaysShifts: Horeko Todays Shifts
read only
- Catalog:
Horeko - Schema:
Views - Label: Todays Shifts
Can only retrieve data.
Table Columns
The columns of the table TodaysShifts 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 | |||
Clocked |
int32 |
Clocked Hour ID | |||
Clocked |
varchar2 |
Clocked Time | |||
Clocking |
datetime |
Clocking Shift End | |||
Clocking |
datetime |
Clocking Shift Start | |||
Department |
int32 |
Department ID | |||
Department |
char |
Department is Flexible | |||
Department |
varchar2 |
Department Name | |||
Employee |
varchar2 |
Employee Full Name | |||
Employee |
int32 |
Employee ID | |||
Employee |
varchar2 |
Employee Image Path | |||
Event |
varchar2 |
Event Name | |||
From |
datetime |
From | |||
Id |
int32 |
ID | |||
Status |
int32 |
Status | |||
TeamId |
int32 |
Team ID | |||
Team |
varchar2 |
Team Name | |||
To |
datetime |
To | |||
Total |
varchar2 |
itgen_horeko_totalbreakstime | |||
Worked |
varchar2 |
Worked Time Excluding Breaks |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: