USP_DATAFORMTEMPLATE_VIEW_WPPHILANTHROPICGIFT2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@CNOTES	nvarchar(1024)	INOUT
@CDATE	datetime	INOUT
@CVALUE	money	INOUT
@ORGANIZATION	nvarchar(200)	INOUT
@LOCATION	nvarchar(100)	INOUT
@GIFTYEAR	UDT_YEAR	INOUT
@TYPE	nvarchar(75)	INOUT
@CATEGORY	nvarchar(500)	INOUT
@LO	money	INOUT
@HI	money	INOUT
@NAME	nvarchar(200)	INOUT
@ORGANIZATIONWEBADDRESS	nvarchar(2000)	INOUT
@SOURCEMATERIAL	nvarchar(2000)	INOUT
@GIFTYEARHI	UDT_YEAR	INOUT
@GIFTYEARLO	UDT_YEAR	INOUT
@TYPECODE	int	INOUT
@EIN	nvarchar(50)	INOUT
@SOURCE	nvarchar(100)	INOUT
@PHILANTHROPICGIFTID	int	INOUT
@HOUSEHOLDID	nvarchar(30)	INOUT
@TASCORE	int	INOUT
@MATCHADDRESS	nvarchar(100)	INOUT
@MATCHCITY	nvarchar(20)	INOUT
@MATCHSTATE	nvarchar(2)	INOUT
@MATCHZIP	nvarchar(5)	INOUT
@ACCOUNTTYPECODE	smallint	INOUT
@MATCHCODE	nvarchar(100)	INOUT

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_WPPHILANTHROPICGIFT2 (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @CNOTES nvarchar(1024) = null output,
                    @CDATE datetime = null output,
                    @CVALUE money = null output,
                    @ORGANIZATION nvarchar(200) = null output,
                    @LOCATION nvarchar(100) = null output,
                    @GIFTYEAR dbo.UDT_YEAR = null output,
                    @TYPE nvarchar(75) = null output,
                    @CATEGORY nvarchar(500) = null output,
                    @LO money = null output,
                    @HI money = null output,
                    @NAME nvarchar(200) = null output,
                    @ORGANIZATIONWEBADDRESS nvarchar(2000) = null output,
                    @SOURCEMATERIAL nvarchar(2000) = null output,
                    @GIFTYEARHI dbo.UDT_YEAR = null output,
                    @GIFTYEARLO dbo.UDT_YEAR = null output,
                    @TYPECODE int = null output,
                    @EIN nvarchar(50) = null output,
                    @SOURCE nvarchar(100) = null output,
                    @PHILANTHROPICGIFTID int = null output,
                    @HOUSEHOLDID nvarchar(30) = null output,
                    @TASCORE int = null output,
                    @MATCHADDRESS nvarchar(100) = null output,
                    @MATCHCITY nvarchar(20) = null output,
                    @MATCHSTATE nvarchar(2) = null output,
                    @MATCHZIP nvarchar(5) = null output,
                    @ACCOUNTTYPECODE smallint = null output,
                    @MATCHCODE nvarchar(100) = null output
                ) as begin

                    set nocount on;

                    set @DATALOADED = 0;

                    select 
                        @DATALOADED = 1,
                        @CDATE = CDATE,
                        @CVALUE = CVALUE,
                        @CNOTES = CNOTES,
                        @ORGANIZATION = ORGANIZATION,
                        @LOCATION = LOCATION,
                        @GIFTYEAR = GIFTYEAR,
                        @TYPE = TYPE,
                        @CATEGORY = CATEGORY,
                        @LO = LO,
                        @HI = HI,
                        @NAME = NAME,
                        @ORGANIZATIONWEBADDRESS = ORGANIZATIONWEBADDRESS,
                        @SOURCEMATERIAL = SOURCEMATERIAL,
                        @GIFTYEARHI = GIFTYEARHI,
                        @GIFTYEARLO = GIFTYEARLO,
                        @TYPECODE = TYPECODE,
                        @EIN = EIN,
                        @SOURCE = SOURCE,
                        @PHILANTHROPICGIFTID = PHILANTHROPICGIFTID,
                        @HOUSEHOLDID = HOUSEHOLDID,
                        @TASCORE = TASCORE,
                        @MATCHADDRESS = MATCHADDRESS,
                        @MATCHCITY = MATCHCITY,
                        @MATCHSTATE = MATCHSTATE,
                        @MATCHZIP = MATCHZIP,
                        @MATCHCODE = MC + ' - ' + dbo.UFN_WPMATCHCODE_DESCRIPTION(MC)
                    from
                        dbo.WPPHILANTHROPICGIFT
                    where
                        ID=@ID;

                    select @ACCOUNTTYPECODE = ACCOUNTTYPECODE from dbo.WEALTHPOINTCONFIGURATION;

                    return 0;

                end;