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