User
Details Eloqua users associated with form submission management.
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 FormSubmission.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 in Eloqua. | |
| userName | String | =,<>,>,<,>=,<=,IN,NOT IN | Display name or login name assigned to the user within Eloqua. |