Goal Measurement Dimension
Module: Goal Management
MEASUREMENT_ID
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, 2024, Oracle and/or its affiliates.