DW_SUSTAINABILITY_EMISSIONS_CF (Preview)

This table requires activation of Sustainability functional area. Sustainability Emissions Fact

Details

Module:

Key Columns

ACTIVITY_EMISSION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ACTIVITY_EMISSION_ID NUMBER 38 0 True Activity Emission Identifier
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. System Identifier
ACTIVITY_ID NUMBER 38 0 Activity Identifier
MEASURE_TYPE_CODE VARCHAR2 32 Measure Type Code DW_ORA_SUS_MEASURE_TYPES_LKP_TL ORA_SUS_MEASURE_TYPES_CODE
EMISSION_TYPE_CODE VARCHAR2 32 Emission Type Code DW_ORA_SUS_EMISSION_TYPES_LKP_TL ORA_SUS_EMISSION_TYPES_CODE
DESCRIPTION VARCHAR2 999 Description
CREATION_TIMESTAMP TIMESTAMP Creation Timestamp
LAST_UPDATE_TIMESTAMP TIMESTAMP Last Update Timestamp
EMISSION_FACTOR_SOURCE VARCHAR2 999 Emission Factor Source
NUMERATOR_UOM_CODE VARCHAR2 16 Numerator UOM Code DW_UNIT_OF_MEASURE_D_TL UOM_CODE
DENOMINATOR_UOM_CODE VARCHAR2 16 Denominator UOM Code DW_UNIT_OF_MEASURE_D_TL UOM_CODE
DENOMINATOR_CURRENCY_CODE VARCHAR2 16 Denominator Currency Code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
EMISSION_FACTOR NUMBER Emission Factor
EMISSION_UOM_CODE VARCHAR2 16 Emission UOM Code DW_UNIT_OF_MEASURE_D_TL UOM_CODE
EMISSION_QTY NUMBER Emission Quantity
GWP_FACTOR NUMBER Gwp Factor
CO2E_UOM_CODE VARCHAR2 16 CO2e UOM Code DW_UNIT_OF_MEASURE_D_TL UOM_CODE
CO2E_EMISSION_QTY NUMBER CO2e Emission Qty