| CONSTITUENTADDRESSSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[ADDRESS].[ID] |
| CONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived using [dbo].[ADDRESS].[CONSTITUENTID] |
| 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] |
| CONSTITUENTADDRESSDIMID |
int |
yes |
|
Reference key to the constituent address dimension, derived using [dbo].[ADDRESS].[CITY], [dbo].[ADDRESS].[STATE], [dbo].[ADDRESS].[COUNTRY], and [dbo].[ADDRESS].[POSTCODE] |
| CONSTITUENTADDRESSDETAILDIMID |
int |
yes |
|
Reference key to the constituent address detail dimension, derived using [dbo].[ADDRESSVALIDATIONUPDATE].[COUNTYCODEID], [dbo].[ADDRESSVALIDATIONUPDATE].[CONGRESSIONALDISTRICTCODEID], [dbo].[ADDRESSVALIDATIONUPDATE].[STATEHOUSEDISTRICTCODEID], [dbo].[ADDRESSVALIDATIONUPDATE].[LOCALPRECINCTCODEID], [dbo].[ADDRESSVALIDATIONUPDATE].[INFOSOURCECODEID], [dbo].[ADDRESSVALIDATIONUPDATE].[REGIONCODEID], and [dbo].[ADDRESSVALIDATIONUPDATE].[ORIGINCODE] |
| 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 |
UDT_MONTHDAY |
|
|
[dbo].[ADDRESS].[STARTDATE] This is in the format of MMDD |
| ENDMONTHDAY |
UDT_MONTHDAY |
|
|
[dbo].[ADDRESS].[ENDDATE] This is in the format of MMDD |
| CONSTITUENTRELATIONSHIPFACTID |
int |
yes |
|
Reference key to the constituent relationship fact, derived using [dbo].[ADDRESS].[RELATIONSHIPID] |
| CONSTITUENTRELATIONSHIPSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[ADDRESS].[RELATIONSHIPID] |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| ETLCONTROLID |
int |
yes |
|
ID generated through the ETL process. |
| SOURCEDIMID |
int |
yes |
|
Source system used. |
| 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] |