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

Copyright © 2019, 2023, Oracle and/or its affiliates.