Our products
Absence Essentials
Getting started
Examples
Video tutorials
Get insights (recordings)
Metrics Definitions & Calculations
New Features
Insights Dashboard
Getting Started
Definitions
Example
Insights Cloud
Welcome
Data marts and Insights services
Report examples
Step 1. Windows setup
Step 2. User setup and security
Step 3: Additional steps for Power BI and Excel users
Troubleshooting
Company Firewall
International Reporting
Get started
Welcome to the International Reporting
International Essentials
Access the International Essentials
How to navigate in the International Essentials?
International Insights Cloud
Power BI Desktop installation
Snowflake driver installation
Connecting to Snowflake Database
Data Transformation
Calculation
Data Model
Data model Diagram and Dictionary
How to do a visual
HR Benchmarks
Examples HR benchmarks
HR domains
Populations: market, market selection, organisation
Get benchmark insights (recordings)
Video tutorial
Metrics Def. & Calculations
New Features in HR Benchmarks
Our datasets
General
Column Name Suffixes
BE_PAYROLL
Release notes
2025 | March 5
2025 | Feb 17
2024 | Nov 11
2024 | Oct 24
2024 | Jul 8
2024 | May 27
2024 | May 8
2023 | May 25
2023 | Apr 27
2022 | Nov 3
2022 | Oct 10
Data Catalog
Free Fields
FACT_PAYROLL_METRICS
COBRA
FACT_EMPLOYEE_COUNT
Links & Info
Press releases
Short Illness | Apr 6, 2023
Sick leave report 2022
E-book
Hr analytics | Oct 20, 2022
Useful links
Categories > Our datasets > BE_PAYROLL > Release notes
11 articles
DIM_EMPLOYEE_SAFE Removed contract free fields column (CONTRACT_FREE_FIELDS_KV).. Added data masking capability for users belonging to a restricted security group.
Updated 2 months ago by daniel.mahoney@sdworx.com
Took contract duration for SME's directly from LOS21 (bypassing Nilos/Artemis for which a default value had been used). Excluded sickness days and periods caused 100% by partial resumption impacts on…
FACT_WAGE_DETAIL and DIM_PAYSLIP_CALCULATION Added datamarts view and demo data. Added possibility to use vrrub122 instead of the regular department Configuration was done on the concern level.. Adde…
Added indicative columns for Bradford, 12MM sickness days and 12MM periods Displayed even when the regular ones are hidden - non-standard conditions..
DIM_EMPLOYEE Added versioning for the function description and function scale. Recoded EMPLOYEE_PK and updated the fact and rep tables. Reworked DEPARTMENT_NAME_FULL_TX to used the label in the langu…
DIM_EMPLOYER Added new column: COMPANY_TRADE_NAME.
FACT_EMPLOYEE_COUNT Changed when headcount = 0, then FTE_CNT_NB = null (instead of 0)\.. DIM_EMPLOYEE (and REP tables) Added new column for the weekend worker flag: WEEKENDWORK_FL 1 if CLA42 applies…
REP_EMPLOYEE_CURR and REP_EMPLOYEE_COUNT Added new columns. CLIENT_FILE_NAME_TX Employer name EMPLOYEE_AGE_NB Employee age EMPLOYEE_AGE_CLASS_EN_TX Employee age class YEARS_OF_SENIORITY_NB Years of s…
Updated 2 months ago by Nick de Bie
DIM_EMPLOYEE Standardized values in column PART_TIME_EN_TX: “fulltime” -> "full-time".. FACT_PAYROLL_METRICS Added new KPI column: KPI$H_ABST___ABSENCEHOURSTOT Filtered on cluster id (sub level 1) H0…
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 wag…
Updated 2 months ago by kevin cardoen
DIM_EMPLOYEE Added new columns identity_card_nb_id. private_phone_nb_id. resign_notice_start_dt. resign_notice_theoret_end_dt. partner_last_name_tx. partner_first_name_tx. partner_full_name_tx. partn…
