Overview

Returns complete row data from a rate table in the insurance system. Unlike the /api/MetaData/RateTables/SelectList endpoint which returns only key-value pairs for dropdowns, this endpoint returns all columns from matching rate table rows for more complex rating scenarios.

What is a Rate Table Lookup Row? Rate tables store versioned rating data (rates, factors, codes, rules) that varies by:

• Carrier (rating company)
• Effective date (rate tables are date-versioned)
• State (some rate tables are state-specific)
• Rate table set (configured per insurance program)

This endpoint retrieves the complete row data for rating calculations, validation, or display purposes.

Key Difference from SelectList:

• SelectList: Returns {Key, Description} pairs for populating dropdowns (2 columns)
• RateTableLookupRows: Returns all columns from matching rows as key-value dictionaries

Typical Use Cases:

• Rating calculations: Get rate factors, multipliers, or base rates for premium calculation
• Multi-column lookups: Need more than just key and description (e.g., rate + territory + class)
• Validation: Check if a combination of values exists in a rate table
• Display: Show detailed rate table information to users

When to Use This Endpoint

Use RateTableLookupRows when:

• ✅ Performing rating calculations that need rate factors, multipliers, or base rates
• ✅ Need multiple columns from rate table rows (not just key and description)
• ✅ Validating that a combination of match keys exists in a rate table
• ✅ Displaying detailed rate table information to users
• ✅ Building complex rating logic based on multiple rate table columns

Use SelectList endpoint instead when:

• ❌ Only need key and description for a dropdown
• ❌ Populating form field options (SelectList is optimized for this)

Use other metadata endpoints when:

• ❌ Need form field metadata (use FormFields, ProposalFields, etc.)
• ❌ Not working with rate tables at all