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 | 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 |
Copyright © 2019, 2025, Oracle and/or its affiliates.