Loading
Insurance
Table of Contents
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

          Search all of Salesforce Help
          Group Voluntary Benefits Expression Sets

          Group Voluntary Benefits Expression Sets

          The expression sets for the product categories Vision, Dental, Medical, Critical Illness, and Dental Summary include variables, constants, decision matrices, and calculation steps.

          To learn more about creating and editing expression sets, see Expression Sets.

          Expression Sets

          Here are the expression sets we use for the Group Voluntary Benefits product categories:

          Product Category Name Expression Set Name
          Vision VisionExpressionSet
          Dental DentalPremiumExpressionSet
          Medical MedicalExpressionSet
          Critical Illness CriticalIllnessExpressionSet
          Dental Summary DentalSummaryRating

          Here's what each step of these expression sets do:

          1. Checks the rating type, whether the calculation is for enrollment or quoting process.
          2. Uses the decision matrix to fetch the base premium based on the age and product code.
          3. Increases the premium by a corresponding factor multiplied to the base premium for each optional coverage selected.
          4. Calculates the member premium from the final premium that’s received in the previous two steps.
          5. Aggregates the member premium for a family or a census to calculate the corresponding premium for the product.

          Decision Matrices

          All these expression sets call specific decision matrices that evaluates input parameters to provide base premium as the output.

          Expression Set Name Decision Matrix Name (Lookup Table) Input Field (Data Type) Output Field (Data Type)
          VisionExpressionSet VisionRatingMatrixRRF Age (Number Range) and Product Code (Text) Base Premium (Currency)
          DentalPremiumExpressionSet DentalRatingMatrix Age (Number Range) and Product Code (Text) Base Premium (Currency)
          MedicalExpressionSet MedicalRatingMatrixRRF Age (Number Range) and Product Code (Text) Base Premium (Currency)
          CriticalIllnessExpressionSet CriticalillnessRatingMatrixRRF Age (Number Range) and Product Code (Text) Base Premium (Currency)
          DentalSummaryRating DentalSummaryRatingMatrix Age (Number Range) and Product Code (Text) Base Premium (Currency)
           
          Loading
          Salesforce Help | Article