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 | 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 |