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 This column is for Oracle Internal use only. Unique Source Record Identifier
PLAN_NAME VARCHAR2 512 Succession Plan Name
DESCRIPTION VARCHAR2 999 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