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     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, 2023, Oracle and/or its affiliates.