DIM_MARKETINGSOURCECODEPART_STAGE

Staging table for the Marketing Source Code Part dimension

Fields

Field	Field Type	Null	Notes	Description
MARKETINGSOURCECODEPARTSYSTEMID	uniqueidentifier	yes		dbo.[MKTSOURCECODEMAPPART].[ID]
MARKETINGSOURCECODEDIMID	int	yes		Reference key to the marketing source code dimension, derived from dbo.[MKTSOURCECODEMAPPART].[MKTSOURCECODEMAPID]
PARTNAME	nvarchar(50)	yes		dbo.[MKTSOURCECODEPARTDEFINITION].[NAME]
PARTCODE	nvarchar(50)	yes		dbo.[MKTSOURCECODEMAPPART].[CODE]
DESCRIPTION	nvarchar(255)	yes		dbo.[MKTSOURCECODEPARTDEFINITIONVALUES].[DESCRIPTION]
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.