State programs

National Medicaid MCO enrollment ledger - every state's reported plan enrollment observations, one view

medicare_semantic.vw_medicaid_mco_enrollment_tracker_reported_observation_v7·partial·semantic_view

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Candidate successor to the v6 source-native Medicaid MCO enrollment ledger.
2The proposed v7 definition preserves the existing source branches and reclassifies New York publisher_state_total as publisher_control; it is not an accepted enrollment total or national sum.

Grain

Key	Grain
N/A	1One source-native reported observation keyed by source_table_fqn and source_observation_key; v7 acceptance is pending.

Columns (32)

Column	Type	Meaning
`state_code`	string
`observation_period`	timestamp
`cadence`	string
`source_table_fqn`	varchar(86)
`source_id`	string
`source_observation_key`	string
`source_time_basis`	string
`source_observation_grain`	string
`source_measure_name_raw`	string
`program_name_raw`	string
`program_class`	string
`geography_type`	string
`geography_name_raw`	string
`geography_fips`	string
`plan_name_raw`	string
`source_plan_identity_id`	string
`canonical_plan_id`	string
`canonical_parent_id`	string
`source_dimension_1_raw`	string
`source_dimension_2_raw`	string
`reported_value`	double
`value_unit`	string
`value_status`	string
`source_row_role`	string
`row_role`	varchar(19)
`aggregation_status`	varchar(33)
`national_aggregation_authorized`	boolean
`source_url`	string
`sha256_content_hash`	string
`semantic_row_sha256`	string
`bronze_object_key`	string
`s3_version_id`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`source_table_fqn,source_observation_key`
Join	`how_to_join(source_fqn="medicare_semantic.vw_medicaid_mco_enrollment_tracker_reported_observation_v7")`
Raw door	Pending governed v7 acceptance: medicare_semantic.vw_medicaid_mco_enrollment_tracker_reported_observation_v7

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