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