Employees: Bouw7 Employees
popular read only REST
- Catalog:
Bouw7 - Schema:
Organization - Label: Employees
Return a list of employees associated with your organization. Return a list of employees associated with your organization.
Can only retrieve data.
Summary
Return a list of employees associated with your organization.
API Source
- Endpoint:
/list/employees - Operation:
get /list/employees
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 79 |
| Full scan rows per minute | 85,400 |
| 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 string |
Table Columns
The columns of the table Employees 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, consisting of street name and house/building number, of the employee. | |
avatar |
varchar2 |
This field is dynamically hydrated by the 'addFileInformation'-method in the schema factory. | filters on the platform, writable, avatar |
The hash of the avatar/profile picture of this employee. | |
birth |
datetime |
Birth Date | filters on the platform, writable, birth |
The birth date of the employee. | |
ca |
datetime |
CA Medewerker Datumtijd | filters on the platform, writable, ca |
||
ca |
datetime |
TATA pas - 2 maanden | filters on the platform, writable, ca |
||
ca |
datetime |
VCA datum - 4 maanden | filters on the platform, writable, ca |
||
city |
varchar2 |
City | filters on the platform, writable, city |
The city of residence of this employee. | |
created |
datetime |
Created at | filters on the platform, writable, created |
The creation date of the object in ATOM/ISO-8601 format | |
created |
int64 |
Created by ID | filters on the platform, writable, created |
The ID of the user. | |
created |
varchar2 |
Created by User Name | filters on the platform, writable, created |
The username of the user. | |
date |
varchar2 |
Date of Employment | filters on the platform, writable, date |
The employment date of the employee. | |
date |
varchar2 |
Date of Resignation | filters on the platform, writable, date |
The resignation date of the employee. | |
department_ |
int64 |
Department Branch ID | filters on the platform, writable, department. |
The branch ID of the department. | |
department_ |
varchar2 |
Department Branch Name | filters on the platform, writable, department. |
The branch name of this department. | |
department_ |
int64 |
Department ID | filters on the platform, writable, department. |
The ID of the department. | |
department_ |
char |
Department Is Active | filters on the platform, writable, department. |
Whether this department is currently active. | |
department_ |
varchar2 |
Department Name | filters on the platform, writable, department. |
Display name of the department. | |
email |
varchar2 |
Email Address | filters on the platform, writable, email |
The email address of the employee. | |
external |
char |
External | filters on the platform, writable, external |
True if employee is external, otherwise false. | |
first |
varchar2 |
First Name | filters on the platform, writable, first |
The given name of the employee. | |
function |
varchar2 |
Function Title | filters on the platform, writable, function |
The function title of this employee. | |
has |
char |
Has Signature | filters on the platform, writable, has |
Whether the employee has a signature file configured. | |
hourly |
varchar2 |
Hourly Rate | filters on the platform, writable, hourly |
The hourly rate. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of this employee. | |
last |
varchar2 |
Last Name | filters on the platform, writable, last |
The family name of the employee. | |
phone |
varchar2 |
Phone Number | filters on the platform, writable, phone |
The phone number of the employee. | |
scab |
int64 |
SCAB Employee ID | filters on the platform, writable, scab |
The internal scab employee ID associated with this employee. | |
selling |
varchar2 |
Selling Hourly Rate | filters on the platform, writable, selling |
The selling hourly rate. | |
updated |
datetime |
Updated At | filters on the platform, writable, updated |
The creation date of the object in ATOM/ISO-8601 format | |
updated |
int64 |
Updated by ID | filters on the platform, writable, updated |
The ID of the user. | |
updated |
varchar2 |
Updated by User Name | filters on the platform, writable, updated |
The username of the user. | |
user_ |
varchar2 |
User Activated at | filters on the platform, writable, user. |
The date the user link was activated in ATOM-format. Null if the user link is inactive. | |
user_ |
int64 |
User ID | filters on the platform, writable, user. |
The ID of the user. | |
user_ |
int64 |
User Link ID | filters on the platform, writable, user. |
The ID of the relation object towards the user. | |
user_ |
int64 |
User Type | filters on the platform, writable, user. |
The type of user. 0 = No account, 1 = Administrator, 2 = Basic, 3 = Platform | |
user_ |
varchar2 |
User User Name | filters on the platform, writable, user. |
The username. The e-mail address the user uses to sign in. | |
workload |
varchar2 |
Work Load | filters on the platform, writable, workload |
The amount of hours this employee is working on a weekly basis. | |
zip |
varchar2 |
ZIP Code | filters on the platform, writable, zip |
The zip code, also known as postal code, associated with the address. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: