2025 | Feb 17
- 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
- PR_DAYS_CNT_NB