USP_MODELINGANDPROPENSITY_GETRATINGS

                    CREATE procedure dbo.[USP_MODELINGANDPROPENSITY_GETRATINGS]
                    (
                        @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

                            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.CONSTITUENT
                        left join dbo.MODELINGANDPROPENSITY MP
                            on CONSTITUENT.ID = 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
                            CONSTITUENT.ID = @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;