2026 | June
RELEASE NOTE, published on 2026, June 23
Headcount 'any day' in production as of June 24
Headcount (any day) on person level
Columns in following tables are added in the data mart BE Payroll:
- DIM_EMPLOYEE
- DIM_EMPLOYEE_SAFE
- FACT_EMPLOYEE_COUNT
What's new?
This release introduces two new features:
- Person-level identifiers — a stable way to identify the same person across multiple contracts
- Any-day headcount metrics — headcount that counts employees active at any point during a month, not only at end-of-month
New columns in DIM_EMPLOYEE and DIM_EMPLOYEE_SAFE
Column | Description |
concern_person_id | A stable, anonymised identifier that links the same person across multiple contracts within the entire concern. Format: CNC_NR-[hash]. NULL for employees excluded from anonymisation. |
company_person_id | A stable identifier that links the same person across multiple contracts within a single company (client file). Equals employee_system_id. |
New columns in FACT_EMPLOYEE_COUNT
Contract-level any-day headcount
Column | Description |
headcount_anyday_nb | = 1 if the employee had an active contract at any point during the month (including suspended contracts). Complements the existing headcount_nb (end-of-month only). |
headcount_active_anyday_nb | Same as above, but excluding suspended contracts. |
New columns in FACT_EMPLOYEE_COUNT
Contract-level any-day headcount
Column | Description |
headcount_anyday_nb | = 1 if the employee had an active contract at any point during the month (including suspended contracts). Complements the existing headcount_nb (end-of-month only). |
headcount_active_anyday_nb | Same as above, but excluding suspended contracts. |
Career-level any-day headcount (deduplication across contracts)
Column | Description |
company_headcount_anyday_nb | Any-day headcount deduplicated per company career — counts each company career once even if the person held multiple contracts at the same time. |
concern_headcount_anyday_nb | Any-day headcount deduplicated per concern career. |
Person-level headcount (deduplication across careers)
Column | Description |
concern_person_headcount_nb | End-of-month headcount deduplicated per person within the concern — counts each unique person once across all companies. |
concern_person_headcount_anyday_nb | Any-day version of the above. |
company_person_headcount_nb | End-of-month headcount deduplicated per person within a single company. |
company_person_headcount_anyday_nb | Any-day version of the above. |
