Data Catalog
Updated
by
Nick de Bie
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 the week, workdays |
DIM_COST_ALLOCATION | Cost allocation | Costcenter ID, Costcenter Tx |
DIM_EMPLOYEE | Employee data | Start data, Hire date, Statute |
DIM_EMPLOYEE_SAFE | Employee data (without sensitive data) | Hire date, gross salary |
DIM_EMPLOYER | Employer data | Name, region |
DIM_PERIOD | Periods | Period_ID as reference |
DIM_SUSPENSION | Suspensions | Parental leave, time credit |
DIM_WAGECODE_CLUSTER | Wage codes clustered | Fixed wage, variable wage |
Facts | Description | Examples |
FACT_DAY_DETAIL | Details day by day | Performed hours, cost allocation, ... |
FACT_EMPLOYEE_COUNT | Counters | Headcount, FTE, In's, Out's, Out first month, Out first year, ... |
FACT_EMPLOYER_METRICS | Employer metrics | Affiliation size, Blue/White-Collars, ... |
FACT_PAYROLL_METRICS | Metrics | Days of absence, Frequency, illness started on, wages, ... |
FACT_PAYROLL_METRICS_SAFE | Metrics (without sensitive data) |
|
FACT_WAGE | Wages | Gross wage, variable wage |
Reference | Description | Examples |
REF_AGE_SENIORITY | SD Worx reference table for Age and Seniority | Age and Seniority scales |
Reports | Description | |
REP_EMPLOYEE_COUNT | DIM_EMPLOYEE & FACT_EMPLOYEE_COUNT | |
REP_EMPLOYEE_CURR | DIM_EMPLOYEE only current employees, takes all employees with CURRENT_FL on 1 | |
REP_PAYROLL_OVERVIEW | DIM_EMPLOYEE & FACT_PAYROLL_METRICS, overview of the last 10 years |
|
REP_PAYROLL_OVERVIEW_xxM | DIM_EMPLOYEE & FACT_PAYROLL_METRICS, overview of the last 12, 18, 24 or 36 months |
|
REP_PAYROLL_OVERVIEW_FISCAL_YEAR | DIM_EMPLOYEE & FACT_PAYROLL_METRICS, overview of the fiscal year |
|
REP_SUSPENSION_DAILY_OVERVIEW | DIM_EMPLOYEE & Suspensions in detail |
|
REP_WAGECODE_OVERVIEW | Overview of the wage codes |
|
