USP_DATALIST_PROSPECTANALYSIS_DASHBOARDS

                CREATE procedure dbo.USP_DATALIST_PROSPECTANALYSIS_DASHBOARDS (
                    @CURRENTAPPUSERID uniqueidentifier
                ) as
                    set nocount on;

                    select
                        PROSPECTSEGMENTATION.ID,
                        1 as REPORTTYPECODE,
            PROSPECTSEGMENTATION.STATUSCODE as UPDATEREQUIRED,
                        PROSPECTSEGMENTATION.NAME,
                        PROSPECTSEGMENTATION.DESCRIPTION,
            PROSPECTSEGMENTATION.STATUS,
                        PROSPECTSEGMENTATION.OWNERID,
                        APPUSER.USERNAME OWNER,
                        CHANGEAGENT.USERNAME ADDEDBY,
                        PROSPECTSEGMENTATION.DATEADDED,
            PROSPECTSEGMENTATION.DATEUPDATED,
                        case when (
                            PROSPECTSEGMENTATION.OTHERSCANMODIFY = 1 or
                            PROSPECTSEGMENTATION.OWNERID = @CURRENTAPPUSERID or
                            PROSPECTSEGMENTATION.OWNERID is null or
                            dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1) then 1
                            else 0
                            end USERCANMODIFY
                    from
                        dbo.PROSPECTSEGMENTATION
                    left join dbo.APPUSER on
            APPUSER.ID = PROSPECTSEGMENTATION.OWNERID
                    left join dbo.CHANGEAGENT on 
            CHANGEAGENT.ID = PROSPECTSEGMENTATION.ADDEDBYID