EmailGroupSubscriptionStatus
Shows subscription statuses of contacts within specific Eloqua email groups.
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.EmailGroupSubscriptionStatus;
Columns
| Name | Type | References | SupportedOperators | Description |
| contactID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the contact whose subscription status is being tracked. | |
| emailGroupID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the email group associated with the subscription status. | |
| isSubscribed | Bool | =,<>,>,<,>=,<=,IN,NOT IN | Flag indicating whether the contact is currently subscribed to the email group. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update to the contact's subscription status for the group. |