DIM_CAMPAIGN

The dimension contains information about campaigns.

Primary Key

Primary Key	Field Type
CAMPAIGNDIMID	int

Fields

Field	Field Type	Null	Notes	Description
CAMPAIGNSYSTEMID	uniqueidentifier	yes		dbo.[CAMPAIGN].[ID]
CAMPAIGNLOOKUPID	nvarchar(100)	yes		dbo.[CAMPAIGN].[USERID]
CAMPAIGNNAME	nvarchar(100)	yes		dbo.[CAMPAIGN].[NAME]
CAMPAIGNDESCRIPTION	nvarchar(300)	yes		dbo.[CAMPAIGN].[DESCRIPTION]
CAMPAIGNTYPE	nvarchar(100)	yes		dbo.[CAMPAIGNTYPECODE].[DESCRIPTION]
CAMPAIGNISACTIVE	bit	yes		dbo.[CAMPAIGN].[ISACTIVE]
CAMPAIGNSTARTDATE	datetime	yes		dbo.[CAMPAIGN].[STARTDATE]
CAMPAIGNENDDATE	datetime	yes		dbo.[CAMPAIGN].[ENDDATE]
CAMPAIGNSTARTDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[CAMPAIGN].[STARTDATE]
CAMPAIGNENDDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[CAMPAIGN].[ENDDATE]
PARENTCAMPAIGNDIMID	int	yes		Reference key to the campaign dimension, derived from dbo.[CAMPAIGN].[HIERARCHYPATH]
PARENTCAMPAIGNSYSTEMID	uniqueidentifier	yes		Derived from dbo.[CAMPAIGN].[HIERARCHYPATH]
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
CAMPAIGNHIERARCHYPATH	hierarchyid	yes		[dbo].[CAMPAIGN].[HIERARCHYPATH]

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_DIM_CAMPAIGN_CAMPAIGNENDDATEDIMID	CAMPAIGNENDDATEDIMID
IX_DIM_CAMPAIGN_CAMPAIGNSTARTDATEDIMID	CAMPAIGNSTARTDATEDIMID
IX_DIM_CAMPAIGN_CAMPAIGNSYSTEMID	CAMPAIGNSYSTEMID
IX_DIM_CAMPAIGN_PARENTCAMPAIGNDIMID	PARENTCAMPAIGNDIMID
IX_DIM_CAMPAIGN_PARENTCAMPAIGNSYSTEMID	PARENTCAMPAIGNSYSTEMID
PK_DIM_CAMPAIGN	CAMPAIGNDIMID	yes	yes	yes