Integrated Command Center
CARE-CROS™ PAMS · 340B Revenue-to-Impact · Unified on coveragegateway.com
⬡
Integration active. A single client record drives both platforms. Every insurance enrollment in CARE-CROS automatically updates 340B payer mix, capture rate, and revenue projections. Every ADAP premium assistance record feeds the duplicate discount detector in real time.
Active Clients
318
↑ 12 this month
Commercial Coverage
38%
↑ 4pts · target 55%
340B Net Revenue MTD
$72K
↑ 8% vs last month
Active Flags
6
2 critical · 4 high
ROPHI Score
2.8×
↑ 0.3 from baseline
Live integration signals
M3 → E4: 22 ADAP-to-ACA transitions enrolled this quarter. Each converted client shifts from 20% to 70% margin tier. Estimated added net revenue: +$114K/year. 44 SEP-eligible clients remain in ADAP direct — outreach pending.
M4 → E3: 3 clients currently receiving ADAP premium assistance AND enrolled in Medicaid (2 FFS · 1 MCO Sunshine Health) — duplicate discount risk flagged for both Medicaid types. Contract pharmacy carve-out must apply to fee-for-service AND managed care. Action required before next fill cycle.
M5 → E4: Coverage lapse detected for 2 clients. Each lapsed client reverts from commercial reimbursement to ADAP direct or uninsured. Estimated monthly revenue at risk: $5,800. Re-enrollment workflow triggered.
Platform HealthALL SYSTEMS LIVE
CARE-CROS modules (M1–M5)92%
340B compliance readiness63%
340B revenue capture rate81%
Integration sync status100%
Impact measurement completeness74%
Payer Mix → Revenue ImpactOptimize →
Every client enrolled in commercial coverage improves 340B margin from 20–25% to 65–70%
Shifting 44 ADAP clients to ACA marketplace = +$210K est. annual net revenue. Next SEP window: open now (ILS qualifying event).
Module Status
M1
Eligibility Screening
ACTIVE
M2
Plan Selection
ACTIVE
M3
Enrollment
ACTIVE
M4
Premium Payment
3 ALERTS
M5
Coverage Monitor
2 LAPSES
340B Engines
E2
Eligibility Checker
2 FLAGS
E3
Dup. Discount Detect
4 FLAGS
E4
Revenue Reconciliation
CURRENT
Critical Dates
NOW OPEN
SEP enrollment window — ILS qualifying event. 44 ADAP clients eligible for ACA transition.
Jul 1–15, 2026
340B OPAIS quarterly registration window. Recertify contract pharmacy arrangement (Medwise Pharmacy) and verify NABP/DEA/NPI identifiers are current. Dispensing with lapsed OPAIS registration is a 340B program violation.
Jun 30, 2026
Q2 340B revenue report due to board. ROPHI baseline report needed.
May 23, 2026
Platform integration build complete. Developer sprint continues.
Client Registry
CLIENT MANAGEMENT · INTAKE · REFERRAL QUEUE
ℹ
The unified client record is the integration's data spine. When a navigator updates insurance status in M3, Engine 4 recalculates the revenue projection for that client's next fill automatically. When E3 flags a duplicate discount risk, M4 is alerted to suspend ADAP premium assistance payment pending review.
Client list
Loading clients...
Selected client — unified record
→Select a client to view the unified record across CARE-CROS and 340B.
M1 — Eligibility Screening
FPL CALCULATION · APTC ESTIMATION · ADAP ASSESSMENT · 340B ELIGIBILITY PRE-SCREEN
Integration: M1 eligibility data (FPL%, insurance status, prescriber NPI) automatically pre-populates Engine 2's patient definition check. A client screened as 340B-eligible in M1 is flagged in the prescription ledger on their first fill — no duplicate entry.
Eligibility Screener
Screening Results
⚠Run screen to see results.
M2 — Plan Selection
TOTAL COST OPTIMIZER · SEP ROUTING · 340B MARGIN IMPACT CALCULATOR
Integration: Plan metal level selected in M2 directly determines the 340B reimbursement rate in Engine 4. A Silver plan with APTC yields commercial reimbursement at 65–70% margin. Each enrollment decision here is a revenue decision.
Plan Comparison Tool
Plan Comparison + Revenue Projection
⚠Run comparison to see results.
M3 — Enrollment Execution
SEP WORKFLOW · DOCUMENTATION · PLAN ACTIVATION · PAYER UPDATE → E4
Integration: Confirming enrollment in M3 writes the new insurance status to the shared client record. Engine 4 reads this update on the next fill — the payer type and reimbursement rate recalculate automatically. Every enrollment confirmation is simultaneously a revenue recognition event in the 340B revenue ledger.
SEP Enrollment Workflow
1
Qualifying event
Document ILS trigger
2
Plan selection
M2 output → confirm
3
Application
HealthCare.gov / HealthSherpa
4
Confirm + activate
M4 ADAP PA linked
Enrollment Log
May 21 · Rivera
CLT-0441 enrolled — BCBS Silver. ADAP PA: $420/mo. E4 payer updated to Commercial.
May 19 · Chen
CLT-0774 enrolled — Aetna Silver. ADAP PA: $680/mo. E4 revenue projection +$28K/yr.
May 15 · Santos
CLT-0318 re-enrolled after lapse — plan reinstated. M5 lapse alert resolved.
Pending · Unassigned
CLT-0592 — uninsured. Medicaid screen negative. SEP assessment needed.
M4 — Premium Assistance Management
ELIGIBILITY VERIFICATION · PA DISBURSEMENT · CAP COMPLIANCE
Policy Engine: PA eligibility is verified against your entity configuration before any disbursement is recorded. APTC qualification, FPL range, and PA cap are enforced automatically based on your program rules.
Client Eligibility Verification
Select a client to verify PA eligibility
Entity PA Policy Rules
Loading entity configuration...
M5 — Coverage Monitoring & Alerts
LAPSE DETECTION · RENEWAL ALERTS · COVERAGE → E4 LEAKAGE BRIDGE
Integration — M5 → E4: A coverage lapse detected in M5 immediately writes a payer status change to the client record. Engine 4 reads this as a revenue leakage event — the expected commercial margin for that client's next fill is reclassified as at-risk. The navigator receives a re-enrollment task and the finance dashboard shows the projected monthly revenue impact of the lapse.
—
Critical alerts
—
High alerts
—
Revenue at risk /mo
Active Coverage Alerts
Loading alerts...
Engine 3 — Compliance Monitor
DUPLICATE DISCOUNT · TB MODIFIER · MANUFACTURER RESTRICTIONS · CONTRACT PHARMACY · MEDICAID MCO · ESP 45-DAY · M4 BRIDGE
Integration — E3 ↔ M4: Engine 3 reads ADAP premium assistance status from M4 in real time. When a 340B fill is submitted for a client whose M4 record shows they are on ADAP direct purchase AND the fill is being billed to Medicaid, E3 fires a critical duplicate discount flag and simultaneously suspends the M4 payment queue for that client pending navigator review.
Engine 4 — Revenue Reconciliation
ERA MATCHING · MARGIN CALCULATION · PHARMACY FEE RECONCILIATION · LEAKAGE ANALYSIS · M3/M5 PAYER UPDATES
Integration — M3/M5 → E4: Payer type for each client updates automatically from M3 enrollment confirmations and M5 lapse alerts. Engine 4 recalculates expected margin per client per fill in real time. For contract pharmacy fills, net margin reflects the actual pharmacy fee structure per Exhibit A ($10 + 8% gross charges, capped per contract terms) — ensuring revenue calculations accurately reflect what the covered entity retains after pharmacy costs.
$72K
Net revenue MTD
↑ 8% vs last mo.
81%
Capture rate
△ Target: 90%+
$285
Avg margin / fill
↑ from $231 Q1
$8.8K
Leakage MTD
↓ 2 lapsed clients
Revenue by Payer YTD
| Payer | Fills | Gross | Net Margin | Margin% |
|---|---|---|---|---|
| Commercial/ACA | 1,247 | $612K | $428K | 70% |
| FL Medicaid | 1,568 | $392K | $98K | 25% |
| ADAP Direct | 520 | $130K | $26K | 20% |
| Uninsured | 193 | $19K | $1K | 5% |
Converting 44 ADAP clients (M3 pipeline) to ACA adds ~$210K annual net revenue. M3 enrollment activity directly drives this number.
Revenue Estimator
—
Gross savings/yr
—
Net revenue/yr
ROPHI Engine
RETURN ON PUBLIC HEALTH INVESTMENT · AUTO-POPULATED FROM ALL PLATFORM LAYERS
Full integration: ROPHI auto-populates from the shared data layer — revenue from E4, clinical outcomes from CAREWare sync, ADAP transitions from M3 enrollment log, coverage rate from M5, ED/hospitalization data from outcomes import. The ROPHI ratio updates every time any connected module is updated.
Loading ROPHI history...
Inputs (auto-populated)
Real Monthly Calculation Trigger
From Engine 4
From Client Registry / CAREWare
From M3 Enrollment Log
Utilization
Return on Public Health Investment
—
ROPHI Ratio
Value Components
340B net revenue—
Avoided ED costs—
Avoided hosp. costs—
VL suppression value—
Coverage expansion value—
Total value generated—
Reinvestment cost—
Optimization Levers
Calculate ROPHI to see recommendations
Supabase Database Schema
UNIFIED DATA MODEL · TABLES SHARED BY CARE-CROS MODULES AND 340B ENGINES
ℹThis is the developer-ready schema specification for your Supabase instance at coveragegateway.com. All CARE-CROS modules and 340B engines read from and write to these tables. Pass this to your developer as the integration specification for Module 6 of the sprint plan.
Core tables (shared spine)
| Table | Key Fields | Used by |
|---|---|---|
| clients | client_id, name, dob, fpl_pct, prescriber_npi, site_id, adap_status, is_340b_eligible | All modules + all engines |
| coverage_records | client_id, coverage_type, plan_name, effective_date, premium, adap_pa_amount, status | M3, M4, M5, E3, E4 |
| rx_fills | fill_id, client_id, ndc, drug_name, fill_date, site_id, prescriber_npi, payer_type, acq_cost, reimb_amount, is_340b, manufacturer, esp_submitted, esp_submission_date, is_contract_pharmacy, contract_pharmacy_name, pharmacy_dispensing_fee, pharmacy_mgmt_fee, payer_subtype (FFS/MCO), medicaid_retroactive_coverage | E1, E2, E3, E4 |
| era_remittances | claim_id, fill_id, payer, paid_amount, paid_date, tb_modifier, reconciled | E4, Compliance log |
CARE-CROS module tables
| Table | Primary Purpose |
|---|---|
| eligibility_screens | M1 FPL/APTC screening records — feeds E2 patient definition |
| plan_comparisons | M2 plan selection + 340B margin projections per client |
| enrollments | M3 SEP workflow records — triggers E4 payer type update |
| adap_pa_records | M4 disbursement log — triggers E3 duplicate discount check |
| coverage_alerts | M5 lapse / renewal alerts — triggers E4 leakage flag |
340B engine tables
| Table | Primary Purpose |
|---|---|
| eligibility_results | E2 per-fill eligibility verdicts + reasons |
| compliance_flags | E3 all flags: dup. discount, TB modifier, restrictions, patient def. |
| revenue_ledger | E4 reconciled revenue per fill: margin, payer, ERA match status |
| rophi_reports | Quarterly ROPHI calculations + value components |
Critical integration triggers (write to your developer)
enrollments.INSERT → UPDATE clients.coverage_type → RECALC revenue_ledger.expected_margin
adap_pa_records.INSERT → CHECK coverage_records for Medicaid overlap → INSERT compliance_flags if risk
coverage_alerts.lapse → UPDATE rx_fills.payer_status → FLAG revenue_ledger as at_risk
rx_fills.INSERT → RUN eligibility_check → RUN dup_discount_check → INSERT results
era_remittances.INSERT → MATCH to rx_fills → UPDATE revenue_ledger.reconciled
→These five database triggers are the integration's nervous system. Implemented as Supabase Edge Functions or PostgreSQL triggers. Pass to developer as sprint spec for Module 6.
Engine 1 — Data Ingestion
CSV import pipeline for CAREWare, pharmacy fills, ERA remittances, and OPAIS data
ℹIn the integrated platform, most Engine 1 ingestion is handled automatically by database triggers as CARE-CROS modules update the shared client record. Manual CSV import is available for historical data migration and external pharmacy feeds not yet connected via API.
CAREWare Client Export
Expected columns
client_code, last_visit_date, last_vl_result, last_vl_date
Pharmacy Rx Fill Data
Expected columns
client_code, fill_date, ndc, drug_name, site_id, prescriber_npi, billed_amount, acquisition_cost, wac_price, b340_acquisition_cost
ERA 835 Remittance
Expected columns
era_date, payer_name, paid_amount, total_paid
Engine 2 — Eligibility Checker
Patient definition validation running automatically on every rx_fills.INSERT via database trigger
ℹPatient definition checks run automatically on every prescription fill via the T4 trigger. This dashboard shows current eligibility status across all clients — use Re-check to re-run E2 validation after updating a client's record.
Impact Dashboard
HAB Core Measures · Equity metrics · Viral suppression · Retention · ED reduction
◉Current VS rate: 78% (target 90%) · Retention: 74% (target 85%) · Coverage rate: 93% · ADAP→ACA transitions YTD: 22 · Active ROPHI: see ROPHI Engine tab
Reports & Export
Quarterly revenue · Compliance status · ROPHI analysis · Community benefit · HAB Core Measures · HRSA reporting
Plan Intelligence Engine
Identify · Compare · Select · Set Caps · Publish to Navigators · Director Access Only
Entity type:
Live CMS Data
Director Access Only
1
Setup›
2
Analyze›
3
Compare›
4
Set Caps›
5
Approve›
6
PublishPlan Analysis
Compare Plans
Cap Builder
Approved List
Publish
47
Plans Available
Service area 2026
—
Score 80+ Optimal
Meets all criteria
—
Avg Net PA Cost
After APTC top plans
0
Plans Approved
Navigator allowlist
Scoring Criteria
Weights auto-adjust by entity type. Fine-tune for your program.
35%
Net premium after APTC stays within PA cap — minimizes program cash outlay
30%
APTC covers largest share of premium — reducing PA contribution from program funds
20%
Lower deductibles and OOP max — protecting clients from cost-sharing that leads to care avoidance
15%
Tier 1-2 coverage for Biktarvy, Descovy, Triumeq — preventing high copay at pharmacy
Total: 100% Balanced
Jurisdiction Parameters
Plan Rankings
Run analysis to score all available plans
| Rank | Plan Name | Carrier | Tier | Premium | Net After APTC | PA Cost/Mo | Deductible | OOP Max | ARV Tier | Score | Action |
|---|
0 plans shown 0 approved
Settings
Entity profile · Contract pharmacy · OPAIS · Users · Notifications · Supabase connection
Entity Profile
Contract PharmacyMedwise Pharmacy
NABP #0312847
DEA #BM4421983
Pharmacy NPI1679834520
OPAIS registrationACTIVE
Contract effectiveJun 5, 2026
ESP deadline (days)45 days
Fee structure$10 + 8% gross (30-day)
Integration Status
Supabase connectionCONNECTED
Netlify deploymentLIVE
SSL certificateVALID
CAREWare syncMANUAL CSV
Pharmacy APIMANUAL CSV
ERA/835 feedMANUAL CSV
OPAIS verificationAUTO-MONITORED
ESP submission tracking45-DAY DEADLINE
Active Alerts
All platform alerts across CARE-CROS and 340B engines
CRITICAL · E3
CLT-0337 duplicate discount risk — ADAP+Medicaid overlap on Biktarvy fill. Suspend billing pending review.
CRITICAL · E3
CLT-0209 TB modifier missing on Medicare Part B claim. Corrective billing required — Jan 2025 IRA requirement.
HIGH · E3
Gilead ESP submission overdue — 12 fills, $41,200 discount eligibility at risk. 45-day deadline. Contract pharmacy agreement (§1.1): Pharmacy bears cost if deadline missed.
HIGH · E3
Contract pharmacy fee reconciliation pending — 8 fills this month. Pharmacy fees ($10 + 8% gross charges per Exhibit A) not deducted from net margin. E4 revenue overstated until reconciled.
HIGH · M5
CLT-0592 coverage lapse — ACA plan terminated. $3,200/mo revenue at risk. SEP workflow needed.
MEDIUM · M4
3 clients approaching $1,500 PCN 16-02 premium cap. Navigator outreach needed for income re-screen.
INFO · M3
44 ADAP clients SEP-eligible. ILS qualifying event open. Revenue opportunity: +$210K/yr if enrolled.
Add New Client
Creates a unified record in both CARE-CROS and 340B systems simultaneously
SEP Enrollment Guide
ILS qualifying event · PCN 16-02 · ADAP premium assistance setup
ℹILS (Involuntary Loss of Minimum Essential Coverage) is the qualifying SEP event for ADAP-to-ACA transitions. Document the triggering event carefully. The SEP window is typically 60 days from the qualifying event date.
Resolve Compliance Flag
Document resolution action and update compliance log
Log Coverage Lapse Resolution
Update coverage status and restore E4 revenue projection
Self-Sufficiency Module M6
SCORING · MILESTONES · GOALS · GRADUATION TRACKING
What is Self-Sufficiency? A consumer achieves self-sufficiency when they transition from full dependence on publicly funded assistance to independent responsibility for their healthcare costs — through income growth, skills development, and sustained coverage stability. CARE-CROS tracks this journey with a monthly Self-Sufficiency Score (SSS) across four dimensions: Financial Independence, Coverage Stability, Clinical Stability, and Economic Mobility.
—
Avg SSS Score
—
Clients Scored
—
Improving Trend
—
Graduated
Tier Distribution
Click "Score All Clients" to generate scores for your program
Client Self-Sufficiency Rankings
Run scoring to see client rankings
Program Readiness Assessment
INTAKE · 340B ELIGIBILITY · ACA ENROLLMENT READINESS · ROPHI PROJECTION · SCORE
How this works: This assessment has four sections (15 minutes to complete). Your answers generate a CARE-CROS Readiness Score (0–100), identify the highest-value platform modules for your program, and produce a personalized ROPHI projection showing your current vs. potential 340B revenue. A shareable link can be generated to send to clients before an introductory call.
Section 1 of 4 — Organization Profile