---
title: "Employees (Robaws)"
description: "Employees"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/robaws/Robaws.Employees.Employees
original: https://documentation.invantive.eu/en/datamodels/robaws/Robaws.Employees.Employees
updated: 2026-11-03T19:00:36Z
license: https://documentation.invantive.eu/en/
---

# Employees: Robaws Employees

`insert` `update` `delete` `REST`

- Catalog: `Robaws`
- Schema: `Employees`
- Primary Keys: `id`
- Label: Employees

Search

Can retrieve data and change data using `insert`, `update` and `delete`.

## API Source

- Endpoint: `/api/v2/employees`
- Operation: `get /api/v2/employees`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 104 |
| Full scan rows per minute | 16,530 |
| Point query rows per minute | 750 |
| Write rows per minute | 539 |

The result can be cached on the client.

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `searchText` | `` | [ ] |  |  |
| `sort` | `` | [ ] |  |  |
| `updatedFrom` | `` | [ ] |  |  |
| `withArchived` | `` | [ ] |  |  |

## 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 |
|---|---|---|:---:|---|---|
| `archivedAt` | `datetime` | Archived at | [ ] | filters on the platform, writable, `archivedAt` |  |
| `bankAccountNumber` | `varchar2` | Bank Account Number | [ ] | filters on the platform, writable, `bankAccountNumber` |  |
| `civilStatus` | `varchar2` | Civil Status | [ ] | filters on the platform, writable, `civilStatus` |  |
| `collaborationEndDate` | `datetime` | Collaboration End Date | [ ] | filters on the platform, writable, `collaborationEndDate` |  |
| `collaborationStartDate` | `datetime` | Collaboration Start Date | [ ] | filters on the platform, writable, `collaborationStartDate` |  |
| `companyId` | `varchar2` | Company ID | [ ] | filters on the platform, writable, `companyId` |  |
| `competenceLevel` | `varchar2` | Competence Level | [ ] | filters on the platform, writable, `competenceLevel` |  |
| `costPerHour` | `decimal` | Cost per Hour | [ ] | filters on the platform, writable, `costPerHour` |  |
| `createdAt` | `datetime` | Created at | [ ] | filters on the platform, writable, `createdAt` |  |
| `dateOfBirth` | `datetime` | Date of Birth | [ ] | filters on the platform, writable, `dateOfBirth` |  |
| `defaultStockLocationId` | `varchar2` | Default Stock Location ID | [ ] | filters on the platform, writable, `defaultStockLocationId` |  |
| `defaultTimeOperationId` | `varchar2` | Default Time Operation ID | [ ] | filters on the platform, writable, `defaultTimeOperationId` |  |
| `deletedAt` | `datetime` | Deleted at | [ ] | filters on the platform, writable, `deletedAt` |  |
| `dimonaExpirationDate` | `datetime` | Dimona Expiration Date | [ ] | filters on the platform, writable, `dimonaExpirationDate` |  |
| `dimonaNumber` | `varchar2` | Dimona Number | [ ] | filters on the platform, writable, `dimonaNumber` |  |
| `distance` | `decimal` | Distance | [ ] | filters on the platform, writable, `distance` |  |
| `domicileAddress_addressLine1` | `varchar2` | Domicile Address Line 1 | [ ] | filters on the platform, writable, `domicileAddress.addressLine1` |  |
| `domicileAddress_addressLine2` | `varchar2` | Domicile Address Line 2 | [ ] | filters on the platform, writable, `domicileAddress.addressLine2` |  |
| `domicileAddress_city` | `varchar2` | Domicile Address City | [ ] | filters on the platform, writable, `domicileAddress.city` |  |
| `domicileAddress_country` | `varchar2` | Domicile Address Country | [ ] | filters on the platform, writable, `domicileAddress.country` |  |
| `domicileAddress_latitude` | `double` | Domicile Address Latitude | [ ] | filters on the platform, writable, `domicileAddress.latitude` |  |
| `domicileAddress_longitude` | `double` | Domicile Address Longitude | [ ] | filters on the platform, writable, `domicileAddress.longitude` |  |
| `domicileAddress_postalCode` | `varchar2` | Domicile Address Postal Code | [ ] | filters on the platform, writable, `domicileAddress.postalCode` |  |
| `driverLicense` | `varchar2` | Driver License | [ ] | filters on the platform, writable, `driverLicense` |  |
| `email` | `varchar2` | Email | [ ] | filters on the platform, writable, `email` |  |
| `emergencyTel` | `varchar2` | In Case of Emergency Phone | [ ] | filters on the platform, writable, `emergencyTel` |  |
| `employeeRoleId` | `varchar2` | Employee Role ID | [ ] | filters on the platform, writable, `employeeRoleId` |  |
| `employerId` | `varchar2` | Employer ID | [ ] | filters on the platform, writable, `employerId` |  |
| `extraFields` | `varchar2` | Extra Fields | [ ] | writable | The JSON text of the nested object. |
| `fullName` | `varchar2` | Full Name | [ ] | filters on the platform, writable, `fullName` |  |
| `grossSalary` | `decimal` | Gross Salary | [ ] | filters on the platform, writable, `grossSalary` |  |
| `gsm` | `varchar2` | Mobile | [ ] | filters on the platform, writable, `gsm` |  |
| `id` | `varchar2` | ID | [ ] | filters on the platform, writable, `id` |  |
| `identityCardExpirationDate` | `datetime` | Identity Card Expiration Date | [ ] | filters on the platform, writable, `identityCardExpirationDate` |  |
| `identityCardNumber` | `varchar2` | Identity Card Number | [ ] | filters on the platform, writable, `identityCardNumber` |  |
| `independentRegistration` | `char` | Independent Registration | [ ] | filters on the platform, writable, `independentRegistration` |  |
| `limosaExpirationDate` | `datetime` | Limosa Expiration Date | [ ] | filters on the platform, writable, `limosaExpirationDate` |  |
| `limosaNumber` | `varchar2` | Limosa Number | [ ] | filters on the platform, writable, `limosaNumber` |  |
| `lockedAt` | `datetime` | Locked at | [ ] | filters on the platform, writable, `lockedAt` |  |
| `name` | `varchar2` | Name | [ ] | filters on the platform, writable, `name` |  |
| `nationality` | `varchar2` | Nationality | [ ] | filters on the platform, writable, `nationality` |  |
| `nssoIdNumber` | `varchar2` | NSSO ID Number | [ ] | filters on the platform, writable, `nssoIdNumber` |  |
| `nssoPayment` | `char` | NSSO Payment | [ ] | filters on the platform, writable, `nssoPayment` |  |
| `nssoPaymentExpirationDate` | `datetime` | NSSO Payment Expiration Date | [ ] | filters on the platform, writable, `nssoPaymentExpirationDate` |  |
| `numberOfDependents` | `int32` | Number of Dependents | [ ] | filters on the platform, writable, `numberOfDependents` |  |
| `planningGroup` | `varchar2` | Planning Group | [ ] | filters on the platform, writable, `planningGroup` |  |
| `position` | `varchar2` | Position | [ ] | filters on the platform, writable, `position` |  |
| `secondment` | `char` | Secondment | [ ] | filters on the platform, writable, `secondment` |  |
| `status` | `varchar2` | Status | [ ] | filters on the platform, writable, `status` |  |
| `statute` | `varchar2` | Statute | [ ] | filters on the platform, writable, `statute` |  |
| `subType` | `varchar2` | Sub Type | [ ] | filters on the platform, writable, `subType` |  |
| `surname` | `varchar2` | Last Name | [ ] | filters on the platform, writable, `surname` |  |
| `tel` | `varchar2` | Phone | [ ] | filters on the platform, writable, `tel` |  |
| `type` | `varchar2` | Type | [ ] | filters on the platform, writable, `type` |  |
| `updatedAt` | `datetime` | Updated at | [ ] | filters on the platform, writable, `updatedAt` |  |
| `weeklyScheduleId` | `varchar2` | Weekly Schedule ID | [ ] | filters on the platform, writable, `weeklyScheduleId` |  |

## Keys

| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
| `Employees_companyId_fk` | `companyId` | [Companies](Robaws.Companies.Companies)`.id` | Key |  |
| `Employees_defaultStockLocationId_fk` | `defaultStockLocationId` | [StockLocations](Robaws.StockLocations.StockLocations)`.id` | Key |  |
| `Employees_employeeRoleId_fk` | `employeeRoleId` | [EmployeeRoles](Robaws.EmployeeRole.EmployeeRoles)`.id` | Key |  |
| `Employees_employerId_fk` | `employerId` | [Suppliers](Robaws.Suppliers.Suppliers)`.id` | Key |  |

## Referenced By

- [Absences](Robaws.Absences.Absences) `employeeId` (Textual)
- [EmployeeCertificates](Robaws.EmployeeCertificates.EmployeeCertificates) `employeeId` (Key)
- [Installations](Robaws.Installations.Installations) `assignedEmployeeId` (Textual)
- [Materials](Robaws.Materials.Materials) `assignedEmployeeId` (Key)
- [StockChanges](Robaws.StockChanges.StockChanges) `assignedEmployeeId` (Key)
- [TimeRegistrations](Robaws.TimeRegistrations.TimeRegistrations) `employeeId` (Textual)
- [Transports](Robaws.Transports.Transports) `driverId` (Key)
- [WorkOrderCommuteEntries](Robaws.WorkOrderCommuteEntries.WorkOrderCommuteEntries) `employeeId` (Textual)
- [WorkOrderTimeEntries](Robaws.WorkOrderTimeEntries.WorkOrderTimeEntries) `employeeId` (Textual)



## Release Notes

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

- [ROBAWS](/en/release-notes/drivers?driver=robaws)

