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 | 32 | 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.