// payer.jsx — Payer Insights section [06] // Four charts: Revenue Concentration, Patient Burden by Payer, // Reimbursement Velocity, and Procedure × Payer Matrix. // ─────────────────────── Helpers ─────────────────────── const planTypeColor = (pt) => { const D = window.ROI_DATA.payer_insights; return D?.payer_colors?.[pt] || "#CCCCCC"; }; const planTypeLabel = (pt) => { const D = window.ROI_DATA.payer_insights; return D?.plan_type_labels?.[pt] || pt; }; // Compact payer name for chart labels (drops parens detail) const compactName = (name) => { if (!name) return ""; return name.length > 28 ? name.slice(0, 26) + "…" : name; }; // ─────────────────────── Chart 1: Revenue Concentration ─────────────────────── const PayerConcentration = () => { const D = window.ROI_DATA.payer_insights; const isMobile = useIsMobile(); const ref = React.useRef(null); const seen = useInView(ref, 0); const p = useProgress(650, seen); // Top 10 by total_revenue const top10 = [...D.mix].sort((a, b) => b.total_revenue - a.total_revenue).slice(0, 10); const totalRev = top10.reduce((s, r) => s + r.total_revenue, 0); const maxRev = top10[0].total_revenue; // Plan-type roll-up for legend const byType = {}; D.mix.forEach(r => { byType[r.plan_type] = (byType[r.plan_type] || 0) + r.total_revenue; }); const grandTotal = Object.values(byType).reduce((s, v) => s + v, 0); const typeOrder = Object.entries(byType).sort((a, b) => b[1] - a[1]); return (
{/* Plan-type breakdown bar */}
{typeOrder.map(([type, rev], i) => { const pct = (rev / grandTotal) * 100; return (
4 ? 0 : 0, overflow: "hidden", whiteSpace: "nowrap", }}> {pct > 8 && ( {planTypeLabel(type)} · {pct.toFixed(0)}% )}
); })}
{/* Top 10 horizontal bar chart */}
{top10.map((row, i) => { const w = (row.total_revenue / maxRev) * 100 * p; const pctOfTotal = (row.total_revenue / grandTotal) * 100; return (
{compactName(row.payer)} {planTypeLabel(row.plan_type).toUpperCase()}
{fmt.usdAbbr(row.total_revenue)} {pctOfTotal.toFixed(1)}% OF TOTAL
); })}
); }; window.PayerConcentration = PayerConcentration; // ─────────────────────── Chart 2: Patient Burden by Payer ─────────────────────── const PayerBurden = () => { const D = window.ROI_DATA.payer_insights; const isMobile = useIsMobile(); const ref = React.useRef(null); const seen = useInView(ref, 0); const p = useProgress(650, seen); // Top 12 by total_revenue, sorted by pct_patient_share desc const candidates = [...D.mix].sort((a, b) => b.total_revenue - a.total_revenue).slice(0, 12); const top = candidates.sort((a, b) => b.pct_patient_share - a.pct_patient_share); const maxShare = Math.max(...top.map(r => r.pct_patient_share)); const xMax = Math.ceil(maxShare / 5) * 5; return (
{top.map((row, i) => { const w = (row.pct_patient_share / xMax) * 100 * p; const warn = row.pct_patient_share >= 20; const burdenColor = warn ? THEME.accent : THEME.primary; return (
{compactName(row.payer)} {fmt.usdAbbr(row.total_revenue)} REVENUE
{/* Scale ticks */} {[0, 25, 50, 75, 100].map(v => v <= xMax && (
))}
{row.pct_patient_share.toFixed(1)}% PATIENT SHARE
{fmt.usd(row.avg_pat_resp_per_claim)} AVG / CLAIM
); })}
); }; window.PayerBurden = PayerBurden; // ─────────────────────── Chart 3: Reimbursement Velocity ─────────────────────── const PayerVelocity = () => { const D = window.ROI_DATA.payer_insights; const isMobile = useIsMobile(); const ref = React.useRef(null); const seen = useInView(ref, 0); const p = useProgress(650, seen); // Top 12 payers by total_claims that have velocity data const candidates = [...D.velocity] .filter(r => r.median_days != null) .sort((a, b) => b.total_claims - a.total_claims).slice(0, 12); // Sort by median asc (fastest at top) const top = candidates.sort((a, b) => a.median_days - b.median_days); const maxDays = Math.max(...top.map(r => r.p90_days || r.median_days)) * 1.05; return (
{top.map((row, i) => { const pct25 = (row.p25_days / maxDays) * 100; const pct75 = (row.p75_days / maxDays) * 100; const pct90 = (row.p90_days / maxDays) * 100; const pctMedian = (row.median_days / maxDays) * 100; const slow = row.median_days >= 25; return (
{compactName(row.payer)} {row.total_claims.toLocaleString()} CLAIMS · {row.pct_paid.toFixed(0)}% PAID
{/* P25-P75 box */}
{/* P90 whisker */}
{/* Median tick */}
{/* Scale ticks at 0/15/30/45/60+ days */} {[15, 30, 45, 60].filter(v => v <= maxDays).map(v => (
))}
{row.median_days}d MEDIAN
); })}
{/* Scale legend */}
BOXES SPAN P25–P75 · FAINT SPLAY EXTENDS TO P90 · BLACK LINE = MEDIAN · MAX SHOWN: {Math.ceil(maxDays)} DAYS
); }; window.PayerVelocity = PayerVelocity; // ─────────────────────── Chart 4: Procedure × Payer Matrix ─────────────────────── const PayerProcMatrix = () => { const D = window.ROI_DATA.payer_insights; const isMobile = useIsMobile(); const ref = React.useRef(null); const seen = useInView(ref, 0); const p = useProgress(650, seen); // Group by procedure code; for each, sort cells by total_paid desc const byProc = {}; D.matrix.forEach(r => { if (!byProc[r.code]) byProc[r.code] = { code: r.code, description: r.description, cells: [] }; byProc[r.code].cells.push(r); }); Object.values(byProc).forEach(g => { g.cells.sort((a, b) => b.total_paid - a.total_paid); }); const procs = Object.values(byProc).sort((a, b) => { const aTotal = a.cells.reduce((s, c) => s + c.total_paid, 0); const bTotal = b.cells.reduce((s, c) => s + c.total_paid, 0); return bTotal - aTotal; }); // Build x-axis scale per procedure based on its max_paid const procScales = {}; procs.forEach(g => { const maxVal = Math.max(...g.cells.map(c => c.max_paid)); procScales[g.code] = maxVal * 1.05; }); return (
{procs.map((g, gi) => { const xMax = procScales[g.code]; const totalPaid = g.cells.reduce((s, c) => s + c.total_paid, 0); return (
{g.code} {g.description} {g.cells.reduce((s, c) => s + c.encounters, 0).toLocaleString()} ENCOUNTERS · {fmt.usdAbbr(totalPaid)} TOTAL
{g.cells.map((cell, ci) => { const pctMin = (cell.min_paid / xMax) * 100; const pctP25 = (cell.p25_paid / xMax) * 100; const pctMed = (cell.median_paid / xMax) * 100; const pctP75 = (cell.p75_paid / xMax) * 100; const pctMax = (cell.max_paid / xMax) * 100; return (
{compactName(cell.payer)}
{/* Min-Max thin line */}
{/* P25-P75 box */}
{/* Median tick */}
{fmt.usd(cell.median_paid)} {cell.pct_reimbursed}% REIMB
); })}
); })} EACH ROW SHOWS PER-ENCOUNTER INSURANCE PAYMENT RANGE FOR ONE PAYER · THIN LINE = MIN-MAX · COLORED BOX = P25-P75 · BLACK TICK = MEDIAN
); }; window.PayerProcMatrix = PayerProcMatrix;