v_DIM_EMAILCAMPAIGN
Email sent to constituents through Luminate Online.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EMAILCAMPAIGNDIMID | int | BBDW.[DIM_EMAILCAMPAIGN].[EMAILCAMPAIGNDIMID] | |
| EMAILCAMPAIGNSYSTEMID | int | BBDW.[DIM_EMAILCAMPAIGN].[EMAILCAMPAIGNSYSTEMID] | |
| EMAILCAMPAIGNNAME | nvarchar(255) | yes | BBDW.[DIM_EMAILCAMPAIGN].[EMAILCAMPAIGNNAME] |
| EMAILCAMPAIGNPURPOSE | nvarchar(255) | yes | BBDW.[DIM_EMAILCAMPAIGN].[EMAILCAMPAIGNPURPOSE] |
| EMAILCAMPAIGNTYPE | nvarchar(64) | yes | BBDW.[DIM_EMAILCAMPAIGN].[EMAILCAMPAIGNTYPE] |
Definition
Copy
create view [BBDW].[v_DIM_EMAILCAMPAIGN] as
select
[EMAILCAMPAIGNDIMID],
[EMAILCAMPAIGNSYSTEMID],
[EMAILCAMPAIGNNAME],
[EMAILCAMPAIGNPURPOSE],
[EMAILCAMPAIGNTYPE]
from [BBDW].[DIM_EMAILCAMPAIGN];