USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTMERGEPROCESS

The load procedure used by the view dataform template "Constituent Merge Process View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(255)	INOUT	Description
@MERGECONFIGURATIONNAME	nvarchar(100)	INOUT	Merge configuration
@SOURCETABLE	nvarchar(200)	INOUT	Duplicate record source
@TARGETCRITERIA	nvarchar(50)	INOUT	Target constituent criteria
@FILTERSELECTIONNAME	nvarchar(100)	INOUT	Excluded constituents
@MINSIMILARITY	decimal(3, 2)	INOUT	Minimum match %
@DELETEDUPES	bit	INOUT	Delete source constituents
@INDIVIDUALSONLY	bit	INOUT	Only merge individuals
@OMITINDORGMATCHES	bit	INOUT	Omit individual/organization matches
@CREATEOUTPUTIDSET	bit	INOUT	Create selection from results
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Selection name
@OVERWRITEOUTPUTIDSET	bit	INOUT	Overwrite existing selection
@BUSINESSPROCESSCATALOGID	uniqueidentifier	INOUT	BUSINESSPROCESSCATALOGID
@PARAMETERSID	uniqueidentifier	INOUT	PARAMETERSID
@SOURCETABLEROWCOUNT	bigint	INOUT	SOURCETABLEROWCOUNT
@ISBASICDEVELOPMENT	bit	INOUT

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTMERGEPROCESS
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(100) = null output,
                    @DESCRIPTION nvarchar(255) = null output,
                    @MERGECONFIGURATIONNAME nvarchar(100) = null output,
                    @SOURCETABLE nvarchar(200) = null output,
                    @TARGETCRITERIA nvarchar(50) = null output,
                    @FILTERSELECTIONNAME nvarchar(100) = null output,
                    @MINSIMILARITY decimal(3,2) = null output,
                    @DELETEDUPES bit = null output,
                    @INDIVIDUALSONLY bit = null output,
                    @OMITINDORGMATCHES bit = null output,
                    @CREATEOUTPUTIDSET bit = null output,
                    @OUTPUTIDSETNAME nvarchar(100) = null output,
                    @OVERWRITEOUTPUTIDSET bit = null output,
                    @BUSINESSPROCESSCATALOGID uniqueidentifier = null output,
                    @PARAMETERSID uniqueidentifier = null output,
                    @SOURCETABLEROWCOUNT bigint = null output,
                    @ISBASICDEVELOPMENT bit = null output
                )
                as
                begin
                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @NAME = NAME,
                        @DESCRIPTION = DESCRIPTION,
                        @MERGECONFIGURATIONNAME = dbo.UFN_MERGECONFIGURATION_GETNAME(MERGECONFIGURATIONID),
                        @SOURCETABLE = dbo.UFN_CONSTITUENTMERGEPROCESS_GETSOURCETABLEDESC(SOURCETABLEID),
                        @TARGETCRITERIA = dbo.UFN_CONSTITUENTMERGEPROCESS_GETTARGETCRITERIATEXT(TARGETCRITERIA),
                        @FILTERSELECTIONNAME = dbo.UFN_IDSET_GETNAME(FILTERSELECTIONID),
                        @MINSIMILARITY = MINSIMILARITY,
                        @DELETEDUPES = DELETEDUPES,
                        @INDIVIDUALSONLY = INDIVIDUALSONLY,
                        @OMITINDORGMATCHES = OMITINDORGMATCHES,
                        @CREATEOUTPUTIDSET = CREATEOUTPUTIDSET,
                        @OUTPUTIDSETNAME = OUTPUTIDSETNAME,
                        @OVERWRITEOUTPUTIDSET = OVERWRITEOUTPUTIDSET,
                        @BUSINESSPROCESSCATALOGID = 'EEEB65A5-EF28-4610-8C22-2C634B8A58C5',
                        @PARAMETERSID = @ID
                    from
                        dbo.CONSTITUENTMERGEPROCESS
                    where
                        ID = @ID;

                    declare @SOURCETABLENAME nvarchar(200);
                    select @SOURCETABLENAME = TABLENAME from dbo.DUPLICATECONSTITUENTSEARCHRESULTSTABLE where FRIENDLYNAME = @SOURCETABLE;
                    create table #temp_tablerowcount(cnt bigint);
                    exec('insert into #temp_tablerowcount(cnt) select count(*) from dbo.' + @SOURCETABLENAME);
                    select top(1) @SOURCETABLEROWCOUNT = cnt from #temp_tablerowcount;
                    drop table #temp_tablerowcount;

                    if exists(select 1 from dbo.INSTALLEDPRODUCTLIST where ID = '42c15648-749e-4859-a56d-3a6474814cc7') 
                    and not exists(select 1 from dbo.INSTALLEDPRODUCTLIST where ID = '3117d2c8-7f46-42f2-abeb-b654f2f63046')
                        set @ISBASICDEVELOPMENT = 1;
                end