DW_SUSTAINABILITY_EMISSIONS_CF (Preview)
This table requires activation of Sustainability functional area. Sustainability Emissions Fact
Details
Module:
Key Columns
ACTIVITY_EMISSION_ID
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 |