FormAsset
Contains metadata for form assets deployed in Eloqua campaigns.
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.FormAsset;
Columns
| Name | Type | References | SupportedOperators | Description |
| formID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the form asset within Eloqua. | |
| formExpired | Bool | =,<>,>,<,>=,<=,IN,NOT IN | Flag indicating whether the form has expired and is no longer active. | |
| formHostType | String | Type of host where the form is deployed, such as Eloqua landing page or external site. | ||
| formName | String | =,<>,>,<,>=,<=,IN,NOT IN | The display name of the form asset as defined in Eloqua. | |
| isArchived | Bool | =,<>,>,<,>=,<=,IN,NOT IN | Flag showing whether the form asset has been archived and is no longer actively used. | |
| isDeleted | Bool | =,<>,>,<,>=,<=,IN,NOT IN | Flag indicating whether the form asset has been deleted from Eloqua. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update made to the form asset record. |