v_FACT_CONSTITUENTADDRESSATTRIBUTE
The constituent address attribute fact table relates constituent address to their attributes.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTADDRESSATTRIBUTEFACTID | bigint | BBDW.[FACT_CONSTITUENTADDRESSATTRIBUTE].[CONSTITUENTADDRESSATTRIBUTEFACTID] | |
| ATTRIBUTEDIMID | int | yes | BBDW.[FACT_CONSTITUENTADDRESSATTRIBUTE].[ATTRIBUTEDIMID] |
| CONSTITUENTADDRESSFACTID | int | yes | BBDW.[FACT_CONSTITUENTADDRESSATTRIBUTE].[CONSTITUENTADDRESSFACTID] |
| CONSTITUENTADDRESSSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTADDRESSATTRIBUTE].[CONSTITUENTADDRESSSYSTEMID] |
| ATTRIBUTESTARTDATEDIMID | int | yes | BBDW.[FACT_CONSTITUENTADDRESSATTRIBUTE].[ATTRIBUTESTARTDATEDIMID] |
| ATTRIBUTESTARTDATE | datetime | yes | BBDW.[FACT_CONSTITUENTADDRESSATTRIBUTE].[ATTRIBUTESTARTDATE] |
| ATTRIBUTEENDDATEDIMID | int | yes | BBDW.[FACT_CONSTITUENTADDRESSATTRIBUTE].[ATTRIBUTEENDDATEDIMID] |
| ATTRIBUTEENDDATE | datetime | yes | BBDW.[FACT_CONSTITUENTADDRESSATTRIBUTE].[ATTRIBUTEENDDATE] |
| ATTRIBUTEVALUE | nvarchar(255) | yes | BBDW.[FACT_CONSTITUENTADDRESSATTRIBUTE].[ATTRIBUTEVALUE] |
| ATTRIBUTEISCURRENT | bit | yes | BBDW.[FACT_CONSTITUENTADDRESSATTRIBUTE].[ATTRIBUTEISCURRENT] |
| ATTRIBUTECOMMENT | nvarchar(255) | yes | BBDW.[FACT_CONSTITUENTADDRESSATTRIBUTE].[ATTRIBUTECOMMENT] |
Definition
Copy
CREATE view [BBDW].[v_FACT_CONSTITUENTADDRESSATTRIBUTE] as
select
ca.[CONSTITUENTADDRESSATTRIBUTEFACTID],
ca.[ATTRIBUTEDIMID],
ca.[CONSTITUENTADDRESSFACTID],
ca.[CONSTITUENTADDRESSSYSTEMID],
ca.[ATTRIBUTESTARTDATEDIMID],
ca.[ATTRIBUTESTARTDATE],
ca.[ATTRIBUTEENDDATEDIMID],
ca.[ATTRIBUTEENDDATE],
ca.[ATTRIBUTEVALUE],
ca.[ATTRIBUTEISCURRENT],
ca.[ATTRIBUTECOMMENT]
from
BBDW.[FACT_CONSTITUENTADDRESSATTRIBUTE] ca
left join BBDW.[DIM_ATTRIBUTE] a on ca.[ATTRIBUTEDIMID] = a.[ATTRIBUTEDIMID]
where (a.[ATTRIBUTEHASCODETABLE] = 1);