BATCHCOAUPDATE (4.0SP5)

Stores

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
BATCHID	uniqueidentifier	false	BATCH.ID	Foreign key to the batch table.
COAUPDATEID	uniqueidentifier	false	COAUPDATE.ID	Foreign key to the AddressFinder table.
ADDRESSID	uniqueidentifier	true	ADDRESS.ID	Foreigh key to the address table.
CONSTITUENTID	uniqueidentifier	true	CONSTITUENT.ID	Foreigh key to the constituent table.
STATEID	uniqueidentifier	true	STATE.ID	Submitted state.
STDSTATEID	uniqueidentifier	true	STATE.ID	Standardized state.
COASTATEID	uniqueidentifier	true	STATE.ID	Standardized state.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.

Fields
Field	Field Type	Null	Notes	Description
ADDRESSBLOCK	nvarchar(150)	false	''	Submitted address.
CITY	nvarchar(50)	false	''	Submitted city.
POSTCODE	nvarchar(12)	false	''	Submitted post code.
STDADDRESSBLOCK	nvarchar(150)	false	''	Standardized address.
STDCITY	nvarchar(50)	false	''	Standardized city.
STDPOSTCODE	nvarchar(12)	false	''	Standardized post code.
STDDPC	nvarchar(8)	false	''	Standardized delivery point code.
STDCART	nvarchar(10)	false	''	Standardized address carrier route.
STDLOT	nvarchar(5)	false	''	Standardized address LOT.
COAADDRESSBLOCK	nvarchar(150)	false	''	Standardized address.
COACITY	nvarchar(50)	false	''	Standardized city.
COAPOSTCODE	nvarchar(12)	false	''	Standardized post code.
COADPC	nvarchar(8)	false	''	Standardized delivery point code.
COACART	nvarchar(10)	false	''	Standardized address carrier route.
COALOT	nvarchar(5)	false	''	Standardized address LOT.
NCOARETURNCODE	tinyint	false	0	The NCOA return code.
NCOAFOOTNOTECODE	tinyint	false	0	The NCOA footnote code.
NCOADPVFOOTNOTECODE	tinyint	false	0	Contains the DPV footnote code.
NCOADMASUPPRESSION	bit	false	0	Contains the DMA suppression returned by NCOA. The DMA suppression flag notifies a mailer that the input record is a consumer who has indicated that they do not prefer to receive advertising mail at home
NCOAMAILGRADECODE	tinyint	false	0	The NCOA mail grade code.
ADDRESSCHANGED	bit	false	0	Indicates if the address has changed from the validation or change of address result file.
SEQUENCE	int	false	0
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.
NCOAMOVEDATE	UDT_FUZZYDATE	false	'00000000'	The NCOA move date.
MOVETYPECODE	tinyint	false	0	Indicates the type of move.
MOVETYPE	nvarchar(10) (Computed)	true		Provides a translation for the 'MOVETYPECODE' field.

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_BATCHCOAUPDATE_ADDRESSID	ADDRESSID	False	False	False
IX_BATCHCOAUPDATE_CONSTITUENTID	CONSTITUENTID	False	False	False
IX_BATCHCOAUPDATE_DATEADDED	DATEADDED	False	False	True
IX_BATCHCOAUPDATE_DATECHANGED	DATECHANGED	False	False	False
PK_BATCHCOAUPDATE	ID	True	True	False

Triggers
Trigger Name	Description
TR_BATCHCOAUPDATE_AUDIT_UPDATE
TR_BATCHCOAUPDATE_AUDIT_DELETE

Referenced by
Referenced by	Field
BATCHCOAUPDATEBATCHSYSTEMMESSAGES	BATCHCOAUPDATEID
BATCHCOAUPDATEBATCHUSERMESSAGE	ID