v_FACT_CONSTITUENTEMAILADDRESS
The Constituent Email Address fact tables contains information about constituent email addresses
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTEMAILADDRESSFACTID | int | BBDW.[FACT_CONSTITUENTEMAILADDRESS].[CONSTITUENTEMAILADDRESSFACTID] | |
| CONSTITUENTEMAILADDRESSSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTEMAILADDRESS].[CONSTITUENTEMAILADDRESSSYSTEMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_CONSTITUENTEMAILADDRESS].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTEMAILADDRESS].[CONSTITUENTSYSTEMID] |
| CONSTITUENTEMAILADDRESSTYPEDIMID | int | yes | BBDW.[FACT_CONSTITUENTEMAILADDRESS].[CONSTITUENTEMAILADDRESSTYPEDIMID] |
| EMAILADDRESS | UDT_EMAILADDRESS | BBDW.[FACT_CONSTITUENTEMAILADDRESS].[EMAILADDRESS] | |
| STARTDATEDIMID | int | yes | BBDW.[FACT_CONSTITUENTEMAILADDRESS].[STARTDATEDIMID] |
| ENDDATEDIMID | int | yes | BBDW.[FACT_CONSTITUENTEMAILADDRESS].[ENDDATEDIMID] |
| CONSTITUENTEMAILADDRESSDIMID | int | yes | BBDW.[FACT_CONSTITUENTEMAILADDRESS].[CONSTITUENTEMAILADDRESSDIMID] |
| CONSTITUENTEMAILADDRESSFLAGDIMID | int | yes | BBDW.[FACT_CONSTITUENTEMAILADDRESS].[CONSTITUENTEMAILADDRESSFLAGDIMID] |
| CONSTITUENTRELATIONSHIPFACTID | int | yes | BBDW.[FACT_CONSTITUENTEMAILADDRESS].[CONSTITUENTRELATIONSHIPFACTID] |
Definition
Copy
create view [BBDW].[v_FACT_CONSTITUENTEMAILADDRESS] as
select
[CONSTITUENTEMAILADDRESSFACTID],
[CONSTITUENTEMAILADDRESSSYSTEMID],
[CONSTITUENTDIMID],
[CONSTITUENTSYSTEMID],
[CONSTITUENTEMAILADDRESSTYPEDIMID],
[EMAILADDRESS],
[STARTDATEDIMID],
[ENDDATEDIMID],
[CONSTITUENTEMAILADDRESSDIMID],
[CONSTITUENTEMAILADDRESSFLAGDIMID],
[CONSTITUENTRELATIONSHIPFACTID]
from BBDW.[FACT_CONSTITUENTEMAILADDRESS]