EmailAsset
Details email assets used to drive form submissions.
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.EmailAsset;
Columns
| Name | Type | References | SupportedOperators | Description |
| emailID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the email asset within Eloqua. | |
| emailCreatedByUserID | Int |
User.userID | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the user who originally created the email asset. |
| emailGroup | String | =,<>,>,<,>=,<=,IN,NOT IN | Name of the email group the asset belongs to, used for categorization and reporting. | |
| emailGroupDescription | String | Text description providing context about the purpose or scope of the email group. | ||
| emailGroupID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the email group associated with the asset. | |
| emailGroupIsDeleted | Bool | =,<>,>,<,>=,<=,IN,NOT IN | Flag indicating whether the associated email group has been deleted. | |
| emailName | String | =,<>,>,<,>=,<=,IN,NOT IN | The display name of the email asset as defined in Eloqua. | |
| isArchived | Bool | =,<>,>,<,>=,<=,IN,NOT IN | Flag showing whether the email asset has been archived and is no longer in active use. | |
| isDeleted | Bool | =,<>,>,<,>=,<=,IN,NOT IN | Flag indicating whether the email asset has been deleted from Eloqua. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update made to the email asset record. | ||
| subjectLine | String | Subject line of the email as it appears in recipients' inboxes. | ||
| user_userID | Int |
User.userID | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the email asset record to the Eloqua user responsible for managing it. |