UFN_STEWARDSHIPPLANSTEP_PARTICIPANTS

Returns the participants for a stewardship plan step.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@STEWARDSHIPPLANSTEPID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_STEWARDSHIPPLANSTEP_PARTICIPANTS
            (
                @STEWARDSHIPPLANSTEPID uniqueidentifier
            ) 
            returns table
            as return (
                select
                    STEWARDSHIPPLANSTEPPARTICIPANT.ID, 
                    STEWARDSHIPPLANSTEPPARTICIPANT.CONSTITUENTID,
                    NF.NAME
                from 
                    dbo.STEWARDSHIPPLANSTEPPARTICIPANT
                cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(STEWARDSHIPPLANSTEPPARTICIPANT.CONSTITUENTID) NF
                where STEWARDSHIPPLANSTEPPARTICIPANT.STEWARDSHIPPLANSTEPID = @STEWARDSHIPPLANSTEPID
            )