---
title: "TimerById (Simplicate)"
description: "Timer by ID"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Hours.TimerById
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Hours.TimerById
updated: 2024-10-18T06:48:11Z
license: https://documentation.invantive.eu/en/
---

# TimerById: Simplicate Timer by ID

`read only` `REST`

- Catalog: `Simplicate`
- Schema: `Hours`
- Label: Timer by ID

Fetches a single timer by its id

Can only retrieve data.

## API Source

- Endpoint: `/timers/timer/{id}`
- Operation: `get /timers/timer/{id}`

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `id` | `` | [x] |  | The template's id |

## Table Columns

The columns of the table `TimerById` 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 |
|---|---|---|:---:|---|---|
| `created_at` | `varchar2` | Created at | [ ] |  |  |
| `description` | `varchar2` | Description | [ ] |  |  |
| `employee_amount` | `double` | Employee Amount | [ ] |  |  |
| `employee_declarable` | `varchar2` | Employee Declarable | [ ] |  |  |
| `employee_employee_id` | `varchar2` | Employee ID | [ ] |  |  |
| `employee_id` | `varchar2` | Employee ID | [ ] |  |  |
| `employee_name` | `varchar2` | Employee Name | [ ] |  |  |
| `employee_person_id` | `varchar2` | Employee Person ID | [ ] |  | Added in order to comply with the original sales/sales responsible_employee response |
| `employee_tariff` | `double` | Employee Tariff | [ ] |  |  |
| `hourstype_billable` | `double` | itgen_spe_hourstype_billable | [ ] |  |  |
| `hourstype_blocked` | `char` | itgen_spe_hourstype_blocked | [ ] |  |  |
| `hourstype_color` | `varchar2` | itgen_spe_hourstype_color | [ ] |  |  |
| `hourstype_id` | `varchar2` | itgen_spe_hourstype_id | [ ] |  |  |
| `hourstype_label` | `varchar2` | itgen_spe_hourstype_label | [ ] |  |  |
| `hourstype_tariff` | `double` | itgen_spe_hourstype_tariff | [ ] |  |  |
| `hourstype_type` | `varchar2` | itgen_spe_hourstype_type | [ ] |  |  |
| `hourstype_vatclass_code` | `varchar2` | itgen_spe_hourstype_vatclass_code | [ ] |  |  |
| `hourstype_vatclass_id` | `varchar2` | itgen_spe_hourstype_vatclass_id | [ ] |  |  |
| `hourstype_vatclass_label` | `varchar2` | itgen_spe_hourstype_vatclass_label | [ ] |  |  |
| `hourstype_vatclass_name` | `varchar2` | itgen_spe_hourstype_vatclass_name | [ ] |  |  |
| `hourstype_vatclass_percentage` | `double` | itgen_spe_hourstype_vatclass_percentage | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `metadata` | `varchar2` | Metadata | [ ] |  | JSON |
| `min_seconds_step` | `double` | itgen_spe_min_seconds_step | [ ] |  |  |
| `project_has_register_mileage_enabled` | `char` | itgen_spe_project_has_register_mileage_enabled | [ ] |  |  |
| `project_id` | `varchar2` | Project ID | [ ] |  |  |
| `project_name` | `varchar2` | Project Name | [ ] |  |  |
| `project_organization_id` | `varchar2` | Project Organisation ID | [ ] |  |  |
| `project_organization_name` | `varchar2` | Project Organisation Name | [ ] |  |  |
| `project_organization_relation_number` | `varchar2` | itgen_spe_project_organization_relation_number | [ ] |  |  |
| `project_person_full_name` | `varchar2` | Project Person Full Name | [ ] |  |  |
| `project_person_id` | `varchar2` | Project Person ID | [ ] |  |  |
| `project_person_relation_number` | `varchar2` | itgen_spe_project_person_relation_number | [ ] |  |  |
| `project_project_manager_amount` | `double` | Project Manager Amount | [ ] |  |  |
| `project_project_manager_declarable` | `varchar2` | Project Manager Declarable | [ ] |  |  |
| `project_project_manager_employee_id` | `varchar2` | Project Manager Employee ID | [ ] |  |  |
| `project_project_manager_id` | `varchar2` | Project Manager ID | [ ] |  |  |
| `project_project_manager_name` | `varchar2` | Project Manager Name | [ ] |  |  |
| `project_project_manager_person_id` | `varchar2` | Project Manager Person ID | [ ] |  | Added in order to comply with the original sales/sales responsible_employee response |
| `project_project_manager_tariff` | `double` | Project Manager Tariff | [ ] |  |  |
| `project_project_number` | `varchar2` | Project Number | [ ] |  |  |
| `projectservice_default_service_id` | `varchar2` | itgen_spe_projectservice_default_service_id | [ ] |  |  |
| `projectservice_id` | `varchar2` | Project Service ID | [ ] |  |  |
| `projectservice_name` | `varchar2` | Project Service Name | [ ] |  |  |
| `projectservice_revenue_group_id` | `varchar2` | itgen_spe_projectservice_revenue_group_id | [ ] |  |  |
| `projectservice_use_in_resource_planner` | `char` | itgen_spe_projectservice_use_in_resource_planner | [ ] |  |  |
| `related_hours_address_country_code` | `varchar2` | itgen_spe_related_hours_address_country_code | [ ] |  |  |
| `related_hours_address_country_id` | `varchar2` | itgen_spe_related_hours_address_country_id | [ ] |  |  |
| `related_hours_address_line_1` | `varchar2` | itgen_spe_related_hours_address_line_1 | [ ] |  |  |
| `related_hours_address_line_2` | `varchar2` | itgen_spe_related_hours_address_line_2 | [ ] |  |  |
| `related_hours_address_locality` | `varchar2` | itgen_spe_related_hours_address_locality | [ ] |  |  |
| `related_hours_address_postal_code` | `varchar2` | itgen_spe_related_hours_address_postal_code | [ ] |  |  |
| `related_hours_address_province` | `varchar2` | itgen_spe_related_hours_address_province | [ ] |  |  |
| `related_hours_address_type` | `varchar2` | itgen_spe_related_hours_address_type | [ ] |  |  |
| `related_hours_assignment_id` | `varchar2` | itgen_spe_related_hours_assignment_id | [ ] |  |  |
| `related_hours_billable` | `char` | itgen_spe_related_hours_billable | [ ] |  |  |
| `related_hours_duration_in_minutes` | `int64` | itgen_spe_related_hours_duration_in_minutes | [ ] |  |  |
| `related_hours_end_date` | `varchar2` | itgen_spe_related_hours_end_date | [ ] |  |  |
| `related_hours_hours` | `double` | itgen_spe_related_hours_hours | [ ] |  |  |
| `related_hours_id` | `varchar2` | itgen_spe_related_hours_id | [ ] |  |  |
| `related_hours_is_external` | `char` | itgen_spe_related_hours_is_external | [ ] |  |  |
| `related_hours_is_recurring` | `char` | itgen_spe_related_hours_is_recurring | [ ] |  |  |
| `related_hours_is_time_defined` | `char` | itgen_spe_related_hours_is_time_defined | [ ] |  |  |
| `related_hours_note` | `varchar2` | itgen_spe_related_hours_note | [ ] |  |  |
| `related_hours_recurrence_id` | `varchar2` | itgen_spe_related_hours_recurrence_id | [ ] |  |  |
| `related_hours_recurrence_rrule_byday` | `varchar2` | itgen_spe_related_hours_recurrence_rrule_byday | [ ] |  |  |
| `related_hours_recurrence_rrule_bysetpos` | `varchar2` | itgen_spe_related_hours_recurrence_rrule_bysetpos | [ ] |  |  |
| `related_hours_recurrence_rrule_count` | `int64` | itgen_spe_related_hours_recurrence_rrule_count | [ ] |  |  |
| `related_hours_recurrence_rrule_dtstart` | `varchar2` | itgen_spe_related_hours_recurrence_rrule_dtstart | [ ] |  |  |
| `related_hours_recurrence_rrule_freq` | `int64` | itgen_spe_related_hours_recurrence_rrule_freq | [ ] |  |  |
| `related_hours_recurrence_rrule_interval` | `int64` | itgen_spe_related_hours_recurrence_rrule_interval | [ ] |  |  |
| `related_hours_recurrence_rrule_until` | `varchar2` | itgen_spe_related_hours_recurrence_rrule_until | [ ] |  |  |
| `related_hours_recurrence_rrule_wkst` | `varchar2` | itgen_spe_related_hours_recurrence_rrule_wkst | [ ] |  |  |
| `related_hours_recurrence_update` | `varchar2` | itgen_spe_related_hours_recurrence_update | [ ] |  |  |
| `related_hours_should_sync_to_cronofy` | `char` | itgen_spe_related_hours_should_sync_to_cronofy | [ ] |  |  |
| `related_hours_source` | `varchar2` | itgen_spe_related_hours_source | [ ] |  |  |
| `related_hours_start_date` | `varchar2` | itgen_spe_related_hours_start_date | [ ] |  |  |
| `seconds_spent` | `int64` | itgen_spe_seconds_spent | [ ] |  |  |
| `state` | `varchar2` | State | [ ] |  |  |
| `updated_at` | `varchar2` | Updated at | [ ] |  |  |



## Release Notes

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

- [Simplicate](/en/release-notes/drivers?driver=simplicate)

