# 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 |  |
ACTIVITY_STATUS_CODE | VARCHAR2 | 32 |  |  | Activity Status Code | DW_ORA_SUS_ACT_STATUS_LKP_TL | ORA_SUS_ACT_STATUS_CODE
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 |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.