USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTMATCHINGSETTINGS

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTMATCHINGSETTINGS
(
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 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,
        @TSLONG = TSLONG
    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;