DW_SUCCSSN_PLAN_SUMMARY_D

This table stores Succession plan summary information

Details

Module: Succession Management

Key Columns

PLAN_ID, ENTERPRISE_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     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    

Copyright © 2019, 2022, Oracle and/or its affiliates.