USP_SIMPLEDATALIST_RECOGNITIONLEVEL

A list of recognition levels for a recognition program.

Parameters

Parameter	Parameter Type	Mode	Description
@RECOGNITIONPROGRAMID	uniqueidentifier	IN	RECOGNITIONPROGRAMID

Definition

Copy



                create procedure dbo.USP_SIMPLEDATALIST_RECOGNITIONLEVEL
                (
                    @RECOGNITIONPROGRAMID uniqueidentifier
                )
                as

                    set nocount on;

                    select
                        ID as VALUE,
                        NAME as LABEL
                    from
                        dbo.RECOGNITIONLEVEL
                    where
                        RECOGNITIONPROGRAMID = @RECOGNITIONPROGRAMID
                        and RECOGNITIONLEVEL.ISACTIVE='True' 
                    order by NAME