computed concept · mined from SQL · revfind
Expected reimbursement
Models what the payer should have paid.
Pipelines
10/53
compute it in SQL
Customers
8
Commonwealth, ECP, ISpine, OneGI, RIA, SGP…
Distinct SQL
15
distinct implementations
the SQL
Steps that compute it
The concrete SQL steps whose text computes expected reimbursement, 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.
Builds a temporary report comparing estimated and actual insurance payments to track recovered revenue from account appeals.
Loads detailed remittance line items, mapping procedure codes, service dates, and payment amounts from electronic remittance advice.
Updates the master transaction table with new or modified records from the imported transaction data.
Updates the charge transaction table by filtering and synchronizing charge-type records from the main transaction source.
Updates the payment transaction table by filtering and synchronizing payment-type records from the main transaction source.
Updates the adjustment transaction table by filtering and synchronizing adjustment-type records from the main transaction source.
Updates the transfer transaction table by filtering and synchronizing transfer-in and transfer-out records from the main transaction source.
Refreshes a detailed recovery report by joining account charges with internal analysis and appeal status for ad-hoc financial tracking.
Builds a temporary report summarizing recovered amounts, appeal statuses, and payment details for patient accounts and charges.
Builds a temporary report comparing initial and current allowed amounts to track financial recovery from insurance appeals.
Standardizes and cleans raw account data by casting types and parsing facility, insurance, and transaction details into a structured format.
Builds the transaction transformation table by mapping insurance levels and ranking payments and refunds for updated accounts.
Loads charge-level details into the transformation table, calculating service units, amounts, and bill types for updated accounts.
Calculates and updates aggregated financial metrics, including payments, adjustments, and denials, for accounts identified in the delta tracking table.
Builds standardized remittance line items by processing service dates, procedure codes, and unique charge matching identifiers.
who computes it · 10
Pipelines that compute expected reimbursement
Grouped by product. Each links to its task tree.
| Customer | Pipeline | Product | Cadence |
|---|---|---|---|
| Commonwealth | Cutover-Daily-Accounts-Processing | RevFind | daily 02:30 |
| Commonwealth | Daily-Accounts-Processing | RevFind | daily 00:30 |
| ECP | Daily-Accounts-Processing-RevFind | RevFind | daily 01:00 |
| ISpine | RevFind-Daily-Processing | RevFind | daily 03:45 |
| OneGI | RevFind-Daily-Processing | RevFind | daily 23:00 |
| OneGI | RevFind-Daily-Processing-ModMed | RevFind | daily 03:00 |
| RIA | Daily-Processing-RevFind | RevFind | monthly 07:30 |
| SGP | RevFind-Daily-Processing | RevFind | daily 01:00 |
| TheOregonClinic | RevFind-EDI-Daily-Processing | RevFind | daily 03:45 |
| USDH | Daily-Processing | RevFind | daily 03:30 |
the rhythm
When it runs
daily & monthly fires · 10
03691215182124
daily 00:30
00:30
daily 01:00
01:00
daily 01:00
01:00
daily 02:30
02:30
daily 03:00
03:00
daily 03:30
03:30
daily 03:45
03:45
daily 03:45
03:45
monthly 07:30
07:30 · 1st
daily 23:00
23:00
HL7 FHIR file/batch eligibility◆ monthly · shaded = overnight (00–06)