USP_SIMPLEDATALIST_CONSTITUENTRECOGNITIONDECLINEDLEVELS

Simple data list that returns a list of all declined levels for a constituent recognition program

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN

Definition

Copy



  CREATE procedure dbo.USP_SIMPLEDATALIST_CONSTITUENTRECOGNITIONDECLINEDLEVELS
        (
          @CONSTITUENTID uniqueidentifier,
          @CURRENTAPPUSERID uniqueidentifier = null,
          @SECURITYFEATUREID uniqueidentifier = null,
          @SECURITYFEATURETYPE tinyint = null
        )
        as

                    set nocount on;

            select
                        ID as VALUE,
                        NAME as LABEL
                      from dbo.RECOGNITIONPROGRAM
           where
            (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[RECOGNITIONPROGRAM].[SITEID] or (SITEID is null and [RECOGNITIONPROGRAM].[SITEID] is null)))
            and ID not in(select DECLINEDLEVEl.RECOGNITIONPROGRAMID from dbo.CONSTITUENTRECOGNITIONDECLINEDLEVEL DECLINEDLEVEL where DECLINEDLEVEl.CONSTITUENTID = @CONSTITUENTID)
            and ID not in(select DECLINEDPROGRAM.RECOGNITIONPROGRAMID from dbo.CONSTITUENTRECOGNITIONDECLINEDPROGRAM DECLINEDPROGRAM where DECLINEDPROGRAM.CONSTITUENTID = @CONSTITUENTID)