| 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) |
yes |
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 optimal 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) |
yes |
CASE [PRODUCTTYPECODE] WHEN 1 THEN N'FAF' WHEN 2 THEN N'BBIS Web' END |
|
| TRANSACTIONTYPE2CODE |
tinyint |
|
Default = 0 |
|
| TRANSACTIONTYPE2 |
nvarchar(26) (Computed) |
yes |
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 Sponsorship' 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 |
|