2024 | May 8

Updated by daniel.mahoney@sdworx.com


BE_PAYROLL

  • FACT_EMPLOYEE_COUNT
    • Changed: if 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
    • new tables for calendar periods

Any feedback?