2023 | Apr 27

Updated by Nick de Bie


DIM_EMPLOYEE

  • Standardized values in column PART_TIME_EN_TX: “fulltime” -> "full-time"


FACT_PAYROLL_METRICS

  • Added new KPI column: KPI$H_ABST___ABSENCEHOURSTOT
    • Filtered on cluster id (sub level 1) H01CL0102 - Absence Hours
    • Excludes cluster id (sub level 2) H01CL010209 - Training Hours


  • For DISTINCT_ILLNESS_PERIODS_12MM and BRADFORD_FACTOR_12MM_NB:  
    • If an employee has days of absence more than 1 year during the last 12 months (KPI$D_12MM_ABS_ILL_1Y__ILLNESS1YEAR > 0), null is returned.


FACT_EMPLOYEE_COUNT

  • Joiner and leaver flags
    • COMPANY_JOINER_FL :
      • 1 = employee joined the company less than 6 months before the observed period
        • includes the month of hire and the 5 next months
    • COMPANY_LEAVER_FL :
      • 1 = employee leaves the company less than 6 months after the observed period
        • includes the month of exit and the 5 months before

Any feedback?