USP_DATALIST_RECOGNITIONLEVELALLAMOUNT

Displays the list of recognition levels for a program with planned giving and revenue amounts.

Parameters

Parameter	Parameter Type	Mode	Description
@RECOGNITIONPROGRAMID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@INCLUDEINACTIVE	bit	IN	Include inactive levels

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_RECOGNITIONLEVELALLAMOUNT
        (
          @RECOGNITIONPROGRAMID uniqueidentifier,
          @INCLUDEINACTIVE bit = 0
        )
                as
                    set nocount on;

                    select RL.ID,
                           RL.NAME,
                            RL.DESCRIPTION,
                           TIERCODE.DESCRIPTION AS TIER,
                           RL.AMOUNT,
                           RL.PLANNEDGIFTAMOUNT,
                           RL.ISACTIVE,
                           RL.BASECURRENCYID
                    from dbo.RECOGNITIONLEVEL RL
                    left join dbo.TIERCODE on RL.TIERCODEID = TIERCODE.ID
                    where RECOGNITIONPROGRAMID = @RECOGNITIONPROGRAMID
          and (RL.ISACTIVE = 1 or @INCLUDEINACTIVE = 1)
                    order by RL.AMOUNT asc