Free Fields
Updated
by
Nick de Bie
The free fields in the tables DIM_EMPLOYEE, DIM_EMPLOYEE_SAFE and REP_EMPLOYEE_CURR are combined in a JSON string in the column CONTRACT_FREE_FIELDS_KV.
- To parse the JSON string in Power Query:
- Select the column CONTRACT_FREE_FIELDS_KV.
- Go to Transform > Parse > JSON and click on the double arrow.
- Select the desired columns.
The free fields in eBlox Payroll are named by default Vrije rubrieken 1 and Vrije rubrieken 2.
- In the tables, you find:
- eBlox Payroll name
- eBlox "rubriek"
- name of the Insights Cloud in italics
Vrije rubrieken 1
Alfanumerieke rubrieken | ||||||
Zone 1 posities (1) | VRRUB011 | Free zone 1 (1 position) | Zone 1 posities (4) | VRRUB014 | Free zone 4 (1 position) | |
Zone 1 posities (2) | VRRUB012 | Free zone 2 (1 position) | Zone 1 posities (5) | VRRUB015 | Free zone 5 (1 position) | |
Zone 1 posities (3) | VRRUB013 | Free zone 3 (1 position) | Zone 1 posities (6) | VRRUB016 | Free zone 6 (1 position) | |
Zone 2 posities (1) | VRRUB021 | Free zone 1 (2 positions) | Zone 2 posities (5) | VRRUB025 | Free zone 5 (2 positions) | |
Zone 2 posities (2) | VRRUB022 | Free zone 2 (2 positions) | Zone 2 posities (6) | VRRUB026 | Free zone 6 (2 positions) | |
Zone 2 posities (3) | VRRUB023 | Free zone 3 (2 positions) | Zone 2 posities (7) | VRRUB027 | Free zone 7 (2 positions) | |
Zone 2 posities (4) | VRRUB024 | Free zone 4 (2 positions) | Zone 2 posities (8) | VRRUB028 | Free zone 8 (2 positions) | |
Zone 3 posities (1) | VRRUB031 | Free zone 1 (3 positions) | Zone 3 posities (2) | VRRUB032 | Free zone 2 (3 positions) | |
Zone 5 posities (1) | VRRUB051 | Free zone 1 (5 positions) | Zone 5 posities (4) | VRRUB054 | Free zone 4 (5 positions) | |
Zone 5 posities (2) | VRRUB052 | Free zone 2 (5 positions) | Zone 5 posities (5) | VRRUB055 | Free zone 5 (5 positions) | |
Zone 5 posities (3) | VRRUB053 | Free zone 3 (5 positions) | Zone 5 posities (6) | VRRUB056 | Free zone 6 (5 positions) | |
Zone 6 posities (1) | VRRUB061 | Free zone 1 (6 positions) | Zone 9 posities (1) | VRRUB091 | Free zone 1 (9 positions) | |
Zone 6 posities (2) | VRRUB062 | Free zone 2 (6 positions) | Zone 9 posities (2) | VRRUB092 | Free zone 2 (9 positions) | |
Zone 12 posities (1) | VRRUB121 | Free zone 1 (12 positions) | ||||
Zone 12 posities (2) | VRRUB122 | Free zone 2 (12 positions) | ||||
Zone 40 posities | VRRUB401 | Free zone (40 positions) |
Vrije rubrieken 2
Datums | Numerieke rubrieken | |||||
Datum (1) | VRDATUM1 | Free date 1 | Zone 7 posities (1) | VRRUB071 | Free zone 1 (7 positions - numeric) | |
Datum (2) | VRDATUM2 | Free date 2 | Zone 7 posities (2) | VRRUB072 | Free zone 2 (7 positions - numeric) | |
Datum (3) | VRDATUM3 | Free date 3 | Zone 7 posities (3) | VRRUB073 | Free zone 3 (7 positions - numeric) | |
Datum (4) | VRDATUM4 | Free date 4 | Zone 7 posities (4) | VRRUB074 | Free zone 4 (7 positions - numeric) | |
Datum (5) | VRDATUM5 | Free date 5 | Zone 7 posities (5) | VRRUB075 | Free zone 5 (7 positions - numeric) | |
Datum (6) | VRDATUM6 | Free date 6 | Zone 7 posities (6) | VRRUB076 | Free zone 6 (7 positions - numeric) | |
Zone 7 posities (7) | VRRUB077 | Free zone 7 (7 positions - numeric) | ||||
Historische datum | Zone 7 posities (8) | VRRUB078 | Free zone 8 (7 positions - numeric) | |||
Datum (H1) | VRHDAT1 | Free date 1 - historical | ||||
Historische alfanumerieke rubrieken | ||||||
Zone 1 posities (H1) | VRRUH011 | Free zone 1 (1 position - historical) | ||||
Zone 1 posities (H2) | VRRUH012 | Free zone 2 (1 position - historical) | ||||
Zone 2 posities (H1) | VRRUH021 | Free zone 1 (2 positions - historical) | ||||
Zone 2 posities (H2) | VRRUH022 | Free zone 2 (2 positions - historical) | ||||
Zone 8 posities (H1) | VRRUH081 | Free zone 1 (8 positions - historical) | ||||
Zone 10 posities (H1) | VRRUH101 | Free zone 1 (10 positions - historical) | ||||
Zone 12 posities (H1) | VRRUH121 | Free zone 1 (12 positions - historical) |
