v_DIM_EMAILMESSAGE
Email sent to constituents through Luminate Online.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EMAILMESSAGEDIMID | int | BBDW.[DIM_EMAILMESSAGE].[EMAILMESSAGEDIMID] | |
| EMAILCAMPAIGNDIMID | int | BBDW.[DIM_EMAILMESSAGE].[EMAILCAMPAIGNDIMID] | |
| EMAILMESSAGESYSTEMID | int | BBDW.[DIM_EMAILMESSAGE].[EMAILMESSAGESYSTEMID] | |
| EMAILMESSAGENAME | nvarchar(255) | yes | BBDW.[DIM_EMAILMESSAGE].[EMAILMESSAGENAME] |
| EMAILMESSAGEPURPOSE | nvarchar(255) | yes | BBDW.[DIM_EMAILMESSAGE].[EMAILMESSAGEPURPOSE] |
| EMAILMESSAGEARCHIVED | bit | BBDW.[DIM_EMAILMESSAGE].[EMAILMESSAGEARCHIVED] | |
| EMAILMESSAGESENDERNAME | nvarchar(255) | yes | BBDW.[DIM_EMAILMESSAGE].[EMAILMESSAGESENDERNAME] |
| EMAILMESSAGESUBJECT | nvarchar(255) | yes | BBDW.[DIM_EMAILMESSAGE].[EMAILMESSAGESUBJECT] |
| EMAILMESSAGEDATECREATED | date | BBDW.[DIM_EMAILMESSAGE].[EMAILMESSAGEDATECREATED] | |
| EMAILMESSAGEDATECREATEDDIMID | int | BBDW.[DIM_EMAILMESSAGE].[EMAILMESSAGEDATECREATEDDIMID] | |
| EMAILMESSAGEDATEMODIFIED | date | yes | BBDW.[DIM_EMAILMESSAGE].[EMAILMESSAGEDATEMODIFIED] |
Definition
Copy
create view [BBDW].[v_DIM_EMAILMESSAGE] as
select
[EMAILMESSAGEDIMID],
[EMAILCAMPAIGNDIMID],
[EMAILMESSAGESYSTEMID],
[EMAILMESSAGENAME],
[EMAILMESSAGEPURPOSE],
[EMAILMESSAGEARCHIVED],
[EMAILMESSAGESENDERNAME],
[EMAILMESSAGESUBJECT],
[EMAILMESSAGEDATECREATED],
[EMAILMESSAGEDATECREATEDDIMID],
[EMAILMESSAGEDATEMODIFIED]
from [BBDW].[DIM_EMAILMESSAGE];