This table stores Succession plan summary information
Module: Succession Management
PLAN_ID, ENTERPRISE_ID
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.