computed concept · mined from SQL · flow
Bundles
Groups procedures into bundles for the estimate.
Pipelines
10/53
compute it in SQL
Customers
7
CCP, EugeneGI, OrthoAlliance, PAA, RIA, SGP…
Distinct SQL
15
distinct implementations
the SQL
Steps that compute it
The concrete SQL steps whose text computes bundles, in plain language (✨ Gemini gloss), most-reused first. The count is how many steps across all trees run this same SQL; the link opens an example pipeline's task tree.
Populates the auto-send queue with visit data to facilitate automated end-of-day processing and communication.
Identifies and recalculates expected charges from service bundles for future visits to ensure accurate cost estimates.
Builds a mapping table by extracting visit, insurance, and service code details from configuration data for use in calculations.
Records financial transactions, such as payments and adjustments, while establishing chronological posting orders for each account's billing history.
Builds the charge type catalog by categorizing professional and facility fees and generating encoded strings for billing and service types.
Updates the combined bundles source table by merging imported surgical bundle details, procedure codes, and surgeon information.
Calculates surgical CPT rates and units for standard data sources using fee schedules and bundled service logic.
Calculates surgical CPT rates and units specifically for Edgewater source data using fee schedules and bundled service logic.
Calculates surgical CPT rates and units for mobile source data using fee schedules and bundled service logic.
Calculates surgical CPT rates and units for Meditech source data using fee schedules and bundled service logic.
Generates visit charges by combining surgical CPT data with diagnosis coverage flags to determine final billable units and types.
Builds a staging table of visit charges by extracting and formatting procedure codes and units from HL7 order bundles.
Loads and categorizes financial transactions into payments, adjustments, or denials based on source codes and coordination of benefits.
Generates visit charges by mapping diagnosis codes and patient demographics to specific service bundles and clinical item IDs.
Refines visit charges by deduplicating evaluation and management codes based on price rankings from the self-pay fee schedule.
who computes it · 10
Pipelines that compute bundles
Grouped by product. Each links to its task tree.
| Customer | Pipeline | Product | Cadence |
|---|---|---|---|
| EugeneGI | Flow-MM-HL7-Processing | Flow | every 30m |
| EugeneGI | HL7-Processing-Nightly | Flow | daily 19:34 |
| PAA | Daily-Processing | Flow | daily 11:15 |
| PAA | Daily-Processing-PAAMobile | Flow | daily 14:30 |
| RIA | Flow-HL7-Processing | Flow | every 1m |
| RIA | Flow-HL7-Processing-AutoSendLettersForFutureVisits | Flow | daily 19:01 |
| SunLife | Daily-Visits-Processing | Flow | daily 10:30 |
| CCP | Daily-Accounts-Processing | RevFind | daily 04:30 |
| OrthoAlliance | Daily-Accounts-Processing | RevFind | daily 09:15 |
| SGP | RevFind-Daily-Processing | RevFind | daily 01:00 |
the rhythm
When it runs
always-on loops · 2 · tick density = frequency