DW_SUSTAINABILITY_MEASURES_CF (Preview)
This table requires activation of Sustainability functional area. Sustainability Measures Fact
Details
Module:
Key Columns
ACTIVITY_ID, ACTIVITY_MEASURE_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ACTIVITY_ID | NUMBER | 38 | 0 | True | Activity Identifier | ||
| ACTIVITY_MEASURE_ID | NUMBER | 38 | 0 | True | Activity Measure Identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. System Identifier | ||||
| CREATION_TIMESTAMP | TIMESTAMP | Creation Timestamp | |||||
| LAST_UPDATE_TIMESTAMP | TIMESTAMP | Last Update Timestamp | |||||
| UOM_CODE | VARCHAR2 | 16 | UOM Code | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
| CURRENCY_CODE | VARCHAR2 | 16 | Currency Code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| MEASURE_TYPE_CODE | VARCHAR2 | 32 | Measure Type Code | DW_ORA_SUS_MEASURE_TYPES_LKP_TL | ORA_SUS_MEASURE_TYPES_CODE | ||
| MEASURE | NUMBER | Measure |