USP_DATAFORMTEMPLATE_LOAD_MATCHFINDERCONFIG

The load procedure used by the edit dataform template "MatchFinder Configuration Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@SITEID	nvarchar(100)	INOUT	Site ID
@ADDRESSTYPECODEID	uniqueidentifier	INOUT	Address type
@PHONETYPECODEID	uniqueidentifier	INOUT	Phone type
@FAXTYPECODEID	uniqueidentifier	INOUT	Fax type
@CONTACTTYPECODEID	uniqueidentifier	INOUT	Contact type
@CONTACTRELATIONSHIPTYPECODEID	uniqueidentifier	INOUT	Contact relationship type
@CONTACTRECIPROCALRELATIONSHIPTYPECODEID	uniqueidentifier	INOUT	Contact reciprocal relationship type
@CONTACTEMAILADDRESSTYPECODEID	uniqueidentifier	INOUT	Contact email type
@ALIASTYPECODEID	uniqueidentifier	INOUT	Alias type
@MATCHINGGIFTCONDITIONTYPECODEID	uniqueidentifier	INOUT	Matching gift condition type
@INFOSOURCECODEID	uniqueidentifier	INOUT	Information source

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_LOAD_MATCHFINDERCONFIG
                    (
                        @DATALOADED bit = 0 output,
                        @SITEID nvarchar(100) = null output,
                        @ADDRESSTYPECODEID uniqueidentifier = null output,
                        @PHONETYPECODEID uniqueidentifier = null output,
                        @FAXTYPECODEID uniqueidentifier = null output,
                        @CONTACTTYPECODEID uniqueidentifier = null output,
                        @CONTACTRELATIONSHIPTYPECODEID uniqueidentifier = null output,
                        @CONTACTRECIPROCALRELATIONSHIPTYPECODEID uniqueidentifier = null output,
                        @CONTACTEMAILADDRESSTYPECODEID uniqueidentifier = null output,
                        @ALIASTYPECODEID uniqueidentifier = null output,
                        @MATCHINGGIFTCONDITIONTYPECODEID uniqueidentifier = null output,
                        @INFOSOURCECODEID uniqueidentifier = null output
                    )
                    as
                    set nocount on;

                    set @DATALOADED = 1;

                    begin try
                        exec dbo.USP_GET_KEY_ACCESS;

                        select top 1
                            @SITEID = coalesce(convert(nvarchar(100), DecryptByKey(SITEID)), ''),
                            @ADDRESSTYPECODEID = ADDRESSTYPECODEID,
                            @PHONETYPECODEID = PHONETYPECODEID,
                            @FAXTYPECODEID = FAXTYPECODEID,
                            @CONTACTTYPECODEID = CONTACTTYPECODEID,
                            @CONTACTRELATIONSHIPTYPECODEID = CONTACTRELATIONSHIPTYPECODEID,
                            @CONTACTRECIPROCALRELATIONSHIPTYPECODEID = CONTACTRECIPROCALRELATIONSHIPTYPECODEID,
                            @CONTACTEMAILADDRESSTYPECODEID = CONTACTEMAILADDRESSTYPECODEID,
                            @ALIASTYPECODEID = ALIASTYPECODEID,
                            @MATCHINGGIFTCONDITIONTYPECODEID = MATCHINGGIFTCONDITIONTYPECODEID,
                            @INFOSOURCECODEID = INFOSOURCECODEID
                        from dbo.MATCHFINDERCONFIGURATION;

                        close symmetric key sym_BBInfinity;
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;

                        close symmetric key sym_BBInfinity;
                        return 1;
                    end catch

                    return 0;