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

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