V_QUERY_BBDW_EMAILADDRESS
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTEMAILADDRESSSYSTEMID | uniqueidentifier | yes | |
| CONSTITUENTDIMID | int | yes | |
| EMAILADDRESS | UDT_EMAILADDRESS | ||
| STARTDATEDIMID | int | yes | |
| STARTDATE | datetime | yes | |
| ENDDATEDIMID | int | yes | |
| ENDDATE | datetime | yes | |
| CONSTITUENTEMAILADDRESSTYPE | nvarchar(100) | yes | |
| DONOTEMAIL | bit | yes | |
| ISPRIMARY | bit | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_EMAILADDRESS] as
select
ea.[CONSTITUENTEMAILADDRESSSYSTEMID],
ea.[CONSTITUENTDIMID],
ea.[EMAILADDRESS],
ea.[STARTDATEDIMID],
ea.[STARTDATE],
ea.[ENDDATEDIMID],
ea.[ENDDATE],
et.[CONSTITUENTEMAILADDRESSTYPE],
ef.[DONOTEMAIL],
ef.[ISPRIMARY]
from BBDW.[FACT_CONSTITUENTEMAILADDRESS] ea
left join BBDW.[DIM_CONSTITUENTEMAILADDRESSTYPE] et on ea.[CONSTITUENTEMAILADDRESSTYPEDIMID] = et.[CONSTITUENTEMAILADDRESSTYPEDIMID] and ea.[CONSTITUENTEMAILADDRESSTYPEDIMID] <> 0
left join BBDW.[DIM_CONSTITUENTEMAILADDRESSFLAG] ef on ea.[CONSTITUENTEMAILADDRESSFLAGDIMID] = ef.[CONSTITUENTEMAILADDRESSFLAGDIMID] and ea.[CONSTITUENTEMAILADDRESSFLAGDIMID] <> 0