DW_CXM_CAMPAIGN_MEMBERS_CF

Campaign members Fact

Details

Module: Marketing Campaigns

Key Columns

CAMPAIGN_MEMBER_ID

Columns

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