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 |