Campaign members Fact
Module: Marketing Campaigns
CAMPAIGN_MEMBER_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CAMPAIGN_MEMBER_ID | NUMBER | 38 | 0 | True | Campaign Member Id. Primary Key of the table. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. System Generated Unique identifier | ||||
| MEMBER_ACTIVE_FLAG | VARCHAR2 | 16 | Indicates whether the campaign is active or not | ||||
| CAMPAIGN_ID | NUMBER | 38 | 0 | Campaign Identifier to which member is associated with | |||
| CONTACT_ID | NUMBER | 38 | 0 | Party Identifier for the contact | DW_CXS_CONTACT_D | CONTACT_ID | |
| MEMBER_EMAIL_ADDRESS | VARCHAR2 | 512 | Email address of the campaign member | ||||
| LEAD_ID | NUMBER | 38 | 0 | Lead Identifier | |||
| MEMBER_STATUS_CODE | VARCHAR2 | 32 | Status of the Campaign Member. ('ORA_RESPONDED', 'ORA_SENT') | DW_CXM_CAMPAIGN_MEMBER_STATUS_D_TL | CODE | ||
| SOURCE_SYSTEM_CAMPAIGN_MEMBER_ID | VARCHAR2 | 128 | Identifier of Source System Campaign Member row | ||||
| MEMBER_RESPONSE_DATE | DATE | Date on which member response is received in Eloqua | |||||
| MEMBER_RESPONSE_TIMESTAMP | TIMESTAMP | Date and Time on which member response is received in Eloqua | |||||
| 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 | Who Column : indicates the user who created the Campaign | ||||
| 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_END_DATE | DATE | Ending date 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 | |||||
| LEAD_NAME | VARCHAR2 | 256 | Lead Name used for identifying the lead. | ||||
| LEAD_NUMBER | VARCHAR2 | 32 | Lead number. System generated key for this table. | ||||
| LEAD_STATUS_CODE | VARCHAR2 | 32 | Status Code . Denotes the current status of the lead.('UNQUALIFIED','CONVERTED','RETIRED','QUALIFIED') | DW_CXS_LEAD_STATUS_D_TL | CODE | ||
| LEAD_QUALIFIED_DATE | DATE | Qualified Date. Stores the date the lead was qualified. | |||||
| LEAD_CHANNEL_TYPE_CODE | VARCHAR2 | 64 | Channel type of the lead. | DW_CXS_LEAD_CHANNEL_D_TL | CODE | ||
| LEAD_OWNER_RESOURCE_PARTY_ID | NUMBER | 38 | 0 | Lead Owner Resource | DW_CXS_RESOURCE_D | RESOURCE_ID | |
| LEAD_PRIMARY_CONTACT_ID | NUMBER | 38 | 0 | Primary Contact Id . Denormalized column from lead contacts table. | DW_CXS_CONTACT_D | CONTACT_ID | |
| LEAD_CUSTOMER_ORGANIZATION_TYPE_CODE | VARCHAR2 | 32 | Lead Customer Organization Type. ('ORGANIZATION','A: Health; T: Health','A: Commercial; T: Higher Ed','A: Commercial; T: Health','A: Commercial; T: PS-SL','PUBLIC_COMPANY') | DW_CXS_ORGANIZATION_TYPE_CODE_D_TL | CODE | ||
| LEAD_ESTIMATED_CLOSE_DATE | DATE | Estimated close date of the deal | |||||
| LEAD_CUSTOMER_EXISTING_FLAG | VARCHAR2 | 32 | Customer Existing Flag. | ||||
| LEAD_CUSTOMER_ID | NUMBER | 38 | 0 | Customer Identifier | DW_CXS_SALES_ACCOUNT_D | PARTY_ID | |
| 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 | Who column: indicates the date and time of the creation of the row. | |||||
| LEAD_CREATION_DATE | DATE | Business specific Creation Date of the lead. | |||||
| LEAD_CREATION_TIMESTAMP | TIMESTAMP | Business specific Creation Date and time of the lead. |
Copyright © 2019, 2024, Oracle and/or its affiliates.