DIM_MARKETINGSOURCECODE_STAGE

Marketing Source Code Table

Fields

Field	Field Type	Null	Notes	Description
MARKETINGSOURCECODESYSTEMID	uniqueidentifier	yes		dbo.[MKTSOURCECODE].[ID]
MARKETINGSEGMENTDIMID	int	yes		Reference key to the site, derived from dbo.[MKTSEGMENT].[ID]
SOURCECODELAYOUT	nvarchar(100)	yes		The source code layout.
SOURCECODE	nvarchar(50)	yes		dbo.[REVENUE_EXT].[SOURCECODE]
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.
SOURCECODEISACTIVE	bit	yes		dbo.[MKTSOURCECODE].[ISACTIVE]
SITEDIMID	int	yes		Reference key to the site, derived from dbo.[SITE].[ID]
SITESYSTEMID	uniqueidentifier	yes		dbo.[SITE].[ID]
MARKETINGSEGMENTATIONDIMID	int	yes		Reference key to the marketing segmentation dimension, derived from dbo.[MKTSEGMENTATION].[ID]