USP_CONSTITUENTMERGEPROCESS_GETPARAMETERS

Retrieves a parameter set for the constituent merge process

Parameters

Parameter	Parameter Type	Mode	Description
@id	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_CONSTITUENTMERGEPROCESS_GETPARAMETERS
            (
                @id uniqueidentifier
            )
            as

                set nocount on;

                select
                    NAME,
                    MERGECONFIGURATIONID,
                    SOURCETABLEID,
                    TARGETCRITERIA,
                    FILTERSELECTIONID,
                    MINSIMILARITY,
                    DELETEDUPES,
                    INDIVIDUALSONLY,
                    OMITINDORGMATCHES,
                    CREATEOUTPUTIDSET,
                    OUTPUTIDSETNAME,
                    OVERWRITEOUTPUTIDSET,
                    CONSTITUENTINACTIVITYREASONCODEID,
                    CONSTITUENTINACTIVITYDETAILS
                from
                    dbo.CONSTITUENTMERGEPROCESS
                where
                    ID = @id;