# Timers: Simplicate Timers Fetches all timers Can retrieve and modify data using insert, update and delete. - Catalog: `Simplicate` - Schema: `Hours` - Primary Keys: `id` - Label: Timers ## Table Columns The columns of the table `Timers` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `created_at` | `string` | Created On | ☐ | | | `description` | `string` | Description | ☐ | | | `employee_amount` | `float` | Employee Amount | ☐ | | | `employee_declarable` | `string` | Billable Employee | ☐ | | | `employee_employee_id` | `string` | Employee ID | ☐ | | | `employee_id` | `string` | Employee ID | ☐ | | | `employee_name` | `string` | Employee Name | ☐ | | | `employee_person_id` | `string` | Employee Person ID | ☐ | Added in order to comply with the original sales/sales responsible_employee response | | `employee_tariff` | `float` | Employee Rate | ☐ | | | `hourstype_billable` | `float` | | ☐ | | | `hourstype_blocked` | `boolean` | | ☐ | | | `hourstype_color` | `string` | | ☐ | | | `hourstype_id` | `string` | | ☐ | | | `hourstype_label` | `string` | | ☐ | | | `hourstype_tariff` | `float` | | ☐ | | | `hourstype_type` | `string` | | ☐ | | | `hourstype_vatclass_code` | `string` | | ☐ | | | `hourstype_vatclass_id` | `string` | | ☐ | | | `hourstype_vatclass_label` | `string` | | ☐ | | | `hourstype_vatclass_name` | `string` | | ☐ | | | `hourstype_vatclass_percentage` | `float` | | ☐ | | | `id` | `string` | ID | ☐ | | | `metadata` | `string` | Metadata | ☐ | JSON | | `min_seconds_step` | `float` | | ☐ | | | `project_has_register_mileage_enabled` | `boolean` | | ☐ | | | `project_id` | `string` | Project ID | ☐ | | | `project_name` | `string` | Project Name | ☐ | | | `project_organization_id` | `string` | Project Organisation ID | ☐ | | | `project_organization_name` | `string` | Project Organisation Name | ☐ | | | `project_organization_relation_number` | `string` | | ☐ | | | `project_person_full_name` | `string` | Project Person Full Name | ☐ | | | `project_person_id` | `string` | Project Person ID | ☐ | | | `project_person_relation_number` | `string` | | ☐ | | | `project_project_manager_amount` | `float` | Project Manager Amount | ☐ | | | `project_project_manager_declarable` | `string` | Project Manager Billable | ☐ | | | `project_project_manager_employee_id` | `string` | Project Manager Employee ID | ☐ | | | `project_project_manager_id` | `string` | Project Manager ID | ☐ | | | `project_project_manager_name` | `string` | Project Manager Name | ☐ | | | `project_project_manager_person_id` | `string` | Project Manager Person ID | ☐ | Added in order to comply with the original sales/sales responsible_employee response | | `project_project_manager_tariff` | `float` | Project Manager Rate | ☐ | | | `project_project_number` | `string` | Project Number | ☐ | | | `projectservice_default_service_id` | `string` | | ☐ | | | `projectservice_id` | `string` | Project Service ID | ☐ | | | `projectservice_name` | `string` | Project Service Name | ☐ | | | `projectservice_revenue_group_id` | `string` | | ☐ | | | `projectservice_use_in_resource_planner` | `boolean` | | ☐ | | | `related_hours_address_country_code` | `string` | | ☐ | | | `related_hours_address_country_id` | `string` | | ☐ | | | `related_hours_address_line_1` | `string` | | ☐ | | | `related_hours_address_line_2` | `string` | | ☐ | | | `related_hours_address_locality` | `string` | | ☐ | | | `related_hours_address_postal_code` | `string` | | ☐ | | | `related_hours_address_province` | `string` | | ☐ | | | `related_hours_address_type` | `string` | | ☐ | | | `related_hours_assignment_id` | `string` | | ☐ | | | `related_hours_billable` | `boolean` | | ☐ | | | `related_hours_duration_in_minutes` | `int64` | | ☐ | | | `related_hours_end_date` | `string` | | ☐ | | | `related_hours_hours` | `float` | | ☐ | | | `related_hours_id` | `string` | | ☐ | | | `related_hours_is_external` | `boolean` | | ☐ | | | `related_hours_is_recurring` | `boolean` | | ☐ | | | `related_hours_is_time_defined` | `boolean` | | ☐ | | | `related_hours_note` | `string` | | ☐ | | | `related_hours_recurrence_id` | `string` | | ☐ | | | `related_hours_recurrence_rrule_byday` | `string` | | ☐ | | | `related_hours_recurrence_rrule_bysetpos` | `string` | | ☐ | | | `related_hours_recurrence_rrule_count` | `int64` | | ☐ | | | `related_hours_recurrence_rrule_dtstart` | `string` | | ☐ | | | `related_hours_recurrence_rrule_freq` | `int64` | | ☐ | | | `related_hours_recurrence_rrule_interval` | `int64` | | ☐ | | | `related_hours_recurrence_rrule_until` | `string` | | ☐ | | | `related_hours_recurrence_rrule_wkst` | `string` | | ☐ | | | `related_hours_recurrence_update` | `string` | | ☐ | | | `related_hours_should_sync_to_cronofy` | `boolean` | | ☐ | | | `related_hours_source` | `string` | | ☐ | | | `related_hours_start_date` | `string` | | ☐ | | | `seconds_spent` | `int64` | | ☐ | | | `state` | `string` | Province | ☐ | | | `updated_at` | `string` | Updated On | ☐ | |