| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 ADDRESSBLOCK |
nvarchar(150) | Default = '' | ||
| CITY |
nvarchar(50) | Default = '' | ||
| POSTCODE |
nvarchar(12) | Default = '' | ||
| ISPRIMARY |
bit | Default = 0 | ||
| DONOTMAIL |
bit | Default = 0 | ||
| UPDATEMATCHINGSPOUSEADDRESSES |
bit | Default = 0 | ||
| SEQUENCE |
int | Default = 0 | ||
| 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. |
| CART |
nvarchar(10) | Default = '' | ||
| DPC |
nvarchar(8) | Default = '' | ||
| LOT |
nvarchar(5) | Default = '' | ||
| OMITFROMVALIDATION |
bit | Default = 0 | ||
| LASTVALIDATIONATTEMPTDATE |
datetime | |
||
| VALIDATIONMESSAGE |
nvarchar(200) | Default = '' | ||
| CERTIFICATIONDATA |
int | Default = 0 | ||
| STARTDATE |
UDT_MONTHDAY | Default = '0000' | For seasonal address types only; DD/MM start date of when this address should be considered for mailings. | |
| ENDDATE |
UDT_MONTHDAY | Default = '0000' | For seasonal address types only; DD/MM end date of when this address should be considered for mailings. | |
| UPDATEMATCHINGHOUSEHOLDADDRESSES |
bit | Default = 0 |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 BATCHID |
uniqueidentifier | BATCH.ID | FK to BATCH | |
| ADDRESSID |
uniqueidentifier | |
ADDRESS.LOCALID | FK to ADDRESS |
| ADDRESSTYPECODEID |
uniqueidentifier | |
ADDRESSTYPECODE.ID | FK to ADDRESSTYPECODE |
| COUNTRYID |
uniqueidentifier | COUNTRY.LOCALID | FK to COUNTRY | |
| STATEID |
uniqueidentifier | |
STATE.LOCALID | FK to STATE |
| ADDEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| CHANGEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| COUNTYCODEID |
uniqueidentifier | |
COUNTYCODE.LOCALID | FK to COUNTYCODE |
| 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 |
| INFOSOURCECODEID |
uniqueidentifier | |
INFOSOURCECODE.ID | FK to INFOSOURCECODE |
| REGIONCODEID |
uniqueidentifier | |
REGIONCODE.LOCALID | FK to REGIONCODE |
| DONOTMAILREASONCODEID |
uniqueidentifier | |
DONOTMAILREASONCODE.ID | FK to DONOTMAILREASONCODE |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_BATCHCONSTITUENTADDRESSUPDATE_ADDRESSID |
ADDRESSID | |||
| IX_BATCHCONSTITUENTADDRESSUPDATE_BATCHID |
BATCHID | |||
 IX_BATCHCONSTITUENTADDRESSUPDATE_DATEADDED |
DATEADDED | |
||
| IX_BATCHCONSTITUENTADDRESSUPDATE_DATECHANGED |
DATECHANGED | |||
| PK_BATCHCONSTITUENTADDRESSUPDATE |
ID | |
|
| Trigger Name | Description |
|---|---|
 TR_BATCHCONSTITUENTADDRESSUPDATE_AUDIT_UPDATE |
|
| TR_BATCHCONSTITUENTADDRESSUPDATE_AUDIT_DELETE |
| Referenced by | Field |
|---|---|
 BATCHCONSTITUENTADDRESSUPDATEBATCHSYSTEMMESSAGES |
BATCHCONSTITUENTADDRESSUPDATEID |
| BATCHCONSTITUENTADDRESSUPDATEBATCHUSERMESSAGE |
ID |