invantive documentation
Invantive Support ForumsLog In / Sign Up

LeaveBalances: Simplicate Leave Balances

read only REST

  • Catalog: Simplicate
  • Schema: HRM
  • Label: Leave Balances

Fetches all leave balances for employees

Can only retrieve data.

API Source

  • Endpoint: /hrm/leavebalance
  • Operation: get /hrm/leavebalance

Table Columns

The columns of the table LeaveBalances 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
balance double Balance
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
first_change varchar2 First Change
last_change double Last Change
leavetype_affects_balance char itgen_spe_leavetype_affects_balance
leavetype_blocked char itgen_spe_leavetype_blocked
leavetype_color varchar2 itgen_spe_leavetype_color
leavetype_id varchar2 itgen_spe_leavetype_id
leavetype_label varchar2 itgen_spe_leavetype_label
year int64 Year

Release Notes

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