State programs

States M2 J-code book: rates computed by published rule, FL + MA (vw_state_medicaid_jcode_computed_v1)

vlada_curated.vw_state_medicaid_jcode_computed_v1·partial·semantic_view

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Florida (106% of ASP, rule 59G-4.251(8)) and Massachusetts (the quarterly Medicare Part B ASP fee, 101 CMR 317.04(1)(a)) print no J-code fee schedule; their rates are the rule applied to the CMS ASP payment limit. rate_type computed_by_rule, the rule document's sha256 on every row.
2Kept apart from the printed rate book (vw_state_medicaid_rate_v2 is printed values only).

Grain

Key	Grain
N/A	1One row per state x code x ASP quarter for states that print no J-code fees and pay a published rule on the CMS ASP file. 216,285 rows, 2 states (FL from 2022Q1, MA from 2026Q1; 3Athena 2026-11-05).

Columns (18)

Column	Type	Meaning
`state`	varchar(2)
`service_line`	varchar(28)
`program`	varchar(65)
`code`	string
`rate_unit`	string
`rate`	double
`rate_type`	varchar(16)
`method`	varchar(62)
`asp_quarter`	string
`effective_from`	date
`effective_to`	date
`is_current`	boolean
`asp_payment_limit`	double
`description`	string
`rule_effective_from`	date
`source_url`	varchar(105)
`source_sha256`	varchar(64)
`source_ref`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	N/A
Join	`how_to_join(source_fqn="vlada_curated.vw_state_medicaid_jcode_computed_v1")`
Raw door	Athena (read-only via query_substrate): vlada_curated.vw_state_medicaid_jcode_computed_v1 (filter state and is_current (or effective_from for a quarter); never mix with printed rates in one median)

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