UFN_PROSPECTPLAN_STEPS

Returns the steps for a plan

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTPLANID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PROSPECTPLAN_STEPS(@PROSPECTPLANID uniqueidentifier)
            returns table
            as return
                select 
                    ID, PLANOUTLINESTEPID, OBJECTIVE, FUNDRAISERID, PROSPECTPLANSTATUSCODEID, STATUSCODE, EXPECTEDDATE, ACTUALDATE, INTERACTIONTYPECODEID, CONSTITUENTID
                from
                    dbo.INTERACTION
                where
                    PROSPECTPLANID = @PROSPECTPLANID
                    and COMPLETED = 0;