DW_GOAL_PLAN_D

Goal Plan Dimension

Details

Module: Goal Management

Key Columns

GOAL_PLAN_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
GOAL_PLAN_ID NUMBER 38 0 True Goal Plan Identifier DW_GOAL_PLAN_D_TL GOAL_PLAN_ID
SOURCE_RECORD_ID VARCHAR2 512 This column is for Oracle Internal use only. unique key
BUSINESS_GROUP_ID NUMBER 38 0 Business Group Identifier
GOAL_PLAN_TYPE_CODE VARCHAR2 32 Goal Plan Type Code DW_GOAL_PLAN_TYPE_D_TL GOAL_PLAN_TYPE
GOAL_PLAN_START_DATE DATE Goal Plan Start Date
GOAL_PLAN_END_DATE DATE Goal Plan End Date
PREV_GOAL_PLAN_ID NUMBER 38 0 Previous Goal Plan Identifier
ENFORCE_GOAL_WEIGHT_FLAG VARCHAR2 32 This is to enforce thesummation of goal weight to 100 at goal plan level if set to yes
GOAL_ACCESS_LEVEL_CODE VARCHAR2 32 Goal Access Level DW_GOAL_ACCESS_LEVEL_D_TL GOAL_ACCESS_LEVEL_CODE
GOAL_PLAN_ACTIVE_FLAG VARCHAR2 32 to decide whether plan is active or not
GOAL_SUBTYPE_CODE VARCHAR2 32 Goal Sub type to support customer specific requirements DW_GOAL_SUB_TYPE_D_TL GOAL_SUB_TYPE
INCLUDE_IN_PERFDOC_FLAG VARCHAR2 32 If this flag is set, the goals in the goal plan would be added to Performance Document
ENABLE_WEIGHTING_FLAG VARCHAR2 32 Flag to indicate whether weighting can be specified with goal.
REVIEW_PERIOD_ID NUMBER 38 0 Review Period Identifier of the goal plan DW_REVIEW_PERIOD_D_TL REVIEW_PERIOD_ID
PRIMARY_GOAL_PLAN_FLAG VARCHAR2 32 Identifies if the goal plan is primary or not