Where Outcome Data Gets Lost Before Anyone Can Use It

piggy bank data

Your clinicians are doing the work. The PHQ-9, the nine-question depression screening tool, is being administered. The GAD-7, its counterpart for anxiety, is getting completed. The screening protocols are in place.

So why can’t you pull a clean population-level trend line out of your electronic health record?

This is one of the most common frustrations in behavioral health operations, and the answer is almost never about clinician compliance. The data exists. The failure happens downstream, in the configuration layer that determines whether a score lands in a structured, countable field or disappears into a free-text note. A PHQ-9 score in the wrong field type is invisible to your reporting system. It happened. It just can’t be counted.

The four gaps below account for the majority of outcome data failures in behavioral health EHRs. None of them require new software to fix. All of them are within reach of operational and IT staff who know where to look.

LOINC Coding Is the Foundation

LOINC (Logical Observation Identifiers Names and Codes) is the universal standard that allows patient assessment results to travel across systems and mean the same thing wherever they land. When a PHQ-9 total score is mapped to a LOINC code, it becomes a discrete, structured data element that any reporting system can find, aggregate, and compare. Without that mapping, the score exists in isolation and cannot be reliably shared or summed across your patient population (Vreeman et al., PMC, 2010).

A PHQ-9 total score mapped to a LOINC-coded field and a PHQ-9 total score typed into a note are wholly different data objects. The first can be counted, trended, and compared across your entire patient population. The second requires specialized text extraction to use, and for any standard reporting workflow, it effectively doesn’t exist.

Here’s how to audit. Pull a sample of PHQ-9 records and confirm the total score field carries a verified LOINC code. If it doesn’t, every report attempting to pull population-level trends is working with a partial picture, and the gap grows with every encounter.

Your LOINC mapping is either the foundation of your outcome reporting or the reason it fails. There is no middle ground.

Free-Text Fields Are Where Population Data Goes to Disappear

The field type where a score is recorded matters more than whether the score was recorded at all. Research comparing structured and unstructured EHR data confirms what informatics teams already know from experience: information captured in free-text clinical notes requires significant computational resources to extract and is effectively unavailable for standard reporting workflows (Seinen et al., PMC, 2025).

When a clinician enters a PHQ-9 total score in a text note field, the score is documented but not usable for population analytics. It vanishes from trend reporting, from service-line outcome profiles, from any query that needs to aggregate across patients. This is a configuration problem, not a clinical one. The clinician did their job, then the field type undid it.

The fix is an EHR template audit: for every active screening template, confirm that total score fields are mapped to discrete, structured data elements. Pay particular attention to templates built at go-live and never revisited, templates copied from other sites, and any template where the score entry is an open text box with no data validation.

Finding unstructured score fields doesn’t mean the data is lost. It means the data is not yet usable. There is a difference, and knowing which situation you’re in is the starting point for remediation.

Re-Administration Intervals Don’t Enforce Themselves

Measurement-based care, the practice of tracking patient progress through repeated, timed screenings, requires consistent re-administration over time. The clinical and operational value of PHQ-9 and GAD-7 data depends on longitudinal tracking, not a single intake snapshot. Research on real-world MBC implementation identifies EHR workflow design and automated prompting as the primary barriers to consistent re-administration in community behavioral health settings (Carlo et al., PMC, 2025). Without built-in interval logic, re-administration rates are driven by individual clinician habits, and those vary.

Most behavioral health EHRs support configurable screening interval alerts. The problem is that this configuration is set once at go-live and rarely reviewed when protocols change. An organization that updated its screening intervals two years ago may still be running the original setup. The result is a longitudinal dataset full of gaps that look like clinician non-compliance but are actually a settings problem.

The audit is simple: pull up the current interval configuration for your PHQ-9 and GAD-7 prompts. Confirm it matches your current clinical protocol. Confirm it’s active across all sites and service lines. If the configuration hasn’t been reviewed since implementation, assume it needs updating.

This is a settings review, not a policy revision. The clinicians don’t need new training. The workflow needs to be rebuilt to support what they’re already trying to do.

Template Variation Across Sites Breaks Aggregation

Cross-site reporting requires that the same data element carry the same field name and structure at every location. If Site A calls the PHQ-9 total score field “PHQ9_Total,” Site B calls it “PHQ-9 Score,” and Site C captures it in a note, a population-level trend report requires manual reconciliation before any analysis can begin. Every additional site multiplies the problem.

This is a common outcome of organic EHR growth. Templates get built by different staff at different times, often starting from different base templates. No single person has visibility into all of them. The inconsistency isn’t intentional. It also isn’t visible until someone tries to run a cross-site query.

A one-hour field naming audit across all active templates surfaces this problem completely. The output is a short list of standardization decisions: which field name becomes the standard, which templates need updating, and what the downstream impact on existing reports will be. That document is worth producing before any payer conversation or leadership reporting request arrives.

The four gaps above are the most common reasons behavioral health organizations can’t get clean population-level outcome data out of systems that are already collecting it. Your clinicians are doing their part. The configuration layer is where the data either holds together or falls apart.

Package your audit findings as a one-page summary: field name, current configuration, impact on reporting, recommended fix. That document goes to leadership and flows  into any vendor evaluation conversation that follows.

What would your PHQ-9 trend line look like if every score your clinicians entered was actually landing in a structured field?


If your team is ready to run the audit, or wants a framework for prioritizing which gaps to address first, contact us.
#BehavioralHealth #MeasurementBasedCare #EHROptimization #ClinicalInformatics #PeopleFirst #XpioHealth


References:

  1. Vreeman DJ, McDonald CJ, Huff SM. Representing Patient Assessments in LOINC. AMIA Annual Symposium Proceedings. PMC. 2010. https://pmc.ncbi.nlm.nih.gov/articles/PMC3041404/
  2. Seinen TM, Kors JA, van Mulligen EM, Rijnbeek PR. Using Structured Codes and Free-Text Notes to Measure Information Complementarity in Electronic Health Records: Feasibility and Validation Study. Journal of Medical Internet Research / PMC. 2025. https://www.ncbi.nlm.nih.gov/pmc/articles/PMC11887999/
  3. Carlo AD, Scott KS, McNutt C, Talebi H, Ratzliff AD. Measurement-Based Care: A Practical Strategy Toward Improving Behavioral Health Through Primary Care. Journal of General Internal Medicine. 2025. https://pubmed.ncbi.nlm.nih.gov/39377965/