> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://support.robaws.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Importing employees

| Make sure you also read the [general information about data import](https://support.robaws.com/en/article/import-general-explanation-18g6g1c/) 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.