USP_RESEARCHGROUPREPORT_GETMODELINGANDPROPENSITYRATINGS

            CREATE procedure dbo.[USP_RESEARCHGROUPREPORT_GETMODELINGANDPROPENSITYRATINGS]
                    (
                        @ID uniqueidentifier,
                        @CURRENTAPPUSERID uniqueidentifier = null
                    )
                    as
                        set NOCOUNT on;

                        declare @ISADMIN bit;
                        declare @APPUSER_IN_NONRACROLE bit;
                        declare @APPUSER_IN_NOSECGROUPROLE bit;

                        set @ISADMIN = dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID);
                        set @APPUSER_IN_NONRACROLE = dbo.UFN_SECURITY_APPUSER_IN_NONRACROLE(@CURRENTAPPUSERID);
                        set @APPUSER_IN_NOSECGROUPROLE = dbo.UFN_SECURITY_APPUSER_IN_NO_SECURITY_GROUP_ROLE(@CURRENTAPPUSERID);

                        select
                            RGM.CONSTITUENTID,
                            MP.ANNUALGIFTLIKELIHOOD,
                            MP.ANNUITYLIKELIHOOD,
                            MP.BEQUESTLIKELIHOOD,
                            MP.CRTLIKELIHOOD,
                            MP.MAJORGIVINGLIKELIHOOD,
                            MP.MEMBERSHIPLIKELIHOOD,
                            SUGGESTEDMEMBERSHIPLEVEL.RANGE as SUGGESTEDMEMBERSHIPLEVEL,
                            MP.NCOAMOVEDINDICATOR,
                            MP.ONLINEGIVINGLIKELIHOOD,
                            MP.PATIENTRESPONSELIKELIHOOD,
                            MP.PLANNEDGIFTLIKELIHOOD,
                            TARGETGIFTRANGE.RANGE as TARGETGIFTRANGE,
                            MP.WPSCREENINGINDICATOR,
                            WEALTHESTIMATORRATING.RANGE as WEALTHESTIMATORRATING
                        from
                            dbo.RESEARCHGROUPMEMBER RGM
                        left join dbo.MODELINGANDPROPENSITY MP
                            on RGM.CONSTITUENTID = MP.ID
                        left join dbo.SUGGESTEDMEMBERSHIPLEVEL
                            on MP.SUGGESTEDMEMBERSHIPLEVELID = SUGGESTEDMEMBERSHIPLEVEL.ID
                        left join dbo.TARGETGIFTRANGE
                            on MP.TARGETGIFTRANGEID = TARGETGIFTRANGE.ID
                        left join dbo.WEALTHESTIMATORRATING
                            on MP.WEALTHESTIMATORRATINGID = WEALTHESTIMATORRATING.ID
                        where
                            RGM.RESEARCHGROUPID = @ID
                            and (@ISADMIN = 1 or 
                                    @APPUSER_IN_NONRACROLE = 1 or
                                    dbo.UFN_SECURITY_APPUSER_GRANTED_CONSTITID_FORREPORT(@CURRENTAPPUSERID, @ID, @APPUSER_IN_NOSECGROUPROLE) = 1)

                        return 0;