invantive documentation
Invantive Support ForumsLog In / Sign Up

HourApprovals: Simplicate Hour Approvals

insert update delete REST

  • Catalog: Simplicate
  • Schema: Hours
  • Primary Keys: id
  • Label: Hour Approvals

Fetches the approval status of each day for each employee

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

API Source

  • Endpoint: /hours/approval
  • Operation: get /hours/approval

Table Columns

The columns of the table HourApprovals 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
approvalstatus_description varchar2 Approval Status Description
approvalstatus_id varchar2 Approval Status ID
approvalstatus_label varchar2 Approval Status Label
date varchar2 Date
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
id varchar2 ID

Release Notes

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