invantive documentation
Invantive Support ForumsLog In / Sign Up

DaysOffPerEmployee: Bouw7 Days Off per Employee

read only REST

  • Catalog: Bouw7
  • Schema: Calendar
  • Label: Days Off per Employee

Returns a list of day off per employee schemas associated with the organization. Returns a list of days off per employee associated with the organization.

Can only retrieve data.

Summary

Returns a list of days off per employee associated with the organization.

API Source

  • Endpoint: /list/days-off-per-employee
  • Operation: get /list/days-off-per-employee

Performance Characteristics

Characteristic Value
Average access latency (ms) 90
Full scan rows per minute 15,000
Point query rows per minute 666

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
q `` A Heimdall Query Languae string

Table Columns

The columns of the table DaysOffPerEmployee 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
createdAt datetime Created at filters on the platform, writable, createdAt The creation date of the object in ATOM/ISO-8601 format
createdBy_id int64 Created by ID filters on the platform, writable, createdBy.id The ID of the user.
createdBy_username varchar2 Created by User Name filters on the platform, writable, createdBy.username The username of the user.
employee_departmentId int64 Employee Department ID filters on the platform, writable, employee.departmentId The ID of the department this employee is enrolled in.
employee_exactSalaryFrequency int64 Employee Exact Salary Frequency filters on the platform, writable, employee.exactSalaryFrequency The exact salary frequency of this employee.
employee_firstName varchar2 Employee First Name filters on the platform, writable, employee.firstName The given name of this employee.
employee_id int64 Employee ID filters on the platform, writable, employee.id The ID of the employee.
employee_lastName varchar2 Employee Last Name filters on the platform, writable, employee.lastName The family name of this employee.
endDate datetime End Date filters on the platform, writable, endDate The end date in ATOM format.
hours varchar2 Hours filters on the platform, writable, hours The duration in hours of this holiday / non-working day.
id int64 ID filters on the platform, writable, id The ID of this holiday / non-working day entry.
isAllDay char itgen_bouw7_isallday filters on the platform, writable, isAllDay Whether the day off per employee is in whole days.
remark varchar2 Remark filters on the platform, writable, remark A remark on this holiday / non-working day.
startDate datetime Start Date filters on the platform, writable, startDate The start date in ATOM format.
status int64 Status filters on the platform, writable, status The status of this holiday / non-working day.
updatedAt datetime Updated At filters on the platform, writable, updatedAt The creation date of the object in ATOM/ISO-8601 format
updatedBy_id int64 Updated by ID filters on the platform, writable, updatedBy.id The ID of the user.
updatedBy_username varchar2 Updated by User Name filters on the platform, writable, updatedBy.username The username of the user.

Release Notes

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