2025 | Feb 17

Updated by daniel.mahoney@sdworx.com


  • Took contract duration for SME's directly from LOS21 (bypassing Nilos/Artemis for which a default value had been used)
  • Excluded sickness days and periods caused 100% by partial resumption
    • impacts only "indicative" columns -- the other columns remain hidden


FACT_CALENDAR_PERIODS and (REP_CALENDAR_PERIODS_12MM)

  • Added new columns related to partial resumption
    • PR_DAYS_CNT_NB
      • a metric that counts the number of days of partial resumption within sickness periods
    • HAS_ONLY_PR_DAYS_FL
      • a flag that indicates a period only has partial resumption days so that it can be easily excluded


Any feedback?