USP_SIMPLEDATALIST_PLANNEDGIFTPROSPECTPLANS

Returns a list of prospect plans that the user can select for a planned gift.

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTID	uniqueidentifier	IN	Prospect
@PLANNEDGIFTID	uniqueidentifier	IN	Planned Gift
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_PLANNEDGIFTPROSPECTPLANS(
                    @PROSPECTID uniqueidentifier = null,
                    @PLANNEDGIFTID uniqueidentifier = null,
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as begin
                    set nocount on;
                    select 
                        PROSPECTPLAN.ID as VALUE,
                        PROSPECTPLAN.NAME as LABEL
                    from dbo.PROSPECTPLAN
                        left join dbo.PROSPECTPLANSITE on PROSPECTPLANSITE.PROSPECTPLANID = PROSPECTPLAN.ID
                    where PROSPECTPLAN.PROSPECTID=@PROSPECTID
                        and (dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, PROSPECTPLANSITE.SITEID) = 1)
                        and ISACTIVE = 1
                    union
                    select 
                        PROSPECTPLAN.ID as VALUE,
                        PROSPECTPLAN.NAME as LABEL
                    from dbo.PLANNEDGIFT
                        inner join dbo.PROSPECTPLAN on PROSPECTPLAN.ID = PLANNEDGIFT.PROSPECTPLANID
                    where PLANNEDGIFT.ID = @PLANNEDGIFTID
                    order by
                        LABEL;

                end