---
title: "TimeTables (Simplicate)"
description: "Time Tables"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.HRM.TimeTables
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.HRM.TimeTables
updated: 2024-10-18T06:48:11Z
license: https://documentation.invantive.eu/en/
---

# TimeTables: Simplicate Time Tables

`insert` `REST`

- Catalog: `Simplicate`
- Schema: `HRM`
- Label: Time Tables

Fetches all available timetables

Can retrieve data and change data using `insert`.

## API Source

- Endpoint: `/hrm/timetable`
- Operation: `get /hrm/timetable`

## Table Columns

The columns of the table `TimeTables` 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 | [ ] |  |  |
| `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 | [ ] |  |  |
| `end_date` | `varchar2` | End Date | [ ] |  |  |
| `even_week_day_1_end_time` | `double` | itgen_spe_even_week_day_1_end_time | [ ] |  |  |
| `even_week_day_1_hours` | `double` | itgen_spe_even_week_day_1_hours | [ ] |  |  |
| `even_week_day_1_start_time` | `double` | itgen_spe_even_week_day_1_start_time | [ ] |  |  |
| `even_week_day_2_end_time` | `double` | itgen_spe_even_week_day_2_end_time | [ ] |  |  |
| `even_week_day_2_hours` | `double` | itgen_spe_even_week_day_2_hours | [ ] |  |  |
| `even_week_day_2_start_time` | `double` | itgen_spe_even_week_day_2_start_time | [ ] |  |  |
| `even_week_day_3_end_time` | `double` | itgen_spe_even_week_day_3_end_time | [ ] |  |  |
| `even_week_day_3_hours` | `double` | itgen_spe_even_week_day_3_hours | [ ] |  |  |
| `even_week_day_3_start_time` | `double` | itgen_spe_even_week_day_3_start_time | [ ] |  |  |
| `even_week_day_4_end_time` | `double` | itgen_spe_even_week_day_4_end_time | [ ] |  |  |
| `even_week_day_4_hours` | `double` | itgen_spe_even_week_day_4_hours | [ ] |  |  |
| `even_week_day_4_start_time` | `double` | itgen_spe_even_week_day_4_start_time | [ ] |  |  |
| `even_week_day_5_end_time` | `double` | itgen_spe_even_week_day_5_end_time | [ ] |  |  |
| `even_week_day_5_hours` | `double` | itgen_spe_even_week_day_5_hours | [ ] |  |  |
| `even_week_day_5_start_time` | `double` | itgen_spe_even_week_day_5_start_time | [ ] |  |  |
| `even_week_day_6_end_time` | `double` | itgen_spe_even_week_day_6_end_time | [ ] |  |  |
| `even_week_day_6_hours` | `double` | itgen_spe_even_week_day_6_hours | [ ] |  |  |
| `even_week_day_6_start_time` | `double` | itgen_spe_even_week_day_6_start_time | [ ] |  |  |
| `even_week_day_7_end_time` | `double` | itgen_spe_even_week_day_7_end_time | [ ] |  |  |
| `even_week_day_7_hours` | `double` | itgen_spe_even_week_day_7_hours | [ ] |  |  |
| `even_week_day_7_start_time` | `double` | itgen_spe_even_week_day_7_start_time | [ ] |  |  |
| `hourly_cost_tariff` | `double` | Hourly Cost Tariff | [ ] |  |  |
| `hourly_sales_tariff` | `double` | Hourly Sales Tariff | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  | employee_id, See /hrm/employee |
| `odd_week_day_1_end_time` | `double` | itgen_spe_odd_week_day_1_end_time | [ ] |  |  |
| `odd_week_day_1_hours` | `double` | itgen_spe_odd_week_day_1_hours | [ ] |  |  |
| `odd_week_day_1_start_time` | `double` | itgen_spe_odd_week_day_1_start_time | [ ] |  |  |
| `odd_week_day_2_end_time` | `double` | itgen_spe_odd_week_day_2_end_time | [ ] |  |  |
| `odd_week_day_2_hours` | `double` | itgen_spe_odd_week_day_2_hours | [ ] |  |  |
| `odd_week_day_2_start_time` | `double` | itgen_spe_odd_week_day_2_start_time | [ ] |  |  |
| `odd_week_day_3_end_time` | `double` | itgen_spe_odd_week_day_3_end_time | [ ] |  |  |
| `odd_week_day_3_hours` | `double` | itgen_spe_odd_week_day_3_hours | [ ] |  |  |
| `odd_week_day_3_start_time` | `double` | itgen_spe_odd_week_day_3_start_time | [ ] |  |  |
| `odd_week_day_4_end_time` | `double` | itgen_spe_odd_week_day_4_end_time | [ ] |  |  |
| `odd_week_day_4_hours` | `double` | itgen_spe_odd_week_day_4_hours | [ ] |  |  |
| `odd_week_day_4_start_time` | `double` | itgen_spe_odd_week_day_4_start_time | [ ] |  |  |
| `odd_week_day_5_end_time` | `double` | itgen_spe_odd_week_day_5_end_time | [ ] |  |  |
| `odd_week_day_5_hours` | `double` | itgen_spe_odd_week_day_5_hours | [ ] |  |  |
| `odd_week_day_5_start_time` | `double` | itgen_spe_odd_week_day_5_start_time | [ ] |  |  |
| `odd_week_day_6_end_time` | `double` | itgen_spe_odd_week_day_6_end_time | [ ] |  |  |
| `odd_week_day_6_hours` | `double` | itgen_spe_odd_week_day_6_hours | [ ] |  |  |
| `odd_week_day_6_start_time` | `double` | itgen_spe_odd_week_day_6_start_time | [ ] |  |  |
| `odd_week_day_7_end_time` | `double` | itgen_spe_odd_week_day_7_end_time | [ ] |  |  |
| `odd_week_day_7_hours` | `double` | itgen_spe_odd_week_day_7_hours | [ ] |  |  |
| `odd_week_day_7_start_time` | `double` | itgen_spe_odd_week_day_7_start_time | [ ] |  |  |
| `productivity_target` | `int64` | Productivity Target | [ ] |  |  |
| `should_write_hours` | `char` | itgen_spe_should_write_hours | [ ] |  |  |
| `start_date` | `varchar2` | Start Date | [ ] |  |  |
| `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)

