USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTDUPLICATESEARCHSETTINGS

The load procedure used by the edit dataform template "Auto Match Configuration Edit Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@LEFTPOSTCODECOUNT	int	INOUT	Number matched ZIP digits required for inexact match
@OVERALLMATCHTHRESHOLD	int	INOUT	Required confidence level to match
@TRANSACTIONTYPE	nvarchar(255)	INOUT
@EMAIL	bit	INOUT	Consider any email match a high confidence match
@FIRSTNAME	bit	INOUT	First Name
@LASTNAMEORORG	bit	INOUT	Last Name/Organization Name
@MAIDENNAME	bit	INOUT	Maiden Name
@MIDDLENAME	bit	INOUT	Middle Name
@ADDRESS	bit	INOUT	Address
@CITY	bit	INOUT	City
@COUNTRY	bit	INOUT	Country
@COUNTY	bit	INOUT	County
@STATE	bit	INOUT	State
@ZIP	bit	INOUT	Zip
@GENDER	bit	INOUT	Gender
@BIRTHDATE	bit	INOUT	Birth Date
@ANYPHONE	bit	INOUT	Any Phone
@LOOKUP_ID	bit	INOUT	Lookup ID
@INACTIVE	bit	INOUT	Include Inactive
@DECEASED	bit	INOUT	Include Deceased
@TITLE	bit	INOUT	Title
@INCLUDENICKNAME	bit	INOUT	Include nicknames
@INCLUDEALIAS	bit	INOUT	Include aliases
@TRANSACTIONTYPE2	nvarchar(52)	INOUT
@EMPLOYER	bit	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTDUPLICATESEARCHSETTINGS(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @LEFTPOSTCODECOUNT int = NULL output,
    @OVERALLMATCHTHRESHOLD int = null output,
  @TRANSACTIONTYPE nvarchar(255) = null output, 
  @EMAIL bit = null output,
  @FIRSTNAME bit =null output,
  @LASTNAMEORORG bit=null output,
  @MAIDENNAME bit=null output,
  @MIDDLENAME bit=null output,
  @ADDRESS bit=null output,
  @CITY     bit=null output,
  @COUNTRY bit=null output,
  @COUNTY     bit=null output,
  @STATE    bit=null output,
  @ZIP     bit=null output,
  @GENDER bit=null output,
  @BIRTHDATE bit=null output,
  @ANYPHONE bit=null output,
  @LOOKUP_ID bit=null output,
  @INACTIVE bit=null output,
  @DECEASED bit=null output,
  @TITLE bit=null output,
  @INCLUDENICKNAME bit=null output,
  @INCLUDEALIAS bit = null output,
  @TRANSACTIONTYPE2 nvarchar(52) = null output,
  @EMPLOYER bit = null output

)
as
    set nocount on;
  set @DATALOADED = 0
    set @TSLONG = 0

    select
        @DATALOADED = 1,
        @TSLONG = TSLONG,
        @LEFTPOSTCODECOUNT = LEFTPOSTCODECOUNT,
        @OVERALLMATCHTHRESHOLD = floor(OVERALLMATCHTHRESHOLD),
    @TRANSACTIONTYPE =TRANSACTIONTYPE ,
    @EMAIL      =EMAIL,
    @FIRSTNAME  =FIRSTNAME,
    @LASTNAMEORORG=LASTNAMEORORG,
    @MAIDENNAME =MAIDENNAME,
    @MIDDLENAME =MIDDLENAME,
    @ADDRESS    =ADDRESS,
    @CITY          =CITY,
    @COUNTRY    =COUNTRY,
    @COUNTY        =COUNTY,
    @STATE        =STATE,
    @ZIP          =ZIP,
    @GENDER     =GENDER,
    @BIRTHDATE  =BIRTHDATE,
    @ANYPHONE   =ANYPHONE,
    @LOOKUP_ID   =LOOKUP_ID,
    @INACTIVE   =INACTIVE,
    @DECEASED   =DECEASED,
    @TITLE = TITLE,
    @INCLUDENICKNAME = INCLUDENICKNAME,
    @INCLUDEALIAS = INCLUDEALIAS,
  @TRANSACTIONTYPE2 = TRANSACTIONTYPE2,
  @EMPLOYER = EMPLOYER
    from dbo.CONSTITUENTDUPLICATESEARCHSETTINGS
    where ID = @ID

    return 0;