Marketing Campaign Dimension
Module: Marketing Campaigns
CAMPAIGN_ID
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 |
Copyright © 2019, 2024, Oracle and/or its affiliates.