v_DIM_CONSTITUENTEMAILADDRESSFLAG
The Constituent Email Address Flag dimension contains information about constituent email address flags
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTEMAILADDRESSFLAGDIMID | int | BBDW.[DIM_CONSTITUENTEMAILADDRESSFLAG].[CONSTITUENTEMAILADDRESSFLAGDIMID] | |
| ISPRIMARY | bit | yes | BBDW.[DIM_CONSTITUENTEMAILADDRESSFLAG].[ISPRIMARY] |
| DONOTEMAIL | bit | yes | BBDW.[DIM_CONSTITUENTEMAILADDRESSFLAG].[DONOTEMAIL] |
Definition
Copy
create view [BBDW].[v_DIM_CONSTITUENTEMAILADDRESSFLAG] as
select
[CONSTITUENTEMAILADDRESSFLAGDIMID],
[ISPRIMARY],
[DONOTEMAIL]
from BBDW.[DIM_CONSTITUENTEMAILADDRESSFLAG]