Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SEQUENCE int   Default = 0
 CONSTITUENTTYPECODE tinyint   Default = 0 0=Individual, 1=Organization, 2=Household, 3=Constituent group
 CONSTITUENTTYPE nvarchar(17) (Computed) CASE [CONSTITUENTTYPECODE] WHEN 0 THEN N'Individual' WHEN 1 THEN N'Organization' WHEN 2 THEN N'Household' WHEN 3 THEN N'Constituent group' END Provides a translation for the 'CONSTITUENTTYPECODE' field.
 BIRTHDATE UDT_FUZZYDATE   Default = '00000000'
 FIRSTNAME nvarchar(50)   Default = ''
 GENDERCODE tinyint   Default = 0 0=Unknown, 1=Male, 2=Female
 GENDER nvarchar(7) (Computed) CASE [GENDERCODE] WHEN 0 THEN N'Unknown' WHEN 1 THEN N'Male' WHEN 2 THEN N'Female' END Provides a translation for the 'GENDERCODE' field.
 GIVESANONYMOUSLY bit   Default = 0
 KEYNAME nvarchar(100)   Default = ''
 LOOKUP_ID nvarchar(100)   Default = ''
 MAIDENNAME nvarchar(100)   Default = ''
 MIDDLENAME nvarchar(50)   Default = ''
 NICKNAME nvarchar(50)   Default = ''
 WEBADDRESS UDT_WEBADDRESS   Default = ''
 DECEASED bit   Default = 0
 DECEASEDDATE UDT_FUZZYDATE   Default = '00000000'
 CONSTITUENT_SITEID uniqueidentifier
 GROUPTYPEID uniqueidentifier
 GROUPDESCRIPTION nvarchar(300)   Default = ''
 GROUPSTARTDATE date
 ORG_NUMEMPLOYEES int   Default = 0
 ORG_NUMSUBSIDIARIES int   Default = 0
 SPOUSE_FIRSTNAME nvarchar(50)   Default = ''
 SPOUSE_NICKNAME nvarchar(50)   Default = ''
 SPOUSE_MIDDLENAME nvarchar(50)   Default = ''
 SPOUSE_MAIDENNAME nvarchar(100)   Default = ''
 SPOUSE_LASTNAME nvarchar(100)   Default = ''
 SPOUSE_BIRTHDATE UDT_FUZZYDATE   Default = '00000000'
 SPOUSE_GENDERCODE tinyint   Default = 0 0=Unknown, 1=Male, 2=Female
 SPOUSE_GENDER nvarchar(7) (Computed) CASE [SPOUSE_GENDERCODE] WHEN 0 THEN N'Unknown' WHEN 1 THEN N'Male' WHEN 2 THEN N'Female' END Provides a translation for the 'SPOUSE_GENDERCODE' field.
 SPOUSE_LOOKUPID nvarchar(100)   Default = ''
 BUSINESS_ADDRESSBLOCK nvarchar(150)   Default = ''
 BUSINESS_CART nvarchar(10)   Default = ''
 BUSINESS_CITY nvarchar(50)   Default = ''
 BUSINESS_DONOTMAIL bit   Default = 0
 BUSINESS_DPC nvarchar(8)   Default = ''
 BUSINESS_EMAILADDRESS UDT_EMAILADDRESS   Default = ''
 BUSINESS_LOOKUPID nvarchar(100)   Default = ''
 BUSINESS_LOT nvarchar(5)   Default = ''
 BUSINESS_NAME nvarchar(100)   Default = ''
 BUSINESS_NUMEMPLOYEES int   Default = 0
 BUSINESS_NUMSUBSIDIARIES int   Default = 0
 BUSINESS_PHONENUMBER nvarchar(100)   Default = ''
 BUSINESS_WEBADDRESS UDT_WEBADDRESS   Default = ''
 BUSINESS_POSTCODE nvarchar(12)   Default = ''
 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.
 BUSINESS_PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit   Default = 0
 BUSINESS_PRIMARYSOFTCREDITMATCHFACTOR decimal(5, 2)   Default = 0
 BUSINESS_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit   Default = 0
 BUSINESS_RECIPROCALSOFTCREDITMATCHFACTOR decimal(5, 2)   Default = 0
 BUSINESS_EMAILADDRESSSTARTDATE date
 SPOUSE_PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit   Default = 0
 SPOUSE_PRIMARYSOFTCREDITMATCHFACTOR decimal(5, 2)   Default = 0
 SPOUSE_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit   Default = 0
 SPOUSE_RECIPROCALSOFTCREDITMATCHFACTOR decimal(5, 2)   Default = 0
 REMOVESPOUSE bit   Default = 0
 DOMANUALREVIEWFORAUTOMATCH bit   Default = 0
 DIFFERENTPHONECODE tinyint   Default = 3
 NEWPHONEENDDATECODE tinyint   Default = 0
 NEWPHONEPRIMARYCODE tinyint   Default = 1
 DIFFERENTEMAILCODE tinyint   Default = 3
 NEWEMAILENDDATECODE tinyint   Default = 0
 NEWEMAILPRIMARYCODE tinyint   Default = 1
 USEGLOBALSETTINGS bit   Default = 1
 DIFFERENTEMAIL nvarchar(42) (Computed) CASE [DIFFERENTEMAILCODE] WHEN 0 THEN N'Ignore email address' WHEN 3 THEN N'Add as new email address' WHEN 2 THEN N'Require manual review (generate exception)' END
 CREATEHISTORICALNAMECODE tinyint   Default = 1
 CREATEHISTORICALNAME nvarchar(3) (Computed) CASE [CREATEHISTORICALNAMECODE] WHEN 0 THEN N'No' WHEN 1 THEN N'Yes' END
 NAMECODE tinyint   Default = 1
 SIMILARADDRESSCODE tinyint   Default = 3
 UNSIMILARADDRESSCODE tinyint   Default = 3
 UNSIMILARADDRESS nvarchar(42) (Computed) CASE [UNSIMILARADDRESSCODE] WHEN 0 THEN N'Ignore address' WHEN 3 THEN N'Add as new address' WHEN 2 THEN N'Require manual review (generate exception)' END
 NEWADDRESSENDDATECODE tinyint   Default = 0
 NEWADDRESSPRIMARYCODE tinyint   Default = 1
 BIRTHDATERULECODE tinyint   Default = 0
 BIRTHDATERULE nvarchar(17) (Computed) CASE [BIRTHDATERULECODE] WHEN 0 THEN N'Ignore birth date' WHEN 1 THEN N'Update birth date' END
 NAME nvarchar(42) (Computed) CASE [NAMECODE] WHEN 0 THEN N'Ignore name' WHEN 1 THEN N'Update name' WHEN 2 THEN N'Require manual review (generate exception)' WHEN 3 THEN N'Add name as an alias' END
 SIMILARADDRESS nvarchar(63) (Computed) CASE [SIMILARADDRESSCODE] WHEN 0 THEN N'Ignore address' WHEN 1 THEN N'Update existing address (old address data will not be retained)' WHEN 2 THEN N'Require manual review (generate exception)' WHEN 3 THEN N'Add as new address' END
 NEWADDRESSENDDATE nvarchar(30) (Computed) CASE [NEWADDRESSENDDATECODE] WHEN 0 THEN N'Make existing address inactive' WHEN 1 THEN N'Keep existing address active' END
 NEWADDRESSPRIMARY nvarchar(61) (Computed) CASE [NEWADDRESSPRIMARYCODE] WHEN 0 THEN N'Never' WHEN 1 THEN N'Only if the current primary address has the same address type' WHEN 2 THEN N'Always' END
 DIFFERENTPHONE nvarchar(42) (Computed) CASE [DIFFERENTPHONECODE] WHEN 0 THEN N'Ignore phone' WHEN 3 THEN N'Add as new phone' WHEN 2 THEN N'Require manual review (generate exception)' END
 NEWPHONEENDDATE nvarchar(28) (Computed) CASE [NEWPHONEENDDATECODE] WHEN 0 THEN N'Make existing phone inactive' WHEN 1 THEN N'Keep existing phone active' END
 NEWPHONEPRIMARY nvarchar(57) (Computed) CASE [NEWPHONEPRIMARYCODE] WHEN 0 THEN N'Never' WHEN 1 THEN N'Only if the current primary phone has the same phone type' WHEN 2 THEN N'Always' END
 NEWEMAILENDDATE nvarchar(36) (Computed) CASE [NEWEMAILENDDATECODE] WHEN 0 THEN N'Make existing email address inactive' WHEN 1 THEN N'Keep existing email address active' END
 NEWEMAILPRIMARY nvarchar(65) (Computed) CASE [NEWEMAILPRIMARYCODE] WHEN 0 THEN N'Never' WHEN 1 THEN N'Only if the current primary email address has the same email type' WHEN 2 THEN N'Always' END

Foreign Key Field Type Null Notes Description
 BATCHID uniqueidentifier   BATCH.ID FK to BATCH
 PRIMARYRECORDID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 SUFFIXCODEID uniqueidentifier SUFFIXCODE.LOCALID FK to SUFFIXCODE
 TITLECODEID uniqueidentifier TITLECODE.LOCALID FK to TITLECODE
 PROSPECTMANAGERFUNDRAISERID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 ORG_INDUSTRYCODEID uniqueidentifier INDUSTRYCODE.LOCALID FK to INDUSTRYCODE
 ORG_PARENTCORPID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 MARITALSTATUSCODEID uniqueidentifier MARITALSTATUSCODE.LOCALID FK to MARITALSTATUSCODE
 SPOUSE_ID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 SPOUSE_TITLECODEID uniqueidentifier TITLECODE.LOCALID FK to TITLECODE
 SPOUSE_SUFFIXCODEID uniqueidentifier SUFFIXCODE.LOCALID FK to SUFFIXCODE
 SPOUSE_RELATIONSHIPTYPECODEID uniqueidentifier RELATIONSHIPTYPECODE.ID FK to RELATIONSHIPTYPECODE
 SPOUSE_RECIPROCALTYPECODEID uniqueidentifier RELATIONSHIPTYPECODE.ID FK to RELATIONSHIPTYPECODE
 BUSINESS_ID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 BUSINESS_ADDRESSTYPECODEID uniqueidentifier ADDRESSTYPECODE.ID FK to ADDRESSTYPECODE
 BUSINESS_COUNTRYID uniqueidentifier COUNTRY.LOCALID FK to COUNTRY
 BUSINESS_DONOTMAILREASONCODEID uniqueidentifier DONOTMAILREASONCODE.ID FK to DONOTMAILREASONCODE
 BUSINESS_EMAILADDRESSTYPECODEID uniqueidentifier EMAILADDRESSTYPECODE.ID FK to EMAILADDRESSTYPECODE
 BUSINESS_INDUSTRYCODEID uniqueidentifier INDUSTRYCODE.LOCALID FK to INDUSTRYCODE
 BUSINESS_PARENTCORPID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 BUSINESS_PHONETYPECODEID uniqueidentifier PHONETYPECODE.LOCALID FK to PHONETYPECODE
 BUSINESS_RELATIONSHIPTYPECODEID uniqueidentifier RELATIONSHIPTYPECODE.ID FK to RELATIONSHIPTYPECODE
 BUSINESS_RECIPROCALTYPECODEID uniqueidentifier RELATIONSHIPTYPECODE.ID FK to RELATIONSHIPTYPECODE
 BUSINESS_STATEID uniqueidentifier STATE.LOCALID FK to STATE
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BUSINESS_PHONE_COUNTRYID uniqueidentifier COUNTRY.LOCALID FK to COUNTRY
 BUSINESS_PRIMARYRECOGNITIONTYPECODEID uniqueidentifier REVENUERECOGNITIONTYPECODE.ID FK to REVENUERECOGNITIONTYPECODE
 BUSINESS_RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier REVENUERECOGNITIONTYPECODE.ID FK to REVENUERECOGNITIONTYPECODE
 SPOUSE_PRIMARYRECOGNITIONTYPECODEID uniqueidentifier REVENUERECOGNITIONTYPECODE.ID FK to REVENUERECOGNITIONTYPECODE
 SPOUSE_RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier REVENUERECOGNITIONTYPECODE.ID FK to REVENUERECOGNITIONTYPECODE

Index Name Field(s) Unique Primary Clustered
 IX_BATCHCONSTITUENTUPDATE_BATCHID BATCHID      
 IX_BATCHCONSTITUENTUPDATE_BUSINESS_ID BUSINESS_ID      
 IX_BATCHCONSTITUENTUPDATE_BUSINESS_PARENTCORPID BUSINESS_PARENTCORPID      
 IX_BATCHCONSTITUENTUPDATE_DATEADDED DATEADDED    
 IX_BATCHCONSTITUENTUPDATE_DATECHANGED DATECHANGED      
 IX_BATCHCONSTITUENTUPDATE_ORG_PARENTCORPID ORG_PARENTCORPID      
 IX_BATCHCONSTITUENTUPDATE_PRIMARYRECORDID PRIMARYRECORDID      
 IX_BATCHCONSTITUENTUPDATE_PROSPECTMANAGERFUNDRAISERID PROSPECTMANAGERFUNDRAISERID      
 IX_BATCHCONSTITUENTUPDATE_SPOUSE_ID SPOUSE_ID      
 PK_BATCHCONSTITUENTUPDATE ID  

Trigger Name Description
 TR_BATCHCONSTITUENTUPDATE_AUDIT_UPDATE
 TR_BATCHCONSTITUENTUPDATE_AUDIT_DELETE

Referenced by Field
 BATCHCONSTITUENTUPDATEADDRESSES BATCHCONSTITUENTUPDATEID
 BATCHCONSTITUENTUPDATEALTERNATELOOKUPIDS BATCHCONSTITUENTUPDATEID
 BATCHCONSTITUENTUPDATEBATCHSYSTEMMESSAGES BATCHCONSTITUENTUPDATEID
 BATCHCONSTITUENTUPDATEBATCHUSERMESSAGE ID
 BATCHCONSTITUENTUPDATEBBNCINFO BATCHCONSTITUENTUPDATEID
 BATCHCONSTITUENTUPDATECONSTITUENCIES BATCHCONSTITUENTUPDATEID
 BATCHCONSTITUENTUPDATECONSTITUENCIESSYSTEM BATCHCONSTITUENTUPDATEID
 BATCHCONSTITUENTUPDATEEMAILADDRESSES BATCHCONSTITUENTUPDATEID
 BATCHCONSTITUENTUPDATEINTERESTS BATCHCONSTITUENTUPDATEID
 BATCHCONSTITUENTUPDATENAMEFORMATS BATCHCONSTITUENTUPDATEID
 BATCHCONSTITUENTUPDATEPHONES BATCHCONSTITUENTUPDATEID
 BATCHCONSTITUENTUPDATERELATIONSHIPS BATCHCONSTITUENTUPDATEID
 BATCHCONSTITUENTUPDATESECURITYATTRIBUTES BATCHCONSTITUENTUPDATEID
 BATCHCONSTITUENTUPDATESITES BATCHCONSTITUENTUPDATEID
 BATCHCONSTITUENTUPDATESOCIALMEDIAACCOUNT BATCHCONSTITUENTUPDATEID
 BATCHCONSTITUENTUPDATESPOUSEALTERNATELOOKUPIDS BATCHCONSTITUENTUPDATEID
 BATCHREVENUECONSTITUENTEDITINFO ID

Entity-Relationship diagram of this table (ADDRESSTYPECODE-BATCHRESULTS877DBC83_98F9_4008_98A0_902FDB35E819)
Entity-Relationship diagram of this table (BATCHREVENUECONSTITUENTEDITINFO-TITLECODE)