EmployeeDivisionsById: Bouw7 itgen_bouw7_employeedivisionsbyid_plural
read only REST
- Catalog:
Bouw7 - Schema:
Organization - Label: itgen_bouw7_employeedivisionsbyid_plural
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 |
`` |
Table Columns
The columns of the table EmployeeDivisionsById 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. |
The address of the employee. | |
afas |
varchar2 |
AFAS Warehouse | filters on the platform, writable, ::ancestor. |
The warehouse material bookings of an employee will be booked on. Only applicable for AFAS. | |
avatar |
varchar2 |
Avatar File Hash | filters on the platform, writable, ::ancestor. |
The hash of the avatar/profile picture of this employee. | |
birth |
datetime |
Birth Date | filters on the platform, writable, ::ancestor. |
The birth date of the employee. | |
bsn |
varchar2 |
SSN | filters on the platform, writable, ::ancestor. |
The BSN of the employee. | |
city |
varchar2 |
City | filters on the platform, writable, ::ancestor. |
The city of the employee. | |
created |
datetime |
Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
created |
varchar2 |
Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
date |
varchar2 |
Date of Employment | filters on the platform, writable, ::ancestor. |
The date of employment of the employee in Y-m-d format. | |
date |
varchar2 |
Date of Resignation | filters on the platform, writable, ::ancestor. |
The date of resignation of the employee in Y-m-d format. | |
department_ |
int64 |
Department ID | filters on the platform, writable, ::ancestor. |
ID of the department. | |
department_ |
varchar2 |
Department Name | filters on the platform, writable, ::ancestor. |
Name of the department. | |
description |
varchar2 |
Description | writable, description |
The name of the division. | |
employee |
varchar2 |
Employee Mail | filters on the platform, writable, ::ancestor. |
The email of the employee. | |
external |
char |
External | filters on the platform, writable, ::ancestor. |
Whether the employee is external. | |
first |
varchar2 |
First Name | filters on the platform, writable, ::ancestor. |
The first name of the employee. | |
function |
varchar2 |
Function | filters on the platform, writable, ::ancestor. |
The function of the employee. | |
hourly |
varchar2 |
Hourly Rate | filters on the platform, writable, ::ancestor. |
The hourly rate | |
id |
int64 |
ID | filters on the platform, writable, ::ancestor. |
The ID of the employee. | |
is |
char |
itgen_bouw7_ispayrolldivision | writable, is |
Whether the division is the payroll division. | |
last |
varchar2 |
Last Name | filters on the platform, writable, ::ancestor. |
The last name of the employee. | |
payroll |
varchar2 |
Payroll Division Description | filters on the platform, writable, ::ancestor. |
The description of the division. | |
payroll |
varchar2 |
Payroll Division Exact Division ID | filters on the platform, writable, ::ancestor. |
The division ID of an Exact Online environment. | |
payroll |
varchar2 |
Payroll Division GL Account Code | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for sales related items. | |
payroll |
varchar2 |
Payroll Division GL Account Code Purchase | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for purchase related items. | |
payroll |
int64 |
Payroll Division ID | filters on the platform, writable, ::ancestor. |
The ID of the division. | |
payroll |
varchar2 |
Payroll Division Journal Code | filters on the platform, writable, ::ancestor. |
A default journal code to use for sales related items. | |
payroll |
varchar2 |
Payroll Division Journal Code Purchase | filters on the platform, writable, ::ancestor. |
A default journal code to use for purchase related items. | |
payroll |
varchar2 |
Payroll Division Sales Invoice Number Prefix | filters on the platform, writable, ::ancestor. |
The prefix (3 digits) used to generate invoice number range per division. | |
phone |
varchar2 |
Phone Number | filters on the platform, writable, ::ancestor. |
The phone number of the employee. | |
scab |
varchar2 |
SCAB Employee ID | filters on the platform, writable, ::ancestor. |
The internal ID of the Scab employee associated with this employee. | |
selling |
varchar2 |
Selling Hourly Rate | filters on the platform, writable, ::ancestor. |
The selling hourly rate | |
signature |
varchar2 |
Signature File Hash | filters on the platform, writable, ::ancestor. |
The hash of the signature file of this employee. | |
updated |
datetime |
Updated At | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
user |
varchar2 |
User Activated at | filters on the platform, writable, ::ancestor. |
The activation date of the user in ATOM/ISO-8601 format. | |
user |
varchar2 |
User Invitation Sent at | filters on the platform, writable, ::ancestor. |
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. | |
user |
int64 |
User Type | filters on the platform, writable, ::ancestor. |
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. |
The username of the user associated with this employee. | |
workhours |
varchar2 |
Work Hours Friday | filters on the platform, writable, ::ancestor. |
The standard amount of workhours on a friday. | |
workhours |
varchar2 |
Work Hours Monday | filters on the platform, writable, ::ancestor. |
The standard amount of workhours on a monday. | |
workhours |
varchar2 |
Work Hours Saturday | filters on the platform, writable, ::ancestor. |
The standard amount of workhours on a saturday. | |
workhours |
varchar2 |
Work Hours Sunday | filters on the platform, writable, ::ancestor. |
The standard amount of workhours on a sunday. | |
workhours |
varchar2 |
Work Hours Thursday | filters on the platform, writable, ::ancestor. |
The standard amount of workhours on a thursday. | |
workhours |
varchar2 |
Work Hours Tuesday | filters on the platform, writable, ::ancestor. |
The standard amount of workhours on a tuesday. | |
workhours |
varchar2 |
Work Hours Wednesday | filters on the platform, writable, ::ancestor. |
The standard amount of workhours on a wednesday. | |
workload |
varchar2 |
Work Load | filters on the platform, writable, ::ancestor. |
The workload of the employee, this value is ignored when the workhour fields contain a value. | |
zip |
varchar2 |
ZIP Code | filters on the platform, writable, ::ancestor. |
ZIP code of the address. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: