COAUPDATE (4.0SP9)

The AddressFinder is represented by this table.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
SITEID	uniqueidentifier	true	SITE.ID	Foreign key for site table.
DATATUNEUPID	uniqueidentifier	false	DATATUNEUP.ID	Foreign key to the data tune-up table.
BATCHID	uniqueidentifier	true	BATCH.ID	The batch instance into which the data will be imported.
BATCHAPPUSERID	uniqueidentifier	true	APPUSER.ID	Represents the user who will be the owner of the batch once it is created by the import process.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
ADDRESSTYPECODEID	uniqueidentifier	true	ADDRESSTYPECODE.ID	Set the former addresses to this address type.
FOOTNOTECODE1REASONCODEID	uniqueidentifier	true	DONOTMAILREASONCODE.ID	The do not mail reason that forwardable moves should be marked with.
FOOTNOTECODE2REASONCODEID	uniqueidentifier	true	DONOTMAILREASONCODE.ID	The do not mail reason that moves with no forwardable addresses should be marked with.
FOOTNOTECODE3REASONCODEID	uniqueidentifier	true	DONOTMAILREASONCODE.ID	The do not mail reason that PO box closings should be marked with.
FOOTNOTECODE4REASONCODEID	uniqueidentifier	true	DONOTMAILREASONCODE.ID	The do not mail reason that moves to foreign addresses should be marked with.
FOOTNOTECODE5REASONCODEID	uniqueidentifier	true	DONOTMAILREASONCODE.ID	The do not mail reason that moves without verifiable second addresses should be marked with.
FOOTNOTECODE6REASONCODEID	uniqueidentifier	true	DONOTMAILREASONCODE.ID	The do not mail reason that moves to addresses without USPS records should be marked with.
FOOTNOTECODE7REASONCODEID	uniqueidentifier	true	DONOTMAILREASONCODE.ID	The do not mail reason that temporary addresses that have lapsed should be marked with.
INFOSOURCECODEID	uniqueidentifier	true	INFOSOURCECODE.ID	The information source to mark addresses with.
MAILGRADEFREASONCODEID	uniqueidentifier	true	DONOTMAILREASONCODE.ID
PRIMARYCONTACTTITLECODEID	uniqueidentifier	true	TITLECODE.ID

Fields
Field	Field Type	Null	Notes	Description
NAME	nvarchar(150)	false	''	Name to be used if there is no site.
DESCRIPTION	nvarchar(250)	false	''	The description of the AddressFinder process.
DATELASTRUN	datetime	true		Stores the date of the list time one of the steps was run.
STEPCODE	tinyint	false	0	Tracks the most current state of the change of update process.
FILENAME	nvarchar(256)	false	''	The file name of the generated file that is to be uploaded to Blackbaud.
FILEUPLOADED	bit	false	0	Indicates whether the process created file has been uploaded to Blackbaud.
FILEAVAILABLE	bit	false	0	Indicates whether the file has been processed by Blackbaud and is available to download.
FILEDOWNLOADED	bit	false	0	Indicates whether the results file has been downloaded from Blackbaud.
PRIMARYCONTACTNAME	nvarchar(250)	false	''	The name of the primary person when data tune-up is complete.
PRIMARYCONTACTEMAIL	UDT_EMAILADDRESS	false	''	The email address of the primary contact when data tune-up is complete.
PRIMARYCONTACTPHONE	nvarchar(20)	false	''	The phone number of the primary contact when data tune-up is complete.
ALTERNATECONTACTNAME	nvarchar(250)	false	''	The name of the primary person when data tune-up is complete.
ALTERNATECONTACTEMAIL	UDT_EMAILADDRESS	false	''	The email address of the primary contact when data tune-up is complete.
ALTERNATECONTACTPHONE	nvarchar(20)	false	''	The phone number of the primary contact when data tune-up is complete.
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
UPDATEADDRESSCODE	tinyint	false	0	Update addresses with forwardable moves or changes and validations.
SAVEFORMERADDRESS	bit	false	0	Save former address in constituent address list when there is a forwardable move.
UPDATEADDRESS	nvarchar(24) (Computed)	true
SABOTENJOBID	uniqueidentifier	true
STEP	nvarchar(15) (Computed)	true

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_COAUPDATE_DATEADDED	DATEADDED	False	False	True
IX_COAUPDATE_DATECHANGED	DATECHANGED	False	False	False
PK_COAUPDATE	ID	True	True	False

Triggers
Trigger Name	Description
TR_COAUPDATE_AUDIT_UPDATE
TR_COAUPDATE_AUDIT_DELETE

Referenced by
Referenced by	Field
BATCHCOAUPDATE	COAUPDATEID
COAUPDATECREATEPROCESS	COAUPDATEID
COAUPDATEFILE	ID
COAUPDATEGETPROCESS	COAUPDATEID
COAUPDATERESUBMITPROCESS	COAUPDATEID
COAUPDATESUBMITPROCESS	COAUPDATEID