Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ISPRIMARY bit   Default = 0 Indicates this address is the primary address.
 DONOTMAIL bit   Default = 0 Indicates this address should not recieve mailings.
 STARTDATE UDT_MONTHDAY   Default = '0000' For seasonal address types only; DD/MM start date of when this address should be considered for mailings.
 ENDDATE UDT_MONTHDAY   Default = '0000' For seasonal address types only; DD/MM end date of when this address should be considered for mailings.
 ADDRESSBLOCK nvarchar(150)   Default = '' Contains the address lines.
 CITY nvarchar(50)   Default = '' Contains the address city.
 POSTCODE nvarchar(12)   Default = '' Contains the address post code.
 CART nvarchar(10)   Default = '' Contains the address carrier route (CART).
 DPC nvarchar(8)   Default = '' Contains the address delivery point code
 LOT nvarchar(5)   Default = '' Contains the address LOT.
 SEQUENCE int   Default = 0 Stores the user-defined sequence for addresses on a constituent.
 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.
 DESCRIPTION nvarchar(300) (Computed) dbo.UFN_ADDRESS_TRANSLATE(ID) Provides a translation field for the address record
 HISTORICALSTARTDATE date Indicates the date that the constituent started using this address.
 HISTORICALENDDATE date Indicates the date that the constituent stopped using this address.
 ISCONFIDENTIAL bit   Default = 0 Indicates this address is confidential.

Foreign Key Field Type Null Notes Description
 CONSTITUENTID uniqueidentifier   CONSTITUENT.LOCALID FK to CONSTITUENT
 ADDRESSTYPECODEID uniqueidentifier ADDRESSTYPECODE.ID FK to ADDRESSTYPECODE
 COUNTRYID uniqueidentifier   COUNTRY.LOCALID FK to COUNTRY
 STATEID uniqueidentifier STATE.LOCALID FK to STATE
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 RELATIONSHIPID uniqueidentifier RELATIONSHIP.ID FK to RELATIONSHIP
 DONOTMAILREASONCODEID uniqueidentifier DONOTMAILREASONCODE.ID FK to DONOTMAILREASONCODE

Index Name Field(s) Unique Primary Clustered
 IX_ADDRESS_CONSTITUENTID CONSTITUENTID      
 IX_ADDRESS_CONSTITUENTID_ISPRIMARY CONSTITUENTID, ISPRIMARY      
 IX_ADDRESS_DATEADDED DATEADDED    
 IX_ADDRESS_DATECHANGED DATECHANGED      
 IX_ADDRESS_DONOTMAIL_ISPRIMARY_ADDRESSTYPECODEID DONOTMAIL, ISPRIMARY, ADDRESSTYPECODEID      
 IX_ADDRESS_ID ID      
 IX_ADDRESS_POSTCODE POSTCODE      
 IX_ADDRESS_RELATIONSHIPID_ID RELATIONSHIPID, ID      
 IX_ADDRESS_STATEID STATEID      
 IX_ADDRESS_STATEID_ADDRESSBLOCK_CITY_POSTCODE STATEID, ADDRESSBLOCK, CITY, POSTCODE      
 PK_ADDRESS ID  

Trigger Name Description
 TR_ADDRESS_INSERT_SEARCHCONSTITUENT
 TR_ADDRESS_INVALIDATE_COORDINATES
 TR_ADDRESS_UPDATE_SEARCHCONSTITUENT
 TR_ADDRESS_TASYNC_I
 TR_ADDRESS_TASYNC_U
 TR_ADDRESS_TASYNC_D
 TR_ADDRESS_DELETE_SEARCHCONSTITUENT
 TR_ADDRESS_AUDIT_UPDATE
 TR_ADDRESS_AUDIT_DELETE
 TR_ADDRESS_AUDIT_ETLDELETEDID

Referenced by Field
 ADDRESSCOORDINATES ADDRESSID
 ADDRESSVALIDATIONUPDATE ID
 BATCHADDRESSVALIDATION ADDRESSID
 BATCHCOAUPDATE ADDRESSID
 BATCHCONSTITUENTADDRESSUPDATE ADDRESSID
 BATCHCONSTITUENTUPDATEADDRESSES ADDRESSID
 BATCHCONSTITUENTUPDATEADDRESSES MANUALEXCEPTIONSIMILARADDRESSID
 BATCHEMAILFINDER ADDRESSID
 BATCHEVENTSPONSORSHIP ADDRESSID
 BATCHPEOPLEFINDER OLDADDRESSID
 BATCHPHONEFINDER ADDRESSID
 CREDITMEMO REMITADDRESSID
 CREDITPAYMENTCHECKPAYMENTMETHODDETAIL ADDRESSID
 DISBURSEMENTPROCESSDISBURSEMENT REMITADDRESSID
 DONATIONBATCH ADDRESSID
 INVOICE REMITADDRESSID
 MAILPREFERENCE ADDRESSID
 MAILPREFERENCEGROUPCONTACT ADDRESSID
 PLANNEDGIFTADDITIONASSET ADDRESSID
 PLANNEDGIFTASSET ADDRESSID
 REGISTRANTBATCH ADDRESSID
 SALESORDER ADDRESSID
 VENDOR REMITADDRESSID
 VENDOR1099SETTING ADDRESSID

Entity-Relationship diagram of this table (ADDRESSCOORDINATES-INVOICE)
Entity-Relationship diagram of this table (MAILPREFERENCE-VENDOR1099SETTING)