Source: https://quadevs.com/case/hedis-pipeline/

Title: HEDIS measure pipeline on .NET and MSSQL | quadevs

[Home](https://quadevs.com/)/ [Cases](https://quadevs.com/cases/)/ HEDIS measurement pipeline

# HEDIS measurement pipeline

A HEDIS measure pipeline built from .NET Windows services. It takes in faxes, syncs insurance portals, sorts documents, retries failed calls and routes incidents to Slack with the stuck order attached. Any submission can be rebuilt from its raw inputs on request.

## What is a HEDIS measurement pipeline?

A HEDIS measure pipeline takes in chart documents and claims, sorts and cleans them for the measure year, then works out the numerators, denominators and exclusions an auditor can reproduce. HEDIS is the NCQA measure set that health plans report to show the quality of the care their members get.

## Manual triage and lost orders

HEDIS measures need chart documents and claims from many sources. They have to be sorted and cleaned, and the numbers must be ones an auditor can check. Sorting by spreadsheet did not scale. An earlier attempt at automation had race conditions that lost orders. It gave no clue about stuck items and told the on-call team nothing in Slack. Every audit meant rebuilding the pipeline state by hand.

## Windows services with an audit row per step

A set of .NET background services on Windows runs the flow of documents and claims. A fax gateway feeds document sorting and routing, and a portal sync pulls claims from insurers. Short failures wait in retry queues of their own, apart from permanent ones. Stuck-order checks flag problems early. A dashboard reads MSSQL and New Relic and pages the on-call team in Slack with the order attached. Each step writes an audit row, so a replay of the raw inputs gives the same final measure.

## Stack and engineering choices

- .NET Windows background services.
- MSSQL transactional core.
- New Relic instrumentation.
- Slack-native incident routing.
- Retry queues with isolation.
- Stuck-order diagnostics.
- Audit-grade order trail.

## Submissions reproduced on request

Any HEDIS submission can be rebuilt from raw inputs to final measure on request. Stuck orders show up within minutes; finding them used to take days. On-call staff handle incidents in Slack with no separate ticket tool, and audits close without rebuilding the pipeline state by hand.

1. [What is a HEDIS measurement pipeline?](https://quadevs.com/case/hedis-pipeline/#definition)
2. [Manual triage and lost orders](https://quadevs.com/case/hedis-pipeline/#problem)
3. [Windows services with an audit row per step](https://quadevs.com/case/hedis-pipeline/#approach)
4. [Stack and engineering choices](https://quadevs.com/case/hedis-pipeline/#engineering)
5. [Submissions reproduced on request](https://quadevs.com/case/hedis-pipeline/#outcome)

Category
:   Healthcare · pipeline

Stack
:   - .NET
    - MSSQL
    - NewRelic
    - HEDIS

Service [HEDIS reporting software and measure pipelines](https://quadevs.com/healthcare/hedis-reporting/)

Also on [EHR integration and lab integration services](https://quadevs.com/healthcare/ehr-lab-integration/) [.NET development and consulting](https://quadevs.com/dotnet-development/) [Windows desktop application development](https://quadevs.com/windows-app-development/) [API development, web services and Windows services](https://quadevs.com/windows-web-services/) [Legacy application modernization](https://quadevs.com/legacy-modernization/) [Software maintenance and application support](https://quadevs.com/software-maintenance/)

Insights [HEDIS automation: a pipeline auditors can reproduce](https://quadevs.com/insights/hedis-data-pipeline/)

 [Previous caseFHIR · TEFCA · USCDI integration](https://quadevs.com/case/fhir-tefca-uscdi/) [Next caseClinical document watcher](https://quadevs.com/case/document-watcher/)

## Related work

[### Multi-clinic web platform

Healthcare · web  Next.js · headless · Twilio · ADA View case](https://quadevs.com/case/multi-clinic-web/)   [### FHIR · TEFCA · USCDI integration

Healthcare · interop  FHIR R4 · SMART v2.1 · TEFCA · USCDI v3 · Da Vinci · CARIN BB · US Core View case](https://quadevs.com/case/fhir-tefca-uscdi/)   [### Clinical document watcher

Healthcare · agents  .NET · OCR · S3 · audit log View case](https://quadevs.com/case/document-watcher/)

[Send a brief. Reply within 1 business day](https://quadevs.com/contact/)  [or email hello@quadevs.com](mailto:hello@quadevs.com)
