USP_DATALIST_CONSTITUENTPROFILEDASHBOARDVOLUNTEERASSIGNMENTS

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

                        if @ISVISIBLE = 1
                        begin
                            select
                                JOB.NAME as JOB,
                                JOBOCCURRENCE.DESCRIPTION as OCCURRENCE,
                                VOLUNTEERLOCATIONCODE.DESCRIPTION as LOCATION,
                                VOLUNTEERASSIGNMENT.DATE,
                                dbo.UFN_HOURMINUTE_DISPLAYTIME(JOBOCCURRENCE.STARTTIME) as STARTTIME,
                                dbo.UFN_HOURMINUTE_DISPLAYTIME(JOBOCCURRENCE.ENDTIME) as ENDTIME
                            from dbo.VOLUNTEERASSIGNMENT
                            inner join dbo.JOBOCCURRENCE on VOLUNTEERASSIGNMENT.JOBOCCURRENCEID = JOBOCCURRENCE.ID
                            inner join dbo.JOB on JOB.ID = JOBOCCURRENCE.JOBID
                            left join dbo.VOLUNTEERLOCATIONCODE on VOLUNTEERLOCATIONCODE.ID = JOBOCCURRENCE.LOCATIONCODEID
                            where VOLUNTEERASSIGNMENT.VOLUNTEERID = @CONSTITUENTID
                            order by JOBOCCURRENCE.DESCRIPTION;
                        end