v_DIM_MEMBERFLAG

The member flag dimension contains information about flags for a member.

Fields

Field Field Type Null Description
MEMBERFLAGDIMID int BBDW.[DIM_MEMBERFLAG].[MEMBERFLAGDIMID]
MEMBERISPRIMARY bit yes BBDW.[DIM_MEMBERFLAG].[MEMBERISPRIMARY]
MEMBERISDROPPED bit yes BBDW.[DIM_MEMBERFLAG].[MEMBERISDROPPED]

Definition

Copy

CREATE view [BBDW].[v_DIM_MEMBERFLAG] as
  select
    [MEMBERFLAGDIMID], 
    [MEMBERISPRIMARY],
    [MEMBERISDROPPED]
  from
    BBDW.[DIM_MEMBERFLAG]