Importing employees
Employees
Column titles
Column title | Field in Robaws |
|---|---|
FIRSTNAME | First name |
LASTNAME | Name |
TEL | Telephone |
GSM | Gsm |
EMERGENCYCALL | Emergencycalls |
BIRTHDATE | Birthdate |
INSZ | INSZ (national register number, Belgium only) |
BANKACCOUNT | Bankaccount |
FUNCTION | Function |
EMPLOYEESINCE | Employed since |
EMPLOYEEGONE | Left employment |
DIMONA | Dimona number (Belgium only) |
STREET | Street |
ZIPCODE | Zipcode |
CITY | City |
COUNTRY | Country |
STATUS | Status |
CIVILSTATE | Civil state (see overview below) |
TYPE | Engagement type (see overview below) |
EMPLOYEESTATUTE | Employee statute (see overview below) |
ID | Id from the database, is used for the update. You can find it in the Excel export |
COSTPERHOUR | Labour cost |
PASSPORT_EXPIRE_DATE | Passnumber due date |
NATIONALITY | Nationality |
DEPENDENT_CHILDREN | Dependants - only enter a number |
DETACHMENT | Secondment - enter Yes or No |
EMPLOYEE_ROLE | Employee role |
COMPETENCE | Competence |
DIMONA_EXPIRE_DATE | Dimona due date |
HOME_WORK_DISTANCE | Home/work commute distance |
APPLY_DEFAULT_MOBILITY | Apply mobility - enter Yes or No |
MOBILITY | Mobility |
APPLY_HOME_WORK_MOBILITY | Apply home/work commuting - enter Yes or No |
HOME_WORK_MOBILITY | Home/work mobility |
TIME_OPERATION_DEFAULT | Default time operation - enter an existing item number |
STOCK_LOCATION | Stock location |
Civil state
Possible values for civil state
- Married
- Unmarried
- Legally cohabiting
- Factually cohabiting
- Legally divorced
- Factually divorced
- Widower/Widow
Type
Possible values for engagement type
- Interim
- Payroll
- OA
- Trainee
- Independent
Employee statute (EMPLOYEESTATUTE)
Possible values for employee statute
- Worker
- White-collar worker
UPDATE_BY
For employees, the update can be carried out on the basis of:
- ID :
The most accurate way to update an existing employee, because the id is always unique. You find the id in the export of the employees.
Updated on: 09/09/2026
Thank you!
