Account
Provides account-level data tied to opportunity analysis.
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.Account;
Columns
| Name | Type | References | SupportedOperators | Description |
| accountId [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the account within Eloqua, used to link engagement and reporting data. | |
| accountName | String | =,<>,>,<,>=,<=,IN,NOT IN | The display name of the account, typically the company or organization name. | |
| accountSource | Int | Numeric code indicating the source system or channel where the account originated. | ||
| companyId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the account to its parent company record. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update made to the account record. | ||
| accountEngagement_accountId | Int |
AccountEngagement.accountId | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the account record to related engagement data in Eloqua. |