# DW_SUCCSSN_PLAN_CANDIDATE_D

This holds succession plan candidate information

## Details

Module: Succession Management

## Key Columns

CANDIDATE_ID, ENTERPRISE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ENTERPRISE_ID | NUMBER | 38 | 0 | True | Identifier of Enterprise |  |
CANDIDATE_ID | NUMBER | 38 | 0 | True | Candidate Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Unique Source Record Identifier This column contains ENTERPRISE_ID and CANDIDATE_ID |  |
PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier | DW_PERSON_D | PERSON_ID
PLAN_ID | NUMBER | 38 | 0 |  | Plan Identifier | DW_SUCCSSN_PLAN_D | PLAN_ID
CANDIDATE_STATUS | VARCHAR2 | 32 |  |  | Candidates current status on the succession plan |  |
CANDIDATE_RANKING | NUMBER | 38 | 0 |  | Numeric ranking of a candidate |  |
EMERGENCY_SUCCESSOR | VARCHAR2 | 32 |  |  | Indicates whether a candidate is an emergency successor |  |
CANDIDATE_TYPE | VARCHAR2 | 32 |  |  | Its is used to identify if the candidate is internal or external. |  |
EXTERNAL_CANDIDATE_ID | NUMBER | 38 | 0 |  | External Candidate Identifier | DW_SUCCSSN_PLAN_EXT_CANDIDATE_D | EXTERNAL_CANDIDATE_ID
READINESS_CODE | VARCHAR2 | 32 |  |  | The readiness code that stores the readiness of the person |  |
SUCCESSION_STATUS | VARCHAR2 | 32 |  |  | Succession staus code |  |
SUCCESSION_STATUS_FLAG | VARCHAR2 | 16 |  |  | Succession staus flag |  |
CREATION_DATE | TIMESTAMP |  |  |  | Creation Date |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Last Update Date |  |

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