UFN_STEWARDSHIPPLAN_PARTICIPANTS

create function dbo.UFN_STEWARDSHIPPLAN_PARTICIPANTS
(
    @PLANID uniqueidentifier
) 
returns table
as return
    select
        STEWARDSHIPPLANPARTICIPANT.ID, 
        STEWARDSHIPPLANPARTICIPANT.CONSTITUENTID, 
        STEWARDSHIPPLANPARTICIPANT.ROLECODEID, 
        CONSTITUENT.NAME, 
        STEWARDSHIPPARTICIPANTROLECODE.DESCRIPTION as PLANPARTICIPANTROLECODE
    from 
        dbo.STEWARDSHIPPLANPARTICIPANT
    join dbo.CONSTITUENT 
        on STEWARDSHIPPLANPARTICIPANT.CONSTITUENTID = CONSTITUENT.ID
    left outer join dbo.STEWARDSHIPPARTICIPANTROLECODE 
        on STEWARDSHIPPLANPARTICIPANT.ROLECODEID = STEWARDSHIPPARTICIPANTROLECODE.ID

    where STEWARDSHIPPLANPARTICIPANT.PLANID = @PLANID