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

# EmployeeById: Bouw7 Employee by ID

`read only` `REST`

- Catalog: `Bouw7`
- Schema: `Organization`
- Label: Employee by ID

Returns a single employee based on the given ID.
Returns a single employee based on the given ID.

Can only retrieve data.

## Summary

Returns a single employee based on the given ID.

## API Source

- Endpoint: `/organization/employee/{id}`
- Operation: `get /organization/employee/{id}`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 90 |
| Full scan rows per minute | 241,000 |
| Point query rows per minute | 666 |

The result can be cached on the client.

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `id` | `` | [x] |  |  |

## Table Columns

The columns of the table `EmployeeById` 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 |
|---|---|---|:---:|---|---|
| `address` | `varchar2` | Address | [ ] | filters on the platform, writable, `address` | The address of the employee. |
| `afasWarehouse` | `varchar2` | AFAS Warehouse | [ ] | filters on the platform, writable, `afasWarehouse` | The warehouse material bookings of an employee will be booked on. Only applicable for AFAS. |
| `avatarFileHash` | `varchar2` | Avatar File Hash | [ ] | filters on the platform, writable, `avatarFileHash` | The hash of the avatar/profile picture of this employee. |
| `birthDate` | `datetime` | Birth Date | [ ] | filters on the platform, writable, `birthDate` | The birth date of the employee. |
| `bsn` | `varchar2` | SSN | [ ] | filters on the platform, writable, `bsn` | The BSN of the employee. |
| `city` | `varchar2` | City | [ ] | filters on the platform, writable, `city` | The city of the employee. |
| `createdAt` | `datetime` | Created at | [ ] | filters on the platform, writable, `createdAt` | The creation time of the entity. |
| `createdBy` | `varchar2` | Created by | [ ] | filters on the platform, writable, `createdBy` | The user that created the entity. |
| `dateOfEmployment` | `varchar2` | Date of Employment | [ ] | filters on the platform, writable, `dateOfEmployment` | The date of employment of the employee in Y-m-d format. |
| `dateOfResignation` | `varchar2` | Date of Resignation | [ ] | filters on the platform, writable, `dateOfResignation` | The date of resignation of the employee in Y-m-d format. |
| `department_id` | `int64` | Department ID | [ ] | filters on the platform, writable, `department.id` | ID of the department. |
| `department_name` | `varchar2` | Department Name | [ ] | filters on the platform, writable, `department.name` | Name of the department. |
| `employeeMail` | `varchar2` | Employee Mail | [ ] | filters on the platform, writable, `employeeMail` | The email of the employee. |
| `external` | `char` | External | [ ] | filters on the platform, writable, `external` | Whether the employee is external. |
| `firstName` | `varchar2` | First Name | [ ] | filters on the platform, writable, `firstName` | The first name of the employee. |
| `function` | `varchar2` | Function | [ ] | filters on the platform, writable, `function` | The function of the employee. |
| `hourlyRate` | `varchar2` | Hourly Rate | [ ] | filters on the platform, writable, `hourlyRate` | The hourly rate |
| `id` | `int64` | ID | [ ] | filters on the platform, writable, `id` | The ID of the employee. |
| `lastName` | `varchar2` | Last Name | [ ] | filters on the platform, writable, `lastName` | The last name of the employee. |
| `payrollDivision_description` | `varchar2` | Payroll Division Description | [ ] | filters on the platform, writable, `payrollDivision.description` | The description of the division. |
| `payrollDivision_exactDivisionId` | `varchar2` | Payroll Division Exact Division ID | [ ] | filters on the platform, writable, `payrollDivision.exactDivisionId` | The division ID of an Exact Online environment. |
| `payrollDivision_glAccountCode` | `varchar2` | Payroll Division GL Account Code | [ ] | filters on the platform, writable, `payrollDivision.glAccountCode` | A default general ledger account code to use for sales related items. |
| `payrollDivision_glAccountCodePurchase` | `varchar2` | Payroll Division GL Account Code Purchase | [ ] | filters on the platform, writable, `payrollDivision.glAccountCodePurchase` | A default general ledger account code to use for purchase related items. |
| `payrollDivision_id` | `int64` | Payroll Division ID | [ ] | filters on the platform, writable, `payrollDivision.id` | The ID of the division. |
| `payrollDivision_journalCode` | `varchar2` | Payroll Division Journal Code | [ ] | filters on the platform, writable, `payrollDivision.journalCode` | A default journal code to use for sales related items. |
| `payrollDivision_journalCodePurchase` | `varchar2` | Payroll Division Journal Code Purchase | [ ] | filters on the platform, writable, `payrollDivision.journalCodePurchase` | A default journal code to use for purchase related items. |
| `payrollDivision_salesInvoiceNumberPrefix` | `varchar2(3)` | Payroll Division Sales Invoice Number Prefix | [ ] | filters on the platform, writable, `payrollDivision.salesInvoiceNumberPrefix` | The prefix (3 digits) used to generate invoice number range per division. |
| `phoneNumber` | `varchar2` | Phone Number | [ ] | filters on the platform, writable, `phoneNumber` | The phone number of the employee. |
| `scabEmployeeId` | `varchar2` | SCAB Employee ID | [ ] | filters on the platform, writable, `scabEmployeeId` | The internal ID of the Scab employee associated with this employee. |
| `sellingHourlyRate` | `varchar2` | Selling Hourly Rate | [ ] | filters on the platform, writable, `sellingHourlyRate` | The selling hourly rate |
| `signatureFileHash` | `varchar2` | Signature File Hash | [ ] | filters on the platform, writable, `signatureFileHash` | The hash of the signature file of this employee. |
| `updatedAt` | `datetime` | Updated At | [ ] | filters on the platform, writable, `updatedAt` | The last updated time of the entity. |
| `updatedBy` | `varchar2` | Updated by | [ ] | filters on the platform, writable, `updatedBy` | The user that last updated the entity. |
| `userActivatedAt` | `varchar2` | User Activated at | [ ] | filters on the platform, writable, `userActivatedAt` | The activation date of the user in ATOM/ISO-8601 format. |
| `userInvitationSentAt` | `varchar2` | User Invitation Sent at | [ ] | filters on the platform, writable, `userInvitationSentAt` | The invitation date of the user in ATOM/ISO-8601 format, for as long as the user has not accepted the invitation to this organization, NULL otherwise. |
| `userType` | `int64` | User Type | [ ] | filters on the platform, writable, `userType` | The type of user associated with this employee. 0 = None, 1 = Admin, 2 = Basic, 3 = Platform. |
| `username` | `varchar2` | User Name | [ ] | filters on the platform, writable, `username` | The username of the user associated with this employee. |
| `workhoursFriday` | `varchar2` | Work Hours Friday | [ ] | filters on the platform, writable, `workhoursFriday` | The standard amount of workhours on a friday. |
| `workhoursMonday` | `varchar2` | Work Hours Monday | [ ] | filters on the platform, writable, `workhoursMonday` | The standard amount of workhours on a monday. |
| `workhoursSaturday` | `varchar2` | Work Hours Saturday | [ ] | filters on the platform, writable, `workhoursSaturday` | The standard amount of workhours on a saturday. |
| `workhoursSunday` | `varchar2` | Work Hours Sunday | [ ] | filters on the platform, writable, `workhoursSunday` | The standard amount of workhours on a sunday. |
| `workhoursThursday` | `varchar2` | Work Hours Thursday | [ ] | filters on the platform, writable, `workhoursThursday` | The standard amount of workhours on a thursday. |
| `workhoursTuesday` | `varchar2` | Work Hours Tuesday | [ ] | filters on the platform, writable, `workhoursTuesday` | The standard amount of workhours on a tuesday. |
| `workhoursWednesday` | `varchar2` | Work Hours Wednesday | [ ] | filters on the platform, writable, `workhoursWednesday` | The standard amount of workhours on a wednesday. |
| `workload` | `varchar2` | Work Load | [ ] | filters on the platform, writable, `workload` | The workload of the employee, this value is ignored when the workhour fields contain a value. |
| `zipCode` | `varchar2` | ZIP Code | [ ] | filters on the platform, writable, `zipCode` | ZIP code of the address. |



## Release Notes

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

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

