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 | 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 |