invantive documentation
Invantive Support ForumsLog In / Sign Up

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: