v_DIM_CONSTITUENTEMAILADDRESS
The Constituent Email Address dimension contains information about constituent email addresses
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTEMAILADDRESSDIMID | int | BBDW.[DIM_CONSTITUENTEMAILADDRESS].[CONSTITUENTEMAILADDRESSDIMID] | |
| INFORMATIONSOURCESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTEMAILADDRESS].[INFORMATIONSOURCESYSTEMID] |
| INFORMATIONSOURCE | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTEMAILADDRESS].[INFORMATIONSOURCE] |
| ORIGIN | nvarchar(9) | yes | BBDW.[DIM_CONSTITUENTEMAILADDRESS].[ORIGIN] |
| ORIGINCODE | tinyint | yes | BBDW.[DIM_CONSTITUENTEMAILADDRESS].[ORIGINCODE] |
Definition
Copy
create view [BBDW].[v_DIM_CONSTITUENTEMAILADDRESS] as
select
[CONSTITUENTEMAILADDRESSDIMID],
[INFORMATIONSOURCESYSTEMID],
[INFORMATIONSOURCE],
[ORIGIN],
[ORIGINCODE]
from BBDW.[DIM_CONSTITUENTEMAILADDRESS]