DIM_FUNDRAISERCAMPAIGN

The dimension relates fundraisers to campaigns

Primary Key

Primary Key	Field Type
FUNDRAISERCAMPAIGNDIMID	int

Fields

Field	Field Type	Null	Notes	Description
FUNDRAISERCAMPAIGNSYSTEMID	uniqueidentifier	yes		dbo.[CAMPAIGNFUNDRAISER].[ID]
FUNDRAISERDIMID	int	yes		Reference key to the fundraiser dimension, derived from dbo.[CAMPAIGNFUNDRAISER].[CONSTITUENTID]
FUNDRAISERSYSTEMID	uniqueidentifier	yes		dbo.[CAMPAIGNFUNDRAISER].[CONSTITUENTID]
CAMPAIGNDIMID	int	yes		Reference key to the campaign dimension, derived from dbo.[CAMPAIGNFUNDRAISER].[CAMPAIGNID]
CAMPAIGNFUNDRAISERPOSITION	nvarchar(100)	yes		dbo.[CAMPAIGNFUNDRAISERPOSITIONCODE].[DESCRIPTION]
CAMPAIGNFUNDRAISERTASK	nvarchar(100)	yes		dbo.[CAMPAIGNFUNDRAISERTASKCODE].[DESCRIPTION]
FROMDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[CAMPAIGNFUNDRAISER].[DATEFROM]
FROMDATE	datetime	yes		dbo.[CAMPAIGNFUNDRAISER].[DATEFROM]
TODATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[CAMPAIGNFUNDRAISER].[DATETO]
TODATE	datetime	yes		dbo.[CAMPAIGNFUNDRAISER].[DATETO]
STATUS	nvarchar(10)	yes		dbo.[CAMPAIGNFUNDRAISER].[STATUS]
ISINCLUDED	bit	yes		Flag indicating when data should be included in results.
ETLCONTROLID	int	yes		ID generated through the ETL process
SOURCEDIMID	int	yes		Source system used
FUNDRAISERCONSTITUENTDIMID	int	yes		Reference key to the constituent dimension, derived using [dbo].[CAMPAIGNFUNDRAISER].[CONSTITUENTID]

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_DIM_FUNDRAISERCAMPAIGN_CAMPAIGNDIMID	CAMPAIGNDIMID
IX_DIM_FUNDRAISERCAMPAIGN_FROMDATEDIMID	FROMDATEDIMID
IX_DIM_FUNDRAISERCAMPAIGN_FUNDRAISERCONSTITUENTDIMID	FUNDRAISERCONSTITUENTDIMID
IX_DIM_FUNDRAISERCAMPAIGN_FUNDRAISERDIMID	FUNDRAISERDIMID
IX_DIM_FUNDRAISERCAMPAIGN_SOURCEDIMID	SOURCEDIMID
IX_DIM_FUNDRAISERCAMPAIGN_TODATEDIMID	TODATEDIMID
PK_DIM_FUNDRAISERCAMPAIGN	FUNDRAISERCAMPAIGNDIMID	yes	yes	yes