CARE-CROS™ Integrated Platform
INTEGRATED
0 clients
🔔
2 CRITICAL flags require immediate action — Duplicate discount risk detected for Broward County TGA clients. Billing suspended automatically.
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%
ACA / Commercial
38% · 70%
FL Medicaid
41% · 25%
ADAP Direct
14% · 20%
Uninsured
7% · 5%
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
PayerFillsGrossNet MarginMargin%
Commercial/ACA1,247$612K$428K70%
FL Medicaid1,568$392K$98K25%
ADAP Direct520$130K$26K20%
Uninsured193$19K$1K5%
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)
TableKey FieldsUsed by
clientsclient_id, name, dob, fpl_pct, prescriber_npi, site_id, adap_status, is_340b_eligibleAll modules + all engines
coverage_recordsclient_id, coverage_type, plan_name, effective_date, premium, adap_pa_amount, statusM3, M4, M5, E3, E4
rx_fillsfill_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_coverageE1, E2, E3, E4
era_remittancesclaim_id, fill_id, payer, paid_amount, paid_date, tb_modifier, reconciledE4, Compliance log
CARE-CROS module tables
TablePrimary Purpose
eligibility_screensM1 FPL/APTC screening records — feeds E2 patient definition
plan_comparisonsM2 plan selection + 340B margin projections per client
enrollmentsM3 SEP workflow records — triggers E4 payer type update
adap_pa_recordsM4 disbursement log — triggers E3 duplicate discount check
coverage_alertsM5 lapse / renewal alerts — triggers E4 leakage flag
340B engine tables
TablePrimary Purpose
eligibility_resultsE2 per-fill eligibility verdicts + reasons
compliance_flagsE3 all flags: dup. discount, TB modifier, restrictions, patient def.
revenue_ledgerE4 reconciled revenue per fill: margin, payer, ERA match status
rophi_reportsQuarterly 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
Publish
Plan 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.
Ryan White (non-340B) Mode
340B margin not applicable. Weights cover PA cost efficiency, APTC conservation, client OOP protection, and ARV formulary.
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
RankPlan NameCarrierTier PremiumNet After APTCPA Cost/Mo DeductibleOOP MaxARV Tier ScoreAction
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
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