HCM - Succession Management
This tables describes Succession Management metrics.
| Metric | Metric Definition |
|---|---|
| Number of Succession Plans | Count (distinct succession plan). |
| Active Plan Count | Count (distinct succession plan) where status = active. |
| Inactive Plan Count | Count (distinct succession plan) = inactive. |
| Incumbent Plan Count | Count (distinct succession plan) where plan type = incumbent. |
| Job Plan Count | Count (distinct succession plan) where plan type = job. |
| Position Plan Count | Count (distinct succession plan) where plan type = position. |
| Number of Private Plans | Count (distinct succession plan) where plan privacy = private. |
| Succession Plans with Candidates | Count (distinct succession plan) where candidate count > zero. |
| Succession Plans without Candidates | Count (distinct succession plan) where candidate count = zero. |
| Active Plans without Candidate | Count (distinct succession plan) where status = active and candidate count = zero. |
| Jobs with Plan without Incumbents | Count (distinct succession plan) where plan type = job and inferred incumbent count = zero. |
| Position with Plan without Incumbents | Count (distinct succession plan) where plan type = position and inferred incumbent count = zero. |
| Plans with Single Owner | Count (distinct succession plan) where count (distinct owner id) = one. |
| Plans with Inactive Owner | Count (distinct succession plan) where owners assignment status = inactive. |
| Successful Plans with High Risk Candidate | Count (distinct succession plan) where candidate succession status = ORA_HRM_SUCCESSOR and candidate risk of loss = high. |
| Incumbent Count - Incumbent Plan | Count (distinct incumbent) from all active incumbent plans. |
| InferRed Incumbent Count | Count (distinct incumbent) from all active succession plans where plan type in (job, position). |
| Total Incumbents | (incumbent count - incumbent plan + inferred incumbent count). |
| Incumbent Departed Count | Count (distinct incumbent) who are terminated. |
| Incumbent with High Risk of Loss | Count (distinct incumbent) where risk of loss category = high. |
| Percentage of Incumbents with High Risk of Loss | (Count (distinct incumbent) where risk of loss category = high * one00) /incumbent count - incumbent plan. |
| Incumbent with High Impact of Loss | Count (distinct incumbent) where impact of loss category = high. |
| Percentage of Incumbents with High Impact of Loss | (Count (distinct incumbent) where impact of loss category = high * one00) /incumbent count - incumbent plan. |
| High Risk of Loss Incumbents without Candidates | Count (distinct incumbent) where risk of loss category = high and candidate count is zero. |
| High Impact of Loss Incumbents without Candidates | Count (distinct incumbent) where impact of loss category = high and candidate count is zero. |
| Plans with High Risk Incumbents and No Candidates | Count (distinct succession plan) where candidate count = zero and incumbent risk of loss = high. |
| Plans with High Risk Incumbents and No Ready Now Candidates | Count (distinct succession plan) where ready now candidate count = zero and incumbent risk of loss = high. |
| Successful Plans with High Risk Incumbents | Count (distinct succession plan) where candidate succession status = ORA_HRM_SUCCESSOR and incumbent risk of loss = high. |
| Number of Candidates | Count (distinct internal candidates + external candidate). |
| Active Candidate Count | Count (distinct candidates) where candidates current status on the succession plan = active. |
| Inactive Candidate Count | Count (distinct candidates) where candidates current status on the succession plan= inactive. |
| Interim Candidates | Count (distinct candidates) where interim flag = Y. |
| Candidates with Succession Plans | Count (distinct candidates) where candidate IN (Select incumbent from active succession plans). Note: The candidate could be a direct incumbent or an inferred incumbent in any other plan. |
| Candidates without Succession Plans | Count (distinct candidates) where candidate NOT IN (select incumbent from active succession plans). |
| Candidate Active Plan Count | Count (distinct plan) where plan status = active . |
| Ready Now Count | Count (distinct candidates) where readiness band = ready now. |
| Ready in 1 Year Count | Count (distinct candidates) where readiness band = ready in < one year. |
| Ready in 2 Years Count | Count (distinct candidates) where readiness band = ready in one - 2 years. |
| Ready in 3 Years Count | Count (distinct candidates) where readiness band = ready in 3 - 4 years. |
| High Risk of Loss Candidates | Count (distinct candidates) where risk of loss band = high. |
| High Impact of Loss Candidates | Count (distinct candidates) where impact of loss band = high. |
| Willing to Relocate Candidates | Count (distinct candidates) where willing to relocate flag = Y. |
| Candidates Success Count - Incumbent Plan | Count (distinct candidates) where candidate succession status = ORA_HRM_SUCCESSOR for the plan. |
| Candidates Success Count - Job Plan | Count (distinct candidates) where candidate succession status = ORA_HRM_SUCCESSOR for the plan. |
| Candidates Success Count - Position Plan | Count (distinct candidates) where candidate succession status = ORA_HRM_SUCCESSOR for the plan. |
| Internal Candidate Count | Count (distinct candidates) where candidate <> external candidate. |
| External Candidate Count | Count (distinct external candidate ID) where candidate = external candidate. |
| Candidate Since (Days) | Time (in days) between the date candidate added to a plan till current date . |
| New Role Candidates - Incumbent Plan | Count (distinct candidates) where candidate succession status = ORA_HRM_MOVED_TO_DIFF_ROLE . |
| New Role Candidates - Job Plan | Count (distinct candidates) where candidate succession status = ORA_HRM_MOVED_TO_DIFF_ROLE . |
| New Role Candidates - Position Plan | Count (distinct candidates) where candidate succession status = ORA_HRM_MOVED_TO_DIFF_ROLE . |
| High Performance Candidates | Count (distinct candidates) where performance category band = high. |
| Medium Performance Candidates | Count (distinct candidates) where performance category band = medium. |
| Low Performance Candidates | Count (distinct candidates) where performance category band = low. |
| High Potential Candidates | Count (distinct candidates) where potential category band = high. |
| Medium Potential Candidates | Count (distinct candidates) where potential category band = medium. |
| Low Potential Candidates | Count (distinct candidates) where potential category band= low. |
| High Performance High Risk of Loss Candidates | Count (distinct candidates) where performance category band= high and risk of loss band= high. |
| High Potential High Risk of Loss Candidates | Count (distinct candidates) where potential category band = high and risk of loss band = high. |
| Percentage of External Candidates | (Number of external candidates/Total candidates) * one00. |
| Percentage of Internal Candidates | (Number of internal candidates/Total candidates) * one00. |
| Candidate Matching - Succession Plan Job | Count (distinct candidates) where candidate job ID = plan job id. |
| Candidate Matching - Succession Plan Position | Count (distinct candidates) where candidate position ID = plan position ID AND business unit ID = plan business unit ID. |
| Succession Plan - Matching Candidate Job | Count (distinct plan_ID) where candidate job ID = plan job id. |
| Succession Plan - Matching Candidate Position | Count (distinct plan_ID) where candidate position ID = plan position ID AND business unit ID = plan business unit ID. |
| Successful Plans | Count (distinct succession plans) where candidate succession status = ORA_HRM_SUCCESSOR for the plan. |
| Candidate Matching - Incumbent Job | Count (distinct candidates) where candidate job ID = incumbent job id. |
| Succession Plan - Candidate Matching Incumbent Job | Count (distinct plan_ID) where candidate job ID = incumbent job id. |