USP_DATAFORMTEMPLATE_ADD_PRELOAD_RECOGNITIONLEVEL

The load procedure used by the edit dataform template "Recognition Level Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@RECOGNITIONPROGRAMID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@HASPLANNEDGIFTAMOUNT	bit	INOUT
@HASREVENUEAMOUNT	bit	INOUT
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PRELOAD_RECOGNITIONLEVEL
                    (
                        @RECOGNITIONPROGRAMID uniqueidentifier,
                        @HASPLANNEDGIFTAMOUNT bit = null output,
                        @HASREVENUEAMOUNT bit = null output,
                        @BASECURRENCYID uniqueidentifier = null output
                    )
                    as

                    set nocount on;

                    select @HASPLANNEDGIFTAMOUNT = 
                              case when PLANNEDGIFTCODE = 2 then
                                    1
                                else
                                    0
                                end
                    from dbo.RECOGNITIONPROGRAM
                    where ID = @RECOGNITIONPROGRAMID;

                    --HASREVENUEAMOUNT depreciated

                    set @HASREVENUEAMOUNT = 1;

                    select
                        @BASECURRENCYID = RECOGNITIONPROGRAM.BASECURRENCYID
                    from dbo.RECOGNITIONPROGRAM
                    where RECOGNITIONPROGRAM.ID = @RECOGNITIONPROGRAMID;