Ashutosh "Ash" Pandey · notes from the field

Building a school-based ESHR for 120,000 students, from a blueprint.

A pioneering, school-based reimbursement infrastructure engineered from inception to full operational deployment within twenty-four months — delivering a comprehensive clinical documentation platform centered on a holistic, whole-child wellness framework.

Client
California county education office
Program
CYBHI & Medi-Cal BOP
Period
2023 – Present
Role
Director, RCM & Health IT

In late 2023, California's $4B Children and Youth Behavioral Health Initiative needed something the state had never built before: a way for school districts to deliver — and bill for — school-based behavioral health services at scale. This is what it took to build the infrastructure underneath that ambition.

The context.

California's Children and Youth Behavioral Health Initiative is one of the largest public investments in youth mental health in US history. The program's premise is simple in language and unprecedented in operations: meet kids where they are — at school — and pay providers to serve them through the CYBHI plumbing that funds hospitals and clinics.

The core challenge lies in a fundamental structural mismatch: educational institutions are not healthcare enterprises. Local Education Agencies — including county offices, school districts, and charter networks — traditionally operate entirely outside the clinical ecosystem, lacking the foundational infrastructure required for medical revenue cycles: enterprise EHRs, Charge Description Masters, payer enrollment networks, automated claim-scrubbing logic, and dedicated denial-management workflows. They have student information systems and instructional staff. The gap between those two worlds is the problem this engagement existed to close.

What had to be built.

The county office mandate covered native Local Education Agencies serving roughly 120,000 students, with the obligation to bill cleanly against the CYBHI fee schedule, and the Medi-Cal Billing Option Payment program for participating LEAs.

The work fell into four layers, designed and stood up in parallel:

Layer 01 — The ESHR
A custom Electronic Student Health Record System on Salesforce Platform.

Engineered from a comprehensive blueprint spanning system architecture, granular user roles, and complex business logic, the platform supports a diverse ecosystem of stakeholders — including providers, clinical supervisors, billing coordinators, administrators, and LEA business officials. Each user interacts with role-based dashboards tailored precisely to their operational metrics. The suite features seven distinct dashboards, derived from extensive stakeholder discovery to mirror true day-to-day workflows, natively supporting individualized Care Plans, Coordination of Services Team (COST) frameworks, and end-to-end referral pipelines.

Layer 02 — The Data Foundation
An Azure-based SQL data warehouse, designed to make the numbers trustworthy and support whole-child analytics.

Seamlessly integrating with Student Information Systems (SIS) to drive advanced analytics and granular whole-child tracking. By designing and orchestrating scheduled ETL pipelines, the system automatically ingests, normalizes, and routes critical clinical datasets directly into ESHR — providing the foundational, high-integrity data required to power compliance-driven billing and revenue cycle operations.

Layer 03 — The Billing Infrastructure
CDM, claims scrubbing, and 837P billing workflows from zero.

Established a Charge Description Master, claims-scrubbing logic, reimbursement-rate tables, and full 837P billing workflows for three different programs simultaneously: the CYBHI multi-payer fee schedule, Medi-Cal BOP, and Managed Care Plan billing. Each program has its own rules, its own forms, its own gotchas — and providers do not have the luxury of caring which is which. The system has to.

Layer 04 — The Human Layer
Helpdesk, training, FAQs, and a continuous-improvement governance loop.

No ESHR survives contact with its users unless someone is on the other end of the help line. Set up the helpdesk function, the support forums and technical assistance framework — and instituted a standing enhancement-and-bug-fix governance process so the system keeps getting better instead of slowly worse.

Most ESHR (EHR) projects fail not because the technology is wrong, but because no one stayed in the room long enough to learn what the people using it actually needed. — a lesson learned the slow way

The system, in brief.

Architecture & Stack
  • ESHR Platform Salesforce (customized over a Salesforce-based EHR system)
  • Data Warehouse Azure SQL with custom ETL pipelines
  • Claims Submission 837P via Availity clearinghouse and 837I to Medi-Cal
  • Payment Reconciliation Carelon TPA / Payspan and Medi-Cal
  • Programs Covered CYBHI fee schedule · Medi-Cal BOP · MCP Billing
  • Compliance HIPAA · Medi-Cal · FERPA
  • Coverage Local Education Agencies · Community-Based Organizations · 120,000+ students

What the numbers say.

24 mo.
From Blueprint to Operations
24,000/yr
Annual Claim Run Rate

The numbers above are presented for what they are: directional indicators of a system that works, not the final measure of it. A 90% clean-claim rate is a meaningful threshold for a Medi-Cal billing operation — particularly one running against three programs simultaneously, on a platform that did not exist two years ago.

The other measure — harder to quantify but more important — is that ten LEAs now have a way to fund the people doing the work. A district that hires a counselor knows the claim will go through. A county business official can answer the question "did we get paid for that?" without a forensic exercise. That is what the system is for.

What it taught me.

Build the help desk first. Not last. The conversations there shape the system more than any requirements document. People will tell the help desk what they cannot tell a survey.
Role-based dashboards are not a feature; they are a posture. The provider, the billing coordinator, and the business official are different people with different questions. A system that serves them all with the same screen serves none of them.
The Charge Description Master is a translation, not a list. It translates what providers do into what payers can pay for. Treating it as a spreadsheet of codes is how revenue leakage gets built into the foundation.
Schools are not hospitals, and pretending otherwise breaks the model. The CYBHI work succeeded to the extent that the system met educators where they were — with language, workflows, and reporting calibrated to how they actually do their jobs, not how a hospital does its.
Twenty-four months is fast. Faster than it looks from the inside. The team that built this did so on a schedule that left no room for sentimental architecture decisions. Every choice had to earn its keep.

The work continues. The system gets better. The next chapters — adding LEAs, expanding programs, integrating more deeply with the state's data infrastructure — are still being written.