Contact
Contains information on Eloqua contacts, including personal, demographic, and system-tracked attributes.
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.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 street address information 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. | ||
| createdDateHour | Datetime | Created timestamp rounded to the hour, used for hourly-level reporting. | ||
| eloquaLinkedAccountId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the contact to a related Eloqua 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, useful for segmentation and domain-level analysis. | |
| fax | String | Fax number for the contact, if provided. | ||
| 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 this contact. | ||
| territory | String | Sales or marketing territory associated with this contact. | ||
| title | String | =,<>,>,<,>=,<=,IN,NOT IN | Job title or role of the contact within their organization. |