UFN_STEWARDSHIPPLANTEMPLATE_STEPS

Returns steps from a stewardship plan template.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@TEMPLATEID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_STEWARDSHIPPLANTEMPLATE_STEPS
(
    @TEMPLATEID uniqueidentifier
)
returns table
as return
    select    
        STEWARDSHIPPLANTEMPLATESTEP.ID,
        STEWARDSHIPPLANTEMPLATESTEP.CATEGORYCODEID,
        STEWARDSHIPPLANTEMPLATESTEP.OBJECTIVE,
        STEWARDSHIPPLANTEMPLATESTEP.DATEOPTIONCODE,
        STEWARDSHIPPLANTEMPLATESTEP.DAYSFROMSTART,
        STEWARDSHIPPLANTEMPLATESTEP.TARGETDATE,
        STEWARDSHIPPLANTEMPLATESTEP.DATELOCKED,
        STEWARDSHIPPLANTEMPLATESTEP.CONTACTMETHODCODEID,
        STEWARDSHIPPLANTEMPLATE.NAME as TEMPLATE,
        STEWARDSHIPPLANTEMPLATESTEP.RECURSCODE            
    from 
        dbo.STEWARDSHIPPLANTEMPLATE

    inner join dbo.STEWARDSHIPPLANTEMPLATESTEP            
        on STEWARDSHIPPLANTEMPLATE.ID = STEWARDSHIPPLANTEMPLATESTEP.TEMPLATEID

    where 
        STEWARDSHIPPLANTEMPLATE.ID = @TEMPLATEID;