# States M2 J-code book: Medicaid J-code rates vs Medicare ASP (vw_state_medicaid_jcode_vs_asp_v1)

`vlada_curated.vw_state_medicaid_jcode_vs_asp_v1` · State programs · status partial

Medicaid physician-administered drug rates (HCPCS J-codes) as each state prints them, beside Medicare's ASP payment limit (ASP + 6%) for the same code and billing unit (hcpcs_dosage). implied_asp_plus = rate / (limit / 1.06) - 1, so 0.06 means the state pays ASP + 6%. Two readings: _at_eff (the ASP quarter the rate took effect, how the state priced it) and _current (today's ASP quarter). A printed $0 / NDC-required / by-report line is never here.

**Grain.** One row per in-force priced HCPCS J-code rate (state x schedule x code x modifiers x program x provider type x setting), beside the Medicare ASP payment limit for the same code in the current quarter and in the quarter the rate took effect. 79,302 rows, 44 states (Athena, 2026-11-05).

| column | type | meaning |
|---|---|---|
| state | string |  |
| schedule_id | string |  |
| service_line | string |  |
| code | string |  |
| modifiers | string |  |
| program | string |  |
| provider_type | string |  |
| setting | string |  |
| geography | string |  |
| population | string |  |
| rate_type | string |  |
| rate_unit | string |  |
| rate | double |  |
| eff | date |  |
| edition_effective_date | date |  |
| description | string |  |
| source_sha256 | string |  |
| source_ref | string |  |
| asp_quarter_current | string |  |
| asp_limit_current | double |  |
| hcpcs_dosage | string |  |
| ratio_to_medicare_current | double |  |
| implied_asp_plus_current | double |  |
| asp_quarter_at_eff | string |  |
| asp_limit_at_eff | double |  |
| ratio_to_medicare_at_eff | double |  |
| implied_asp_plus_at_eff | double |  |
| unit_mismatch_suspect | boolean |  |

Query it: `query_substrate` with `SELECT ... FROM vlada_curated.vw_state_medicaid_jcode_vs_asp_v1 WHERE ... LIMIT 100`; read `describe_data_source("vlada_curated.vw_state_medicaid_jcode_vs_asp_v1")` first.