USP_MATCHFINDER_LOADCONFIG

Retrieves configuration information for integrating with the MatchFinder Online service.

Parameters

Parameter	Parameter Type	Mode
@REQUIREADDRESSTYPECODE	bit	IN
@ADDRESSTYPECODEID	uniqueidentifier	INOUT
@REQUIREPHONETYPECODE	bit	IN
@PHONETYPECODEID	uniqueidentifier	INOUT
@REQUIREFAXTYPECODE	bit	IN
@FAXTYPECODEID	uniqueidentifier	INOUT
@REQUIRECONTACTTYPECODE	bit	IN
@CONTACTTYPECODEID	uniqueidentifier	INOUT
@REQUIRECONTACTRELATIONSHIPTYPECODE	bit	IN
@CONTACTRELATIONSHIPTYPECODEID	uniqueidentifier	INOUT
@REQUIRECONTACTRECIPROCALRELATIONSHIPTYPECODE	bit	IN
@CONTACTRECIPROCALRELATIONSHIPTYPECODEID	uniqueidentifier	INOUT
@REQUIRECONTACTEMAILADDRESSTYPECODE	bit	IN
@CONTACTEMAILADDRESSTYPECODEID	uniqueidentifier	INOUT
@REQUIREALIASTYPECODE	bit	IN
@ALIASTYPECODEID	uniqueidentifier	INOUT
@REQUIREMATCHINGGFITCONDITIONTYPECODE	bit	IN
@MATCHINGGIFTCONDITIONTYPECODEID	uniqueidentifier	INOUT
@INFOSOURCECODEID	uniqueidentifier	INOUT

Definition

Copy



            CREATE procedure dbo.USP_MATCHFINDER_LOADCONFIG
            (
                @REQUIREADDRESSTYPECODE bit = 0,
                @ADDRESSTYPECODEID uniqueidentifier = null output,

                @REQUIREPHONETYPECODE bit = 0,
                @PHONETYPECODEID uniqueidentifier = null output,

                @REQUIREFAXTYPECODE bit = 0,
                @FAXTYPECODEID uniqueidentifier = null output,

                @REQUIRECONTACTTYPECODE bit = 0,
                @CONTACTTYPECODEID uniqueidentifier = null output,

                @REQUIRECONTACTRELATIONSHIPTYPECODE bit = 0,
                @CONTACTRELATIONSHIPTYPECODEID uniqueidentifier = null output,

                @REQUIRECONTACTRECIPROCALRELATIONSHIPTYPECODE bit = 0, 
                @CONTACTRECIPROCALRELATIONSHIPTYPECODEID uniqueidentifier = null output,

                @REQUIRECONTACTEMAILADDRESSTYPECODE bit = 0,
                @CONTACTEMAILADDRESSTYPECODEID uniqueidentifier = null output,

                @REQUIREALIASTYPECODE bit = 0,
                @ALIASTYPECODEID uniqueidentifier  = null output,

                @REQUIREMATCHINGGFITCONDITIONTYPECODE bit = 0,
                @MATCHINGGIFTCONDITIONTYPECODEID uniqueidentifier = null output,

                @INFOSOURCECODEID uniqueidentifier = null output
            )
            as
            set nocount on;

            begin try
                select top 1
                    @ADDRESSTYPECODEID = ADDRESSTYPECODEID,
                    @PHONETYPECODEID = PHONETYPECODEID,
                    @FAXTYPECODEID = FAXTYPECODEID,
                    @CONTACTTYPECODEID = CONTACTTYPECODEID,
                    @CONTACTRELATIONSHIPTYPECODEID = CONTACTRELATIONSHIPTYPECODEID,
                    @CONTACTRECIPROCALRELATIONSHIPTYPECODEID = CONTACTRECIPROCALRELATIONSHIPTYPECODEID,
                    @CONTACTEMAILADDRESSTYPECODEID = CONTACTEMAILADDRESSTYPECODEID,
                    @ALIASTYPECODEID = ALIASTYPECODEID,
                    @MATCHINGGIFTCONDITIONTYPECODEID = MATCHINGGIFTCONDITIONTYPECODEID,
                    @INFOSOURCECODEID = INFOSOURCECODEID
                from dbo.MATCHFINDERCONFIGURATION

                if @ADDRESSTYPECODEID is null and @REQUIREADDRESSTYPECODE = 1
                    raiserror('ERR_MFCONFIG_NOADDRESSTYPECODE', 16, 1);
                if @PHONETYPECODEID is null and @REQUIREPHONETYPECODE = 1
                    raiserror('ERR_MFCONFIG_NOPHONETYPECODE', 16, 1);
                if @FAXTYPECODEID is null and @REQUIREFAXTYPECODE = 1
                    raiserror('ERR_MFCONFIG_NOFAXTYPECODE', 16, 1);
                if @CONTACTTYPECODEID is null and @REQUIRECONTACTTYPECODE = 1 
                    raiserror('ERR_MFCONFIG_NOCONTACTTYPECODE', 16, 1);
                if @CONTACTRELATIONSHIPTYPECODEID is null and @REQUIRECONTACTRELATIONSHIPTYPECODE = 1
                    raiserror('ERR_MFCONFIG_NOCONTACTEMAILTYPECODE', 16, 1);
                if @CONTACTRECIPROCALRELATIONSHIPTYPECODEID is null and @REQUIRECONTACTRECIPROCALRELATIONSHIPTYPECODE = 1
                    raiserror('ERR_MFCONFIG_NOCONTACTRELATIONSHIPTYPECODE', 16, 1);
                if @CONTACTEMAILADDRESSTYPECODEID is null and @REQUIRECONTACTEMAILADDRESSTYPECODE = 1
                    raiserror('ERR_MFCONFIG_NOCONTACTRECIPROCALRELATIONSHIPTYPECODE', 16, 1);
                if @MATCHINGGIFTCONDITIONTYPECODEID is null and @REQUIREMATCHINGGFITCONDITIONTYPECODE = 1
                    raiserror('ERR_MFCONFIG_NOMATCHINGGIFTCONDITIONTYPECODE', 16, 1);
                if @ALIASTYPECODEID is null and @REQUIREALIASTYPECODE = 1 
                    raiserror('ERR_MFCONFIG_NOALIASTYPECODE', 16, 1);
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;