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

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