opt_25_10 is 25% down over 10 months, on every quote that offers it. The catch is in the last four words: not every quote offers it. This page explains why, and gives you a lookup that always lands on a sensible option.
Why an exact id can be missing
The down payments follow the minimum earned premium
Each quote offers five down payments. They start 10 points below the deal’s premium-weighted minimum earned rate, never below 10%, and step up by 5 points:totals.weighted_minimum_earned_rate on the quote, weighted by each policy’s premium. So the rungs move with the deal:
A 25% minimum earned, the most common case, does give you a 25% row. But an exact 25% rung exists only when the weighted minimum earned rounds to 20% or less, or to 25%, 30% or 35%. A deal whose weighted minimum earned comes to 27% has no 25% row at all.
The terms follow the policy dates
The longest term always ends before the policies do. A 12-month policy typically gets terms of 6 to 11 months; a shorter policy gets fewer and shorter terms. A policy shorter than 3 months can’t be financed at all.Some cells are dropped
An option whose APR would exceed the state’s limit (17.9% in Texas) is left out, so the grid can be ragged: a term can exist at one down payment and be missing at another. An ineligible quote has no options at all, and neither does an eligible one where every option was dropped (see eligible, but no options). In both casesoptions is empty and recommended_option_id is null.
The lookup
Try the exact id. If it’s missing, take the same term at the nearest down payment at or above your target, so the client never puts down less than your rule intends. If that term isn’t offered either, fall back torecommended_option_id.
term_months and down_payment_rate, as above, rather than by taking an id apart. The id format is stable, but the fields are what we document as the values.
A worked example
A single ocean marine policy with a 27% minimum earned, financed over its 12-month term (illustrative figures):- 25% over 10 months:
opt_25_10doesn’t exist. The nearest down payment at or above 25% for 10 months is 27%, so the lookup returnsopt_27_10. - 40% over 10 months: nothing at or above 40%. The lookup returns
recommended_option_id, which here isopt_27_10. - 25% over 12 months: no 12-month term (the loan has to end before the policy does), so the lookup returns
recommended_option_id.
When your client has already chosen
If your client picked an option on the interactive quote, use theirs:selected_option_id on the quote. A house rule is for the default you show first, not for overriding a choice.
The ladder may change. We’re considering a fixed 5% grid of down payments (10, 15, 20, 25 and so on) instead of one that follows the minimum earned. The lookup above is correct either way: exact id first, then the nearest down payment at or above your target for the same term, then the recommended option. Write it once and it keeps working.