DW_SUCCSSN_PLAN_SUMMARY_D

This table stores Succession plan summary information

Details

Module: Succession Management

Key Columns

ENTERPRISE_ID, PLAN_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PLAN_ID NUMBER 38 0 True Succession Plan Identifier
ENTERPRISE_ID NUMBER 38 0 True Enterprise Identifier
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
INCUMBENT_COUNT NUMBER 38 0 Incumbent Count
CANDIDATE_COUNT NUMBER 38 0 Candidate Count
SUCCESSOR_STATUS_CANDIDATE_COUNT NUMBER 38 0 Successor Status Candidate Count
DIFF_ROLE_STATUS_CANDIDATE_COUNT NUMBER 38 0 Diff Role Status Candidate Count
OWNER_COUNT NUMBER 38 0 Owner Count
PLAN_COUNT NUMBER 38 0 Plan Count
INCUMBENT_PLAN_TYPE_FLAG VARCHAR2 16 Incumbent Plan Type Flag
JOB_PLAN_TYPE_FLAG VARCHAR2 16 Job Plan Type Flag
POSITION_PLAN_TYPE_FLAG VARCHAR2 16 Position Plan Type Flag
ACTIVE_FLAG VARCHAR2 16 Plan Active Flag
PLAN_CREATION_DATE DATE Succession Plan Creation Date