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