USP_REPORT_MATCHFINDERBATCHVALIDATIONREPORT

Provides data for the Update Multiple Constituents from MatchFinder Online Validation Report.

Parameters

Parameter Parameter Type Mode Description
@BATCHID uniqueidentifier IN

Definition

Copy


            create procedure dbo.USP_REPORT_MATCHFINDERBATCHVALIDATIONREPORT
            (
                @BATCHID uniqueidentifier
            )
            as
            set nocount on;

            select
                [MFO].CONSTITUENTID,
                [CONSTITUENT].NAME,
                MFORGNAME
            from dbo.UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH as [MFO]
            left join dbo.CONSTITUENT on CONSTITUENT.ID = [MFO].CONSTITUENTID
            where [MFO].BATCHID = @BATCHID