| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 SEQUENCE |
int | Default = 0 | Sequence | |
| BIOLOGICALINFORMATION |
xml |  |
||
| PHONEINFORMATION |
xml | |
||
| EMAILADDRESSINFORMATION |
xml | |
||
| 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. |
| HOMEADDRESSINFORMATION |
xml | |
||
| BUSINESSADDRESSINFORMATION |
xml | |
||
| OTHERADDRESSINFORMATION |
xml | |
||
| CREATENEWBUSINESSADDRESS |
bit | Default = 0 | ||
| CREATENEWHOMEADDRESS |
bit | Default = 0 | ||
| CREATENEWOTHERADDRESS |
bit | Default = 0 | ||
| PROCESS |
bit | Default = 1 | ||
| DONOTMAILBUSINESSADDRESS |
bit | Default = 0 | ||
| DONOTMAILHOMEADDRESS |
bit | Default = 0 | ||
| DONOTMAILOTHERADDRESS |
bit | Default = 0 |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 BATCHID |
uniqueidentifier | BATCH.ID | FK to BATCH | |
| CONSTITUENTID |
uniqueidentifier | CONSTITUENT.LOCALID | FK to CONSTITUENT | |
| CHANGEDBYAPPUSERID |
uniqueidentifier | APPUSER.ID | FK to APPUSER | |
| ADDEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| CHANGEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| NEWBUSINESSADDRESSTYPECODEID |
uniqueidentifier | |
ADDRESSTYPECODE.ID | FK to ADDRESSTYPECODE |
| NEWHOMEADDRESSTYPECODEID |
uniqueidentifier | |
ADDRESSTYPECODE.ID | FK to ADDRESSTYPECODE |
| NEWOTHERADDRESSTYPECODEID |
uniqueidentifier | |
ADDRESSTYPECODE.ID | FK to ADDRESSTYPECODE |
| INFOSOURCECODEID |
uniqueidentifier | |
INFOSOURCECODE.ID | FK to INFOSOURCECODE |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_EXCHANGECONTACTBATCH_BATCHID |
BATCHID | |||
| IX_EXCHANGECONTACTBATCH_CHANGEDBYAPPUSERID |
CHANGEDBYAPPUSERID | |||
| IX_EXCHANGECONTACTBATCH_CONSTITUENTID |
CONSTITUENTID | |||
 IX_EXCHANGECONTACTBATCH_DATEADDED |
DATEADDED | |
||
| IX_EXCHANGECONTACTBATCH_DATECHANGED |
DATECHANGED | |||
| IX_EXCHANGECONTACTBATCH_NEWBUSINESSADDRESSTYPECODEID |
NEWBUSINESSADDRESSTYPECODEID | |||
| IX_EXCHANGECONTACTBATCH_NEWHOMEADDRESSTYPECODEID |
NEWHOMEADDRESSTYPECODEID | |||
| IX_EXCHANGECONTACTBATCH_NEWOTHERADDRESSTYPECODEID |
NEWOTHERADDRESSTYPECODEID | |||
| PK_EXCHANGECONTACTBATCH |
ID | |
|
| Trigger Name | Description |
|---|---|
 TR_EXCHANGECONTACTBATCH_AUDIT_UPDATE |
|
| TR_EXCHANGECONTACTBATCH_AUDIT_DELETE |
| Referenced by | Field |
|---|---|
 EXCHANGECONTACTBATCHBATCHSYSTEMMESSAGES |
EXCHANGECONTACTBATCHID |
| EXCHANGECONTACTBATCHBATCHUSERMESSAGE |
ID |