BE_PAYROLL

3 articles

Data Catalog

This data mart includes data from Payroll (SME market) and eBlox (PR / Large Enterprise). Views. Dimensions. Description. Examples. DIM_CALENDAR Default calendar Quarters, week numbers, days in the w…

Updated 1 month ago by Nick de Bie

Free Fields

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: Selec…

Updated 11 months ago by Nick de Bie

FACT_PAYROLL_METRICS

Construction of the metrics columns Prefix Kind Info More info M$ - Metric KPI$ - Indicators P$ - Percentages A - Amounts H - Hours D - Days FIX - Fixed wage ADD - Additional wage VAR - Variable wage…

Updated 11 months ago by kevin cardoen

(opens in a new tab)

BE_PAYROLL

Data Catalog

Free Fields

FACT_PAYROLL_METRICS

Contact Us