Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ADDRESSBLOCK nvarchar(150)   Default = '' Submitted address.
 CITY nvarchar(50)   Default = '' Submitted city.
 POSTCODE nvarchar(12)   Default = '' Submitted post code.
 STDADDRESSBLOCK nvarchar(150)   Default = '' Standardized address.
 STDCITY nvarchar(50)   Default = '' Standardized city.
 STDPOSTCODE nvarchar(12)   Default = '' Standardized post code.
 STDDPC nvarchar(8)   Default = '' Standardized delivery point code.
 STDCART nvarchar(10)   Default = '' Standardized address carrier route.
 STDLOT nvarchar(5)   Default = '' Standardized address LOT.
 COAADDRESSBLOCK nvarchar(150)   Default = '' Standardized address.
 COACITY nvarchar(50)   Default = '' Standardized city.
 COAPOSTCODE nvarchar(12)   Default = '' Standardized post code.
 COADPC nvarchar(8)   Default = '' Standardized delivery point code.
 COACART nvarchar(10)   Default = '' Standardized address carrier route.
 COALOT nvarchar(5)   Default = '' Standardized address LOT.
 NCOARETURNCODE tinyint   Default = 0 The NCOA return code.
 NCOAFOOTNOTECODE tinyint   Default = 0 The NCOA footnote code.
 NCOADPVFOOTNOTECODE tinyint   Default = 0 Contains the DPV footnote code.
 NCOADMASUPPRESSION bit   Default = 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   Default = 0 The NCOA mail grade code.
 ADDRESSCHANGED bit   Default = 0 Indicates if the address has changed from the validation or change of address result file.
 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.
 NCOAMOVEDATE UDT_FUZZYDATE   Default = '00000000' The NCOA move date.
 MOVETYPECODE tinyint   Default = 0 Indicates the type of move.
 MOVETYPE nvarchar(10) (Computed) CASE [MOVETYPECODE] WHEN 0 THEN N'None' WHEN 1 THEN N'Individual' WHEN 2 THEN N'Household' WHEN 3 THEN N'Business' END Provides a translation for the 'MOVETYPECODE' field.

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

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

Trigger Name Description
 TR_BATCHCOAUPDATE_AUDIT_UPDATE
 TR_BATCHCOAUPDATE_AUDIT_DELETE

Referenced by Field
 BATCHCOAUPDATEBATCHSYSTEMMESSAGES BATCHCOAUPDATEID
 BATCHCOAUPDATEBATCHUSERMESSAGE ID

Entity-Relationship diagram of this table