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

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