legacy-unmigrated-heritage

{
  "sql": "SELECT c.cust_id, c.legacy_acct, c.legacy_mismatch, c.status, c.first_name, c.last_name, c.email, c.phone, lp.legacy_policy_id, lp.source_system, lp.plan_code, lp.migration, lp.modern_policy_id, lp.effective_date AS legacy_effective_date, p.policy_id, p.line, p.status AS policy_status, p.effective_date, p.expiration_date FROM customers c LEFT JOIN legacy_policies lp ON lp.cust_id = c.cust_id LEFT JOIN policies p ON p.policy_id = lp.modern_policy_id WHERE c.email LIKE '%' OR c.phone LIKE '%' LIMIT 5"
}

{
  "rows": [
    {
      "cust_id": "CUST-prospect-il-auto",
      "legacy_acct": null,
      "legacy_mismatch": 0,
      "status": "PROSPECT",
      "first_name": "Aaron",
      "last_name": "Halloway",
      "email": "aaron.halloway@example.com",
      "phone": null,
      "legacy_policy_id": null,
      "source_system": null,
      "plan_code": null,
      "migration": null,
      "modern_policy_id": null,
      "legacy_effective_date": null,
      "policy_id": null,
      "line": null,
      "policy_status": null,
      "effective_date": null,
      "expiration_date": null
    },
    {
      "cust_id": "CUST-nest-household",
      "legacy_acct": "EVG2241K7",
      "legacy_mismatch": 0,
      "status": "CUSTOMER",
      "first_name": "Marisol",
      "last_name": "Trujillo",
      "email": "marisol.trujillo@example.com",
      "phone": null,
      "legacy_policy_id": null,
      "source_system": null,
      "plan_code": null,
      "migration": null,
      "modern_policy_id": null,
      "legacy_effective_date": null,
      "policy_id": null,
      "line": null,
      "policy_status": null,
      "effective_date": null,
      "expiration_date": null
    },
    {
      "cust_id": "CUST-heritage-auto",
      "legacy_acct": "EVG0098H1",
      "legacy_mismatch": 0,
      "status": "CUSTOMER",
      "first_name": "Walter",
      "last_name": "Pennington",
      "email": "walter.pennington@example.com",
      "phone": null,
      "legacy_policy_id": "LGP-heritage-auto-p_auto",
      "source_system": "EVERGREEN",
      "plan_code": "AP1",
      "migration": "MIGRATED",
      "modern_policy_id": "POL-heritage-auto-p_auto",
      "legacy_effective_date": "2025-02-01",
      "policy_id": "POL-heritage-auto-p_auto",
      "line": "AUTO",
      "policy_status": "ACTIVE",
      "effective_date": "2025-02-01",
      "expiration_date": "2026-02-01"
    },
    {
      "cust_id": "CUST-ca-masked-auto",
      "legacy_acct": null,
      "legacy_mismatch": 0,
      "status": "CUSTOMER",
      "first_name": "Priya",
      "last_name": "Anand",
      "email": "priya.anand@example.com",
      "phone": null,
      "legacy_policy_id": null,
      "source_system": null,
      "plan_code": null,
      "migration": null,
      "modern_policy_id": null,
      "legacy_effective_date": null,
      "policy_id": null,
      "line": null,
      "policy_status": null,
      "effective_date": null,
      "expiration_date": null
    },
    {
      "cust_id": "CUST-fl-coastal-home",
      "legacy_acct": null,
      "legacy_mismatch": 0,
      "status": "CUSTOMER",
      "first_name": "Gloria",
      "last_name": "Esposito",
      "email": "gloria.esposito@example.com",
      "phone": null,
      "legacy_policy_id": null,
      "source_system": null,
      "plan_code": null,
      "migration": null,
      "modern_policy_id": null,
      "legacy_effective_date": null,
      "policy_id": null,
      "line": null,
      "policy_status": null,
      "effective_date": null,
      "expiration_date": null
    }
  ],
  "row_count": 5,
  "truncated": false
}

{
  "sql": "SELECT c.cust_id, c.legacy_acct, c.legacy_mismatch, c.status, c.first_name, c.last_name, c.dob, c.email, c.phone, lp.legacy_policy_id, lp.source_system, lp.plan_code, lp.rate_sym, lp.bill_sym, lp.migration, lp.modern_policy_id, lp.effective_date AS legacy_effective_date, p.policy_id, p.line, p.status AS policy_status, p.effective_date, p.expiration_date, p.term_months FROM customers c LEFT JOIN legacy_policies lp ON lp.cust_id = c.cust_id LEFT JOIN policies p ON p.policy_id = lp.modern_policy_id WHERE c.legacy_acct = 'EVG3390U1' AND c.first_name = 'Doris' AND c.last_name = 'Maddox'"
}

{
  "rows": [
    {
      "cust_id": "CUST-legacy-unmigrated-auto",
      "legacy_acct": "EVG3390U1",
      "legacy_mismatch": 0,
      "status": "CUSTOMER",
      "first_name": "Doris",
      "last_name": "Maddox",
      "dob": "1949-03-08",
      "email": "doris.maddox@example.com",
      "phone": null,
      "legacy_policy_id": "LGP-legacy-unmigrated-auto-l1",
      "source_system": "EVERGREEN",
      "plan_code": "AP1",
      "rate_sym": "05",
      "bill_sym": "F0",
      "migration": "NOT_MIGRATED",
      "modern_policy_id": null,
      "legacy_effective_date": "2007-04-01",
      "policy_id": null,
      "line": null,
      "policy_status": null,
      "effective_date": null,
      "expiration_date": null,
      "term_months": null
    }
  ],
  "row_count": 1,
  "truncated": false
}

{
  "sql": "WITH legacy AS ( SELECT lp.legacy_policy_id, lp.cust_id, lp.plan_code, lp.rate_sym, lp.bill_sym, lp.effective_date, c.address_id FROM legacy_policies lp JOIN customers c ON c.cust_id = lp.cust_id WHERE lp.cust_id = 'CUST-legacy-unmigrated-auto' ), addr AS ( SELECT a.state, a.region FROM addresses a JOIN legacy l ON a.address_id = l.address_id ) SELECT l.legacy_policy_id, l.plan_code, l.rate_sym, l.bill_sym, l.effective_date, a.state, a.region, lc.modern_line, lc.modern_tier_id, lc.modern_coverages, lc.doc_id, lc.notes, t.label AS tier_label, t.sellable, t.retired_on FROM legacy l JOIN addr a LEFT JOIN legacy_crosswalk lc ON lc.legacy_plan_code = l.plan_code AND lc.region = a.region AND lc.cust_status = 'CUSTOMER' AND date('2025-06-01') BETWEEN date(lc.effective_start) AND date(lc.effective_end) LEFT JOIN tiers t ON t.tier_id = lc.modern_tier_id"
}

{
  "rows": [
    {
      "legacy_policy_id": "LGP-legacy-unmigrated-auto-l1",
      "plan_code": "AP1",
      "rate_sym": "05",
      "bill_sym": "F0",
      "effective_date": "2007-04-01",
      "state": "NY",
      "region": "R-NE",
      "modern_line": null,
      "modern_tier_id": null,
      "modern_coverages": null,
      "doc_id": null,
      "notes": null,
      "tier_label": null,
      "sellable": null,
      "retired_on": null
    }
  ],
  "row_count": 1,
  "truncated": false
}

{
  "query": "legacy migration unmigrated policy move to new plan manually legacy crosswalk AP1 not migrated portal migration rules",
  "limit": 5
}

{
  "results": [
    {
      "doc_id": "KB-LEGACY-XWALK",
      "title": "Reading an EVERGREEN plan code (legacy → CANOPY)",
      "category": "HOWTO",
      "applies_to": "{\"lines\": [\"AUTO\"]}",
      "snippet": "PEICO is migrating from the legacy **EVERGREEN** mainframe to **CANOPY**. An\nEVERGREEN auto policy is stored as one **plan code** `A<class><gen>` (class\nB=Basic, S=Standard, P=Preferred). A plan code does NOT map to a CANOPY tier on\nits own…"
    },
    {
      "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-CLAIMS-STATUS",
      "title": "Claim status: FNOL → OPEN → CLOSED, and who may move it",
      "category": "POLICY",
      "applies_to": "{\"lines\": \"ALL\"}",
      "snippet": "**FNOL** = loss reported, not yet accepted for handling. **OPEN** = accepted\nand with an adjuster (the adjuster sets the reserve). **CLOSED** = resolved.\nA service rep may promote FNOL → OPEN once the loss details are confirmed\nwith the cus…"
    },
    {
      "doc_id": "KB-TX-MOTO",
      "title": "TX: motorcycle custom-parts coverage unavailable",
      "category": "UNDERWRITING",
      "applies_to": "{\"lines\": [\"MOTO\"], \"states\": [\"TX\"]}",
      "snippet": "Due to a historical licensing limitation, Custom Parts & Equipment coverage is\n**not available on motorcycle policies in Texas**.\n"
    },
    {
      "doc_id": "KB-DISC-WHOLE-LIFE",
      "title": "Whole life disclosures: surrender, cash value, not an investment",
      "category": "COMPLIANCE",
      "applies_to": "{\"lines\": [\"LIFE_W\"]}",
      "snippet": "Before binding whole life, disclose and record: (1) **surrender charges** apply for\nthe first several policy years and reduce early cash value; (2) cash value accrues\nslowly and may be borrowed against, reducing the death benefit; (3) whole…"
    }
  ]
}

{
  "doc_id": "KB-LEGACY-XWALK"
}

{
  "doc_id": "KB-LEGACY-XWALK",
  "title": "Reading an EVERGREEN plan code (legacy → CANOPY)",
  "category": "HOWTO",
  "applies_to": "{\"lines\": [\"AUTO\"]}",
  "body_md": "PEICO is migrating from the legacy **EVERGREEN** mainframe to **CANOPY**. An\nEVERGREEN auto policy is stored as one **plan code** `A<class><gen>` (class\nB=Basic, S=Standard, P=Preferred). A plan code does NOT map to a CANOPY tier on\nits own — the mapping depends on the customer's **market (region)** and\n**status**, so you must look it up in the crosswalk, never guess from the letter.\n- **Standard** plans (AS2, AS4) → Pine, everywhere.\n- **Preferred AP3** means different things by market: in the Northeast it is the\n  Evergreen tier, but in the Southeast AP3 was a relabeled Standard → Pine.\n- **AP3 and AP1 are closed to new business.** A prospect cannot be put on them;\n  the live preferred plan for new business is **AP5** (→ Evergreen). **AP1** is\n  grandfathered for existing customers only and maps to the **retired Heritage**\n  tier, which cannot be re-bound once dropped.\nWhen an EVERGREEN record and the CANOPY policy disagree, treat it as an\nunverified migration discrepancy: surface it, do not silently \"correct\" either side.\n"
}

{
  "query": "Heritage retired tier cannot be rebound grandfathered existing customers only manual move to new plan endorsement or rewrite auto heritage",
  "limit": 10
}

{
  "results": [
    {
      "doc_id": "KB-LEGACY-XWALK",
      "title": "Reading an EVERGREEN plan code (legacy → CANOPY)",
      "category": "HOWTO",
      "applies_to": "{\"lines\": [\"AUTO\"]}",
      "snippet": "PEICO is migrating from the legacy **EVERGREEN** mainframe to **CANOPY**. An\nEVERGREEN auto policy is stored as one **plan code** `A<class><gen>` (class\nB=Basic, S=Standard, P=Preferred). A plan code does NOT map to a CANOPY tier on\nits own…"
    },
    {
      "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-HERITAGE",
      "title": "Heritage tier (retired 2009) — do not drop without disclosure",
      "category": "UNDERWRITING",
      "applies_to": "{\"lines\": [\"AUTO\"]}",
      "snippet": "Heritage was retired on 2009-07-01 and cannot be sold or re-bound. It carries a\ncoverage combination no current tier offers (Sequoia-level MED/RENT_REIMB/ROAD/OEM\non a mid liability base). A customer who drops Heritage **loses that combinat…"
    },
    {
      "doc_id": "KB-SUITABILITY",
      "title": "Suitability requirement for Life & Health",
      "category": "COMPLIANCE",
      "applies_to": "{\"lines\": [\"LIFE_T\", \"LIFE_W\", \"HLTH\"]}",
      "snippet": "Before binding any Life or Supplemental Health policy you must complete a\n**suitability record** (income, existing coverage, dependents, stated need,\nhorizon, risk tolerance) with outcome SUITABLE. Selling **whole life** to a\nshort-horizon,…"
    },
    {
      "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-CLAIMS-STATUS",
      "title": "Claim status: FNOL → OPEN → CLOSED, and who may move it",
      "category": "POLICY",
      "applies_to": "{\"lines\": \"ALL\"}",
      "snippet": "**FNOL** = loss reported, not yet accepted for handling. **OPEN** = accepted\nand with an adjuster (the adjuster sets the reserve). **CLOSED** = resolved.\nA service rep may promote FNOL → OPEN once the loss details are confirmed\nwith the cus…"
    },
    {
      "doc_id": "KB-DISC-WHOLE-LIFE",
      "title": "Whole life disclosures: surrender, cash value, not an investment",
      "category": "COMPLIANCE",
      "applies_to": "{\"lines\": [\"LIFE_W\"]}",
      "snippet": "Before binding whole life, disclose and record: (1) **surrender charges** apply for\nthe first several policy years and reduce early cash value; (2) cash value accrues\nslowly and may be borrowed against, reducing the death benefit; (3) whole…"
    },
    {
      "doc_id": "KB-GLOSSARY-AUTO",
      "title": "Auto coverage codes, decoded",
      "category": "GLOSSARY",
      "applies_to": "{\"lines\": [\"AUTO\", \"MOTO\", \"RV\", \"BOAT\", \"CLSC\"]}",
      "snippet": "EVERGREEN stores auto coverages under terse codes. Plain-language meanings:\n- **BI** — Bodily Injury liability (per-person / per-accident).\n- **PD** — Property Damage liability.\n- **UM/UIM** (`UMUIM`) — Uninsured / Underinsured Motorist.\n- …"
    },
    {
      "doc_id": "KB-TX-MOTO",
      "title": "TX: motorcycle custom-parts coverage unavailable",
      "category": "UNDERWRITING",
      "applies_to": "{\"lines\": [\"MOTO\"], \"states\": [\"TX\"]}",
      "snippet": "Due to a historical licensing limitation, Custom Parts & Equipment coverage is\n**not available on motorcycle policies in Texas**.\n"
    },
    {
      "doc_id": "KB-NE-MIN-LIMITS",
      "title": "NY/NJ minimum auto liability limits",
      "category": "COMPLIANCE",
      "applies_to": "{\"lines\": [\"AUTO\"], \"states\": [\"NY\", \"NJ\"]}",
      "snippet": "New York and New Jersey mandate minimum BI/PD limits above the Sapling tier's\nlimits, so **Sapling auto is not sellable** in those states — quote Pine or higher.\n"
    }
  ]
}

{
  "doc_id": "KB-HERITAGE"
}

{
  "doc_id": "KB-HERITAGE",
  "title": "Heritage tier (retired 2009) — do not drop without disclosure",
  "category": "UNDERWRITING",
  "applies_to": "{\"lines\": [\"AUTO\"]}",
  "body_md": "Heritage was retired on 2009-07-01 and cannot be sold or re-bound. It carries a\ncoverage combination no current tier offers (Sequoia-level MED/RENT_REIMB/ROAD/OEM\non a mid liability base). A customer who drops Heritage **loses that combination\npermanently**. Disclose the downgrade trap before any tier change off Heritage.\n"
}

{
  "sql": "SELECT tier_id, code, label, position, sellable, retired_on, notes FROM tiers WHERE line = 'AUTO' ORDER BY position"
}

{
  "rows": [
    {
      "tier_id": "AUTO:HERITAGE",
      "code": "HERITAGE",
      "label": "Heritage",
      "position": 0,
      "sellable": 0,
      "retired_on": "2009-07-01",
      "notes": "Retired 2009. Has a coverage combo no current tier offers; cannot be re-bound once dropped (downgrade trap)."
    },
    {
      "tier_id": "AUTO:SAPLING",
      "code": "SAPLING",
      "label": "Sapling",
      "position": 1,
      "sellable": 1,
      "retired_on": null,
      "notes": null
    },
    {
      "tier_id": "AUTO:PINE",
      "code": "PINE",
      "label": "Pine",
      "position": 2,
      "sellable": 1,
      "retired_on": null,
      "notes": null
    },
    {
      "tier_id": "AUTO:EVERGREEN",
      "code": "EVERGREEN",
      "label": "Evergreen",
      "position": 3,
      "sellable": 1,
      "retired_on": null,
      "notes": null
    },
    {
      "tier_id": "AUTO:SEQUOIA",
      "code": "SEQUOIA",
      "label": "Sequoia",
      "position": 4,
      "sellable": 1,
      "retired_on": null,
      "notes": null
    }
  ],
  "row_count": 5,
  "truncated": false
}

{
  "sql": "SELECT rule_id, line, tier_id, coverage_id, state, effect, condition, effective_start, effective_end, reason_doc, notes FROM eligibility_rules WHERE line = 'AUTO' AND state = 'NY' AND (tier_id IN ('AUTO:SAPLING','AUTO:PINE','AUTO:EVERGREEN','AUTO:SEQUOIA') OR tier_id IS NULL) AND date('2025-06-01') BETWEEN date(effective_start) AND date(effective_end) ORDER BY tier_id, coverage_id"
}

{
  "rows": [],
  "row_count": 0,
  "truncated": false
}

{}

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