FACT_CONSTITUENTSOLICITCODE_STAGE

Intermediate storage table for FACT_CONSTITUENTSOLICITCODE

Fields

Field	Field Type	Null	Notes	Description
CONSTITUENTSOLICITCODESYSTEMID	uniqueidentifier	yes		[dbo].[CONSTITUENTSOLICITCODE].[ID]
CONSTITUENTSYSTEMID	uniqueidentifier	yes		[dbo].[CONSTITUENTSOLICITCODE].[CONSTITUENTID]
SOLICITCODEDIMID	int	yes		Reference key to the solicit code dimension, derived from [dbo].[CONSTITUENTSOLICITCODE].[SOLICITCODEID]
CONSTITUENTSOLICITCODESEQUENCE	int	yes		[dbo].[CONSTITUENTSOLICITCODE].[SEQUENCE]
CONSTITUENTSOLICITCODESTARTDATE	datetime	yes		[dbo].[CONSTITUENTSOLICITCODE].[STARTDATE]
CONSTITUENTSOLICITCODESTARTDATEDIMID	int	yes		Reference key to the date dimension, derived from [dbo].[CONSTITUENTSOLICITCODE].[STARTDATE]
CONSTITUENTSOLICITCODEENDDATE	datetime	yes		[dbo].[CONSTITUENTSOLICITCODE].[ENDDATE]
CONSTITUENTSOLICITCODEENDDATEDIMID	int	yes		Reference key to the date dimension, derived from [dbo].[CONSTITUENTSOLICITCODE].[ENDDATE]
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.
CONSTITUENTSOLICITCODECOMMENT	nvarchar(100)	yes		[dbo].[CONSTITUENTSOLICITCODE].[COMMENTS]
CONSTITUENTSOLICITCODECONSENTPREFERENCE	nvarchar(11)	yes		dbo.[CONSTITUENTSOLICITCODE].[CONSENTPREFERENCE]
CONSTITUENTSOLICITCODESOURCECODE	nvarchar(100)	yes		dbo.[DATAPROTECTIONEVIDENCESOURCECODE].[DESCRIPTION]
CONSTITUENTSOLICITCODESOURCEFILEPATH	nvarchar(260)	yes		dbo.[CONSTITUENTSOLICITCODE].[SOURCEFILEPATH]
CONSTITUENTSOLICITCODEPRIVACYPOLICYFILEPATH	nvarchar(260)	yes		dbo.[CONSTITUENTSOLICITCODE].[PRIVACYPOLICYFILEPATH]
CONSTITUENTSOLICITCODESUPPORTINGINFORMATION	nvarchar(max)	yes		dbo.[CONSTITUENTSOLICITCODE].[SUPPORTINGINFORMATION]
CONSTITUENTSOLICITCODECONSENTSTATEMENT	nvarchar(max)	yes		dbo.[CONSTITUENTSOLICITCODE].[CONSENTSTATEMENT]
SOLICITCODECHANNELOPTOUTSYSTEMID	uniqueidentifier	yes		dbo.[CONSTITUENTSOLICITCODE].[SOLICITCODECHANNELOPTOUTID]