2024 | May 8

Updated by daniel.mahoney@sdworx.com


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 and the real average days per week is 2


FACT_CALENDAR_PERIODS and REP_CALENDAR_PERIODS_12MM

  • published new tables on calendar periods

Any feedback?