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

# EmployeeCustomAttributeValuesByEmployeeId: Bouw7 Employee Custom Attribute Values by Employee ID

`read only` `REST`

- Catalog: `Bouw7`
- Schema: `Organization`
- Label: Employee Custom Attribute Values by Employee 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 `EmployeeCustomAttributeValuesByEmployeeId` 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, `::ancestor.address` | The address of the employee. |
| `afasWarehouse` | `varchar2` | AFAS Warehouse | [ ] | filters on the platform, writable, `::ancestor.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, `::ancestor.avatarFileHash` | The hash of the avatar/profile picture of this employee. |
| `birthDate` | `datetime` | Birth Date | [ ] | filters on the platform, writable, `::ancestor.birthDate` | The birth date of the employee. |
| `bsn` | `varchar2` | SSN | [ ] | filters on the platform, writable, `::ancestor.bsn` | The BSN of the employee. |
| `city` | `varchar2` | City | [ ] | filters on the platform, writable, `::ancestor.city` | The city of the employee. |
| `createdAt` | `datetime` | Created at | [ ] | filters on the platform, writable, `::ancestor.createdAt` | The creation time of the entity. |
| `createdBy` | `varchar2` | Created by | [ ] | filters on the platform, writable, `::ancestor.createdBy` | The user that created the entity. |
| `customAttribute_fieldType` | `varchar2` | Custom Attribute Field Type | [ ] | writable, `customAttribute.fieldType` | The I18N key of the field type. |
| `customAttribute_fieldTypeId` | `int64` | Custom Attribute Field Type ID | [ ] | writable, `customAttribute.fieldTypeId` | The ID of the field type. |
| `customAttribute_id` | `int64` | Custom Attribute ID | [ ] | writable, `customAttribute.id` | The ID of the custom attribute. |
| `customAttribute_isDisplayedOnCompletion` | `char` | Custom Attribute Is Displayed on Completion | [ ] | writable, `customAttribute.isDisplayedOnCompletion` | Whether the custom attribute is displayed on a completion document. |
| `customAttribute_isDisplayedOnInvoice` | `char` | Custom Attribute Is Displayed on Invoice | [ ] | writable, `customAttribute.isDisplayedOnInvoice` | Whether the custom attribute is displayed on an invoice document. |
| `customAttribute_isReadOnly` | `char` | Custom Attribute Is Read-only | [ ] | writable, `customAttribute.isReadOnly` | Whether the custom attribute is a read-only field. |
| `customAttribute_isRequired` | `char` | Custom Attribute Is Required | [ ] | writable, `customAttribute.isRequired` | Whether the custom attribute is a required field. |
| `customAttribute_name` | `varchar2` | Custom Attribute Name | [ ] | writable, `customAttribute.name` | The name of the custom attribute. |
| `dateOfEmployment` | `varchar2` | Date of Employment | [ ] | filters on the platform, writable, `::ancestor.dateOfEmployment` | The date of employment of the employee in Y-m-d format. |
| `dateOfResignation` | `varchar2` | Date of Resignation | [ ] | filters on the platform, writable, `::ancestor.dateOfResignation` | The date of resignation of the employee in Y-m-d format. |
| `department_id` | `int64` | Department ID | [ ] | filters on the platform, writable, `::ancestor.department.id` | ID of the department. |
| `department_name` | `varchar2` | Department Name | [ ] | filters on the platform, writable, `::ancestor.department.name` | Name of the department. |
| `employeeMail` | `varchar2` | Employee Mail | [ ] | filters on the platform, writable, `::ancestor.employeeMail` | The email of the employee. |
| `external` | `char` | External | [ ] | filters on the platform, writable, `::ancestor.external` | Whether the employee is external. |
| `firstName` | `varchar2` | First Name | [ ] | filters on the platform, writable, `::ancestor.firstName` | The first name of the employee. |
| `function` | `varchar2` | Function | [ ] | filters on the platform, writable, `::ancestor.function` | The function of the employee. |
| `hourlyRate` | `varchar2` | Hourly Rate | [ ] | filters on the platform, writable, `::ancestor.hourlyRate` | The hourly rate |
| `id` | `int64` | ID | [ ] | filters on the platform, writable, `::ancestor.id` | The ID of the employee. |
| `lastName` | `varchar2` | Last Name | [ ] | filters on the platform, writable, `::ancestor.lastName` | The last name of the employee. |
| `payrollDivision_description` | `varchar2` | Payroll Division Description | [ ] | filters on the platform, writable, `::ancestor.payrollDivision.description` | The description of the division. |
| `payrollDivision_exactDivisionId` | `varchar2` | Payroll Division Exact Division ID | [ ] | filters on the platform, writable, `::ancestor.payrollDivision.exactDivisionId` | The division ID of an Exact Online environment. |
| `payrollDivision_glAccountCode` | `varchar2` | Payroll Division GL Account Code | [ ] | filters on the platform, writable, `::ancestor.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, `::ancestor.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, `::ancestor.payrollDivision.id` | The ID of the division. |
| `payrollDivision_journalCode` | `varchar2` | Payroll Division Journal Code | [ ] | filters on the platform, writable, `::ancestor.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, `::ancestor.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, `::ancestor.payrollDivision.salesInvoiceNumberPrefix` | The prefix (3 digits) used to generate invoice number range per division. |
| `phoneNumber` | `varchar2` | Phone Number | [ ] | filters on the platform, writable, `::ancestor.phoneNumber` | The phone number of the employee. |
| `scabEmployeeId` | `varchar2` | SCAB Employee ID | [ ] | filters on the platform, writable, `::ancestor.scabEmployeeId` | The internal ID of the Scab employee associated with this employee. |
| `sellingHourlyRate` | `varchar2` | Selling Hourly Rate | [ ] | filters on the platform, writable, `::ancestor.sellingHourlyRate` | The selling hourly rate |
| `signatureFileHash` | `varchar2` | Signature File Hash | [ ] | filters on the platform, writable, `::ancestor.signatureFileHash` | The hash of the signature file of this employee. |
| `updatedAt` | `datetime` | Updated At | [ ] | filters on the platform, writable, `::ancestor.updatedAt` | The last updated time of the entity. |
| `updatedBy` | `varchar2` | Updated by | [ ] | filters on the platform, writable, `::ancestor.updatedBy` | The user that last updated the entity. |
| `userActivatedAt` | `varchar2` | User Activated at | [ ] | filters on the platform, writable, `::ancestor.userActivatedAt` | The activation date of the user in ATOM/ISO-8601 format. |
| `userInvitationSentAt` | `varchar2` | User Invitation Sent at | [ ] | filters on the platform, writable, `::ancestor.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, `::ancestor.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, `::ancestor.username` | The username of the user associated with this employee. |
| `value` | `varchar2` | Value | [ ] | writable, `value` | The value of the custom attribute. |
| `workhoursFriday` | `varchar2` | Work Hours Friday | [ ] | filters on the platform, writable, `::ancestor.workhoursFriday` | The standard amount of workhours on a friday. |
| `workhoursMonday` | `varchar2` | Work Hours Monday | [ ] | filters on the platform, writable, `::ancestor.workhoursMonday` | The standard amount of workhours on a monday. |
| `workhoursSaturday` | `varchar2` | Work Hours Saturday | [ ] | filters on the platform, writable, `::ancestor.workhoursSaturday` | The standard amount of workhours on a saturday. |
| `workhoursSunday` | `varchar2` | Work Hours Sunday | [ ] | filters on the platform, writable, `::ancestor.workhoursSunday` | The standard amount of workhours on a sunday. |
| `workhoursThursday` | `varchar2` | Work Hours Thursday | [ ] | filters on the platform, writable, `::ancestor.workhoursThursday` | The standard amount of workhours on a thursday. |
| `workhoursTuesday` | `varchar2` | Work Hours Tuesday | [ ] | filters on the platform, writable, `::ancestor.workhoursTuesday` | The standard amount of workhours on a tuesday. |
| `workhoursWednesday` | `varchar2` | Work Hours Wednesday | [ ] | filters on the platform, writable, `::ancestor.workhoursWednesday` | The standard amount of workhours on a wednesday. |
| `workload` | `varchar2` | Work Load | [ ] | filters on the platform, writable, `::ancestor.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, `::ancestor.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)

