DIM_CAMPAIGNPRIORITY

The Campaign Priority dimension contains information about campaign priorities.

Primary Key

Primary Key	Field Type
CAMPAIGNPRIORITYDIMID	int

Fields

Field	Field Type	Null	Notes	Description
CAMPAIGNSUBPRIORITYSYSTEMID	uniqueidentifier	yes		dbo.[CAMPAIGNSUBPRIORITY].[ID]
CAMPAIGNSUBPRIORITY	nvarchar(100)	yes		dbo.[CAMPAIGNSUBPRIORITY].[NAME]
CAMPAIGNPRIORITY	nvarchar(100)	yes		dbo.[CAMPAIGNPRIORITYTYPECODE].[DESCRIPTION]
CAMPAIGNSUBPRIORITYGOAL	money	yes		dbo.[CAMPAIGNSUBPRIORITY].[GOAL]
CAMPAIGNPRIORITYGOAL	money	yes		dbo.[CAMPAIGNPRIORITY].[GOAL]
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
CAMPAIGNDIMID	int	yes		Reference key to the campaign dimension, derived from dbo.[CAMPAIGNPRIORITY].[CAMPAIGNID]

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_DIM_CAMPAIGNPRIORITY_CAMPAIGNDIMID	CAMPAIGNDIMID
PK_DIM_CAMPAIGNPRIORITY	CAMPAIGNPRIORITYDIMID	yes	yes	yes