Corporate customers can update the employee base data via a csv-interface in regular intervals (daily, weekly or monthly). The data will be interchanged via a secured sFTP-access, that is provided by Atlatos. The csv file can be used to control the access data dispatch when a new employee is created as well as the deactivation or deletion of individual employees. The structure of the csv file is shown in the template „Instructions_Employeebasedataimport_AtlatosCSV“. Format of the file: ISO-8859-1,comma separated.
As a general rule, a comparison to the data stored in Atlatos is carried out for each data record. If the cost center in the recorded csv file differs from the one listed in the Atlatos Profi Traveller, this will be changed. Thus, the csv file of the customer is the leading system.
Manual changes made by travellers will be overwritten if the field is maintained in the csv file.
|
Column head |
description |
type |
Field length |
|
access |
This field controls whether the employee is deleted, inactive or active
M = send new access data for new employees or if the branch changes N = do not send new access data (default value) I = employee is inactive P = employee is passive L = delete employee Z = send new access data |
text |
|
|
User name |
The username is the unique ID of the employee within in the company, which is also listed as a primary key in Atlatos Profi Traveller. It is recommended to use the e-mail address or the personnel number of the traveller. If the personnel number is unambiguous, this is an advantage because in case of a name change no change of the username is necessary If no single-on procedure is used,it is necessary to enter the user name for the log in. If the employees rarely know their personnel numbers,the e-mail address is to be preferred.
Company-specific value, Attention: The username must start alphanumerically and may additionally contain the special characters .-_@+!#~ as well as spaces. However, with a space in the username, the user cannot save a URL where the username is already filled out. Changing the username: "new username;old username" (If the file is semicolon-separated: "new username,old username") |
text |
|
|
salutation |
Mr or Mrs |
text |
|
|
title |
Dr., Prof.,.. This section is optional |
text |
|
|
First name |
First name of the traveller |
text |
|
|
Last name |
Last name of the traveller |
text |
|
|
branch |
The corresponding company of the travellers, which also corresponds to the billing address, has to be indicated. Please note that the branch must already be in Atlatos. |
text |
|
|
department |
Please specify the department or a grouping that makes sense for the company (for example cost center) |
text |
|
|
phone |
Telephone number of the traveller |
text |
|
|
|
E-mail address of the traveller |
text |
Optional information:
|
Column head |
description |
type |
Field length |
|
Date of birth |
Date of birth of the traveller |
date |
|
|
Type of BahnCard |
BC25 /50 /100 1. Or 2. Class BCB= BahnCard Business BC= BahnCard private |
text |
|
|
BahnCard number |
Number of the BC of the traveller |
text |
|
|
Validity of BC |
Date until the BahnCard is valid |
date |
|
|
Frequent flyer card |
Information of the provider and the respective number |
text |
|
|
Personnel number |
Company internal personnel number of the traveller |
text |
|
|
Accounting unit |
|||
|
Project number |
Number of the project to which the traveller is assigned |
text |
|
|
Order number |
Number of the respective order |
text |
|
|
Action number |
text |
||
|
Train compartment type |
cmp= compartment wgn= high-capacity wagons tbl= seat with a desk |
text |
|
|
Train seat type |
win= window ail= aisle |
text |
|
|
Flight seat type |
win = window ail = aisle |
text |
|
|
Flight meal |
Indicate your preferences ( for example vegetarian) |
text |
|
|
Rental car - preferred provider |
Rental car provider |
text |
|
|
Hotel - smoker |
True or false |
text |
|
|
ID number |
Number of your ID card |
text |
|
|
ID Card validity |
Duration of validity of the ID card |
date |
|
|
ID card date of birth |
Date of birth that is indicated on the ID card |
date |
|
Bank code number |
Bank code number of the debit card |
text |
|
|
Bank account number |
Bank account number |
text |
|
|
debit card validity |
Duration of validity of the debit card (year) |
date |
|
|
Credit card validity |
Duration of validity of the credit card |
date |
|
|
Credit card number |
Credit card number |
text |
|
|
Travel profile |
|||
|
Approver/booking authorization |
ra= approver of travel requests rka= approver of travel expense reports book= booking authorization report= report authorization If nothing is selected, ra is selected automatically |
text |
Comments
0 comments
Article is closed for comments.