States M2 FFS rate book: vw_state_medicaid_rate_v2

What it is

1. 1Medicaid product M2 (FFS rate book) of the States lane: the state's Medicaid fee-for-service fee schedules, one row per published rate.
2. 2Filter state and is_current = true, then code (and modifiers, provider_type, setting) before reading rate; rate_type and rate_unit say what the number is (a fee, a percent of Medicare, a per-diem).
3. 3These are the state's FFS maximums, never managed care negotiated rates.
4. 446 state(s): AK AL AR AZ CA CO CT DC DE FL GA HI IA ID IL IN KY LA MD ME MN MO MS MT NC ND NE NH NJ NM NV NY OH OK OR PA RI SC SD TX UT VA WA WI WV WY.

Grain

Columns (29)

Query it

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