State programs

Medicaid managed care upcoming rate-cycle events, next 18 months

medicare_semantic.vw_medicaid_mco_upcoming_rate_events_v1·partial·semantic_view

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Published or projected next rate-cycle start dates for each state-program with a current source period, with event-date basis and provenance.
2Projection is the day after the latest period end, and is not a published certification.

Grain

Key	Grain
N/A	1Latest known program period successor event by state and program, next 18 months.

Columns (14)

Column	Type	Meaning
`state_code`	string
`program_name_raw`	string
`program_class`	string
`event_date`	date
`event_date_basis`	varchar(49)
`next_cycle_date_published`	boolean
`basis_period_start`	date
`basis_period_end`	date
`rate_period_convention`	string
`document_title`	string
`document_url`	string
`sha256_content_hash`	string
`evidence_locator`	string
`source_table_fqn`	varchar(49)

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`state_code,program_name_raw`
Join	`how_to_join(source_fqn="medicare_semantic.vw_medicaid_mco_upcoming_rate_events_v1")`
Raw door	Athena read-only at medicare_semantic.vw_medicaid_mco_upcoming_rate_events_v1.
Note	Current-date filtered view; rate-cell values are not included.

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