computed concept · mined from SQL · flow
Good-faith estimate
Computes the patient's good-faith cost estimate / patient responsibility.
Pipelines
11/53
compute it in SQL
Customers
11
ECP, EyeSouth, HeatonEye, ISpine, MNEye, OneGI…
Distinct SQL
12
distinct implementations
the SQL
Steps that compute it
The concrete SQL steps whose text computes good-faith estimate, 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.
Flags specific charges as patient responsibility based on source system indicators and insurance remittance transfer records.
Extracts and transforms electronic remittance advice data from raw transaction files into a structured format for processing.
Transforms raw remittance transaction data into a structured format by parsing payer details, payment amounts, and insurance filing indicators.
Categorizes and loads financial transactions, such as payments, adjustments, and denials, while mapping them to specific charges and payers.
Aggregates transaction data to calculate total adjustments, denials, and payments per charge and coordination of benefits level.
Builds standardized transaction records by mapping source adjustments to specific categories and ordering them for account-level analysis.
Aggregates transaction data into summaries of adjustments, denials, and payments per charge to support account-level financial reporting.
Identifies and loads charges where the patient is designated as the responsible party for payment.
Loads granular charge-level data, including procedure codes, modifiers, and calculated patient liability for individual healthcare services.
Loads and categorizes financial transactions, adjustments, and coordination of benefits transfers from the source practice management system.
Updates the temporary refunds table by merging custom property data with visit and insurance details to track patient refunds.
Standardizes remittance claim data by mapping filing indicators and calculating sequence ordinals for payment tracking.
who computes it · 11
Pipelines that compute good-faith estimate
Grouped by product. Each links to its task tree.
| Customer | Pipeline | Product | Cadence |
|---|---|---|---|
| PAA | Daily-Processing | Flow | daily 11:15 |
| HeatonEye | Daily-Processing | Mixed | daily 08:30 |
| ECP | Daily-Accounts-Processing-RevFind | RevFind | daily 01:00 |
| EyeSouth | Daily-Processing | RevFind | daily 06:30 |
| ISpine | RevFind-Daily-Processing | RevFind | daily 03:45 |
| MNEye | Daily-Processing-Accounts | RevFind | chained |
| OneGI | RevFind-Daily-Processing-ModMed | RevFind | daily 03:00 |
| OrthoAlliance | Daily-Accounts-Processing | RevFind | daily 09:15 |
| TheOregonClinic | RevFind-EDI-Daily-Processing | RevFind | daily 03:45 |
| USDH | Daily-Processing | RevFind | daily 03:30 |
| USHP | RevFind-Daily-Processing-Accounts | RevFind | daily 06:45 |
the rhythm
When it runs
daily & monthly fires · 11
03691215182124
daily 01:00
01:00
daily 03:00
03:00
daily 03:30
03:30
daily 03:45
03:45
daily 03:45
03:45
daily 06:30
06:30
daily 06:45
06:45
daily 08:30
08:30
daily 09:15
09:15
daily 11:15
11:15
chained
runs after the source-data load
HL7 FHIR file/batch eligibility◆ monthly · shaded = overnight (00–06)