---
title: "MyClockingStateBreaksByHourID (Horeko)"
description: "My Clocking State Breaks by Hour ID"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/horeko/Horeko.Clocking.MyClockingStateBreaksByHourID
original: https://documentation.invantive.eu/en/datamodels/horeko/Horeko.Clocking.MyClockingStateBreaksByHourID
updated: 2025-06-11T11:15:01Z
license: https://documentation.invantive.eu/en/
---

# MyClockingStateBreaksByHourID: Horeko My Clocking State Breaks by Hour ID

`read only` `REST`

- Catalog: `Horeko`
- Schema: `Clocking`
- Label: My Clocking State Breaks 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` | `` | [x] |  |  |

## Table Columns

The columns of the table `MyClockingStateBreaksByHourID` 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 |
|---|---|---|:---:|---|---|
| `BreakLength` | `int32` | Break Length | [ ] |  |  |
| `ClockedInBy_EmployeeNumber` | `varchar2` | itgen_horeko_clockedinby_employeenumber | [ ] |  |  |
| `ClockedInBy_FirstName` | `varchar2` | itgen_horeko_clockedinby_firstname | [ ] |  |  |
| `ClockedInBy_FullName` | `varchar2` | itgen_horeko_clockedinby_fullname | [ ] |  |  |
| `ClockedInBy_Id` | `int32` | itgen_horeko_clockedinby_id | [ ] |  |  |
| `ClockedInBy_ImagePath` | `varchar2` | itgen_horeko_clockedinby_imagepath | [ ] |  |  |
| `ClockedInBy_LastName` | `varchar2` | itgen_horeko_clockedinby_lastname | [ ] |  |  |
| `ClockedInBy_MiddleName` | `varchar2` | itgen_horeko_clockedinby_middlename | [ ] |  |  |
| `ClockedOutBy_EmployeeNumber` | `varchar2` | itgen_horeko_clockedoutby_employeenumber | [ ] |  |  |
| `ClockedOutBy_FirstName` | `varchar2` | itgen_horeko_clockedoutby_firstname | [ ] |  |  |
| `ClockedOutBy_FullName` | `varchar2` | itgen_horeko_clockedoutby_fullname | [ ] |  |  |
| `ClockedOutBy_Id` | `int32` | itgen_horeko_clockedoutby_id | [ ] |  |  |
| `ClockedOutBy_ImagePath` | `varchar2` | itgen_horeko_clockedoutby_imagepath | [ ] |  |  |
| `ClockedOutBy_LastName` | `varchar2` | itgen_horeko_clockedoutby_lastname | [ ] |  |  |
| `ClockedOutBy_MiddleName` | `varchar2` | itgen_horeko_clockedoutby_middlename | [ ] |  |  |
| `ClockInMethod` | `int32` | Clock-in Method | [ ] |  | 0 = Fingerprint \| 1 = Android app \| 2 = iOS app \| 3 = PIN \| 4 = Manager \| 5 = Web app |
| `ClockOutMethod` | `int32` | Clock-out Method | [ ] |  | 0 = Fingerprint \| 1 = Android app \| 2 = iOS app \| 3 = PIN \| 4 = Manager \| 5 = Web app |
| `Comment` | `varchar2` | Comment | [ ] |  |  |
| `Comment_2` | `varchar2` | itgen_horeko_comment_2 | [ ] |  |  |
| `DepartmentName` | `varchar2` | Department Name | [ ] |  |  |
| `Employee_EmployeeNumber` | `varchar2` | itgen_horeko_employee_employeenumber | [ ] |  |  |
| `Employee_FirstName` | `varchar2` | itgen_horeko_employee_firstname | [ ] |  |  |
| `Employee_FullName` | `varchar2` | itgen_horeko_employee_fullname | [ ] |  |  |
| `Employee_Id` | `int32` | Employee ID | [ ] |  |  |
| `Employee_ImagePath` | `varchar2` | itgen_horeko_employee_imagepath | [ ] |  |  |
| `Employee_LastName` | `varchar2` | itgen_horeko_employee_lastname | [ ] |  |  |
| `Employee_MiddleName` | `varchar2` | itgen_horeko_employee_middlename | [ ] |  |  |
| `End` | `datetime` | End | [ ] |  |  |
| `End_2` | `datetime` | itgen_horeko_end_2 | [ ] |  |  |
| `Id` | `int32` | ID | [ ] |  |  |
| `Id_2` | `int32` | itgen_horeko_id_2 | [ ] |  |  |
| `ManagerComment` | `varchar2` | Manager Comment | [ ] |  |  |
| `Meal_Id` | `int32` | Meal ID | [ ] |  |  |
| `Meal_MealName` | `varchar2` | itgen_horeko_meal_mealname | [ ] |  |  |
| `Meal_MealPrice` | `double` | itgen_horeko_meal_mealprice | [ ] |  |  |
| `RoundedEnd` | `datetime` | Rounded End | [ ] |  |  |
| `RoundedStart` | `datetime` | Rounded Start | [ ] |  |  |
| `Shift_Break` | `int32` | itgen_horeko_shift_break | [ ] |  |  |
| `Shift_End` | `datetime` | itgen_horeko_shift_end | [ ] |  |  |
| `Shift_Id` | `int32` | Shift ID | [ ] |  |  |
| `Shift_Name` | `varchar2` | itgen_horeko_shift_name | [ ] |  |  |
| `Shift_Start` | `datetime` | itgen_horeko_shift_start | [ ] |  |  |
| `Start` | `datetime` | Start | [ ] |  |  |
| `Start_2` | `datetime` | itgen_horeko_start_2 | [ ] |  |  |
| `Status` | `int32` | Status | [ ] |  | 0 = Undecided \| 1 = Approved \| 2 = Disapproved |
| `StatusChangedBy_EmployeeNumber` | `varchar2` | itgen_horeko_statuschangedby_employeenumber | [ ] |  |  |
| `StatusChangedBy_FirstName` | `varchar2` | itgen_horeko_statuschangedby_firstname | [ ] |  |  |
| `StatusChangedBy_FullName` | `varchar2` | itgen_horeko_statuschangedby_fullname | [ ] |  |  |
| `StatusChangedBy_Id` | `int32` | itgen_horeko_statuschangedby_id | [ ] |  |  |
| `StatusChangedBy_ImagePath` | `varchar2` | itgen_horeko_statuschangedby_imagepath | [ ] |  |  |
| `StatusChangedBy_LastName` | `varchar2` | itgen_horeko_statuschangedby_lastname | [ ] |  |  |
| `StatusChangedBy_MiddleName` | `varchar2` | itgen_horeko_statuschangedby_middlename | [ ] |  |  |
| `StatusChangedDateTime` | `datetime` | Status Changed Date Time | [ ] |  |  |
| `TeamName` | `varchar2` | Team Name | [ ] |  |  |
| `Type` | `int32` | Type | [ ] |  | 0 = Lunch \| 1 = Smoke |
| `UndefinedClockedInLocation` | `char` | Undefined Clocked-in Location | [ ] |  |  |
| `UndefinedClockedOutLocation` | `char` | Undefined Clocked-out Location | [ ] |  |  |
| `WorkedTimeExcludingBreaks` | `double` | Worked Time Excluding Breaks | [ ] |  |  |
| `WorkedTimeIncludingBreaks` | `double` | Worked Time including Breaks | [ ] |  |  |



## Release Notes

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

- [Horeko](/en/release-notes/drivers?driver=horeko)

