2023 | Apr 27

Updated by Nick de Bie


BE_PAYROLL

  • DIM_EMPLOYEE
    • Changed standardized value 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
    • DISTINCT_ILLNESS_PERIODS_12MM and BRADFORD_FACTOR_12MM_NB
      • If an employee is absence more than 1 year during the last 12 months (KPI$D_12MM_ABS_ILL_1Y__ILLNESS1YEAR > 0), null is returned.


  • FACT_EMPLOYEE_COUNT
    • Added 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 next 5 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?