ExternalActivityAttributes
Displays attributes and metadata for external campaign activities.
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 CampaignExternalActivity.ExternalActivityAttributes;
Columns
| Name | Type | References | SupportedOperators | Description |
| externalAssetId [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the external asset record within Eloqua. | |
| externalAssetName | String | Display name of the external asset, such as the event, webinar, or activity label. | ||
| externalAssetType | Int | Numeric code representing the type of external asset. | ||
| externalAssetTypeName | String | =,<>,>,<,>=,<=,IN,NOT IN | Text description of the external asset type, such as Webinar, Event, or Social Activity. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update to the external asset attributes. |