DW_SUCCSSN_PLAN_CANDIDATE_D

This holds succession plan candidate information

Details

Module: Succession Management

Key Columns

ENTERPRISE_ID, CANDIDATE_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