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
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.