Account
Provides account-level data, including details on organizations tracked in Eloqua and their associated 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 AccountActivity.Account;
Columns
| Name | Type | References | SupportedOperators | Description |
| accountId [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the account within Eloqua, used to link reporting and engagement data to the correct account. | |
| accountName | String | =,<>,>,<,>=,<=,IN,NOT IN | The display name of the account, typically representing the company or organization name. | |
| accountSource | Int | Numeric code that indicates the source system or channel where the account originated. | ||
| companyId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier that associates the account with its parent company record. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update to the account record or its related attributes. | ||
| accountEngagement_accountId | Int |
AccountEngagement.accountId | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key reference connecting this account to its engagement tracking data. |