State programs

States M7 Forward exposure: vw_la_medicaid_mco_rate_procurement_exposure_v1

medicare_semantic.vw_la_medicaid_mco_rate_procurement_exposure_v1·partial·semantic_view

Rows

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Medicaid product M7 (Forward exposure) of the States lane: forward exposure: members whose plan faces a rate reset or a procurement event, by plan and parent.
2One view per state (vw_<st>_medicaid_mco_rate_procurement_exposure_v1).
3One row per plan for the observation period; enrollment_with_rate_reset_next_6_months is members, not plans.
4MN, MO, MS and OK views are an older schema without observation_period.
51 state(s): LA.

Grain

Key	Grain
N/A	1Forward exposure: members whose plan faces a rate reset or a procurement event, by plan and parent. 25 rows (Athena, 2026-10-29). 3Period 2026-07-01 to 2026-07-01 (observation_period).

Columns (58)

Column	Type	Meaning
`state_code`	varchar(2)
`observation_period`	date
`enrollment_month`	date
`plan_name_raw`	string
`plan_identity_id`	string
`enrollment`	double
`prior_enrollment_month`	date
`prior_enrollment`	double
`month_over_month_change`	double
`month_over_month_change_pct`	double
`legal_entity_name`	string
`ultimate_parent_name`	string
`canonical_parent_id`	string
`ticker`	string
`public_parent_rollup_authorized`	boolean
`latest_bounded_rate_period_start`	date
`latest_bounded_rate_period_end`	date
`rate_period_status`	varchar(68)
`exact_active_rate_period_publishable`	boolean
`numeric_plan_pmpm_publishable`	boolean
`numeric_plan_pmpm`	decimal(12,2)
`rate_source_url`	varchar(155)
`rate_source_sha256`	varchar(64)
`contract_extension_end`	date
`contract_schedule_id`	varchar(63)
`contract_legal_stage`	varchar(31)
`contract_source_locator`	varchar(66)
`runway_party_rows`	bigint
`runway_verified_party_term_rows`	bigint
`days_until_contract_extension_end`	bigint
`contract_expiration_horizon`	varchar(22)
`enrollment_with_active_rate_period`	double
`enrollment_with_future_rate_effective_event`	double
`enrollment_with_contract_expiration_next_6_months`	double
`enrollment_with_contract_expiration_next_12_months`	double
`enrollment_with_contract_expiration_next_18_months`	double
`successor_procurement_publishable`	boolean
`post_2026_contract_term_publishable`	boolean
`sfy2027_rate_event_publishable`	boolean
`contract_source_url`	varchar(121)
`contract_source_sha256`	varchar(64)
`rate_reset_event_date`	date
`rate_reset_event_date_basis`	varchar(49)
`rate_reset_date_published`	boolean
`rate_period_convention`	string
`rate_reset_source_url`	string
`rate_reset_source_sha256`	string
`rate_reset_source_locator`	string
`rate_reset_schedule_status`	varchar(27)
`observed_state_plan_enrollment_denominator`	double
`exact_program_extension_enrollment`	double
`program_extension_coverage_pct`	double
`headline_publishable`	boolean
`headline_hold_reason`	varchar(90)
`enrollment_source_url`	string
`enrollment_source_sha256`	string
`enrollment_source_locator`	string
`enrollment_semantic_row_sha256`	string

Query it

describe_data_source(source_fqn="medicare_semantic.vw_la_medicaid_mco_rate_procurement_exposure_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_la_medicaid_mco_rate_procurement_exposure_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="medicare_semantic.vw_la_medicaid_mco_rate_procurement_exposure_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_la_medicaid_mco_rate_procurement_exposure_v1 (filter state_code)
Company names	`ultimate_parent_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings

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