USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTMATCHINGSETTINGS

Parameters

Parameter	Parameter Type	Mode
@DATALOADED	bit	INOUT
@AUTOMATCHTHRESHOLD	int	INOUT
@OVERALLMATCHTHRESHOLDBATCH	int	INOUT
@OVERALLMATCHTHRESHOLD	int	INOUT
@AUTOMATCHTHRESHOLDMICROSITE	int	INOUT
@OVERALLMATCHTHRESHOLDMICROSITE	int	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTMATCHINGSETTINGS
(
    @DATALOADED bit = 0 output,
    @AUTOMATCHTHRESHOLD int = null output,
    @OVERALLMATCHTHRESHOLDBATCH int = null output,
    @OVERALLMATCHTHRESHOLD int = null output,
    @AUTOMATCHTHRESHOLDMICROSITE int = null output,
    @OVERALLMATCHTHRESHOLDMICROSITE int = null output
)
as
    set nocount on;

    set @DATALOADED = 1

    select top 1
        @AUTOMATCHTHRESHOLD = AUTOMATCHTHRESHOLD,
        @OVERALLMATCHTHRESHOLDBATCH = OVERALLMATCHTHRESHOLDBATCH,
        @OVERALLMATCHTHRESHOLD = OVERALLMATCHTHRESHOLD
    from dbo.CONSTITUENTDUPLICATESEARCHSETTINGS
    where TRANSACTIONTYPE = 'Default Criteria'
    order by DATECHANGED;

    select top 1
        @AUTOMATCHTHRESHOLDMICROSITE = AUTOMATCHTHRESHOLD,
        @OVERALLMATCHTHRESHOLDMICROSITE = OVERALLMATCHTHRESHOLD
    from dbo.CONSTITUENTDUPLICATESEARCHSETTINGS
    where TRANSACTIONTYPE2CODE = 7 --Microsite Anonymous User
    order by DATECHANGED;

    return 0;