DW_CXM_CAMPAIGN_CF

Marketing Campaign Fact

Details

Module: Marketing Campaigns

Key Columns

CAMPAIGN_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CAMPAIGN_ID NUMBER 38 0 True Primary key.    
SOURCE_RECORD_ID VARCHAR2 256     Unique Identifier    
STRING_CAMPAIGN_ID VARCHAR2 256     Unique Identifier    
CAMPAIGN_ACTUAL_COST NUMBER       Amount of money spent to run the campaign.    
CAMPAIGN_BUDGETED_COST NUMBER       Amount of money budgeted for the campaign.    
CAMPAIGN_CURRENCY_CODE VARCHAR2 16     Currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
CAMPAIGN_OWNER_RESOURCE_PARTY_ID NUMBER 38 0   Owner of the campaign row. DW_CXS_RESOURCE_D RESOURCE_ID
CAMPAIGN_CREATED_BY VARCHAR2 64     Campaign Created By    
CAMPAIGN_REGION_CODE VARCHAR2 128     Region code of the Campaign.    
CAMPAIGN_NAME VARCHAR2 128     Name of the campaign    
CAMPAIGN_START_DATE DATE       Starting Date for the campaign    
CAMPAIGN_START_TIMESTAMP TIMESTAMP       Starting TIMESTAMP for the campaign    
CAMPAIGN_END_DATE DATE       Ending date for the campaign. Responses received after this date are still counted    
CAMPAIGN_END_TIMESTAMP TIMESTAMP       Ending TIMESTAMP for the campaign. Responses received after this date are still counted    
CAMPAIGN_PRODUCT_DESCRIPTION VARCHAR2 128     Product Name on the Campaign.    
CAMPAIGN_STATUS_CODE VARCHAR2 32     Status code of the Campaign created. ('ORA_DRAFT', 'ORA_COMPLETED, ORA_ACTIVE') DW_CXM_CAMPAIGN_STATUS_D_TL CODE
CAMPAIGN_TYPE_CODE VARCHAR2 32     Type of campaign. ( 'ORA_EVENT','ORA_BLOG_POST') DW_CXM_CAMPAIGN_TYPE_D_TL CODE
CAMPAIGN_DESCRIPTION VARCHAR2 999     Description of the campaign    
CAMPAIGN_ACTIVE_FLAG VARCHAR2 16     Indicates whether the campaign is active('Y') or not ('N')    
GLOBAL_CURRENCY_CAMPAIGN_ACTUAL_COST NUMBER       Campaign actual cost in global currency    
GLOBAL_CURRENCY_CAMPAIGN_BUDGETED_COST NUMBER       Campaign budgeted cost in global currency    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
CAMPAIGN_CREATION_DATE DATE       Campaign Creation date    
CAMPAIGN_CREATION_TIMESTAMP TIMESTAMP       Campaign Creation TimeStamp    
CREATION_DATE DATE       Who column: indicates the date of the creation of the row.    
CREATED_BY VARCHAR2 64     Who column: indicates the user who created the row.    
CREATION_TIMESTAMP TIMESTAMP       Campaign Creation TimeStamp    

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