V_QUERY_BBDW_PROSPECT

Fields

Field	Field Type	Null
PROSPECTDIMID	int
PROSPECTSYSTEMID	uniqueidentifier	yes
CONSTITUENTDIMID	int	yes
FULLNAME	nvarchar(154)	yes
FUNDRAISERDIMID	int	yes
PROSPECTSTATUS	nvarchar(100)	yes
PROSPECTMANAGERSTARTDATEDIMID	int	yes
PROSPECTMANAGERSTARTDATE	datetime	yes
PROSPECTMANAGERENDDATEDIMID	int	yes
PROSPECTMANAGERENDDATE	datetime	yes
ISACTIVEPROSPECT	bit	yes

Definition

Copy

create view BBDW.[V_QUERY_BBDW_PROSPECT] as 

select
  p.[PROSPECTDIMID],
  p.[PROSPECTSYSTEMID],
  p.[CONSTITUENTDIMID],
  c.[FULLNAME],
  p.[FUNDRAISERDIMID],
  p.[PROSPECTSTATUS],
  p.[PROSPECTMANAGERSTARTDATEDIMID],
  p.[PROSPECTMANAGERSTARTDATE],
  p.[PROSPECTMANAGERENDDATEDIMID],
  p.[PROSPECTMANAGERENDDATE],
  c.[ISACTIVEPROSPECT]
from BBDW.[DIM_PROSPECT] p
inner join BBDW.[DIM_CONSTITUENT] c on c.[CONSTITUENTDIMID] = p.[CONSTITUENTDIMID]
where p.[PROSPECTDIMID] > 0