USP_DATALIST_CONSTITUENTRECOGNITIONDECLINEDLEVELS

A list of declined recognition levels for a constituent.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTRECOGNITIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



    CREATE procedure dbo.USP_DATALIST_CONSTITUENTRECOGNITIONDECLINEDLEVELS(@CONSTITUENTRECOGNITIONID uniqueidentifier)
    as
        set nocount on;

        select 
             DECLINED.ID,
             RL.NAME AS LEVEL,
             DECLINED.DATEADDED,
             RECOGNITIONDECLINEDLEVELREASONCODE.DESCRIPTION as REASONCODE
        from dbo.CONSTITUENTRECOGNITION
      inner join dbo.CONSTITUENTRECOGNITIONDECLINEDLEVEL DECLINED ON DECLINED.CONSTITUENTID = CONSTITUENTRECOGNITION.CONSTITUENTID
       left join dbo.RECOGNITIONDECLINEDLEVELREASONCODE on DECLINED.REASONCODEID = RECOGNITIONDECLINEDLEVELREASONCODE.ID
      inner join dbo.RECOGNITIONLEVEL RL ON RL.ID = DECLINED.RECOGNITIONLEVELID
        where CONSTITUENTRECOGNITION.ID = @CONSTITUENTRECOGNITIONID
      and CONSTITUENTRECOGNITION.RECOGNITIONPROGRAMID = DECLINED.RECOGNITIONPROGRAMID
      order by DATEADDED desc