UFN_CONSTITUENTMATCH_SUFFIXSCOREDEDUCTION_BYRESULT

            create function dbo.UFN_CONSTITUENTMATCH_SUFFIXSCOREDEDUCTION_BYRESULT (
                @SUFFIXRESULT tinyint
            )
            returns table -- Writing as in-line table for performance vs scalar function

            with schemabinding
            as return
                -- minimal deductions for mismatched suffixes unless they are incompatible (e.g., Jr/Sr)

                -- in that case manual review if all else is likely match or higher

                select
                    case @SUFFIXRESULT 
                        --when 0 then 0 

                        when 1 then 1 
                        when 2 then 3 
                        when 3 then 18 
                        else 0 
                    end as DEDUCTION;