Drugs and formularies

ASP Pricing File, Medicare Part B quarterly payment limits (parse revision 2, every CMS revision kept)

drug_silver.fact_drug_asp_quarterly_v2·live·silver

Rows

55,035

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Medicare Part B payment limits per HCPCS billing unit, every quarter Q1 2005 onward, parse revision 2 (ASP parser 2.0.0).
2Each CMS revision of a quarter is kept (cms_vintage_sequence); use WHERE is_current for the latest.
3The payment limit is 106% of ASP on a two-quarter lag, not the ASP.
42005-2009 limits are the publisher's '$' text parsed exactly; clotting_factor_flag marks clotting-factor codes (a flag, not dollars).
5Infusion AWP% / DME infusion limit exist 2005-2016 only;
6Independent ESRD limit 2005 only. asp_pricing_lookup, drug_price_composite and prove_drug_reimbursement_decision read this table from 2026-10-05.

Grain

Key	Grain
N/A	1One row per (hcpcs_code, release_quarter, cms_vintage_sequence); among is_current rows (hcpcs_code, effective_period_start) is unique: 55,035 rows = 55,035 keys over 88 quarterly editions, Q1 2005 to Q4 2026 (Athena e3c215d1, f0abf87e).

Columns (31)

Column	Type	Meaning
`hcpcs_code`	string
`short_description`	string
`hcpcs_dosage`	string
`payment_limit_usd`	double
`coinsurance_percentage`	double
`vaccine_awp_percentage`	double
`vaccine_limit_usd`	double
`blood_awp_percentage`	double
`blood_limit_usd`	double
`notes`	string
`release_quarter`	string
`independent_esrd_limit_usd`	double
`infusion_awp_percentage`	double
`dme_infusion_limit_usd`	double
`clotting_factor_flag`	boolean
`source_member_name`	string
`observed_period`	date
`asserted_at`	date
`effective_period_start`	date
`effective_period_end`	date
`cms_vintage_sequence`	int
`parse_revision`	int
`parser_artifact_hash`	string
`source_url`	string
`sha256_content_hash`	string
`source_id`	string
`is_current`	boolean
`bronze_object_key`	string
`s3_version_id`	string
`vintage_tag`	string
`drug_source_version_id`	string

Query it

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

Item	Value
Typed tools that read it	asp_pricing_lookup
Identity key	`hcpcs_code,effective_period_start`
Join	`how_to_join(source_fqn="drug_silver.fact_drug_asp_quarterly_v2")`
Raw door	Tools: asp_pricing_lookup, drug_price_composite; Athena: drug_silver.fact_drug_asp_quarterly_v2 (filter is_current = true)
Note	Parse revision 2 of the same CMS files (Data Tracker drug wave 1B, PR 3114, defects ASP-1..ASP-5). Versioned, never overwritten; the v1 card stays live as the rollback.

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