Versions Compared

Old Version 3

changes.mady.by.user Li Lian Cheong

Saved on

compared with

New Version Current

changes.mady.by.user Marie-Line Ardito

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


 

Image Added


Info
iconfalse
titleProcess Owner
Paola Chauby
WW Delivery, Process&Support Controller
SBS Decision & Piloting Solutions Team
WW Solutions:
  • Marie-Line Ardito
Regional Animator:
  • Emma Glasson (EMEA)
  • Karina Tsuji (LATAM & NAM)
  • Lilian Cheong (APAC)
Info
iconfalse
titleD&PS Expert
Marie-Line Ardito



General Description

YOU Profile - measure the percentage of employees' Profiles completed.
YOU Feedback - measure the total number of feedback and the number of feedback given and received
The employee turnover is the measurement on number of employee (
headcount
Internal Workforce) leaving the organisation.
It is split by Voluntary and Involuntary.
 

Voluntary: Refers to termination of employment initiated by the employee (employee-driven); Resignation, End of Probation period initiated by the employee, etc. It is considered Voluntary only if it is initiated by the employee.
Involuntary: Refers to termination of employment initiated by the organisation (company-driven); Redundancy and retrenchment; Employees taking opportunities for voluntary redundancy; Normal/statutory retirement; Early retirement; Dismissals and "compromise" (mutual agreements).
Calculation: Number of leaving (by Total, Voluntary and Involuntary)
                        ------------------------------------------------------------------
                                      Average number of active employees*
12 Month rolling Turnover :
12 Month rolling turnover rate is calculated by dividing the total number of employees leaving in the last 12 months by the AVERAGE of the number of employees in the same 12 months period.
12 month rolling Turnover % = (sum of Terminations in last 12 months / Average Internal Workforce in last 12 months)

*Within the reference period
and following the Headcount definition



Info
iconfalse
titleTarget Users
  • SBS Management Comitee
  • CRM / BRM
  • GBUs Directors


Info
iconfalse
titleAuthorization & Rights
All the accesses must be validated by the
SBS General Manager
Request for accesses
Access form



Sources

YOU Profile/Feedback

Refresh frequency
Monthly

% YOU Profile

YOU - Big Query Table
# User Id with profile published vs Total of User Id
Filter
Entity = SBS
Refresh frequency
Monthly


Sources

You Feedback

YOU - Big Query Table
# User Id with "feedback given"
# User Id with "feedback received"
Refresh frequency
Monthly


Sources

Employee Turnover - Month

BW
- QV_BW_QRY_CPHRPANHR_0001 (hirings and terminations)
Business Unit (Ent. Grp) = SBS
Employee class <> Apprentice, Student, trainee (CBRA, CFRA, BFRA, BSGP, BUSA, 5BRA, 5BRT)
- QV_BW_QRY_CPHRPANHR_0001 (Internal Workforce FTE)
Business Unit (Ent. Grp) = SBS
Refresh frequency
Monthly


Sources

Employee Turnover - Rolling Month

BW
- QV_BW_QRY_CPHRPANHR_0001 (hirings and terminations)
Business Unit (Ent. Grp) = SBS
Employee class <> Apprentice, Student, trainee (CBRA, CFRA, BFRA, BSGP, BUSA, 5BRA, 5BRT)
- QV_BW_QRY_CPHRPANHR_0001 (Internal Workforce FTE)
Business Unit (Ent. Grp) = SBS
Employee class <> Apprentice, Student, trainee (CBRA, CFRA, BFRA, BSGP, BUSA, 5BRA, 5BRT)
Refresh frequency
Monthly


Scope

  • Current year
  • Y-1
  • Dimension Service Center based on Business Unit (Ent. Grp), Entity Type SBS Operation and the site (Curitiba, Carnaxide, Bangkok, Riga, Devnya, Shanghai)