v_DIM_CONSTITUENTADDRESSDETAIL
Contains additional information about constituent addresses.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTADDRESSDETAILDIMID | int | BBDW.[DIM_CONSTITUENTADDRESSDETAIL].[CONSTITUENTADDRESSDETAILDIMID] | |
| COUNTYCODESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTADDRESSDETAIL].[COUNTYCODESYSTEMID] |
| COUNTY | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTADDRESSDETAIL].[COUNTY] |
| CONGRESSIONALDISTRICTCODESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTADDRESSDETAIL].[CONGRESSIONALDISTRICTCODESYSTEMID] |
| CONGRESSIONALDISTRICT | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTADDRESSDETAIL].[CONGRESSIONALDISTRICT] |
| STATEHOUSEDISTRICTCODESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTADDRESSDETAIL].[STATEHOUSEDISTRICTCODESYSTEMID] |
| STATEHOUSEDISTRICT | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTADDRESSDETAIL].[STATEHOUSEDISTRICT] |
| STATESENATEDISTRICTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTADDRESSDETAIL].[STATESENATEDISTRICTSYSTEMID] |
| STATESENATEDISTRICT | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTADDRESSDETAIL].[STATESENATEDISTRICT] |
| LOCALPRECINCTCODESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTADDRESSDETAIL].[LOCALPRECINCTCODESYSTEMID] |
| LOCALPRECINCT | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTADDRESSDETAIL].[LOCALPRECINCT] |
| INFOSOURCECODESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTADDRESSDETAIL].[INFOSOURCECODESYSTEMID] |
| INFOSOURCE | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTADDRESSDETAIL].[INFOSOURCE] |
| REGIONCODESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTADDRESSDETAIL].[REGIONCODESYSTEMID] |
| REGION | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTADDRESSDETAIL].[REGION] |
| ORIGINCODE | tinyint | yes | BBDW.[DIM_CONSTITUENTADDRESSDETAIL].[ORIGINCODE] |
| ORIGIN | nvarchar(10) | yes | BBDW.[DIM_CONSTITUENTADDRESSDETAIL].[ORIGIN] |
Definition
Copy
CREATE view [BBDW].[v_DIM_CONSTITUENTADDRESSDETAIL] as
select
cad.[CONSTITUENTADDRESSDETAILDIMID],
cad.[COUNTYCODESYSTEMID],
cad.[COUNTY],
cad.[CONGRESSIONALDISTRICTCODESYSTEMID],
cad.[CONGRESSIONALDISTRICT],
cad.[STATEHOUSEDISTRICTCODESYSTEMID],
cad.[STATEHOUSEDISTRICT],
cad.[STATESENATEDISTRICTSYSTEMID],
cad.[STATESENATEDISTRICT],
cad.[LOCALPRECINCTCODESYSTEMID],
cad.[LOCALPRECINCT],
cad.[INFOSOURCECODESYSTEMID],
cad.[INFOSOURCE],
cad.[REGIONCODESYSTEMID],
cad.[REGION],
cad.[ORIGINCODE],
cad.[ORIGIN]
from BBDW.[DIM_CONSTITUENTADDRESSDETAIL] cad