File format
The transfer file is UTF-8 format semicolon (;) separated text data. Material does not contain titles. There is no upper limit for field lengths. The salary data schema file can be downloaded from the service.
Restrictions
- Employees with Employee identifier 0 will not be included in the material
- Empty project codes are replaced as follows. Project codes 1 and 2: the value is not replaced even if their value is NULL. Project codes 3-5: if the value is NULL, then the value is replaced by the value of the next project code. For example, project code3 = NULL, project code4 = 123, and project code5 = NULL, are the values project code3 = 123, project code4 = NULL, and project code5 = NULL.
Data records
Column |
Description |
Integration query field |
Format |
Notes |
A |
Employee identifier |
Set automatically, cannot be overridden |
string |
" is used as enclosure for this field. If integration ID is empty, employee number will be used |
B |
Salary code |
SalaryCode |
string |
|
C |
Start date |
StartDateTime |
string |
Format DD.MM.YYYY |
D |
End date |
EndDateTime |
string |
Format DD.MM.YYYY |
E |
Amount, hours |
"Amount" field if UnitType is 'H' or 'S', otherwise 0 |
decimal |
Amount of hours with accuracy of 2 decimals. , as decimal separator. This field contains information if field is outputted as hours. |
F |
Amount, days |
"Amount" field if UnitType is 'J', otherwise 0 |
decimal |
Amount of days with accuracy of 2 decimals. , as decimal separator. This field contains information if field is outputted as days. |
G |
Amount, decimal / units |
"Amount" field if UnitType is 'U' or 'D', otherwise 0 |
decimal |
Amount with accuracy of 2 decimals. , as decimal separator. This field contains information if field is outputted as decimal or units. |
H |
Project code 1 |
ProjectCode1 |
string |
" is used as enclosure for this field |
I |
Project code 2 |
ProjectCode2 |
string |
" is used as enclosure for this field |
J |
Project code 3 |
ProjectCode3 |
string |
" is used as enclosure for this field |
K |
Project code 4 |
ProjectCode4 |
string |
" is used as enclosure for this field |
L |
Project code 5 |
ProjectCode5 |
string |
" is used as enclosure for this field |
M |
Amount, currency |
"Amount" field if UnitType='C', otherwise 0 |
decimal |
Amount of currency with accuracy of 2 decimals. , as decimal separator. This field contains information if field is outputted as currency. |