USP_DATALIST_DESIGNATIONLEVELSTEWARDSHIPRECIPIENTS

                CREATE procedure dbo.USP_DATALIST_DESIGNATIONLEVELSTEWARDSHIPRECIPIENTS(@ID uniqueidentifier = null)
                as                 
                    set nocount on;

                    select 
                        distinct D.ID, 
                        D.CONSTITUENTID,
                        NF.NAME,
                        S.DESCRIPTION as TYPE,
                        D.STARTDATE,
                        D.ENDDATE
                    from dbo.DESIGNATIONLEVELSTEWARDSHIPRECIPIENTS D
                        left outer join dbo.STEWARDSHIPRECIPIENTTYPECODE S on D.TYPECODEID = S.ID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(D.CONSTITUENTID) NF
                    where D.CONSTITUENTID is not null and D.DESIGNATIONLEVELID = @ID