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