2022 | Nov 3
Updated
by
kevin cardoen
FACT_PAYROLL_METRICS and FACT_PAYROLL_METRICS_SAFE
- Changed WAGE_PERIOD_ID to PERIOD_ID
- to maintain uniformity between different tables and datamarts
DIM_WAGECODE_CLUSTER
- Added new clusters and wage codes (ref legacy changes)
Wagecode | Cluster | Description |
01F0, 01F1 | D01CL0102050201 | Maternity leave |
01F2, 01F3 | D01CL010205030102 | Birth leave - NIHDI cost |
01F4, 01F5 | D01CL0102050204 | Prophylactic leave |
01F6, 01F7 | D01CL010205020202 | Maternity protection (Excl PWH) - Employer cost |
01G0, 01G1, 01G2, 01G3 | D01CL010205030302 | Foster parent leave - NIHDI/NEO cost |
01G4, 01G5 | D01CL010205030402 | Adoption leave - NIHDI cost |
01G6, 01G7 | D01CL0102050301 | Birth leave |
01G8, 01G9 | D01CL010203020303 | Quarantine |
07A9 | D01CL0102060202 | War |
2542, 2543, 2581, 2582 | A01CL07010204 | Contribution to (early) holiday pay - Public sector |
26D0, 26D1, 26D2, 26D3, 26D4, 26D5, 26D6, 26D7, 26D8, 26D9 | A01CL03020301 | Taxable bonus per payment period |
32A0, 32A1, 32A2, 32A3 | A01CL0405060101 | Relocation costs |
32A4, 32A5, 32A6 | A01CL0405060201 | Furnishing costs |
32A7, 32A8, 32A9 | A01CL0405060301 | School fees |
41D0, 41D1, 41D2, 41D3 | A01CL0405060102 | Already paid relocation costs |
41D4, 41D5, 41D6 | A01CL0405060202 | Already paid furnishing costs |
41D7, 41D8, 41D9 | A01CL0405060302 | Already paid school fees |
5098 | A01CL11020102 | Administration of non-periodic bonuses calculation |
5191 | A01CL11020111 | Administration of end-of-year bonuses for intermediaries |
5621, 5631, 5641 | A01CL06020212 | Older regulation - Start-up agreement |
76D0, 76D1, 76D2, 76D3, 76D4, 76D5, 76D6, 76D7, 76D8, 76D9 | H01CL03020301 | Taxable bonus per payment period |
91F0, 91F1, 71F0, 71F1 | H01CL0102050201 | Maternity leave |
91F2, 91F3, 91G6, 91G7, 71F2, 71F3, 71G6, 71G7 | H01CL010205030102 | Birth leave - NIHDI cost |
91F4, 91F5, 71F4, 71F5 | H01CL0102050204 | Prophylactic leave |
91F6, 91F7, 71F6, 71F7 | H01CL010205020202 | Maternity protection (Excl PWH) |
91G0, 91G1, 91G2, 91G3, 71G0, 71G1, 71G2, 71G3 | H01CL010205030302 | Foster parent leave - NIHDI/NEO cost |
91G4, 91G5, 71G4, 71G5 | H01CL010205030402 | Adoption leave - NIHDI cost |
91G8, 91G9, 71G8, 71G9 | H01CL010203020303 | Quarantine |
97A9 | H01CL0102060202 | War |
