Version: Canary - 2.4 🚧

Versions

Version Name	Internal Release Date	API Release Date	Latest Payer MRF Month	Production Schema	Release Notes
2.4.2	03/25/2026	04/01/2026	2026_01	tq_production.clear_rates_2026_01
2.4.1	02/19/2026	02/25/2026	2025_12	tq_production.clear_rates_2025_12	Slack Release Notes
2.4.0	02/05/2026	02/11/2026	2025_11	tq_production.clear_rates_greg_2025_11	Slack Release Notes
2.3.2	01/22/2026	01/28/2026	2025_11	tq_production.clear_rates_calcifer_2025_11	Slack Release Notes
2.3.1	01/08/2026	01/14/2026	2025_11	tq_production.clear_rates_2025_11	Slack Release Notes
2.3.0	12/4/2025	12/10/2025	2025_10	tq_production.clear_rates_2025_10	Slack Release Notes
2.2.2	11/14/2025	11/19/2025	2025_09		Slack Release Notes
2.2.1	10/30/2025	11/5/2025	2025_08		Slack Release Notes
2.2.0	10/15/2025	10/21/2025	2025_08		Slack Release Notes

v2.4.1 Release Notes

Updates:

Professional Rates now have Modifiers 26 and TC. These new ROIDs will not be loaded to the API yet, but they will be included in the underlying data release
Adds hospital subtype: Long Term Acute Care Hospitals
Adds networks: Cigna National PPO, Aetna National PPO, UHC Select EPO
For Exchange, start pulling payer data as well (we'd only been using hospital data for Exchange)
Added Nomi rates for Consumer
Cleans up canonical_gross_charge so that canonical_gross_charge is only populated if greater than canonical_rate
Include service code 23 for professional fees
Use provider_parent_system as the health_system_name for labs
SelectHealth network naming and product_network_label selection updates

Provisions
- Introduced limited-scope, data-only provision-based features to support UX ideation and early data feedback
- New Provisions Table including:
  - Implant carveouts
  - Drug carveouts
  - Stoploss
  - Inpatient base rate / percentage / per diem
  - Outpatient surgical groupers
  - Draft table: tq_dev.internal_dev_mmalhotra.provisions_final
- Implant carveouts:
  - Uses inferred provisions and DevPR to generate bundled rates for device-dependent procedures
  - Logic currently applies to a limited set of providers
  - New fields added to prod_combined_abridged
Taxonomy updates
- Added taxonomy_classification
- Added taxonomy_specialization
- Fields added to the API table
Provider updates
- provider_subtype now includes all physician group specialties
- Physical Therapy Physician Groups added

RC to HCPCS imputations
Best payer and best hospital rate columns to kick off API work on filtering templates to payer- or hospital-data only
Add remaining OPPS codes that were previously excluded. We should now have all OPPS codes
Bug fix Exchange plans that were previously including many "Commercial" payer_class_name rates from hospital MRF

Provider Types:
- Infusion Center Spines [DATA-243]
- Lab Spines (select labs w/ national coverage) [DATA-242] | [DATA-235]
Add CAR-T DRGs + Plausibility [DATA-232]
Accuracy Methdology Updates see accuracy-scores page for details
- PG-specific accuracy methodology [DATA-238]
- ASP/Medicare-based accuracy methodology for drugs
- Anesthesia-specific outlier bounds
Outpatient Outlier Lower Bound increased to 50% of Medicare [DATA-237]
OPG imputation identification uses stricter parameters [DATA-240]
Exchange plans

Labs
- Guardant rates are now available for all payers
- Implemented lab-specific accuracy scoring methodology
More Hospital MRF Rates:
- Include rates for Providers Posting HCPCS as Inpatient. This adds 260 more providers with OP hospital rates.
- Include rates for Providers ALWAYS Posting DRGs w/ Rev Codes. Previously, we only included rates with NULL Rev Codes. Affects just a handful of providers, but important ones!
New Payers:
- Added SummaCare
Misc:
- Always populate medicare_rate in prod tables
- Remove "capitation" negotiation_arranagment from payer MRF data pulls (only happens 0.02% of the time, but on average these rates are 7x higher than ffs rates)
- Validated Rates tiebreaker fix: in v2.3.0 we started selecting the highest rate. This introduced problems where a hospital PoC and payer PoC validated each other, because then the highest GC would be used (even if it were a state-average when a hospital-reported GC is available). Now, in this case, we rely on the hierarchy of GC sources to break ties.

Tables are in tq_production!
Accuracy :
- Validated rates: select the higher rate as the canonical rate
- Anesthesia rates: always prioritize normalized over raw (@Stefano DiSano)
Life Sciences:
- Add NDC to Drug Code Crosswalk for Hospital rates with an NDC but NULL billing code (ty @Monika Malhotra for PRs!)
Employer:
- A Network Check version of CLD enhanced w/ extra imputation tiers
Medicare:
- Update to Fixed Medicare Reference Data Tables (we had been using static ones)
- Lab Medicare Fee Schedule for Physician Groups (@Sam Jones)
Plan Mappings:
- Fix Premera Blue Cross mapping so we have AK rates for Alaska Heritage Network (@Hunter Brown | thread)
- Fix Wellmark Bluecard to use PPO plan and rename from IA HMO to IA PPO (@Sam Jones | thread)
- Implement Plan Bridge Hierarchies for MO Blue (@Stefano DiSano)
- IBC Hospital Data added for Main Line Health (@Stefano DiSano)
Misc:
- Round all rate features to 2 decimals

Highlights:
- Analyze: features for next week's lab template demos
- Adds is_lab_code indicator
- Adds medicare reference pricing for the new lab codes
Spines:
- We built Physician Group Spines and Clear Rates is now using it (s/o @Nick Pattison for the design and architecture, it's quite a technical marvel he cooked up!). This will help to boost coverage and improve rates for Employer Network Check reports and add more PGs for Analyze.
Market Solutions:
- Two New Drug Dosage Standardization Methods (s/o @Monika Malhotra for the research and PRs to add these net new transformations to the Clear Rates codebase!)
- Uses new unit/quantity fields in Hospital MRF data to dosage standardize
- Uses NDC field from Hospital MRF data + strength/strength_unit from Medispan to dosage standardize