# DW_GOAL_MEASUREMENT_D

Goal Measurement Dimension

## Details

Module: Goal Management

## Key Columns

MEASUREMENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
MEASUREMENT_ID | NUMBER | 38 | 0 | True | Measurement Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. Unique Key |  |
GOAL_ID | NUMBER | 38 | 0 |  | Goal Identifier |  |
BUSINESS_GROUP_ID | NUMBER | 38 | 0 |  | Business Group Identifier |  |
MEASUREMENT_NAME | VARCHAR2 | 512 |  |  | Measurement Name |  |
ACHIEVED_WEIGHT | NUMBER |  |  |  | Achieved Weight |  |
START_DATE | DATE |  |  |  | Start Date |  |
END_DATE | DATE |  |  |  | End Date |  |
MEASUREMENT_TYPE_CODE | VARCHAR2 | 32 |  |  | Measurement Type | DW_GOAL_MEASUREMENT_TYPE_D_TL | MEASUREMENT_TYPE_CODE
TARGET_TYPE | VARCHAR2 | 32 |  |  | Target Type | DW_GOAL_TARGET_TYPE_D_TL | TARGET_TYPE
TARGET_PERCENTAGE | NUMBER |  |  |  | Target Percentage |  |
TARGET_VALUE | NUMBER |  |  |  | Target Value |  |
ACTUAL_VALUE | NUMBER |  |  |  | Actual Value |  |
MAX_TARGET | NUMBER |  |  |  | Max Target |  |
MIN_TARGET | NUMBER |  |  |  | Min Target |  |
UOM_CODE | VARCHAR2 | 32 |  |  | Uom Code | DW_GOAL_UOM_CODE_D_TL | UOM_CODE
DISPLAY_SEQUENCE | NUMBER | 38 | 0 |  | Display Sequence |  |

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