v_DIM_CONSTITUENTPHONEFLAG
The Constituent Phone Flag dimension contains flags for constituent phone numbers
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTPHONEFLAGDIMID | int | BBDW.[DIM_COUNTRY].[CONSTITUENTPHONEFLAGDIMID] | |
| ISPRIMARY | bit | yes | BBDW.[DIM_COUNTRY].[ISPRIMARY] |
| DONOTCALL | bit | yes | BBDW.[DIM_COUNTRY].[DONOTCALL] |
| ISCONFIDENTIAL | bit | yes | BBDW.[DIM_COUNTRY].[ISCONFIDENTIAL] |
Definition
Copy
create view [BBDW].[v_DIM_CONSTITUENTPHONEFLAG] as
select
[CONSTITUENTPHONEFLAGDIMID],
[ISPRIMARY],
[DONOTCALL],
[ISCONFIDENTIAL]
from BBDW.[DIM_CONSTITUENTPHONEFLAG]