FACT_CONSTITUENTEMAILADDRESS

Contains information about constituent email addresses

Primary Key

Primary Key	Field Type
CONSTITUENTEMAILADDRESSFACTID	int

Fields

Field	Field Type	Null	Notes	Description
CONSTITUENTEMAILADDRESSSYSTEMID	uniqueidentifier	yes		dbo.[EMAILADDRESS].[ID]
CONSTITUENTDIMID	int	yes		Reference key to the Constituent dimension, derived from dbo.[EMAILADDRESS].[CONSTITUENTID]
CONSTITUENTSYSTEMID	uniqueidentifier	yes		dbo.[EMAILADDRESS].[CONSTITUENTID]
CONSTITUENTEMAILADDRESSTYPEDIMID	int	yes		Reference key to the constituent email address type dimension, derived from dbo.[EMAILADDRESS].[EMAILADDRESSTYPECODEID]
EMAILADDRESS	UDT_EMAILADDRESS			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]
CONSTITUENTRELATIONSHIPFACTID	int	yes		Reference key to the Constituent Relationship Fact, derived using dbo.[EMAILADDRESS].[RELATIONSHIPID]
CONSTITUENTRELATIONSHIPSYSTEMID	uniqueidentifier	yes		dbo.[EMAILADDRESS].[RELATIONSHIPID]
ISINCLUDED	bit	yes		ID generated through the ETL process.
ETLCONTROLID	int	yes		ID generated through the ETL process.
SOURCEDIMID	int	yes		Source system used.

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_FACT_CONSTITUENTEMAILADDRESS	CONSTITUENTEMAILADDRESSFACTID	yes	yes	yes