v_DIM_CONTACTTYPE
Contains contact types used for constituent relationships.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONTACTTYPEDIMID | int | BBDW.[DIM_CONTACTTYPE].[CONTACTTYPEDIMID] | |
| CONTACTTYPESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONTACTTYPE].[CONTACTTYPESYSTEMID] |
| CONTACTTYPE | nvarchar(100) | yes | BBDW.[DIM_CONTACTTYPE].[CONTACTTYPE] |
| ISACTIVE | bit | yes | BBDW.[DIM_CONTACTTYPE].[ISACTIVE] |
Definition
Copy
create view [BBDW].[v_DIM_CONTACTTYPE] as
select
cat.[CONTACTTYPEDIMID],
cat.[CONTACTTYPESYSTEMID],
cat.[CONTACTTYPE],
cat.[ISACTIVE]
from BBDW.[DIM_CONTACTTYPE] cat