UFN_DESIGNATIONLEVEL_GETSTEWARDSHIPRECIPIENTS

Returns the stewardship recipients for a given designation level.
Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode	Description
@DESIGNATIONLEVELID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
Definition

Copy


            CREATE function [dbo].[UFN_DESIGNATIONLEVEL_GETSTEWARDSHIPRECIPIENTS]
            (
                @DESIGNATIONLEVELID uniqueidentifier,
                @CURRENTAPPUSERID uniqueidentifier
            )            
            returns @RECIPIENTS table
                (
                    ID uniqueidentifier,
                    CONSTITUENTID uniqueidentifier NOT NULL,
                    CONSTITUENTNAME nvarchar(154) NOT NULL
                )
            as
            begin
                declare @STEWARDSHIPRECIPIENTCOUNT int;
                select @STEWARDSHIPRECIPIENTCOUNT = count(*) from dbo.DESIGNATIONLEVELSTEWARDSHIPRECIPIENTS where DESIGNATIONLEVELID = @DESIGNATIONLEVELID;                                    

                if @STEWARDSHIPRECIPIENTCOUNT = 0      --if the stewardship recipient list has not been modified, derive the recipients from the donor list

                    begin    
                       insert @RECIPIENTS
                       select distinct null, 
                            CONSTITUENTID, 
                            dbo.UFN_CONSTITUENT_BUILDNAME(CONSTITUENTID) NAME
                       from dbo.UFN_DESIGNATIONLEVEL_GETDONORS(@DESIGNATIONLEVELID, null, null, @CURRENTAPPUSERID);
                    end
                else  
                    begin
                        insert @RECIPIENTS
                        select ID, CONSTITUENTID, dbo.UFN_CONSTITUENT_BUILDNAME(CONSTITUENTID) NAME
                        from dbo.DESIGNATIONLEVELSTEWARDSHIPRECIPIENTS
                        where DESIGNATIONLEVELID = @DESIGNATIONLEVELID;                        
                    end                    

               RETURN

            end