V_CONSTITUENT_WITHNULLCONSTITSECURITY

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier	yes

Definition

Copy


create view BBDW.[V_CONSTITUENT_WITHNULLCONSTITSECURITY]
as
    select
        [DIM_CONSTITUENT].[CONSTITUENTSYSTEMID] as [ID]
    from
    BBDW.[DIM_CONSTITUENT]
    left join BBDW.[FACT_CONSTITUENTSECURITYGROUPASSIGNMENT] on [DIM_CONSTITUENT].[CONSTITUENTDIMID] = [FACT_CONSTITUENTSECURITYGROUPASSIGNMENT].[CONSTITUENTDIMID]
    where    [FACT_CONSTITUENTSECURITYGROUPASSIGNMENT].[CONSTITUENTDIMID] is null;