User
Provides details about Eloqua users involved in campaign activities.
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 CampaignAnalysis.User;
Columns
| Name | Type | References | SupportedOperators | Description |
| userID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the user record within Eloqua. | |
| isDeleted | Bool | =,<>,>,<,>=,<=,IN,NOT IN | Flag indicating whether the user account has been marked as deleted. | |
| lastModifiedDateTime | Datetime | Timestamp of the most recent update made to the user record. | ||
| userEmailAddress | String | =,<>,>,<,>=,<=,IN,NOT IN | Email address associated with the user account. | |
| userName | String | =,<>,>,<,>=,<=,IN,NOT IN | Display name or login name assigned to the user within Eloqua. |