# 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 |  |

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