v_DIM_CONSTITUENTADDRESSFLAG
Contains flags for constituent addresses.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTADDRESSFLAGDIMID | int | BBDW.[DIM_CONSTITUENTADDRESSFLAG].[CONSTITUENTADDRESSFLAGDIMID] | |
| DONOTMAIL | bit | yes | BBDW.[DIM_CONSTITUENTADDRESSFLAG].[DONOTMAIL] |
| ISCONFIDENTIAL | bit | yes | BBDW.[DIM_CONSTITUENTADDRESSFLAG].[ISCONFIDENTIAL] |
| ISPRIMARY | bit | yes | BBDW.[DIM_CONSTITUENTADDRESSFLAG].[ISPRIMARY] |
Definition
Copy
create view [BBDW].[v_DIM_CONSTITUENTADDRESSFLAG] as
select
caf.[CONSTITUENTADDRESSFLAGDIMID],
caf.[DONOTMAIL],
caf.[ISCONFIDENTIAL],
caf.[ISPRIMARY]
from BBDW.[DIM_CONSTITUENTADDRESSFLAG] caf