Bridge Dimension which is for Goal ID and Goal Plan ID mapping
Module: Goal Management
GOAL_PLAN_GOAL_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| GOAL_PLAN_GOAL_ID | NUMBER | 38 | 0 | True | Goal Plan Goal Identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 512 | This column is for Oracle Internal use only. unique key | ||||
| GOAL_PLAN_ID | NUMBER | 38 | 0 | Goal Plan Identifier | DW_GOAL_PLAN_D_TL | GOAL_PLAN_ID | |
| GOAL_ID | NUMBER | 38 | 0 | Goal Identifier | |||
| GOAL_WEIGHT | NUMBER | Weight or importance of a goal relative to other goals expressed in percentage | |||||
| PRIORITY_CODE | VARCHAR2 | 64 | Priority of the goal | DW_GOAL_PRIORITY_D_TL | PRIORITY_CODE | ||
| GOAL_PLAN_SET_ID | NUMBER | 38 | 0 | Goal Plan Set Identifier | DW_GOAL_PLAN_SET_D_TL | GOAL_PLAN_SET_ID | |
| EFFECTIVE_START_DATE | DATE | Effective Start Date | |||||
| EFFECTIVE_END_DATE | DATE | Effective End Date | |||||
| REVIEW_PERIOD_ID | NUMBER | 38 | 0 | Review Period Identifier | DW_REVIEW_PERIOD_D_TL | REVIEW_PERIOD_ID | |
| ASSIGNMENT_ID | NUMBER | 38 | 0 | Assignment Identifier |
Copyright © 2019, 2025, Oracle and/or its affiliates.