This holds succession plan candidate information
Module: Succession Management
ENTERPRISE_ID, CANDIDATE_ID
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 |