invantive documentation
Invantive Support ForumsLog In / Sign Up

Absences: Simplicate itgen_spe_absences_plural

insert update delete REST

  • Catalog: Simplicate
  • Schema: HRM
  • Primary Keys: id
  • Label: itgen_spe_absences_plural

Fetches all absence for employees

Can retrieve data and change data using insert, update and delete.

API Source

  • Endpoint: /hrm/absence
  • Operation: get /hrm/absence

Table Columns

The columns of the table Absences 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
absencetype_blocked char itgen_spe_absencetype_blocked
absencetype_color varchar2 itgen_spe_absencetype_color
absencetype_id varchar2 itgen_spe_absencetype_id
absencetype_label varchar2 itgen_spe_absencetype_label
created_at varchar2 Created at
description varchar2 Description
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
hours double Hours
id varchar2 ID
start_date varchar2 Start Date
updated_at varchar2 Updated at
year int64 Year

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: