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