v_FACT_EMAILACTIVITY
Email sent to constituents through Luminate Online.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EMAILACTIVITYFACTID | bigint | BBDW.[FACT_EMAILACTIVITY].[EMAILACTIVITYFACTID] | |
| EMAILCAMPAIGNDIMID | int | BBDW.[FACT_EMAILACTIVITY].[EMAILCAMPAIGNDIMID] | |
| EMAILMESSAGEDIMID | int | BBDW.[FACT_EMAILACTIVITY].[EMAILMESSAGEDIMID] | |
| CONSTITUENTDIMID | int | BBDW.[FACT_EMAILACTIVITY].[CONSTITUENTDIMID] | |
| CONSTITUENTSYSTEMID | uniqueidentifier | BBDW.[FACT_EMAILACTIVITY].[CONSTITUENTSYSTEMID] | |
| EMAILSENDDATE | datetime | BBDW.[FACT_EMAILACTIVITY].[EMAILSENDDATE] | |
| EMAILSENDDATEDIMID | int | BBDW.[FACT_EMAILACTIVITY].[EMAILSENDDATEDIMID] | |
| EMAILSENDTIMEDIMID | int | BBDW.[FACT_EMAILACTIVITY].[EMAILSENDTIMEDIMID] | |
| RECIPIENTOPEN | bit | BBDW.[FACT_EMAILACTIVITY].[RECIPIENTOPEN] | |
| RECIPIENTOPENTIME | datetime | yes | BBDW.[FACT_EMAILACTIVITY].[RECIPIENTOPENTIME] |
| RECIPIENTOPENDATEDIMID | int | yes | BBDW.[FACT_EMAILACTIVITY].[RECIPIENTOPENDATEDIMID] |
| RECIPIENTOPENTIMEDIMID | int | yes | BBDW.[FACT_EMAILACTIVITY].[RECIPIENTOPENTIMEDIMID] |
| RECIPIENTCLICK | bit | BBDW.[FACT_EMAILACTIVITY].[RECIPIENTCLICK] | |
| RECIPIENTCLICKTIME | datetime | yes | BBDW.[FACT_EMAILACTIVITY].[RECIPIENTCLICKTIME] |
| RECIPIENTCLICKDATEDIMID | int | yes | BBDW.[FACT_EMAILACTIVITY].[RECIPIENTCLICKDATEDIMID] |
| RECIPIENTCLICKTIMEDIMID | int | yes | BBDW.[FACT_EMAILACTIVITY].[RECIPIENTCLICKTIMEDIMID] |
| RECIPIENTACTION | bit | yes | BBDW.[FACT_EMAILACTIVITY].[RECIPIENTACTION] |
| RECIPIENTACTIONTIME | datetime | yes | BBDW.[FACT_EMAILACTIVITY].[RECIPIENTACTIONTIME] |
| RECIPIENTACTIONDATEDIMID | int | yes | BBDW.[FACT_EMAILACTIVITY].[RECIPIENTACTIONDATEDIMID] |
| RECIPIENTACTIONTIMEDIMID | int | yes | BBDW.[FACT_EMAILACTIVITY].[RECIPIENTACTIONTIMEDIMID] |
| RECIPIENTHARDBOUNCE | bit | yes | BBDW.[FACT_EMAILACTIVITY].[RECIPIENTHARDBOUNCE] |
| RECIPIENTSOFTBOUNCE | bit | yes | BBDW.[FACT_EMAILACTIVITY].[RECIPIENTSOFTBOUNCE] |
| RECIPIENTUNSUBSCRIBE | bit | yes | BBDW.[FACT_EMAILACTIVITY].[RECIPIENTUNSUBSCRIBE] |
| FORWARDEDOPENCOUNT | int | yes | BBDW.[FACT_EMAILACTIVITY].[FORWARDEDOPENCOUNT] |
| FORWARDEDACTIONCOUNT | int | yes | BBDW.[FACT_EMAILACTIVITY].[FORWARDEDACTIONCOUNT] |
| TOTALCLICKCOUNT | int | yes | BBDW.[FACT_EMAILACTIVITY].[TOTALCLICKCOUNT] |
| TOTALOPENCOUNT | int | yes | BBDW.[FACT_EMAILACTIVITY].[TOTALOPENCOUNT] |
| STATSLASTUPDATED | datetime | yes | BBDW.[FACT_EMAILACTIVITY].[STATSLASTUPDATED] |
Definition
Copy
create view [BBDW].[v_FACT_EMAILACTIVITY] as
select
[EMAILACTIVITYFACTID],
[EMAILCAMPAIGNDIMID],
[EMAILMESSAGEDIMID],
[CONSTITUENTDIMID],
[CONSTITUENTSYSTEMID],
[EMAILSENDDATE],
[EMAILSENDDATEDIMID],
[EMAILSENDTIMEDIMID],
[RECIPIENTOPEN],
[RECIPIENTOPENTIME],
[RECIPIENTOPENDATEDIMID],
[RECIPIENTOPENTIMEDIMID],
[RECIPIENTCLICK],
[RECIPIENTCLICKTIME],
[RECIPIENTCLICKDATEDIMID],
[RECIPIENTCLICKTIMEDIMID],
[RECIPIENTACTION],
[RECIPIENTACTIONTIME],
[RECIPIENTACTIONDATEDIMID],
[RECIPIENTACTIONTIMEDIMID],
[RECIPIENTHARDBOUNCE],
[RECIPIENTSOFTBOUNCE],
[RECIPIENTUNSUBSCRIBE],
[FORWARDEDOPENCOUNT],
[FORWARDEDACTIONCOUNT],
[TOTALCLICKCOUNT],
[TOTALOPENCOUNT],
[STATSLASTUPDATED]
from [BBDW].[FACT_EMAILACTIVITY];