USP_DATALIST_CONSTITUENTPROFILEDASHBOARDINTERACTIONS

                    CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILEDASHBOARDINTERACTIONS
                    (
                        @CONSTITUENTID uniqueidentifier,
                        @ISVISIBLE bit = 1
                    )
                    as
                        set nocount on;

                        if @ISVISIBLE = 1
                        begin
                            select 
                                I.DATE,
                                case I.COMPLETED when 1 then 'Completed' else I.STATUS end STATUS,
                                coalesce(FC.NAME, '') OWNER,
                                I.OBJECTIVE,
                                dbo.UFN_INTERACTIONTYPECODE_GETDESCRIPTION(I.INTERACTIONTYPECODEID) TYPE
                            from
                                dbo.INTERACTION I
                                left outer join dbo.CONSTITUENT FC on FC.ID=I.FUNDRAISERID
                            where
                                I.CONSTITUENTID=@CONSTITUENTID
                                and I.ISINTERACTION=1
                                and I.STATUSCODE!=0
                            order by
                                I.DATE
                        end