SD Worx | Insights

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

Welcome

Data marts and Insights services

Report examples

Getting started

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

Getting started

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

BE_PAYROLL

14 articles

Release notes

11 articles by 3 authors

Data Catalog

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

Updated 2 months 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 2 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 2 months ago by kevin cardoen

Powered by HelpDocs (opens in a new tab)

Contact Us