Goal Plan Dimension
Module: Goal Management
GOAL_PLAN_ID
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 |