USP_DATALIST_STEWARDSHIPPLANASSIGNMENTPROCESS

Returns a list of stewardship plan assignment process parameter sets.

Parameters

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

Definition

Copy



create procedure dbo.USP_DATALIST_STEWARDSHIPPLANASSIGNMENTPROCESS
(
    @CURRENTAPPUSERID uniqueidentifier = null
)
as
    set nocount on;

    select
        /*Add additional select fields here*/
        STEWARDSHIPPLANASSIGNMENTPROCESS.ID,
        STEWARDSHIPPLANASSIGNMENTPROCESS.NAME,
        STEWARDSHIPPLANASSIGNMENTPROCESS.DESCRIPTION,
        IDSETREGISTER.NAME as PLANSELECTION,
        BPI.OWNERID as OWNERID
    from
        dbo.STEWARDSHIPPLANASSIGNMENTPROCESS
        left join dbo.BUSINESSPROCESSINSTANCE BPI on STEWARDSHIPPLANASSIGNMENTPROCESS.ID = BPI.BUSINESSPROCESSPARAMETERSETID
        left join dbo.IDSETREGISTER on STEWARDSHIPPLANASSIGNMENTPROCESS.IDSETREGISTERID = IDSETREGISTER.ID
    where 
        dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, STEWARDSHIPPLANASSIGNMENTPROCESS.ID) = 1
    order by STEWARDSHIPPLANASSIGNMENTPROCESS.NAME