Error itgendoc001X
xMsg javascript has not been loaded.
Simplicate API Data ModelFetches all available timetables
Catalog: Simplicate
Schema: HRM
This is a read-only table function. The Simplicate API may not support changing the data or the Invantive SQL driver for Simplicate does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Simplicate API.
Select Simplicate API URL: /hrm/timetable
Insert Simplicate API URL: /hrm/timetable
Update Simplicate API URL: /hrm/timetable
Delete Simplicate API URL: /hrm/timetable
Field Selection Method: NotRequired
Base Path: data[*]
Select Simplicate API Operation: get /hrm/timetable
Table Function Columns
The columns of the table function TimeTables are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
created_at |
string |
Created at |
☐ |
|
employee_amount |
float |
|
☐ |
|
employee_declarable |
string |
|
☐ |
|
employee_employee_id |
string |
|
☐ |
|
employee_id |
string |
Employee ID |
☐ |
|
employee_name |
string |
|
☐ |
|
employee_person_id |
string |
|
☐ |
|
employee_tariff |
float |
|
☐ |
|
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_sales_tariff |
float |
|
☐ |
|
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 |
|
☐ |
|
start_date |
string |
Start Date |
☐ |
|
updated_at |
string |
Updated at |
☐ |
|
06-04-2021 14:59 Version 20.1.393-BETA+3152
