USP_SIMPLEDATALIST_STEWARDSHIPPLANTEMPLATES

List of stewardship plan templates.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_STEWARDSHIPPLANTEMPLATES
(
    @CURRENTAPPUSERID uniqueidentifier
)
as
    select
        ID as VALUE, 
        NAME as LABEL
    from 
        dbo.STEWARDSHIPPLANTEMPLATE    
    where 
        exists(select ID from dbo.STEWARDSHIPPLANTEMPLATESTEP where TEMPLATEID = STEWARDSHIPPLANTEMPLATE.ID)
    and
        dbo.UFN_STEWARDSHIPPLANTEMPLATE_USERHASSITEACCESS(@CURRENTAPPUSERID, ID) = 1
    order by
        NAME