| Excerpt |
|---|
This export tool is used to export persons to PIMS |
Preparation
This export is an executable which only task is to produce the PIMS export file and place it on an FTP server. It runs every hour.
Access
To access the utility, the user needs to have Write access to the routine 988 PIMS.
Fields exported
| Field no | Field name exported | Field in Adonis | Comments |
|---|---|---|---|
| 1 | person adonis id | PIN | |
| 2 | firstname | Firstname | |
| 3 | lastname | Lastname | |
| 4 | employeetype | Contract Type | |
| 5 | status | Employmentenddate | If employmentenddate is NULL then status=active |
| 6 |
| 7 | phonenumber | ||
| teletype | Teletype | 2=Homephone | |
| number | Teleno | ||
| 8 | extids - id name | AlternativePIN |
| 9 |
| address |
| address1 |
Step-by-Step import
When the file is prepared you are ready to import the file as follows:
- Filename - Fetch the file from where you have saved it
- Chose the separator used in the file. This can vary depending on the regional settings on the user's computer.
- Chose if you want to skip importing a record if the system finds that the person has an existing competence with same code. Note that this only checks the code and not the date from and expiry date of the record.
- Chose if the file should be Archived after the import.
| Address line 1 | |||
| address2 | Address line 2 | ||
| address3 | Address line 3 | ||
| postcode | Postcode | ||
| postname | Postname | ||
| country | Address Country | ||
| 10 | birthdate | Birthdate | YYYY-MM-DD |
| 11 | nextofkin | ||
| priority | Priority | ||
| name | Name | ||
| relation | Relationship | ||
| birthdate | Birthdate | ||
| comments | Comments | ||
| address1 | Address line 1 | ||
| postcode | Postcode | ||
| postname | Postname | ||
| country | Address_country | ||
| 12 | rotation | ||
| shiftfrom | Shift start date | All of the person's shifts will be listed with date from and to | |
| shiftto | Shift end date | All of the person's shifts will be listed with date from and to | |
| positiontype | Code | CODE of the person's position | |
| project | Description | Description of Rotation Plan | |
| location | Rotation name | Name of Project | |
| 13 | categories | If a person has a Competence code 'OC I-VI' or 'OC A-E' the competence code with highest level will be shown here | |
| validfrom | |||
| projectcategory | |||
| employeecategory |