| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 SEQUENCE |
int | Default = 0 | ||
| ADDRESSBLOCK |
nvarchar(150) | Default = '' | ||
| CITY |
nvarchar(max) | Default = '' | ||
| POSTCODE |
nvarchar(12) | Default = '' | ||
| HISTORICALSTARTDATE |
date |  |
||
| ISPRIMARY |
bit | Default = 0 | ||
| DONOTMAIL |
bit | Default = 0 | ||
| UPDATEHOUSEHOLD |
bit | Default = 0 | ||
| STARTDATE |
UDT_MONTHDAY | Default = '0000' | ||
| ENDDATE |
UDT_MONTHDAY | Default = '0000' | ||
| DPC |
nvarchar(max) | Default = '' | ||
| CART |
nvarchar(max) | Default = '' | ||
| LOT |
nvarchar(5) | Default = '' | ||
| CERTIFICATIONDATA |
int | Default = 0 | ||
| LASTVALIDATIONATTEMPTDATE |
date | |
||
| OMITFROMVALIDATION |
bit | Default = 0 | ||
| VALIDATIONMESSAGE |
nvarchar(200) | Default = '' | ||
| DATEADDED |
datetime | Default = getdate() | Indicates the date this record was added. | |
| DATECHANGED |
datetime | Default = getdate() | Indicates the date this record was last changed. | |
| TS |
timestamp | Timestamp. | ||
 TSLONG |
bigint (Computed) | |
CONVERT(bigint, TS) | Numeric representation of the timestamp. |
| INFOSOURCECOMMENTS |
nvarchar(256) | Default = '' | Contains additional comments about the information source. | |
| HISTORICALENDDATE |
date | |
||
| ISMANUALEXCEPTION |
bit | Default = 0 |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 BATCHCONSTITUENTUPDATEID |
uniqueidentifier | BATCHCONSTITUENTUPDATE.ID | FK to BATCHCONSTITUENTUPDATE | |
| ADDRESSTYPECODEID |
uniqueidentifier | |
ADDRESSTYPECODE.ID | FK to ADDRESSTYPECODE |
| COUNTRYID |
uniqueidentifier | COUNTRY.LOCALID | FK to COUNTRY | |
| STATEID |
uniqueidentifier | |
STATE.LOCALID | FK to STATE |
| DONOTMAILREASONCODEID |
uniqueidentifier | |
DONOTMAILREASONCODE.ID | FK to DONOTMAILREASONCODE |
| INFOSOURCECODEID |
uniqueidentifier | |
INFOSOURCECODE.ID | FK to INFOSOURCECODE |
| COUNTYCODEID |
uniqueidentifier | |
COUNTYCODE.LOCALID | FK to COUNTYCODE |
| REGIONCODEID |
uniqueidentifier | |
REGIONCODE.LOCALID | FK to REGIONCODE |
| CONGRESSIONALDISTRICTCODEID |
uniqueidentifier | |
CONGRESSIONALDISTRICTCODE.ID | FK to CONGRESSIONALDISTRICTCODE |
| STATEHOUSEDISTRICTCODEID |
uniqueidentifier | |
STATEHOUSEDISTRICTCODE.ID | FK to STATEHOUSEDISTRICTCODE |
| STATESENATEDISTRICTCODEID |
uniqueidentifier | |
STATESENATEDISTRICTCODE.ID | FK to STATESENATEDISTRICTCODE |
| LOCALPRECINCTCODEID |
uniqueidentifier | |
LOCALPRECINCTCODE.ID | FK to LOCALPRECINCTCODE |
| ADDEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| CHANGEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| ADDRESSID |
uniqueidentifier | |
ADDRESS.LOCALID | FK to ADDRESS |
| MANUALEXCEPTIONSIMILARADDRESSID |
uniqueidentifier | |
ADDRESS.LOCALID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_BATCHCONSTITUENTUPDATEADDRESSES_ADDRESSID |
ADDRESSID | |||
| IX_BATCHCONSTITUENTUPDATEADDRESSES_BATCHCONSTITUENTUPDATEID |
BATCHCONSTITUENTUPDATEID | |||
 IX_BATCHCONSTITUENTUPDATEADDRESSES_DATEADDED |
DATEADDED | |
||
| IX_BATCHCONSTITUENTUPDATEADDRESSES_DATECHANGED |
DATECHANGED | |||
| PK_BATCHCONSTITUENTUPDATEADDRESSES |
ID | |
|
| Trigger Name | Description |
|---|---|
 TR_BATCHCONSTITUENTUPDATEADDRESSES_AUDIT_UPDATE |
|
| TR_BATCHCONSTITUENTUPDATEADDRESSES_AUDIT_DELETE |
| Referenced by | Field |
|---|---|
 BATCHREVENUECONSTITUENTEDITINFO |
BATCHCONSTITUENTUPDATEADDRESSESID |