UFN_PLANOUTLINE_STEPSFORPROSPECT

Returns steps from a plan outline for use on a specific prospect plan.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@PLANOUTLINEID	uniqueidentifier	IN
@PROSPECTID	uniqueidentifier	IN
@BASEDATE	datetime	IN

Definition

Copy



            CREATE function dbo.UFN_PLANOUTLINE_STEPSFORPROSPECT(@PLANOUTLINEID uniqueidentifier, @PROSPECTID uniqueidentifier, @BASEDATE datetime)
            returns @RET table (
                PLANOUTLINESTEPID uniqueidentifier,
                OBJECTIVE nvarchar(100),
                OWNERID uniqueidentifier,
                PROSPECTPLANSTATUSCODEID uniqueidentifier,
                EXPECTEDDATE datetime,
                INTERACTIONTYPECODEID uniqueidentifier,
                FUNDRAISERID uniqueidentifier
            )
            with execute as caller
            as begin
                declare @PROSPECTMANAGERFUNDRAISERID uniqueidentifier;
                select @PROSPECTMANAGERFUNDRAISERID = PROSPECTMANAGERFUNDRAISERID from dbo.PROSPECT where ID=@PROSPECTID;

                insert into @RET
                select 
                    ID,
                    OBJECTIVE, 
                    case FUNDRAISERROLECODE when 0 then @PROSPECTMANAGERFUNDRAISERID else null end,
                    PROSPECTPLANSTATUSCODEID, 
                    dateadd(day, DATEOFFSET, dbo.UFN_DATE_GETEARLIESTTIME(@BASEDATE)),
                    INTERACTIONTYPECODEID,
                    case FUNDRAISERROLECODE when 0 then @PROSPECTMANAGERFUNDRAISERID else null end
                from 
                    dbo.PLANOUTLINESTEP
                where 
                    PLANOUTLINEID=@PLANOUTLINEID;

                return;
            end