DW_SUCCSSN_PLAN_D

Holds Succession Plan details

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 Primary Key for Succession Plan in Fusion Source.    
ENTERPRISE_ID NUMBER 38 0 True Primary Key for Succession Plan in Fusion Source.    
SOURCE_RECORD_ID VARCHAR2 128     Unique Source Record Identifier    
PLAN_NAME VARCHAR2 512     Succession Plan Name    
DESCRIPTION VARCHAR2 4000     Succession Plan Description    
PLAN_TYPE VARCHAR2 32     Plan Type (Incumbent/Job/Position)    
STATUS VARCHAR2 32     Status of sucession plan    
ACCESS_TYPE_CODE VARCHAR2 32     Access type (Public / Private)    
BUSINESS_UNIT_ID NUMBER 38 0   Business Unit identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
POSITION_ID NUMBER 38 0   Position Identifier DW_POSITION_D POSITION_ID
JOB_ID NUMBER 38 0   Job Identifier DW_JOB_D JOB_ID
DEPARTMENT_ID NUMBER 38 0   Department Identifier DW_DEPARTMENT_D DEPARTMENT_ID
GRADE_ID NUMBER 38 0   Grade Identifier DW_PAY_GRADE_D GRADE_ID
INCUMBENT_PERSON_ID NUMBER 38 0   Incumbent person Identifier DW_PERSON_D PERSON_ID
ENABLE_ALERTS VARCHAR2 32     Alerts Enabled    
INCUMBENT_ROLE_CHANGE_FLAG VARCHAR2 16     Incum Role change flag    
CANDIDATE_SAME_ROLE_CHANGE_ALERT VARCHAR2 256     Candidate move to incum role alert    
CANDIDATE_DIFF_ROLE_CHANGE_ALERT VARCHAR2 256     Candidate move into different role than incum role alert    
INCUMBENT_JOB_CHANGE_ALERT VARCHAR2 256     Incum job change alert    
CREATION_DATE DATE       Creation date of plan    
LAST_UPDATE_DATE TIMESTAMP       Last updated date of plan