UFN_PLANOUTLINE_STEPS

Returns a plan outline's steps.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PLANOUTLINEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PLANOUTLINE_STEPS(@PLANOUTLINEID uniqueidentifier)
            returns table
            as return
                select ID, OBJECTIVE, FUNDRAISERROLECODE, PROSPECTPLANSTATUSCODEID, DATEOFFSET, INTERACTIONTYPECODEID
                from dbo.PLANOUTLINESTEP
                where PLANOUTLINEID=@PLANOUTLINEID