UFN_PROSPECTPLAN_FUNDRAISERS

Gets a table of fundraiser IDs for a given prospect plan.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTPLANID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PROSPECTPLAN_FUNDRAISERS(@PROSPECTPLANID uniqueidentifier) 
            returns table
            as return
                select 0 SEQUENCE, 'Primary manager' FUNDRAISERROLE, PRIMARYMANAGERFUNDRAISERID ID from dbo.PROSPECTPLAN where ID=@PROSPECTPLANID
                union all
                select 1 SEQUENCE, 'Secondary manager' FUNDRAISERROLE, SECONDARYMANAGERFUNDRAISERID ID from dbo.PROSPECTPLAN where ID=@PROSPECTPLANID
                union all
                select 
                    SF.SEQUENCE + 2 SEQUENCE, 
                    coalesce(SRC.DESCRIPTION, 'Secondary solicitor') FUNDRAISERROLE, 
                    SF.FUNDRAISERID ID 
                from 
                    dbo.SECONDARYFUNDRAISER SF
                    left outer join dbo.SOLICITORROLECODE SRC on SRC.ID=SF.SOLICITORROLECODEID
                where
                    SF.PROSPECTPLANID = @PROSPECTPLANID