DW_GOAL_PLAN_GOAL_D

Bridge Dimension which is for Goal ID and Goal Plan ID mapping

Details

Module: Goal Management

Key Columns

GOAL_PLAN_GOAL_ID

Columns

Columns
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