FormSubmission
Reports data from submitted forms, including captured fields and submission metadata.
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.FormSubmission;
Columns
| Name | Type | References | SupportedOperators | Description |
| formSubmitId [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the form submission event record within Eloqua. | |
| accountID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the form submission to the associated account. | |
| contactID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the contact who submitted the form. | |
| eloquaCampaignID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the form submission event to the related Eloqua campaign. | |
| eloquaLinkedAccountID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the form submission event to a related Eloqua linked account record. | |
| emailID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the email asset that directed the contact to the form, if applicable. | |
| formId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier of the form that was submitted. | |
| formSubmitDateHour | Datetime | Date and time, rounded to the hour, when the form submission occurred. | ||
| landingPageId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the landing page where the form was hosted. | |
| segmentID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the segment associated with the email or campaign that led to the form submission. | |
| sentDateHour | Datetime | Date and time, rounded to the hour, when the related email was originally sent. |