| NAME |
nvarchar(100) |
|
Default = '' |
The name of the parameter set. |
| OPTIONCODE |
tinyint |
|
Default = 0 |
The type of business process being run |
| OPTION |
nvarchar(16) (Computed) |
yes |
CASE [OPTIONCODE] WHEN 0 THEN N'Fast process' WHEN 1 THEN N'Detailed process' WHEN 2 THEN N'Custom settings' END |
Provides a translation for the 'OPTIONCODE' field. |
| ISINCREMENTAL |
bit |
|
Default = 0 |
Only process constituents that were added or updated since this business process last ran |
| LASTRUNON |
datetime |
yes |
|
The time this constituent duplicate search process last ran |
| ISEXHAUSTIVE |
bit |
|
Default = 0 |
Indicates whether a search will narrow its results by comparing tokens of the name and address. |
| CHECKPHONE |
bit |
|
Default = 1 |
Constituent phone parameter for match |
| CHECKEMAIL |
bit |
|
Default = 1 |
Email Address match parameter |
| REQUIRESECONDARYMATCH |
bit |
|
Default = 1 |
Indicates whether or not the constituents must have a secondary match(phone, address, email etc) to be considered a duplicate. |
| MAXMATCHPERCONSTITUENT |
tinyint |
|
Default = 10 |
The maximum number of constituents that one constituent can be matched against. |
| NAMEMATCHTHRESHOLD |
decimal(20, 4) |
|
Default = 70 |
The match percentage a record's name must pass to be included in duplicate search results. |
| ADDRESSMATCHTHRESHOLD |
decimal(20, 4) |
|
Default = 70 |
The match percentage a record's address must pass to be included in duplicate search results. |
| OVERALLMATCHTHRESHOLD |
decimal(20, 4) |
|
Default = 70 |
The overall match percentage a record must pass to be included in duplicate search results. |
| CHECKSTATE |
bit |
|
Default = 1 |
Constituent state parameter for match |
| CHECKPOSTCODE |
bit |
|
Default = 1 |
Constituent zip parameter for match |
| LEFTPOSTCODECOUNT |
tinyint |
|
Default = 3 |
The number of left-most digits of a zipcode that will be considered while performing duplicate searches. |
| CHECKCOUNTRY |
bit |
|
Default = 1 |
Constituent country parameter for match |
| CHECKBIRTHDATE |
bit |
|
Default = 1 |
Constituent birth date parameter for match |
| CHECKGENDER |
bit |
|
Default = 1 |
Constituent gender parameter for match |
| CHECKMIDDLENAME |
bit |
|
Default = 1 |
Constituent middle name parameter for match |
| CHECKMAIDENNAME |
bit |
|
Default = 1 |
Constituent middle name parameter for match |
| INCLUDEINACTIVE |
bit |
|
Default = 0 |
Constituent inactive flag parameter for match |
| INCLUDEDECEASED |
bit |
|
Default = 0 |
Constituent inactive flag parameter for match |
| INCLUDEGROUPS |
bit |
|
Default = 1 |
Constituent group flag parameter for match |
| INCLUDEORGANIZATIONS |
bit |
|
Default = 1 |
Constituent organization flag parameter for match |
| 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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| POSTCODEPREFIXLENGTH |
tinyint |
|
Default = 12 |
|