USP_DATAFORMTEMPLATE_VIEW_PLEDGEGIFTFEE

The load procedure used by the view dataform template "Pledge Gift Fee View Edit 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.
@USECUSTOM	bit	INOUT	Use custom gift fees
@CUSTOMFEE	numeric(5, 1)	INOUT	Gift fee
@APPLYFEE	bit	INOUT	Apply gift fees to pledge payments

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PLEDGEGIFTFEE
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @USECUSTOM bit = null output,
                @CUSTOMFEE numeric(5, 1) = null output,
                @APPLYFEE bit = null output
            )
            as
            begin                                                
                set nocount on;

                --Set default values if row does not exist

                select @DATALOADED = 1, @APPLYFEE = 1;

                select 
                    @USECUSTOM = USECUSTOM,
                    @CUSTOMFEE = CUSTOMFEE,
                    @APPLYFEE = case when WAIVEFEE = 1 then 0 else 1 end
                from
                    dbo.PLEDGEGIFTFEEOVERRIDE
                where
                    ID = @ID;

                return 0;                    
            end