---
title: "DaysOffPerEmployee (Bouw7)"
description: "Days Off per Employee"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/exactonlinebouw/Bouw7.Calendar.DaysOffPerEmployee
original: https://documentation.invantive.eu/en/datamodels/exactonlinebouw/Bouw7.Calendar.DaysOffPerEmployee
updated: 2026-11-01T17:44:22Z
license: https://documentation.invantive.eu/en/
---

# 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](https://heimdall.bouw7.nl/docs/query-language) 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:

- [Bouw7](/en/release-notes/drivers?driver=bouw7)

