v_FACT_CONSTITUENTADDRESS
Contains information about constituent addresses.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTADDRESSFACTID | int | BBDW.[FACT_CONSTITUENTADDRESS].[CONSTITUENTADDRESSFACTID] | |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_CONSTITUENTADDRESS].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTADDRESS].[CONSTITUENTSYSTEMID] |
| CONSTITUENTADDRESSTYPEDIMID | int | yes | BBDW.[FACT_CONSTITUENTADDRESS].[CONSTITUENTADDRESSTYPEDIMID] |
| CONSTITUENTADDRESSFLAGDIMID | int | yes | BBDW.[FACT_CONSTITUENTADDRESS].[CONSTITUENTADDRESSFLAGDIMID] |
| DONOTMAILREASONDIMID | int | yes | BBDW.[FACT_CONSTITUENTADDRESS].[DONOTMAILREASONDIMID] |
| ADDRESSBLOCK | nvarchar(150) | yes | BBDW.[FACT_CONSTITUENTADDRESS].[ADDRESSBLOCK] |
| ADDRESSLINE1 | nvarchar(150) | yes | BBDW.[FACT_CONSTITUENTADDRESS].[ADDRESSLINE1] |
| ADDRESSLINE2 | nvarchar(150) | yes | BBDW.[FACT_CONSTITUENTADDRESS].[ADDRESSLINE2] |
| ADDRESSLINE3 | nvarchar(150) | yes | BBDW.[FACT_CONSTITUENTADDRESS].[ADDRESSLINE3] |
| ADDRESSLINE4 | nvarchar(150) | yes | BBDW.[FACT_CONSTITUENTADDRESS].[ADDRESSLINE4] |
| ADDRESSLINE5 | nvarchar(150) | yes | BBDW.[FACT_CONSTITUENTADDRESS].[ADDRESSLINE5] |
| CONSTITUENTADDRESSDIMID | int | yes | BBDW.[FACT_CONSTITUENTADDRESS].[CONSTITUENTADDRESSDIMID] |
| CONSTITUENTADDRESSDETAILDIMID | int | yes | BBDW.[FACT_CONSTITUENTADDRESS].[CONSTITUENTADDRESSDETAILDIMID] |
| CART | nvarchar(10) | yes | BBDW.[FACT_CONSTITUENTADDRESS].[CART] |
| DPC | nvarchar(8) | yes | BBDW.[FACT_CONSTITUENTADDRESS].[DPC] |
| LOT | nvarchar(5) | yes | BBDW.[FACT_CONSTITUENTADDRESS].[LOT] |
| HISTORICALSTARTDATEDIMID | int | yes | BBDW.[FACT_CONSTITUENTADDRESS].[HISTORICALSTARTDATEDIMID] |
| HISTORICALENDDATEDIMID | int | yes | BBDW.[FACT_CONSTITUENTADDRESS].[HISTORICALENDDATEDIMID] |
| STARTMONTHDAY | UDT_MONTHDAY | BBDW.[FACT_CONSTITUENTADDRESS].[STARTMONTHDAY] | |
| ENDMONTHDAY | UDT_MONTHDAY | BBDW.[FACT_CONSTITUENTADDRESS].[ENDMONTHDAY] | |
| CONSTITUENTRELATIONSHIPFACTID | int | yes | BBDW.[FACT_CONSTITUENTADDRESS].[CONSTITUENTRELATIONSHIPFACTID] |
| CONSTITUENTINFORMATIONDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTINFORMATIONDIMID] |
| CONSTITUENTAGE | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTAGE] |
| CONSTITUENTDEMOGRAPHICDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTDEMOGRAPHICDIMID] |
Definition
Copy
CREATE view [BBDW].[v_FACT_CONSTITUENTADDRESS] as
select
ca.[CONSTITUENTADDRESSFACTID],
ca.[CONSTITUENTDIMID],
ca.[CONSTITUENTSYSTEMID],
ca.[CONSTITUENTADDRESSTYPEDIMID],
ca.[CONSTITUENTADDRESSFLAGDIMID],
ca.[DONOTMAILREASONDIMID],
ca.[ADDRESSBLOCK],
ca.[ADDRESSLINE1],
ca.[ADDRESSLINE2],
ca.[ADDRESSLINE3],
ca.[ADDRESSLINE4],
ca.[ADDRESSLINE5],
ca.[CONSTITUENTADDRESSDIMID],
ca.[CONSTITUENTADDRESSDETAILDIMID],
ca.[CART],
ca.[DPC],
ca.[LOT],
ca.[HISTORICALSTARTDATEDIMID],
ca.[HISTORICALENDDATEDIMID],
ca.[STARTMONTHDAY],
ca.[ENDMONTHDAY],
ca.[CONSTITUENTRELATIONSHIPFACTID],
c.[CONSTITUENTINFORMATIONDIMID],
c.[AGE] as [CONSTITUENTAGE],
c.[CONSTITUENTDEMOGRAPHICDIMID]
from BBDW.[FACT_CONSTITUENTADDRESS] ca
left join BBDW.[DIM_CONSTITUENT] c on ca.[CONSTITUENTDIMID] = c.[CONSTITUENTDIMID]