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
A ruleset configured for the integration will fill the values automatically. If a field needs to have a customised value, some fields can be replaced by setting an override for it by having the ruleset pick a value which is named 'Override' combined with the column name. Field names for using override are represented in the table below. For example by having a rule which picks a field with 'AS OverrideSalaryCode', the picked value will automatically replace the SalaryCode field. The fields that can be overridden are: Salary code, unit type, amount, project codes 1-5. More information can be found in Setting up integration rulesets - article.
|
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. |