v_DIM_FUNDRAISERCAMPAIGN

The dimension relates fundraisers to campaigns

Fields

Field	Field Type	Null	Description
FUNDRAISERCAMPAIGNDIMID	int		BBDW.[DIM_FUNDRAISERCAMPAIGN].[FUNDRAISERCAMPAIGNDIMID]
FUNDRAISERCAMPAIGNSYSTEMID	uniqueidentifier	yes	BBDW.[DIM_FUNDRAISERCAMPAIGN].[FUNDRAISERCAMPAIGNSYSTEMID]
FUNDRAISERDIMID	int	yes	BBDW.[DIM_FUNDRAISERCAMPAIGN].[FUNDRAISERDIMID]
FUNDRAISERSYSTEMID	uniqueidentifier	yes	BBDW.[DIM_FUNDRAISERCAMPAIGN].[FUNDRAISERSYSTEMID]
CAMPAIGNDIMID	int	yes	BBDW.[DIM_FUNDRAISERCAMPAIGN].[CAMPAIGNDIMID]
CAMPAIGNFUNDRAISERPOSITION	nvarchar(100)	yes	BBDW.[DIM_FUNDRAISERCAMPAIGN].[CAMPAIGNFUNDRAISERPOSITION]
CAMPAIGNFUNDRAISERTASK	nvarchar(100)	yes	BBDW.[DIM_FUNDRAISERCAMPAIGN].[CAMPAIGNFUNDRAISERTASK]
FROMDATEDIMID	int	yes	BBDW.[DIM_FUNDRAISERCAMPAIGN].[FROMDATEDIMID]
FROMDATE	datetime	yes	BBDW.[DIM_FUNDRAISERCAMPAIGN].[FROMDATE]
TODATEDIMID	int	yes	BBDW.[DIM_FUNDRAISERCAMPAIGN].[TODATEDIMID]
TODATE	datetime	yes	BBDW.[DIM_FUNDRAISERCAMPAIGN].[TODATE]
STATUS	nvarchar(10)	yes	BBDW.[DIM_FUNDRAISERCAMPAIGN].[STATUS]
FUNDRAISERCONSTITUENTDIMID	int	yes	BBDW.[DIM_FUNDRAISERCAMPAIGN].[FUNDRAISERCONSTITUENTDIMID]

Definition

Copy


create view [BBDW].[v_DIM_FUNDRAISERCAMPAIGN] as 
  select 
    [FUNDRAISERCAMPAIGNDIMID],
    [FUNDRAISERCAMPAIGNSYSTEMID],
    [FUNDRAISERDIMID],
    [FUNDRAISERSYSTEMID],
    [CAMPAIGNDIMID],
    [CAMPAIGNFUNDRAISERPOSITION],
    [CAMPAIGNFUNDRAISERTASK],
    [FROMDATEDIMID],
    [FROMDATE],
    [TODATEDIMID],
    [TODATE],
    [STATUS],
    [FUNDRAISERCONSTITUENTDIMID]
  from [BBDW].[DIM_FUNDRAISERCAMPAIGN];