Product Configuration¶

This guide explains how to configure insurance products in the tiger Rating Engine, including setting up rating factors, tables, formulas, and managing product versions.

Overview ¶

Product configuration involves four main components:

Products: Define insurance lines (BOP, Auto, etc.)
Rating Factors: Input variables for calculations
Rating Tables: Multi-dimensional rate lookups
Formulas: Calculation logic and rules

Product Configuration Overview — *Screenshot Placeholder: Admin dashboard showing four tiles - Products (3 active), Rating Factors (45 total), Rating Tables (12 active), Formulas (38 configured) with “Configure” buttons*¶

Accessing Configuration ¶

Admin Interface ¶

Access the admin interface:

Navigate to /admin/
Log in with admin credentials
See the Rating section in the sidebar

Note

Only users with Product Manager or Administrator roles can access configuration.

Navigation Structure ¶

Admin Navigation — *Screenshot Placeholder: Admin sidebar showing Rating section expanded with Products, Rating Factors, Rating Tables, Rating Table Values, Formulas, Rating Runs, and Rating Coverages*¶

Admin sections:

Products: Main product definitions
Rating Factors: Input field configurations
Rating Tables: Rate lookup tables
Rating Table Values: Individual table entries
Formulas: Calculation logic
Rating Runs: Calculation history (read-only)
Rating Coverages: Coverage results (read-only)

Creating a New Product ¶

Step 1: Product Definition ¶

New Product Form — *Screenshot Placeholder: Product creation form with fields for Product Code, Product Name, Description, Effective Date, End Date (optional), Is Active checkbox*¶

To create a new product:

Click Products → Add Product

Fill in required fields:

Product Code: GL_POLICY
Product Name: General Liability Insurance
Description: Comprehensive general liability coverage for businesses
Effective Date: 2025-02-01
End Date: [Leave blank for no expiration]
☑ Is Active

Click Save and continue editing

Step 2: Product Settings ¶

Configure product settings:

Base Premium: Starting calculation point
Minimum Premium: Floor value
Maximum Premium: Ceiling value
Options: Special features or rules

Setting Up Rating Factors ¶

Understanding Factor Types ¶

Rating Factor Types — Screenshot Placeholder: Grid showing different factor types with examples - Text (territory), Decimal (building_value), Integer (employees), Choice (class_code), Boolean (sprinklers), Date (prior_claims_date)¶

Factor types available:

Creating a Rating Factor ¶

To create a factor:

Navigate to Rating Factors → Add Rating Factor

Complete the form:

Basic Information:
├── Product: [Select Product]
├── Factor Code: building_sqft
├── Factor Name: Building Square Footage
└── Description: Total square footage of insured building

Configuration:
├── Data Type: Decimal
├── Required: ☑
└── Default Value: [Leave blank or set default]

Validation Rules:
├── Minimum Value: 500
├── Maximum Value: 1000000
└── Decimal Places: 0

Click Save

Factor Validation Rules ¶

Configure validation:

Required Field: Must be provided
Min/Max Values: Numeric boundaries
Pattern Matching: Regex for text fields
Choice Lists: Predefined valid options
Custom Rules: Python expressions

Managing Choice Lists ¶

Choice List Management — *Screenshot Placeholder: Choice list editor showing table with Value, Display Name, Sort Order columns and Add/Remove buttons*¶

For choice fields:

Building Class Options:
├── A | Fire Resistive        | Sort: 1
├── B | Joisted Masonry        | Sort: 2
├── C | Non-Combustible        | Sort: 3
├── D | Frame Construction      | Sort: 4
└── E | Mixed Construction      | Sort: 5

Creating Rating Tables ¶

Table Structure ¶

Rating tables support:

Multiple Dimensions: Up to 10 factors
Date Versioning: Different rates over time
Interpolation: Calculate between points
Default Values: Fallback rates

Step 1: Define Table ¶

Create a new table:

Go to Rating Tables → Add Rating Table

Enter basic information:

Table Definition:
├── Table Code: GL_BASE_RATES
├── Table Name: General Liability Base Rates
├── Description: Base rates by territory and class
└── Product: General Liability Insurance

Configure dimensions

Step 2: Configure Dimensions ¶

Table Dimensions Configuration — *Screenshot Placeholder: Dimensions section with add button and list showing Dimension 1: Territory (factor dropdown), Dimension 2: Business Class (factor dropdown)*¶

Add table dimensions:

Dimension Configuration:
├── Dimension 1:
│   ├── Factor: territory
│   └── Type: Exact Match
├── Dimension 2:
│   ├── Factor: business_class
│   └── Type: Exact Match
└── Dimension 3:
    ├── Factor: protection_class
    └── Type: Range/Interpolate

Step 3: Enter Table Values ¶

Table Values Entry — Screenshot Placeholder: Django admin page showing “Rating table values” list with columns for Table, Dimensions (JSON), Rate Value, Effective Date, and action buttons (Add, Import CSV, Generate Permutations)¶

Enter rate values:

Method 1: Manual Entry

Manual Table Entry — *Screenshot Placeholder: Individual value entry form with dimension values and rate field*¶

Click Add Table Value
Select dimension values
Enter rate value
Set effective date

Method 2: Bulk Import

Bulk Import Table Values — *Screenshot Placeholder: CSV upload interface with template download link and file upload area*¶

Download CSV template
Fill with values
Upload CSV file
Review and confirm

Method 3: Auto-Generate Permutations

Click Generate Permutations
Select values for each dimension
Set default rate
System creates all combinations

Table Value Management ¶

Manage values:

Filter: By dimension values
Search: Find specific rates
Bulk Edit: Update multiple values
Version History: Track changes
Export: Download to Excel

Creating Formulas ¶

Formula Types ¶

Three formula types:

Python Expression

# Calculate property premium
base_rate * (building_value / 100) * territory_factor

Table Lookup

Table: GL_BASE_RATES
Lookup: territory, business_class
Result: Store in 'base_rate'

Factor Multiply

Factors: base_premium, territory_mod, class_mod, safety_credit
Operation: Multiply all values
Result: final_premium

Creating a Python Expression Formula ¶

Create Python Formula — *Screenshot Placeholder: Formula creation form with code editor showing syntax highlighting and available variables sidebar*¶

Steps:

Navigate to Formulas → Add Formula
Select Python Expression type

Enter formula details:

Basic Information:
├── Product: General Liability Insurance
├── Formula Code: CALC_BASE_PREMIUM
├── Formula Name: Calculate Base Premium
└── Description: Calculates base premium from limits

Expression:
├── Expression: liability_limit * 0.001 * base_rate_factor
├── Result Variable: base_premium
└── Execution Order: 1

Configure safety settings:

Safety Settings:
├── ☑ Validate expression syntax
├── ☑ Restrict to safe functions
├── ☑ Log execution details
└── Timeout: 1000ms

Creating a Table Lookup Formula ¶

Create Table Lookup Formula — *Screenshot Placeholder: Table lookup formula form with table selection dropdown and dimension mapping fields*¶

Configure table lookup:

Select Table Lookup type

Configure lookup:

Table Configuration:
├── Table: GL_BASE_RATES
├── Effective Date: Use run effective date
└── Result Variable: base_rate

Dimension Mapping:
├── Territory: Map to 'territory' factor
├── Business Class: Map to 'business_class' factor
└── Protection: Map to 'protection_class' factor

Options:
├── ☑ Use interpolation if available
├── ☑ Use default if no match
└── Default Value: 1.0

Formula Dependencies ¶

Managing dependencies:

Execution Order: Sequential processing
Variable Dependencies: Required inputs
Conditional Execution: Based on factors
Parallel Execution: Independent formulas

Testing Formulas ¶

Formula Testing Interface — *Screenshot Placeholder: Test interface with input values on left, Execute button, and results panel on right showing calculated value and execution log*¶

Test your formulas:

Click Test Formula
Enter sample values
Execute calculation
Review results and logs

Managing Product Versions ¶

Version Control ¶

Version management:

Effective Dates: When changes take effect
Change Tracking: What was modified
Parallel Versions: Multiple active versions
Version History: Complete audit trail

Creating a New Version ¶

Create Product Version — *Screenshot Placeholder: Version creation dialog with options to copy existing product, modify specific components, and set effective date*¶

To create a version:

Select existing product
Click Create Version
Choose what to copy: * All configurations * Specific components * Structure only
Set effective date
Make modifications

Rate Changes ¶

Rate Change Workflow — *Screenshot Placeholder: Rate change interface showing current rates, proposed rates, percentage change, and approval workflow*¶

Implementing rate changes:

Create Draft: New table values
Review Changes: Compare old vs new
Set Effective Date: When changes apply
Approve: Management approval
Activate: Make live

Best Practices ¶

Naming Conventions ¶

Use consistent naming:

Products:
├── Code: PRODUCT_TYPE (e.g., GL_POLICY, BOP_STANDARD)
└── Name: Descriptive name with version

Factors:
├── Code: lowercase_underscore (e.g., building_value, territory_code)
└── Name: Title Case Description

Tables:
├── Code: PRODUCT_TABLE_PURPOSE (e.g., GL_BASE_RATES)
└── Name: Clear description of contents

Formulas:
├── Code: ACTION_TARGET (e.g., CALC_BASE_PREMIUM)
└── Name: Verb + Object

Documentation ¶

Document everything:

Product Description: Purpose and coverage
Factor Help Text: Guide users
Table Notes: Explain rate basis
Formula Comments: Calculation logic

Testing Strategy ¶

Testing Checklist — *Screenshot Placeholder: Testing checklist with sections for Unit Tests, Integration Tests, Edge Cases, and User Acceptance*¶

Test thoroughly:

Testing Checklist:
☐ Individual formula validation
☐ Complete calculation flow
☐ Edge cases (min/max values)
☐ Missing data handling
☐ Date-based versioning
☐ Performance under load
☐ User acceptance testing