| 🎯 Bucket touched | Migrated (HCP-era warranties) + Pure ST |
| ⚠️ Problem | Warranty windows expiring in next 30/60/90 days create a re-call-out window. Without calendar visibility, BSP loses the renewal touch. |
| 💰 $ at stake | Avg warranty-expiry call → $250-$400 inspection or upsell. 50 expiries/mo × $300 = $15K/mo. |
| ✅ Action unlocked | Auto-email warranty-expiry-30-days touchpoint. Stephanie approval to enable. |
Warranty end dates are not stored in the Nexus warehouse. Neither titan.jobs nor the HCP customer export contains a warranty_end_date field. No fabricated data is shown. When warranty capture is wired, this page will populate with all jobs whose warranty expires in the next 90 days.
Requires adding a warranty_end_date column to titan.jobs (or a new titan.warranties table) plus pulling ST and HCP warranty endpoints nightly. Estimated effort: 6 hours. Owner: Robert.
| Source | Missing Field | Fix |
|---|---|---|
| Loading... | ||
Produced? Read-only endpoint /api/warranty/calendar returns available=false with a documented gap list.
Correct? Validated against titan.jobs schema (no warranty_* column) and HCP export index (no warranties field).
Changed real data? No writes performed. Read-only.