Contact
Contains contact information related to opportunity engagement and outcomes.
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 OpportunityAnalysis.Contact;
Columns
| Name | Type | References | SupportedOperators | Description |
| contactId [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the contact record within Eloqua. | |
| accountID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the contact to its associated account record. | |
| businessPhone | String | Primary business phone number for the contact. | ||
| company | String | =,<>,>,<,>=,<=,IN,NOT IN | Name of the company or organization associated with the contact. | |
| contactAddress1 | String | Primary street address line for the contact. | ||
| contactAddress2 | String | Secondary street address line for the contact, if applicable. | ||
| contactAddress3 | String | Additional address details for the contact, if applicable. | ||
| contactCity | String | City portion of the contact's address. | ||
| contactCountry | String | =,<>,>,<,>=,<=,IN,NOT IN | Country portion of the contact's address. | |
| contactStateProv | String | State or province portion of the contact's address. | ||
| contactZipPostalCode | String | ZIP code or postal code of the contact's address. | ||
| createdDate | Datetime | Date and time when the contact record was first created in Eloqua. | ||
| createdDateHour | Datetime | Created timestamp rounded to the hour, useful for hourly-level reporting. | ||
| eloquaLinkedAccountId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the contact to a related Eloqua linked account record. | |
| emailAddress | String | =,<>,>,<,>=,<=,IN,NOT IN | Primary email address of the contact. | |
| emailAddressDomain | String | =,<>,>,<,>=,<=,IN,NOT IN | Domain portion of the contact's email address, often used for segmentation and analysis. | |
| fax | String | Fax number for the contact, if available. | ||
| firstName | String | First name of the contact. | ||
| lastModifiedDate | Datetime | Timestamp of the most recent update to the contact record. | ||
| lastName | String | Last name or surname of the contact. | ||
| leadSourceMostRecent | String | Most recent source that generated the lead for this contact. | ||
| leadSourceOriginal | String | Original source that first generated the lead for this contact. | ||
| mobilePhone | String | Mobile phone number for the contact. | ||
| salesPerson | String | Assigned salesperson responsible for managing this contact. | ||
| territory | String | Sales or marketing territory associated with the contact. | ||
| title | String | =,<>,>,<,>=,<=,IN,NOT IN | Job title or role of the contact within their organization. | |
| account_accountId | Int |
Account.accountId | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the contact record back to the associated account record. |