USP_DATAFORMTEMPLATE_VIEW_MATCHFINDERCONFIG

The load procedure used by the view dataform template "MatchFinder Configuration View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@ADDRESSTYPECODE	nvarchar(100)	INOUT	Address type
@PHONETYPECODE	nvarchar(100)	INOUT	Phone type
@FAXTYPECODE	nvarchar(100)	INOUT	Fax type
@CONTACTTYPECODE	nvarchar(100)	INOUT	Contact type
@CONTACTRELATIONSHIPTYPECODE	nvarchar(100)	INOUT	Contact relationship type
@CONTACTRECIPROCALRELATIONSHIPTYPECODE	nvarchar(100)	INOUT	Contact reciprocal relationship type
@CONTACTEMAILADDRESSTYPECODE	nvarchar(100)	INOUT	Contact email type
@ALIASTYPECODE	nvarchar(100)	INOUT	Alias type
@MATCHINGGIFTCONDITIONTYPECODE	nvarchar(100)	INOUT	Matching gift condition type
@INFOSOURCECODE	nvarchar(100)	INOUT	Information source

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MATCHFINDERCONFIG
                    (
                        @DATALOADED bit = 0 output,
                        @ADDRESSTYPECODE nvarchar(100) = null output,
                        @PHONETYPECODE nvarchar(100) = null output,
                        @FAXTYPECODE nvarchar(100) = null output,
                        @CONTACTTYPECODE nvarchar(100) = null output,
                        @CONTACTRELATIONSHIPTYPECODE nvarchar(100) = null output,
                        @CONTACTRECIPROCALRELATIONSHIPTYPECODE nvarchar(100) = null output,
                        @CONTACTEMAILADDRESSTYPECODE nvarchar(100) = null output,
                        @ALIASTYPECODE nvarchar(100) = null output,
                        @MATCHINGGIFTCONDITIONTYPECODE nvarchar(100) = null output,
                        @INFOSOURCECODE nvarchar(100) = null output
                    )
                    as
                    set nocount on;

                    set @DATALOADED = 1;

                    begin try
                        select top 1
                            @ADDRESSTYPECODE = (select DESCRIPTION from dbo.ADDRESSTYPECODE where ID = ADDRESSTYPECODEID),
                            @PHONETYPECODE = (select DESCRIPTION from dbo.PHONETYPECODE where ID = PHONETYPECODEID),
                            @FAXTYPECODE = (select DESCRIPTION from dbo.PHONETYPECODE where ID = FAXTYPECODEID),
                            @CONTACTTYPECODE = (select DESCRIPTION from dbo.CONTACTTYPECODE where ID = CONTACTTYPECODEID),
                            @CONTACTRELATIONSHIPTYPECODE = (select DESCRIPTION from dbo.RELATIONSHIPTYPECODE where ID = CONTACTRELATIONSHIPTYPECODEID),
                            @CONTACTRECIPROCALRELATIONSHIPTYPECODE = (select DESCRIPTION from dbo.RELATIONSHIPTYPECODE where ID = CONTACTRECIPROCALRELATIONSHIPTYPECODEID),
                            @CONTACTEMAILADDRESSTYPECODE = (select DESCRIPTION from dbo.EMAILADDRESSTYPECODE where ID = CONTACTEMAILADDRESSTYPECODEID),
                            @ALIASTYPECODE = (select DESCRIPTION from dbo.ALIASTYPECODE where ID = ALIASTYPECODEID),
                            @MATCHINGGIFTCONDITIONTYPECODE = (select DESCRIPTION from dbo.MATCHINGGIFTCONDITIONTYPECODE where ID = MATCHINGGIFTCONDITIONTYPECODEID),
                            @INFOSOURCECODE = dbo.UFN_INFOSOURCECODE_GETDESCRIPTION(INFOSOURCECODEID)
                        from dbo.MATCHFINDERCONFIGURATION;
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;