# TimeTables: Simplicate Timetables Fetches all available timetables - Catalog: `Simplicate` - Schema: `HRM` - Label: Timetables - Retrieve: true - Insert: true - Update: false - Delete: false ## Table Columns The columns of the table `TimeTables` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `created_at` | `string` | Created On | ☐ | | | `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 | ☐ | | | `end_date` | `string` | End Date | ☐ | | | `even_week_day_1_end_time` | `float` | | ☐ | | | `even_week_day_1_hours` | `float` | | ☐ | | | `even_week_day_1_start_time` | `float` | | ☐ | | | `even_week_day_2_end_time` | `float` | | ☐ | | | `even_week_day_2_hours` | `float` | | ☐ | | | `even_week_day_2_start_time` | `float` | | ☐ | | | `even_week_day_3_end_time` | `float` | | ☐ | | | `even_week_day_3_hours` | `float` | | ☐ | | | `even_week_day_3_start_time` | `float` | | ☐ | | | `even_week_day_4_end_time` | `float` | | ☐ | | | `even_week_day_4_hours` | `float` | | ☐ | | | `even_week_day_4_start_time` | `float` | | ☐ | | | `even_week_day_5_end_time` | `float` | | ☐ | | | `even_week_day_5_hours` | `float` | | ☐ | | | `even_week_day_5_start_time` | `float` | | ☐ | | | `even_week_day_6_end_time` | `float` | | ☐ | | | `even_week_day_6_hours` | `float` | | ☐ | | | `even_week_day_6_start_time` | `float` | | ☐ | | | `even_week_day_7_end_time` | `float` | | ☐ | | | `even_week_day_7_hours` | `float` | | ☐ | | | `even_week_day_7_start_time` | `float` | | ☐ | | | `hourly_cost_tariff` | `float` | Hourly Rate | ☐ | | | `hourly_sales_tariff` | `float` | Hourly Sales Rate | ☐ | | | `id` | `string` | ID | ☐ | employee_id, See /hrm/employee | | `odd_week_day_1_end_time` | `float` | | ☐ | | | `odd_week_day_1_hours` | `float` | | ☐ | | | `odd_week_day_1_start_time` | `float` | | ☐ | | | `odd_week_day_2_end_time` | `float` | | ☐ | | | `odd_week_day_2_hours` | `float` | | ☐ | | | `odd_week_day_2_start_time` | `float` | | ☐ | | | `odd_week_day_3_end_time` | `float` | | ☐ | | | `odd_week_day_3_hours` | `float` | | ☐ | | | `odd_week_day_3_start_time` | `float` | | ☐ | | | `odd_week_day_4_end_time` | `float` | | ☐ | | | `odd_week_day_4_hours` | `float` | | ☐ | | | `odd_week_day_4_start_time` | `float` | | ☐ | | | `odd_week_day_5_end_time` | `float` | | ☐ | | | `odd_week_day_5_hours` | `float` | | ☐ | | | `odd_week_day_5_start_time` | `float` | | ☐ | | | `odd_week_day_6_end_time` | `float` | | ☐ | | | `odd_week_day_6_hours` | `float` | | ☐ | | | `odd_week_day_6_start_time` | `float` | | ☐ | | | `odd_week_day_7_end_time` | `float` | | ☐ | | | `odd_week_day_7_hours` | `float` | | ☐ | | | `odd_week_day_7_start_time` | `float` | | ☐ | | | `productivity_target` | `int64` | Productivity Target | ☐ | | | `should_write_hours` | `boolean` | | ☐ | | | `start_date` | `string` | Start Date | ☐ | | | `updated_at` | `string` | Updated On | ☐ | |