coastalshield-eligibility

{
  "sql": "SELECT c.cust_id, c.first_name, c.last_name, c.email, c.phone, a.line1, a.city, a.state, a.zip FROM customers c LEFT JOIN addresses a ON c.address_id = a.address_id WHERE c.first_name = 'Gloria' AND c.last_name = 'Esposito' AND a.line1 LIKE '%Mangrove Way%' AND a.city = 'Naples' AND a.state = 'FL'"
}

{
  "rows": [
    {
      "cust_id": "CUST-fl-coastal-home",
      "first_name": "Gloria",
      "last_name": "Esposito",
      "email": "gloria.esposito@example.com",
      "phone": null,
      "line1": "12 Mangrove Way",
      "city": "Naples",
      "state": "FL",
      "zip": "34102"
    }
  ],
  "row_count": 1,
  "truncated": false
}

{
  "sql": "SELECT p.policy_id, p.line, p.tier_id, p.status, p.effective_date, p.expiration_date, p.base_premium_cents, p.final_premium_cents, p.rating_as_of FROM policies p WHERE p.cust_id = 'CUST-fl-coastal-home' AND p.line = 'HOME'"
}

{
  "rows": [
    {
      "policy_id": "POL-fl-coastal-home-p_home",
      "line": "HOME",
      "tier_id": "HOME:SEQUOIA",
      "status": "ACTIVE",
      "effective_date": "2025-04-01",
      "expiration_date": "2026-04-01",
      "base_premium_cents": 574173,
      "final_premium_cents": 526797,
      "rating_as_of": "2025-04-01"
    }
  ],
  "row_count": 1,
  "truncated": false
}

{
  "query": "coastal wind resilience credit discount"
}

{
  "results": [
    {
      "doc_id": "KB-PROMO-COASTALSHIELD",
      "title": "COASTALSHIELD terms",
      "category": "PROMO",
      "applies_to": "{\"lines\": [\"HOME\", \"CONDO\"], \"states\": [\"FL\", \"GA\", \"NC\"]}",
      "snippet": "$120 wind-resilience credit for Southeast home/condo policies. Cap $120; min premium $600."
    },
    {
      "doc_id": "KB-EVERGREEN-CLASSIC",
      "title": "Evergreen Classic (Home, retired 2018) — wind/hail math",
      "category": "UNDERWRITING",
      "applies_to": "{\"lines\": [\"HOME\"]}",
      "snippet": "Retired 2018-01-01. Uses a legacy flat-capped wind/hail deductible (1.5% of\ndwelling, capped) rather than the current percentage math. Not re-bindable.\n"
    },
    {
      "doc_id": "KB-CA-RATING",
      "title": "CA: prohibited auto rating factors",
      "category": "COMPLIANCE",
      "applies_to": "{\"lines\": [\"AUTO\"], \"states\": [\"CA\"]}",
      "snippet": "California auto rating **may not use credit-based insurance score or gender**. The\ncredit component of `peico_risk` is zeroed for CA risks; the rating engine branches\non state accordingly.\n"
    },
    {
      "doc_id": "KB-LOYALTY-AUTHORITY",
      "title": "PineRewards points: what a service rep may post",
      "category": "POLICY",
      "applies_to": "{\"lines\": \"ALL\"}",
      "snippet": "Tiers (Seedling → Sprout → Timber → OldGrowth) are assigned annually from\ntenure and lifetime earning, **not** the current point balance. Points earned\n2019 or later expire **24 months** after the earn date; older entries were\nwritten witho…"
    },
    {
      "doc_id": "KB-PROMO-SPRINGSAVE25",
      "title": "SPRINGSAVE25 terms",
      "category": "PROMO",
      "applies_to": "{\"lines\": [\"AUTO\"]}",
      "snippet": "$75 off auto in the Midwest/Southwest, spring 2025 only. Offer window 2025-03-20 through 2025-06-21; does not apply after 2025-06-21. Applicability is determined by the offer window as of the quote date."
    },
    {
      "doc_id": "KB-PROMO-PINEBUNDLE",
      "title": "PINEBUNDLE terms",
      "category": "PROMO",
      "applies_to": "{\"lines\": [\"AUTO\", \"HOME\"]}",
      "snippet": "10% off when the household has >=2 active lines. Cap $500; min premium $250. Stacks with the multi-line discount."
    },
    {
      "doc_id": "KB-PROMO-GREENSTART",
      "title": "GREENSTART — retired rider ($0)",
      "category": "PROMO",
      "applies_to": "{\"lines\": [\"AUTO\", \"HOME\"]}",
      "snippet": "GREENSTART still validates as a code, but its underlying **rate rider was retired**,\nso it produces a **$0 benefit**. Do not promise customers a discount from it.\n"
    }
  ]
}

{
  "doc_id": "KB-PROMO-COASTALSHIELD"
}

{
  "doc_id": "KB-PROMO-COASTALSHIELD",
  "title": "COASTALSHIELD terms",
  "category": "PROMO",
  "applies_to": "{\"lines\": [\"HOME\", \"CONDO\"], \"states\": [\"FL\", \"GA\", \"NC\"]}",
  "body_md": "$120 wind-resilience credit for Southeast home/condo policies. Cap $120; min premium $600."
}

{
  "sql": "SELECT promo_code, label, scope, window_start, window_end, effect, active, caps, notes FROM promotions WHERE promo_code = 'COASTALSHIELD'"
}

{
  "rows": [
    {
      "promo_code": "COASTALSHIELD",
      "label": "Coastal Wind Resilience Credit",
      "scope": "{\"lines\": [\"HOME\", \"CONDO\"], \"regions\": [\"R-SE\"], \"customer\": \"ANY\"}",
      "window_start": "2025-05-01",
      "window_end": "2026-11-30",
      "effect": "{\"type\": \"DOLLARS_OFF\", \"value\": 120}",
      "active": 1,
      "caps": "{\"max_benefit_usd\": 120, \"min_premium_floor_usd\": 600}",
      "notes": "SE region only; intended for wind-mitigated dwellings."
    }
  ],
  "row_count": 1,
  "truncated": false
}

{}

{
  "ok": true,
  "note": "Deliver your closing message now."
}