User
Contains metadata about Eloqua system users and their roles.
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.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 record has been marked as deleted. | |
| lastModifiedDateTime | Datetime | Timestamp of the most recent update 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 in Eloqua. |