FACT_CONSTITUENTEMAILADDRESS_STAGE

Intermediate storage for constituent email addresses

Fields

Field	Field Type	Null	Notes	Description
CONSTITUENTEMAILADDRESSSYSTEMID	uniqueidentifier			dbo.[EMAILADDRESS].[ID]
CONSTITUENTSYSTEMID	uniqueidentifier	yes		dbo.[EMAILADDRESS].[CONSTITUENTID]
CONSTITUENTEMAILADDRESSTYPEDIMID	int	yes		Reference key to the constituent email address type dimension, derived from dbo.[EMAILADDRESS].[EMAILADDRESSTYPECODEID]
EMAILADDRESS	nvarchar(100)	yes		dbo.[EMAILADDRESS].[EMAILADDRESS]
STARTDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[EMAILADDRESS].[STARTDATE]
STARTDATE	datetime	yes		dbo.[EMAILADDRESS].[STARTDATE]
ENDDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[EMAILADDRESS].[ENDDATE]
ENDDATE	datetime	yes		[dbo].[EMAILADDRESS].[ENDDATE]
CONSTITUENTEMAILADDRESSDIMID	int	yes		Reference key to the constituent email address dimension, derived from dbo.[EMAILADDRESS].[INFOSOURCECODEID] and dbo.[EMAILADDRESS].[ORIGINCODE]
CONSTITUENTEMAILADDRESSFLAGDIMID	int	yes		Reference key to the constituent email address flag dimension, derived from dbo.[EMAILADDRESS].[ISPRIMARY] and dbo.[EMAILADDRESS].[DONOTEMAIL]
CONSTITUENTRELATIONSHIPSYSTEMID	uniqueidentifier	yes		dbo.[EMAILADDRESS].[RELATIONSHIPID]
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.