USP_DATALIST_RECOGNITIONLEVEL

Displays the list of recognition levels for a program.

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_RECOGNITIONLEVEL
                    (
                        @RECOGNITIONPROGRAMID uniqueidentifier,
                        @INCLUDEINACTIVE bit = 0
                    )
                as
                    set nocount on;

                    select RL.ID,
                           RL.NAME,
                            RL.DESCRIPTION,
                           TIERCODE.DESCRIPTION AS TIER,
                           RL.AMOUNT,
                           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