This article is also available in:

Importing employees

Make sure you also read the general information about data import in Robaws.


Employees


Column titles

Column title

Field in Robaws

FIRSTNAME

First name

LASTNAME

Name

TEL

Telephone

GSM

Gsm

EMAIL

Email

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.


So in the UPDATE_BY column you fill in ID and not the value of the field, which you fill in in the column concerned.

Updated on: 09/09/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!