State programs

Medicaid managed care rate timing by certified cycle and amendment

medicare_semantic.vw_medicaid_mco_rate_timing_v1·partial·semantic_view

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Source-linked rate periods, certification dates, actuary and publisher-reported program change percentages with explicit nulls for unrecovered CMS submission, approval and amendment details.
2Successor dates distinguish published periods from period-end projections.

Grain

Key	Grain
N/A	1One capitation v2 state, program, rating period and amendment key.

Columns (24)

Column	Type	Meaning
`state_code`	string
`program_name_raw`	string
`program_class`	string
`rating_period_start`	date
`rating_period_end`	date
`rate_period_convention`	string
`amendment_seq`	int
`certification_date`	date
`cms_submission_date`	date
`cms_approval_date`	date
`amendment_effective_date`	date
`amendment_reason`	string
`amendment_retroactive`	boolean
`actuary_firm`	string
`rate_change_pct_reported`	double
`rate_change_basis_raw`	string
`expected_next_cycle_date`	date
`expected_next_cycle_basis`	varchar(49)
`next_cycle_date_published`	boolean
`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_rate_timing_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_medicaid_mco_rate_timing_v1 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`state_code,program_name_raw,rating_period_start,rating_period_end,amendment_seq`
Join	`how_to_join(source_fqn="medicare_semantic.vw_medicaid_mco_rate_timing_v1")`
Raw door	Athena read-only at medicare_semantic.vw_medicaid_mco_rate_timing_v1.
Note	The shared capitation v2 cycle key also joins to rate_cell_v2; no rate cells are duplicated here.

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