USP_REPORT_PURPOSEPROFILE

Returns the data necessary for the Fundraising Purpose Profile report.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            CREATE proc dbo.USP_REPORT_PURPOSEPROFILE (@ID uniqueidentifier = null)
            as
                select    
                    DESIGNATIONLEVEL.ID, 
                    DESIGNATIONLEVEL.[NAME], 
                    DESIGNATIONLEVEL.DESCRIPTION, 
                    DLC.DESCRIPTION as CATEGORY, 
                    FPT.DESCRIPTION AS DESIGNATIONLEVELTYPE,
          DESIGNATIONLEVEL.ISACCEPTINGFUNDS,
          DESIGNATIONLEVEL.ISDISBURSINGMONEY
                from
                    dbo.DESIGNATIONLEVEL
                    inner join dbo.DESIGNATIONLEVELTYPE FPT on DESIGNATIONLEVEL.DESIGNATIONLEVELTYPEID = FPT.ID
                    left join dbo.DESIGNATIONLEVELCATEGORYCODE DLC on DESIGNATIONLEVEL.DESIGNATIONLEVELCATEGORYCODEID = DLC.ID
                    /*#IDSETEXTENSION*/
                where
                    (DESIGNATIONLEVEL.ID = @ID or @ID is null);