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 | 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 |
Copyright © 2019, 2024, Oracle and/or its affiliates.