# DW_GOAL_PLAN_ASSIGNMENT_GOAL_A

Goal Plan Assignment level goal aggregate table

## Details

Module: Goal Management

## Key Columns

GOAL_PLAN_ASSIGNMENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
GOAL_PLAN_ASSIGNMENT_ID | NUMBER | 38 | 0 | True | Goal Plan Assignment Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. Source Record Identifier. A unique Identifier for the records |  |
GOAL_PLAN_ID | NUMBER | 38 | 0 |  | Goal Plan Identifier | DW_GOAL_PLAN_D | GOAL_PLAN_ID
ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Assignment Identifier |  |
REVIEW_PERIOD_ID | NUMBER | 38 | 0 |  | Review Period Identifier of the goal plan | DW_REVIEW_PERIOD_D | REVIEW_PERIOD_ID
GOAL_PLAN_SET_ID | NUMBER | 38 | 0 |  | Goal Plan Set Identifier |  |
TOTAL_GOALS | NUMBER | 38 | 0 |  | count of goals |  |

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