DIM_CAMPAIGN_STAGE

Intermediate storage table for campaigns

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 using [dbo].[CAMPAIGN].[STARTDATE]
CAMPAIGNENDDATEDIMID	int	yes		Reference key to the date dimension, derived using [dbo].[CAMPAIGN].[ENDDATE]
PARENTCAMPAIGNDIMID	int	yes		Reference key to the campaign dimension, derived using [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_TEXT	nvarchar(500)	yes		[dbo].[CAMPAIGN].[HIERARCHYPATH] converted to nvarchar(500)