# DW_SUSTAINABILITY_ACTIVITIES_CF (Preview)

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

## Details

Module:

## Key Columns

ACTIVITY_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ACTIVITY_ID | NUMBER | 38 | 0 | True | Activity Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. System Identifier |  |
ACTIVITY_NUMBER | VARCHAR2 | 128 |  |  | Activity Number |  |
EXTERNAL_REF_NUM | VARCHAR2 | 128 |  |  | External Reference Number |  |
ORIGINAL_ACTIVITY_ID | NUMBER | 38 | 0 |  | Original Activity Identifier |  |
ACTIVITY_TYPE_CODE | VARCHAR2 | 256 |  |  | Activity Type Code |  |
SUSTAINABILITY_LEDGER_ID | NUMBER | 38 | 0 |  | Sustainability Ledger Identifier | DW_SUSTAINABILITY_LEDGERS_D | LEDGER_ID
SUSTAINABILITY_LEDGER_CALENDAR_ID | NUMBER | 38 | 0 |  | Identifier for the calendar associated to sustainability Ledger |  |
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Fiscal period set name #2 | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Fiscal period type #2 | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal Entity Identifier | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
PERIOD_ID | NUMBER | 38 | 0 |  | Period Identifier | DW_SUSTAINABILITY_PERIODS_D | PERIOD_ID
PERIOD_START_DATE | DATE |  |  |  | Period Start Date #2 | DW_DAY_D | CALENDAR_DATE
PERIOD_END_DATE | DATE |  |  |  | Period End Date | DW_DAY_D | CALENDAR_DATE
INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | Inventory Item Identifier #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
ITEM_VALIDATION_ORGANISATION_ID | NUMBER | 38 | 0 |  | Item Validation Organisation Identifier #1 | DW_INTERNAL_ORG_D | ORGANIZATION_ID
SUPPLIER_ID | NUMBER | 38 | 0 |  | Supplier Identifier | DW_PARTY_D | SUPPLIER_ID
ACTIVITY_DATE | DATE |  |  |  | Activity Date | DW_DAY_D | CALENDAR_DATE
STATUS_CODE | VARCHAR2 | 32 |  |  | Activity Status | DW_ORA_SUS_ACT_STATUS_LKP_TL | ORA_SUS_ACT_STATUS_CODE
CONSUMPTION_START_DATE | DATE |  |  |  | Consumption Start Date | DW_DAY_D | CALENDAR_DATE
CONSUMPTION_END_DATE | DATE |  |  |  | Consumption End Date | DW_DAY_D | CALENDAR_DATE
POSTING_DATE | DATE |  |  |  | Posting Date | DW_DAY_D | CALENDAR_DATE
POSTING_TIMESTAMP | TIMESTAMP |  |  |  | Posting Date with Timestamp |  |
SCOPE_CODE | VARCHAR2 | 32 |  |  | Scope Code | DW_ORA_SUS_SCOPES_LKP_TL | ORA_SUS_SCOPES_CODE
SCOPE_CATEGORY_CODE | VARCHAR2 | 32 |  |  | Scope Category Code | DW_ORA_SUS_SCOPE_CATEGORIES_LKP_TL | ORA_SUS_SCOPE_CATEGORIES_CODE
DATA_QUALITY_CODE | VARCHAR2 | 32 |  |  | Data Quality Code | DW_ORA_SUS_DATA_QUALITY_LKP_TL | ORA_SUS_DATA_QUALITY_CODE
COUNTRY_CODE | VARCHAR2 | 16 |  |  | Country Code | DW_COUNTRY_D_TL | COUNTRY
ENTRY_TYPE_CODE | VARCHAR2 | 32 |  |  | Entry Type Code | DW_ORA_SUS_ENTRY_TYPE_LKP_TL | ORA_SUS_ENTRY_TYPE_CODE
SOURCE_TYPE_CODE | VARCHAR2 | 128 |  |  | Source Type Code | DW_ORA_SUS_SOURCE_TYPE_LKP_TL | ORA_SUS_SOURCE_TYPE_CODE
CALCULATION_OVERRIDE_CODE | VARCHAR2 | 128 |  |  | Calculation Override Code | DW_ORA_SUS_CAL_MODE_LKP_TL | ORA_SUS_CAL_MODE_CODE
COMMENTS | VARCHAR2 | 999 |  |  | Comments |  |
DESCRIPTION | VARCHAR2 | 999 |  |  | Description |  |
CREATION_DATE | DATE |  |  |  | Creation date without timestamp | DW_DAY_D | CALENDAR_DATE
CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Creation Timestamp |  |
LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Last Update Timestamp |  |
TOTAL_CO2E_UOM | VARCHAR2 | 16 |  |  | Total CO2 Emissions UOM | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
TOTAL_CO2E | NUMBER |  |  |  | Total CO2 Emissions |  |

## Notes

#1 For join with Item Dimension along with INVENTORY_ITEM_ID also join on column ITEM_VALIDATION_ORGANISATION_ID. #2 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on PERIOD_START_DATE column.

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