---
title: "EmployeeHourLogs (Bouw7)"
description: "Employee Hour Logs"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/exactonlinebouw/Bouw7.HourLog.EmployeeHourLogs
original: https://documentation.invantive.eu/en/datamodels/exactonlinebouw/Bouw7.HourLog.EmployeeHourLogs
updated: 2026-11-01T17:44:22Z
license: https://documentation.invantive.eu/en/
---

# EmployeeHourLogs: Bouw7 Employee Hour Logs

`popular` `read only` `REST`

- Catalog: `Bouw7`
- Schema: `HourLog`
- Label: Employee Hour Logs

Returns a list of employee hour logs associated with your organization.
Returns a list of employee hour logs associated with your organization.

Can only retrieve data.

## Summary

Returns a list of employee hour logs associated with your organization.

## API Source

- Endpoint: `/list/hour-logs/employee`
- Operation: `get /list/hour-logs/employee`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 3,510 |
| Full scan rows per minute | 163,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 Language](https://heimdall.bouw7.nl/docs/query-language) string |

## Table Columns

The columns of the table `EmployeeHourLogs` 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 |
|---|---|---|:---:|---|---|
| `approvedAt` | `datetime` | Approved at | [ ] | filters on the platform, writable, `approvedAt` | The time this hour log entry was approved at. |
| `approvedBy_id` | `int64` | Approved by ID | [ ] | filters on the platform, writable, `approvedBy.id` | The ID of the user. |
| `approvedBy_username` | `varchar2` | Approved by User Name | [ ] | filters on the platform, writable, `approvedBy.username` | The username. The e-mail address the user uses to sign in. |
| `bookingStatus` | `int64` | Booking Status | [ ] | filters on the platform, writable, `bookingStatus` | The booking status of this entry. 0 = Registered, 1 = Invoiced, 2 = Not billable, 3 = Credited. |
| `comment` | `varchar2` | Comment | [ ] | filters on the platform, writable, `comment` | The remark added to this entry. |
| `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. |
| `endTime` | `varchar2` | End Time | [ ] | filters on the platform, writable, `endTime` | The end time of the workday. Only available if enabled for your organization. |
| `exactUpdatedAt` | `varchar2` | itgen_bouw7_exactupdatedat | [ ] | filters on the platform, writable, `exactUpdatedAt` | The last time the entity was updated in Exact Online in ATOM format. |
| `hourlyRate` | `varchar2` | Hourly Rate | [ ] | filters on the platform, writable, `hourlyRate` | The hourly rate. |
| `hours` | `varchar2` | Hours | [ ] | filters on the platform, writable, `hours` | The amount of hours logged to this entry. |
| `id` | `int64` | ID | [ ] | filters on the platform, writable, `id` | The ID of the hour log. |
| `invoiceLine_id` | `int64` | Invoice Line ID | [ ] | filters on the platform, writable, `invoiceLine.id` | The ID of the invoice line. |
| `invoiceLine_invoiceId` | `int64` | Invoice Line Invoice ID | [ ] | filters on the platform, writable, `invoiceLine.invoiceId` | The ID of the invoice this invoice line belongs to. |
| `invoiceLine_invoiceStatusId` | `int64` | Invoice Line Invoice Status ID | [ ] | filters on the platform, writable, `invoiceLine.invoiceStatusId` | The ID of the status of the invoice this line belongs to. |
| `invoicedAmount` | `varchar2` | Invoiced Amount | [ ] | filters on the platform, writable, `invoicedAmount` | The amount to invoice for this hour log entry. |
| `isApproved` | `char` | Is Approved | [ ] | filters on the platform, writable, `isApproved` | Whether this hour log entry has been approved for processing. |
| `isExternal` | `char` | Is External | [ ] | filters on the platform, writable, `isExternal` | Whether the employee associated with this hour log entry is external. |
| `isMutable` | `char` | itgen_bouw7_ismutable | [ ] | filters on the platform, writable, `isMutable` | Whether the booked item is mutable. |
| `isPaidOff` | `char` | Is Paid Off | [ ] | filters on the platform, writable, `isPaidOff` | Whether this price of this hour log entry has been paid off. |
| `isScabPaidOff` | `char` | Is Scab Paid Off | [ ] | filters on the platform, writable, `isScabPaidOff` | Whether this price of this hour log entry has been paid off for scab users. |
| `logDate` | `datetime` | Log Date | [ ] | filters on the platform, writable, `logDate` | The log date of this entry. ATOM format. |
| `projectSecurityLink_code` | `varchar2` | Project Security Link Code | [ ] | filters on the platform, writable, `projectSecurityLink.code` | The security code. |
| `projectSecurityLink_costType` | `int64` | itgen_bouw7_projectsecuritylink_costtype | [ ] | filters on the platform, writable, `projectSecurityLink.costType` | The name of the cost type. |
| `projectSecurityLink_id` | `int64` | Project Security Link ID | [ ] | filters on the platform, writable, `projectSecurityLink.id` | The ID of the project security link. |
| `projectSecurityLink_name` | `varchar2` | Project Security Link Name | [ ] | filters on the platform, writable, `projectSecurityLink.name` | The name of the project security link. |
| `projectSecurityLink_parentName` | `varchar2` | itgen_bouw7_projectsecuritylink_parentname | [ ] | filters on the platform, writable, `projectSecurityLink.parentName` | The name of the security code. |
| `projectSecurityLink_projectId` | `int64` | Project Security Link Project ID | [ ] | filters on the platform, writable, `projectSecurityLink.projectId` | The ID of the project associated with this security code. |
| `projectSecurityLink_status` | `int64` | Project Security Link Status | [ ] | filters on the platform, writable, `projectSecurityLink.status` | The status of the project security link. |
| `project_branchId` | `int64` | Project Branch ID | [ ] | filters on the platform, writable, `project.branchId` | The ID of the branch of this project. |
| `project_categoryId` | `int64` | Project Category ID | [ ] | filters on the platform, writable, `project.categoryId` | The ID of the category of this project. |
| `project_contactName` | `varchar2` | Project Contact Name | [ ] | filters on the platform, writable, `project.contactName` | The name of the contact associated with this project. |
| `project_executorName` | `varchar2` | Project Executor Name | [ ] | filters on the platform, writable, `project.executorName` | The full name of the executor associated with this project. |
| `project_id` | `int64` | Project ID | [ ] | filters on the platform, writable, `project.id` | The ID of the project. |
| `project_name` | `varchar2` | Project Name | [ ] | filters on the platform, writable, `project.name` | The name of the project. |
| `project_number` | `varchar2` | Project Number | [ ] | filters on the platform, writable, `project.number` | The number of the project. |
| `project_projectLeaderName` | `varchar2` | Project Project Leader Name | [ ] | filters on the platform, writable, `project.projectLeaderName` | The full name of the project leader associated with this project. |
| `project_status` | `varchar2` | Project Status | [ ] | filters on the platform, writable, `project.status` | The name of the current status of this project. |
| `project_statusId` | `int64` | Project Status ID | [ ] | filters on the platform, writable, `project.statusId` | The ID of the status of this project. |
| `project_workPlannerName` | `varchar2` | Project Work Planner Name | [ ] | filters on the platform, writable, `project.workPlannerName` | The full name of the work planner associated with this project. |
| `startTime` | `varchar2` | Start Time | [ ] | filters on the platform, writable, `startTime` | The start time of the workday. Only available if enabled for your organization. |
| `type_id` | `int64` | Type ID | [ ] | filters on the platform, writable, `type.id` | The ID of the hour type. |
| `type_name` | `varchar2` | Type Name | [ ] | filters on the platform, writable, `type.name` | The name of the hour type. |
| `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)

