trigger
How it's scheduled
New appointments land continuously on the Batch / file feed. Front-of-house work is time-boxed — the estimate and letter have to reach the patient before the visit — so the pipeline polls every 30 minutes to process the visits within minutes of an appointment being booked, rather than waiting for an overnight batch.
| Scheduled task | Cadence | Server | State | Coordination |
|---|---|---|---|---|
\MDC\SemiHourly - Model Processing - Commonwealth | every 30 min (from 07:00) | prod-db-3 | enabled | standalone |
shape
The RevFind back-office spine
RevFind pipelines share a back-office shape: ingest → load accounts → reconcile remits → model contracts → surface underpayments. Lit stages are the ones this pipeline runs.
task tree
What the pipeline runs
Tasks in order, each with what it does — typed stepsfrom the MDClarity task docs (click to open the reference), sub-jobsyou can expand inline (▶) to reveal their own tasks, and SQL steps summarized by Gemini (✨). Every step shows the tables it writes/reads and which earlier step it feeds from(sqlglot lineage).
Revfind-Contract-Modeling-Processing
- ProcessScenarioModelProcessScenarioModelCalculates account estimates for queued scenario models to perform what-if analysis for contract modeling and pricing.