Drugs and formularies

IRA Maximum Fair Price (CMS-negotiated)

drug_silver.fact_drug_reimbursement#ira_mfp·live·silver

Rows

N/A

Columns

N/A

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS Inflation-Reduction-Act negotiated maximum fair prices.
2Current official selected-drug publication has valid priced periods effective in 2026 and 2027; selected-only 2028 rows are not price facts until CMS publishes MFP amounts.

Grain

Key	Grain
N/A	1One row per valid (NDC11, IPAY program_year, MFP effective_period_start, MFP effective_period_end) negotiated MFP price period.

Columns (0)

Columns are not in the catalog for this source; describe_data_source("drug_silver.fact_drug_reimbursement#ira_mfp") reads them live.

Query it

describe_data_source(source_fqn="drug_silver.fact_drug_reimbursement#ira_mfp")     # the card, live
query_substrate(sql="SELECT * FROM drug_silver.fact_drug_reimbursement#ira_mfp WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	ira_drug_label_risk_screen, ira_mfp_exposure
Identity key	`ndc11`
Join	`how_to_join(source_fqn="drug_silver.fact_drug_reimbursement#ira_mfp")`
Raw door	Tool: ira_mfp_exposure; Athena: drug_silver.fact_drug_reimbursement (filter price_type='ira_mfp' and is_current=true)
Note	Implemented end-to-end (pipelines/drug/silver/ira_mfp_*); parser serves only valid MFP price intervals and profiles raw CMS update rows separately.

This page as markdown: /docs-md/data/drug_silver_fact_drug_reimbursement_ira_mfp.md · every page in one file: /llms-full.txt