medallion-status.yaml — as of 2026-08-12.| Source system | Snowflake share | SFTP files | Direct SQL Server | Vendor API | All |
|---|---|---|---|---|---|
| NextGen | · | 8 | · | · | 8 |
| HL7 interface | · | 7 | · | · | 7 |
| EDI (835/837) | · | 4 | · | · | 4 |
| eClinicalWorks | · | 3 | · | · | 3 |
| athenahealth | 2 | · | · | · | 2 |
| FHIR | · | · | · | 2 | 2 |
| ModMed | · | 2 | · | · | 2 |
| Centricity | · | 1 | · | · | 1 |
| Experity | · | 1 | · | · | 1 |
| gGastro | · | · | 1 | · | 1 |
| MSN | · | 1 | · | · | 1 |
| NexTech · FHIR | · | · | · | 1 | 1 |
| NextTech | · | · | 1 | · | 1 |
| Phygen | · | 1 | · | · | 1 |
| QuickSight | · | · | · | 1 | 1 |
| Snowflake | 1 | · | · | · | 1 |
Customers per source × delivery channel, tinted by bronze progress. eClinicalWorks spans SFTP files and direct SQL Server (Partnercare) — the same feed, two transports.
Delimited files — CSV / pipe / tab, plus the rare ^|^ multichar — parsed via ProcessDataFile. Usually pushed to our SFTP, sometimes pulled from a vendor host (a separate axis — see vendor pull). The workhorse and widest blast radius: it fires for any customer with a delimited feed, even a secondary one.
File-based HL7 (ADT / SIU / DFT / ORM) — no MLLP listeners. Needs a parser + message-type mapping before first live.
ClarityFlow consumes HL7 continuously through the day — not the daily batch cadence the rest of medallion runs at. Bronze needs a frequent small-batch HL7 mode before Flow's HL7 customers can move. ClarityFlow-only: RevFind's daily cadence is unaffected.
X12 claims & remits. Some pipelines use the in-repo EDIParser task; iSpine routes parsing through an off-repo PowerShell script (insert_edi.ps1). Medallion needs a first-class X12 parser either way.
We reach out to *their* server (e.g. MSNFTP.MSNLLC.NET) instead of receiving a push — a transport-direction signal, independent of file format. Needs outbound creds + scheduling.
athenahealth (and other Snowflake-share sources) read straight from a Snowflake share — no inbound files to receive or parse, though bronze still writes parquet like every source. Cloud-native, the smoothest path. NB: 'Athena' here is athenahealth, NOT AWS Athena.
First-class FHIR API connectors — API client & token handling rather than file ingest. First customer is ARSA (medallion-native, no legacy export). ModMed's off-repo Flow-MM API (OneGI) is invisible to the export and not counted here.
Live OLTP reads against the EHR's SQL Server — no file drop at all. Spans NexTech (EyeSouth) and eClinicalWorks-over-SQL-Server (Partnercare); new-stack feeds the export can't see (OneGI's gGastro) are added via a curated override. Needs a network path + read credentials.
Scripts we run inside the customer's network pull data out of their NextGen SQL Server and push the output back to us over inbound SFTP. Distinct from direct SQL Server (we never reach their DB) and from plain SFTP delimited (the burden is the on-prem extract agent we install and maintain). HillsboroEye is the first — medallion-native, invisible to the legacy export.
SGP's daily source: exported by QuickSight into S3 and picked up there. Narrow — SGP's bronze pickup is live; the full RevFind-Source replacement (#5533) is still in flight.
| Customer | Bronze | Silver | Gold |
|---|---|---|---|
| In flight in medallionat least one layer building, cutting over, or live11 customers · 18 cells moving | |||
| ARSAClarityFlow⇢ legacy | NexTech · FHIR✦ | live ✓✦ | |
| CommonwealthRevFind | athena | cutover | internal✦ |
| ECPRevFind | EDISnow | parallel | |
| HillsboroEyeRevFind⇢ legacy | NextGen✦ | live ✓✦ | |
| OCPRevFind | SFTP CSV✦ | building✦ | |
| OneGIClarityFlowRevFind | ModMedECWgGastro✦ | ||
| PrecisionHealthRevFind | EDI 835✦ | ||
| SGPRevFind | QuickSight | ||
| StrideCareClarityFlowRevFind | HL7athena | parallel | |
| SuncoastSkinRevFind | EDI 835✦ | ||
| WomensCareClarityFlowgated · HL7 v2 fileslegacy HL7 pipeline built in parallel so the customer isn't blocked | HL7 v2✦ | ||
| Gated on EDI / X12 ingestblocked until the X12 parser exists in medallion3 customers | |||
| ISpineRevFind | EDI | ||
| TheOregonClinicRevFind | EDI | ||
| USDHRevFind | EDI | ||
| Gated on vendor-host pullwe must reach out to their SFTP3 customers | |||
| EugeneGIClarityFlow | HL7ModMed | ||
| RIAClarityFlowRevFind | HL7MSN | ||
| SWOrofacialClarityFlow | HL7 | ||
| Gated on direct SQL Serverlive OLTP reads, no file drop1 customer | |||
| EyeSouthRevFind | NextGenNexTech | ||
| Gated on HL7 v2 ingestfile-based HL7 parser needed3 customers | |||
| OrthoAllianceClarityFlowRevFind | HL7NextGen | ||
| PPRMClarityFlow | HL7NextGen | ||
| SeaRadClarityFlow | HL7 | ||
| Gated on vendor APIFHIR connector needed2 customers | |||
| MannEyeClarityFlow | FHIR | ||
| NWDermClarityFlow | FHIR | ||
| Gated on SFTP delimited ingestthe workhorse path12 customers | |||
| CCPRevFind | Experity | ||
| FemwellRevFind | — | ||
| HeatonEyeClarityFlowRevFind | NextGen | parked | |
| JewishBoardRevFind | — | ||
| MNEyeClarityFlowRevFind | NextGen | parked | |
| MiddletownMedicalRevFind | ECW | ||
| Monarch | — | ||
| PAARevFind | Phygen | ||
| SouthSoundRadiologyClarityFlow | — | ||
| SunLifeClarityFlow | NextGenECW | ||
| USHPRevFind | NextGen | ||
| WildflowerClarityFlow | — | ||
| No detected ingest shapeexport shows no parseable format (e.g. TFOC/Centricity)1 customer | |||
| TFOCClarityFlowRevFind | Centricity | ||