UFN_PROSPECTPLAN_SECONDARYFUNDRAISERS

Returns the secondary fundraisers for a prospect plan.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTPLANID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_PROSPECTPLAN_SECONDARYFUNDRAISERS(@PROSPECTPLANID uniqueidentifier)
            returns table 
            as return
                select 
                    SF.ID, 
                    SF.FUNDRAISERID, 
                    SF.SOLICITORROLECODEID, 
                    SF.SEQUENCE, 
                    NF_C.NAME, 
                    SRC.DESCRIPTION as SOLICITORROLECODE,
                    SF.DATEFROM,
                    SF.DATETO
                from 
                    dbo.SECONDARYFUNDRAISER as SF
                    left join SOLICITORROLECODE as SRC on SF.SOLICITORROLECODEID = SRC.ID
                    cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(SF.FUNDRAISERID) NF_C
                where 
                    SF.PROSPECTPLANID=@PROSPECTPLANID