USP_DATALIST_PROSPECTPLAN_PARTICIPANTS

List of participants for a given prospect plan.

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTPLANID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_PROSPECTPLAN_PARTICIPANTS(@PROSPECTPLANID uniqueidentifier)
                as begin
                    set nocount on;
                    select PP.ID, PP.CONSTITUENTID, NF.NAME, PPRC.DESCRIPTION as PLANPARTICIPANTROLECODE
                    from dbo.PLANPARTICIPANT as PP
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(PP.CONSTITUENTID) NF
                    left outer join dbo.PLANPARTICIPANTROLECODE as PPRC on PP.PLANPARTICIPANTROLECODEID = PPRC.ID
                    where PP.PROSPECTPLANID=@PROSPECTPLANID
                end