Holds Succession Plan details
Module: Succession Management
PLAN_ID, ENTERPRISE_ID
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 | 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 |
Copyright © 2019, 2022, Oracle and/or its affiliates.