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.