profit_employees_basic: AFAS Profit Employees (Basic)
read only REST
- Catalog:
AfasOnline - Schema:
GetConnector - Label: Employees (Basic)
Can only retrieve data.
Summary
Profit_Employees_basic
API Source
- Endpoint:
/connectors/Profit_Employees_basic - Metadata:
metainfo/get/Profit_Employees_basic
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 353 |
| Full scan rows per minute | 65,100 |
| Point query rows per minute | 169 |
The result can be cached on the client.
Table Columns
The columns of the table profit_employees_basic 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 |
|---|---|---|---|---|---|
blocked |
int32 |
Geblokkeerd | fetched only when named, Blocked |
||
bsn |
varchar2 |
Burgerservicenummer | fetched only when named, BSN |
||
datebirth |
varchar2 |
Geboortedatum | fetched only when named, Date |
||
dvid |
varchar2 |
Status dienstverband code | fetched only when named, DvId |
||
employeeid |
varchar2 |
Medewerker | fetched only when named, Employee |
||
employer |
varchar2 |
Werkgever | fetched only when named, Employer |
||
employmentend |
varchar2 |
Datum uit dienst | fetched only when named, Employment |
||
employmentstart |
varchar2 |
Datum in dienst | fetched only when named, Employment |
||
function |
varchar2 |
Omschrijving functie | fetched only when named, Function |
||
functionid |
varchar2 |
Functie | fetched only when named, Function |
||
mail |
varchar2 |
E-mail werk | fetched only when named, Mail |
||
name |
varchar2 |
Naam | fetched only when named, Name |
||
oe |
varchar2 |
Organisatorische eenheid | fetched only when named, OE |
||
personid |
varchar2 |
Nummer | fetched only when named, Person |