Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ROUTINENAME nvarchar(128)   Default = '' The name of the routine which provides the core duplicate search operation.
 LEFTPOSTCODECOUNT tinyint   Default = 3 The number of left-most digits of a zipcode that will be considered while performing duplicate searches.
 OVERALLMATCHTHRESHOLD decimal(20, 4)   Default = 70 The overall match percentage a record must pass to be included in duplicate search results.
 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.
 TRANSACTIONTYPE nvarchar(256)   Default = '' Auto match will used based on the transaction type
 EMAIL bit   Default = 1 Email Address auto match parameter
 LASTNAMEORORG bit   Default = 1 Constituent last name or organization and is an optinal parameter for auto match
 FIRSTNAME bit   Default = 1 Constituent first name parameter for auto match
 MAIDENNAME bit   Default = 1 Constituent maiden name parameter for auto match
 MIDDLENAME bit   Default = 1 Constituent middle name parameter for auto match
 ADDRESS bit   Default = 1 Constituent address parameter for auto match
 CITY bit   Default = 1 Constituent city parameter for auto match
 COUNTRY bit   Default = 1 Constituent country parameter for auto match
 COUNTY bit   Default = 1 Constituent county parameter for auto match
 STATE bit   Default = 1 Constituent state parameter for auto match
 ZIP bit   Default = 1 Constituent zip parameter for auto match
 ANYPHONE bit   Default = 1 Constituent anyphone parameter for auto match
 BIRTHDATE bit   Default = 0 Constituent birth date parameter for auto match
 GENDER bit   Default = 0 Constituent gender parameter for auto match
 LOOKUP_ID bit   Default = 0 Constituent lookup id parameter for auto match
 INACTIVE bit   Default = 0 Constituent include inactive flag parameter for auto match
 DECEASED bit   Default = 0 Constituent include deceased flag parameter for auto match
 TITLE bit   Default = 0 Constituent title parameter for auto match
 INCLUDENICKNAME bit   Default = 0 Flags whether constituents' nickname should be considered for auto match.
 INCLUDEALIAS bit   Default = 0 Flags whether constituents' aliases should be considered for auto match.
 CHECKOPTIONALCRITERIA bit   Default = 0 Flags whether information other than the flagged criteria should be considered if provided for auto match.
 NORMALIZEADDRESS bit   Default = 0 Flags whether addresses should be normalized for auto match.
 PRODUCTTYPECODE tinyint   Default = 1
 PRODUCTTYPE nvarchar(8) (Computed) CASE [PRODUCTTYPECODE] WHEN 1 THEN N'FAF' WHEN 2 THEN N'BBIS Web' END
 TRANSACTIONTYPE2CODE tinyint   Default = 0
 TRANSACTIONTYPE2 nvarchar(26) (Computed) CASE [TRANSACTIONTYPE2CODE] WHEN 0 THEN N'Default Criteria' WHEN 1 THEN N'FAF Donation' WHEN 2 THEN N'FAF Registration' WHEN 3 THEN N'Advocacy Registration Form' WHEN 4 THEN N'FAF Tributee' WHEN 5 THEN N'FAF ContactUs' WHEN 6 THEN N'FAF Sponsorhip' WHEN 7 THEN N'Microsite Anonymous User' WHEN 8 THEN N'Default Criteria- BBIS Web' WHEN 9 THEN N'Donations' WHEN 10 THEN N'Event Registrations' WHEN 11 THEN N'Fundraisers' WHEN 12 THEN N'Memberships' WHEN 13 THEN N'Profile Updates' WHEN 14 THEN N'Signups' END
 EMPLOYER bit   Default = 1
 AUTOMATCHTHRESHOLD decimal(20, 4)   Default = 95
 OVERALLMATCHTHRESHOLDBATCH decimal(20, 4)   Default = 70
 ADDRESSMATCHTHRESHOLD decimal(20, 4)   Default = 86

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_CONSTITUENTDUPLICATESEARCHSETTINGS_DATEADDED DATEADDED    
 IX_CONSTITUENTDUPLICATESEARCHSETTINGS_DATECHANGED DATECHANGED      
 PK_CONSTITUENTDUPLICATESEARCHSETTINGS ID  

Trigger Name Description
 TR_CONSTITUENTDUPLICATESEARCHSETTINGS_AUDIT_UPDATE
 TR_CONSTITUENTDUPLICATESEARCHSETTINGS_AUDIT_DELETE