USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTDUPLICATESEARCHSETTINGS

The save 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 indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@LEFTPOSTCODECOUNT	int	IN	Number matched ZIP digits required for inexact match
@OVERALLMATCHTHRESHOLD	int	IN	Required confidence level to match
@TRANSACTIONTYPE	nvarchar(255)	IN
@EMAIL	bit	IN	Consider any email match a high confidence match
@FIRSTNAME	bit	IN	First Name
@LASTNAMEORORG	bit	IN	Last Name/Organization Name
@MAIDENNAME	bit	IN	Maiden Name
@MIDDLENAME	bit	IN	Middle Name
@ADDRESS	bit	IN	Address
@CITY	bit	IN	City
@COUNTRY	bit	IN	Country
@COUNTY	bit	IN	County
@STATE	bit	IN	State
@ZIP	bit	IN	Zip
@GENDER	bit	IN	Gender
@BIRTHDATE	bit	IN	Birth Date
@ANYPHONE	bit	IN	Any Phone
@LOOKUP_ID	bit	IN	Lookup ID
@INACTIVE	bit	IN	Include Inactive
@DECEASED	bit	IN	Include Deceased
@TITLE	bit	IN	Title
@INCLUDENICKNAME	bit	IN	Include nicknames
@INCLUDEALIAS	bit	IN	Include aliases
@TRANSACTIONTYPE2	varchar(52)	IN
@EMPLOYER	bit	IN

Definition

Copy


    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTDUPLICATESEARCHSETTINGS (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @LEFTPOSTCODECOUNT int,
    @OVERALLMATCHTHRESHOLD int,
  @TRANSACTIONTYPE nvarchar(255),
  @EMAIL bit ,
  @FIRSTNAME bit,
  @LASTNAMEORORG bit,
  @MAIDENNAME bit,
  @MIDDLENAME bit,    
  @ADDRESS bit,    
  @CITY bit,        
  @COUNTRY bit,    
  @COUNTY bit,    
  @STATE bit,    
  @ZIP bit,        
  @GENDER bit,    
  @BIRTHDATE bit,    
  @ANYPHONE bit,    
  @LOOKUP_ID bit,
  @INACTIVE bit,
  @DECEASED bit,
  @TITLE bit,
  @INCLUDENICKNAME bit,
  @INCLUDEALIAS bit,
  @TRANSACTIONTYPE2 varchar(52),
  @EMPLOYER bit
)
as

    set nocount on;

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        -- handle updating the data
        update dbo.CONSTITUENTDUPLICATESEARCHSETTINGS 
        set
        LEFTPOSTCODECOUNT = @LEFTPOSTCODECOUNT,
        OVERALLMATCHTHRESHOLD = @OVERALLMATCHTHRESHOLD,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE,
    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,
  EMPLOYER = @EMPLOYER
        where ID    = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;