ClockingStateByHourID: Horeko Clocking State by Hour ID
read only REST
- Catalog:
Horeko - Schema:
Clocking - Label: Clocking State by Hour ID
Returns clocking state for specific clocked hour Returns clocking state for provided clocked hour id.
Can only retrieve data.
API Source
- Endpoint:
/v4/clock/{id}/state - Operation:
get /v4/clock/{id}/state
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` |
Table Columns
The columns of the table ClockingStateByHourID 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 Length | |||
Clocked |
varchar2 |
itgen_horeko_clockedinby_employeenumber | |||
Clocked |
varchar2 |
itgen_horeko_clockedinby_firstname | |||
Clocked |
varchar2 |
itgen_horeko_clockedinby_fullname | |||
Clocked |
int32 |
itgen_horeko_clockedinby_id | |||
Clocked |
varchar2 |
itgen_horeko_clockedinby_imagepath | |||
Clocked |
varchar2 |
itgen_horeko_clockedinby_lastname | |||
Clocked |
varchar2 |
itgen_horeko_clockedinby_middlename | |||
Clocked |
varchar2 |
itgen_horeko_clockedoutby_employeenumber | |||
Clocked |
varchar2 |
itgen_horeko_clockedoutby_firstname | |||
Clocked |
varchar2 |
itgen_horeko_clockedoutby_fullname | |||
Clocked |
int32 |
itgen_horeko_clockedoutby_id | |||
Clocked |
varchar2 |
itgen_horeko_clockedoutby_imagepath | |||
Clocked |
varchar2 |
itgen_horeko_clockedoutby_lastname | |||
Clocked |
varchar2 |
itgen_horeko_clockedoutby_middlename | |||
Clock |
int32 |
Clock-in Method | 0 = Fingerprint | 1 = Android app | 2 = iOS app | 3 = PIN | 4 = Manager | 5 = Web app | ||
Clock |
int32 |
Clock-out Method | 0 = Fingerprint | 1 = Android app | 2 = iOS app | 3 = PIN | 4 = Manager | 5 = Web app | ||
Comment |
varchar2 |
Comment | |||
Department |
varchar2 |
Department Name | |||
Employee_ |
varchar2 |
itgen_horeko_employee_employeenumber | |||
Employee_ |
varchar2 |
itgen_horeko_employee_firstname | |||
Employee_ |
varchar2 |
itgen_horeko_employee_fullname | |||
Employee_ |
int32 |
Employee ID | |||
Employee_ |
varchar2 |
itgen_horeko_employee_imagepath | |||
Employee_ |
varchar2 |
itgen_horeko_employee_lastname | |||
Employee_ |
varchar2 |
itgen_horeko_employee_middlename | |||
End |
datetime |
End | |||
Id |
int32 |
ID | |||
Manager |
varchar2 |
Manager Comment | |||
Rounded |
datetime |
Rounded End | |||
Rounded |
datetime |
Rounded Start | |||
Shift_ |
int32 |
itgen_horeko_shift_break | |||
Shift_ |
datetime |
itgen_horeko_shift_end | |||
Shift_ |
int32 |
Shift ID | |||
Shift_ |
varchar2 |
itgen_horeko_shift_name | |||
Shift_ |
datetime |
itgen_horeko_shift_start | |||
Start |
datetime |
Start | |||
Status |
int32 |
Status | 0 = Undecided | 1 = Approved | 2 = Disapproved | ||
Status |
varchar2 |
itgen_horeko_statuschangedby_employeenumber | |||
Status |
varchar2 |
itgen_horeko_statuschangedby_firstname | |||
Status |
varchar2 |
itgen_horeko_statuschangedby_fullname | |||
Status |
int32 |
itgen_horeko_statuschangedby_id | |||
Status |
varchar2 |
itgen_horeko_statuschangedby_imagepath | |||
Status |
varchar2 |
itgen_horeko_statuschangedby_lastname | |||
Status |
varchar2 |
itgen_horeko_statuschangedby_middlename | |||
Status |
datetime |
Status Changed Date Time | |||
Team |
varchar2 |
Team Name | |||
Undefined |
char |
Undefined Clocked-in Location | |||
Undefined |
char |
Undefined Clocked-out Location | |||
Worked |
double |
Worked Time Excluding Breaks | |||
Worked |
double |
Worked Time including Breaks |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: