DW_CXM_CAMPAIGN_D

Marketing Campaign Dimension

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 This column is for Oracle Internal use only. System Generated Unique Identifier
STRING_CAMPAIGN_ID VARCHAR2 256 String converted Unique Identifier
CAMPAIGN_CREATED_BY VARCHAR2 64 Who column: indicates the user who created the Campaign
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
CAMPAIGN_REGION_CODE VARCHAR2 128 Region code of the Campaign.
CAMPAIGN_NAME VARCHAR2 128 Name of the campaign
CAMPAIGN_START_DATE TIMESTAMP Starting Date for the campaign
CAMPAIGN_END_DATE TIMESTAMP Ending date for the campaign. Responses received after this date are still counted
CAMPAIGN_CREATION_DATE TIMESTAMP Campaign Creation date
CREATION_DATE TIMESTAMP Who column: indicates the date of the creation of the row.
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')
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date of the latest update of the row.
CAMPAIGN_CATEGORY_CODE VARCHAR2 32 Category of the Campaign DW_CXM_CAMPAIGN_CATEGORY_D_TL CODE