FACT_CONSTITUENTMAILPREFERENCE_STAGE

Intermediate storage for the constituent mail preference fact

Fields

Field	Field Type	Null	Notes	Description
CONSTITUENTMAILPREFERENCESYSTEMID	uniqueidentifier	yes		[dbo].[MAILPREFERENCE].[ID]
CONSTITUENTSYSTEMID	uniqueidentifier	yes		[dbo].[MAILPREFERENCE].[CONSTITUENTID]
CONSTITUENTADDRESSSYSTEMID	uniqueidentifier	yes		[dbo].[MAILPREFERENCE].[ADDRESSID]
CONSTITUENTEMAILADDRESSSYSTEMID	uniqueidentifier	yes		[dbo].[MAILPREFERENCE].[EMAILADDRESSID]
ACKNOWLEDGEMENTPROCESSDIMID	int	yes		Reference key to the process dimension, derived from [dbo].[MAILPREFERENCE].[ACKNOWLEDGEMENTID]
CORRESPONDENCEPROCESSDIMID	int	yes		Reference key to the process dimension, derived from [dbo].[MAILPREFERENCE].[CORRESPONDENCEID]
PLEDGEREMINDERPROCESSDIMID	int	yes		Reference key to the process dimension, derived from [dbo].[MAILPREFERENCE].[PLEDGEREMINDERID]
SENDMAIL	bit	yes		[dbo].[MAILPREFERENCE].[SENDMAIL]
USESEASONALADDRESS	bit	yes		[dbo].[MAILPREFERENCE].[USESEASONALADDRESS]
USEPRIMARYADDRESS	bit	yes		[dbo].[MAILPREFERENCE].[USEPRIMARYADDRESS]
USEPRIMARYEMAILADDRESS	bit	yes		[dbo].[MAILPREFERENCE].[USEPRIMARYEMAIL]
DONOTSENDOTHERCHANNEL	bit	yes		[dbo].[MAILPREFERENCE].[DONOTSENDOTHERCHANNEL]
CONSTITUENTMAILPREFERENCECOMMENT	nvarchar(500)	yes		[dbo].[MAILPREFERENCE].[COMMENTS]
MAILTYPECODE	tinyint	yes		[dbo].[MAILPREFERENCE].[MAILTYPECODE]
MAILTYPE	nvarchar(29)	yes		[dbo].[MAILPREFERENCE].[MAILTYPE]
BUSINESSUNITDIMID	int	yes		Reference key to the business unit dimension, derived from [dbo].[MAILPREFERENCE].[BUSINESSUNITCODEID]
APPEALCATEGORYSYSTEMID	uniqueidentifier	yes		[dbo].[MAILPREFERENCE].[CATEGORYCODEID]
APPEALCATEGORY	nvarchar(100)	yes		[dbo].[APPEALCATEGORYCODE].[DESCRIPTION]
SITEDIMID	int	yes		Reference key to the site dimension, derived from [dbo].[MAILPREFERENCE].[SITEID]
CORRESPONDENCECODESYSTEMID	uniqueidentifier	yes		[dbo].[MAILPREFERENCE].[CORRESPONDENCECODEID]
CORRESPONDENCECODE	nvarchar(255)	yes		[dbo].[CORRESPONDENCECODE].[DESCRIPTION]
RECEIPTTYPECODE	tinyint	yes		[dbo].[MAILPREFERENCE].[RECEIPTTYPECODE]
RECEIPTTYPE	nvarchar(13)	yes		[dbo].[MAILPREFERENCE].[RECEIPTTYPE]
DELIVERYMETHODCODE	tinyint	yes		[dbo].[MAILPREFERENCE].[DELIVERYMETHODCODE]
DELIVERYMETHOD	nvarchar(5)	yes		[dbo].[MAILPREFERENCE].[DELIVERYMETHOD]
EVENTCATEGORYCODESYSTEMID	uniqueidentifier	yes		[dbo].[MAILPREFERENCE].[EVENTCATEGORYCODEID]
EVENTCATEGORY	nvarchar(100)	yes		[dbo].[EVENTCATEGORYCODE].[DESCRIPTION]
PURPOSELEVELSYSTEMID	uniqueidentifier	yes		[dbo].[MAILPREFERENCE].[PURPOSEID]
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.
CONSTITUENTSOLICITCODESYSTEMID	uniqueidentifier	yes	Default = ('00000000-0000-0000-0000-000000000000')	[dbo].[CONSTITUENTSOLICITCODE].[ID]
HASINHERITEDCONSENT	bit	yes	Default = 0	[dbo].[MAILPREFERENCE].[HASINHERITEDCONSENT]
SOURCECODE	nvarchar(100)	yes	Default = ''	[dbo].[DATAPROTECTIONEVIDENCESOURCECODE].[DESCRIPTION]
SOURCEFILEPATH	nvarchar(260)	yes	Default = ''	[dbo].[MAILPREFERENCE].[SOURCEFILEPATH]
PRIVACYPOLICYFILEPATH	nvarchar(260)	yes	Default = ''	[dbo].[MAILPREFERENCE].[PRIVACYPOLICYFILEPATH]
SUPPORTINGINFORMATION	nvarchar(max)	yes	Default = ''	[dbo].[MAILPREFERENCE].[SUPPORTINGINFORMATION]
CONSENTSTATEMENT	nvarchar(max)	yes	Default = ''	[dbo].[MAILPREFERENCE].[CONSENTSTATEMENT]