FACT_CONSTITUENTADDRESS_STAGE
Intermediate storage table for constituent addresses.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| CONSTITUENTADDRESSSYSTEMID | uniqueidentifier | yes | [dbo].[ADDRESS].[ID] | |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | [dbo].[ADDRESS].[CONSTITUENTID] | |
| CONSTITUENTADDRESSTYPEDIMID | int | yes | Reference key to the constituent address type dimension, derived using [dbo].[ADDRESS].[ADDRESSTYPECODEID] | |
| CONSTITUENTADDRESSFLAGDIMID | int | yes | Reference key to the constituent address flag dimension, derived using [dbo].[ADDRESS].[DONOTMAIL],[dbo].[ADDRESS].[ISCONFIDENTIAL], and [dbo].[ADDRESS].[ISPRIMARY] | |
| DONOTMAILREASONDIMID | int | yes | Reference key to the do not mail reason dimension, derived using [dbo].[ADDRESS].[DONOTMAILREASONCODEID] | |
| ADDRESSBLOCK | nvarchar(150) | yes | [dbo].[ADDRESS].[ADDRESSBLOCK] | |
| CITY | nvarchar(50) | yes | [dbo].[ADDRESS].[CITY] | |
| STATE | nvarchar(100) | yes | [dbo].[STATE].[DESCRIPTION] | |
| STATEABBREVIATION | nvarchar(50) | yes | [dbo].[STATE].[ABBREVIATION] | |
| COUNTRY | nvarchar(100) | yes | [dbo].[COUNTRY].[DESCRIPTION] | |
| COUNTRYABBREVIATION | nvarchar(5) | yes | [dbo].[COUNTRY].[ABBREVIATION] | |
| POSTCODE | nvarchar(12) | yes | [dbo].[ADDRESS].[POSTCODE] | |
| COUNTYCODESYSTEMID | uniqueidentifier | yes | [dbo].[ADDRESSVALIDATIONUPDATE].[COUNTYCODEID] | |
| COUNTY | nvarchar(100) | yes | [dbo].[COUNTYCODE].[DESCRIPTION] | |
| CONGRESSIONALDISTRICTCODESYSTEMID | uniqueidentifier | yes | [dbo].[ADDRESSVALIDATIONUPDATE].[CONGRESSIONALDISTRICTCODEID] | |
| CONGRESSIONALDISTRICT | nvarchar(100) | yes | [dbo].[CONGRESSIONALDISTRICTCODE].[DESCRIPTION] | |
| STATEHOUSEDISTRICTCODESYSTEMID | uniqueidentifier | yes | [dbo].[ADDRESSVALIDATIONUPDATE].[STATEHOUSEDISTRICTCODEID] | |
| STATEHOUSEDISTRICT | nvarchar(100) | yes | [dbo].[STATEHOUSEDISTRICTCODE].[DESCRIPTION] | |
| LOCALPRECINCTCODESYSTEMID | uniqueidentifier | yes | [dbo].[ADDRESSVALIDATIONUPDATE].[LOCALPRECINCTCODEID] | |
| LOCALPRECINCT | nvarchar(100) | yes | [dbo].[LOCALPRECINCTCODE].[DESCRIPTION] | |
| INFOSOURCECODESYSTEMID | uniqueidentifier | yes | [dbo].[ADDRESSVALIDATIONUPDATE].[INFOSOURCECODEID] | |
| INFOSOURCE | nvarchar(100) | yes | [dbo].[INFOSOURCECODE].[DESCRIPTION] | |
| REGIONCODESYSTEMID | uniqueidentifier | yes | [dbo].[ADDRESSVALIDATIONUPDATE].[REGIONCODEID] | |
| REGION | nvarchar(100) | yes | [dbo].[REGIONCODE].[DESCRIPTION] | |
| ORIGINCODE | tinyint | yes | [dbo].[ADDRESSVALIDATIONUPDATE].[ORIGINCODE] | |
| ORIGIN | nvarchar(10) | yes | [dbo].[ADDRESSVALIDATIONUPDATE].[ORIGIN] | |
| CART | nvarchar(10) | yes | [dbo].[ADDRESS].[CART] | |
| DPC | nvarchar(8) | yes | [dbo].[ADDRESS].[DPC] | |
| LOT | nvarchar(5) | yes | [dbo].[ADDRESS].[LOT] | |
| HISTORICALSTARTDATEDIMID | int | yes | Reference key to the date dimension, derived using [dbo].[ADDRESS].[HISTORICALSTARTDATE] | |
| HISTORICALSTARTDATE | datetime | yes | [dbo].[ADDRESS].[HISTORICALSTARTDATE] | |
| HISTORICALENDDATEDIMID | int | yes | Reference key to the date dimension, derived using [dbo].[ADDRESS].[HISTORICALENDDATE] | |
| HISTORICALENDDATE | datetime | yes | [dbo].[ADDRESS].[HISTORICALENDDATE] | |
| STARTMONTHDAY | char(4) | yes | [dbo].[ADDRESS].[STARTDATE] This is in the format of MMDD | |
| ENDMONTHDAY | char(4) | yes | [dbo].[ADDRESS].[ENDDATE] This is in the format of MMDD | |
| CONSTITUENTRELATIONSHIPSYSTEMID | uniqueidentifier | yes | [dbo].[ADDRESS].[RELATIONSHIPID] | |
| ISINCLUDED | bit | yes | Flag indicating when data should be included in results. | |
| SOURCEDIMID | int | yes | Source system used. | |
| ETLCONTROLID | int | yes | ID generated through the ETL process. | |
| STATESENATEDISTRICTSYSTEMID | uniqueidentifier | yes | dbo.[ADDRESSVALIDATIONUPDATE].[STATESENATEDISTRICTCODEID] | |
| STATESENATEDISTRICT | nvarchar(100) | yes | dbo.[STATESENATEDISTRICTCODE].[DESCRIPTION] | |
| ADDRESSLINE1 | nvarchar(150) | yes | First line in dbo.[ADDRESS].[ADDRESSBLOCK] | |
| ADDRESSLINE2 | nvarchar(150) | yes | Second line in dbo.[ADDRESS].[ADDRESSBLOCK] | |
| ADDRESSLINE3 | nvarchar(150) | yes | Third line in dbo.[ADDRESS].[ADDRESSBLOCK] | |
| ADDRESSLINE4 | nvarchar(150) | yes | Forth line in dbo.[ADDRESS].[ADDRESSBLOCK] | |
| ADDRESSLINE5 | nvarchar(150) | yes | Fifth line in dbo.[ADDRESS].[ADDRESSBLOCK] |