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.

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