ContactIntegrationFields
Displays external integration fields mapped to Eloqua contacts, used for synchronization with third-party systems.
Select
The driver uses the Oracle Eloqua Reporting API to access entities. To query a view, a fully qualified query consisting of both the schema name and table name is required to avoid any ambiguity.
For example, the following query specifies the schema name followed by the table name to access this view:
SELECT * FROM ActivityDetails.ContactIntegrationFields;
Columns
| Name | Type | References | SupportedOperators | Description |
| contactId [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the contact record within Eloqua. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update to the integration fields for this contact. | ||
| lastMSCRMCampaignID | String | Identifier of the most recent Microsoft Dynamics CRM campaign linked to this contact. | ||
| lastMSCRMCampaignName | String | Name of the most recent Microsoft Dynamics CRM campaign associated with this contact. | ||
| lastMSCRMCampaignResponseID | String | Identifier of the most recent Microsoft Dynamics CRM campaign response linked to this contact. | ||
| lastMSCRMCampaignStatus | String | Status of the most recent Microsoft Dynamics CRM campaign for this contact, such as Active or Completed. | ||
| lastSFDCCampaignID | String | Identifier of the most recent Salesforce campaign linked to this contact. | ||
| lastSFDCCampaignName | String | Name of the most recent Salesforce campaign associated with this contact. | ||
| lastSFDCCampaignStatus | String | Status of the most recent Salesforce campaign for this contact, such as In Progress or Closed. | ||
| mscrmAccountID | String | Identifier for the linked Microsoft Dynamics CRM account associated with this contact. | ||
| mscrmContactID | String | Identifier for the corresponding Microsoft Dynamics CRM contact record. | ||
| mscrmEmailOptOut | String | Indicator of whether the contact has opted out of emails in Microsoft Dynamics CRM. | ||
| mscrmLeadID | String | Identifier for the corresponding Microsoft Dynamics CRM lead record associated with this contact. | ||
| mscrmLeadRating | String | Lead quality or rating value assigned in Microsoft Dynamics CRM for this contact. | ||
| oracleSalesCloudAccountID | String | Identifier for the linked Oracle Sales Cloud account associated with this contact. | ||
| oracleSalesCloudContactID | String | Identifier for the corresponding Oracle Sales Cloud contact record. | ||
| oracleSalesCloudLeadID | String | Identifier for the corresponding Oracle Sales Cloud lead record associated with this contact. | ||
| sfdcAccountID | String | Identifier for the linked Salesforce account associated with this contact. | ||
| sfdcContactID | String | Identifier for the corresponding Salesforce contact record. | ||
| sfdcEmailOptOut | String | Indicator of whether the contact has opted out of emails in Salesforce CRM. | ||
| sfdcLeadID | String | Identifier for the corresponding Salesforce lead record associated with this contact. | ||
| sfdcLeadRating | String | Lead quality or rating value assigned in Salesforce CRM for this contact. |