State programs

California Medi-Cal county-plan program-delivery roster

medicare_silver.ca_medi_cal_mcp_county_plan_roster·live·silver

Rows

218

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Production-reconciled and exact-replay-idempotent structured transcription of the final DHCS 2023-to-2024 county-plan/model matrix.
2It retains raw display and legal names, source-native model and plan ordering, plan class, prime/subcontracted status, eligibility qualifier, notes and footnotes, exact citation, and separate operative/current/analytics flags.
3It includes the source-native Medi-Cal Fee For Service delivery row and does not coerce it into a managed-care plan.

Grain

Key	Grain
N/A	1One source roster occurrence, roster year, county name, and source-native plan ordinal.

Columns (39)

Column	Type	Meaning
`corpus_snapshot_date`	date
`occurrence_id`	string
`document_sha256`	string
`roster_year`	int
`roster_status`	string
`source_as_of_date`	date
`effective_start_date`	date
`county_name`	string
`program_model`	string
`program_model_raw`	string
`plan_ordinal`	int
`raw_plan_display_name`	string
`raw_plan_legal_name`	string
`raw_plan_note`	string
`footnote_marker`	string
`displayed_plan_class`	string
`prime_or_subcontracted_status`	string
`eligibility_qualifier`	string
`source_page_number`	int
`source_citation`	string
`is_operative`	boolean
`is_current_claimed`	boolean
`is_analytics_eligible`	boolean
`semantic_row_sha256`	string
`observed_period`	date
`asserted_at`	date
`effective_period_start`	date
`effective_period_end`	date
`cms_vintage_sequence`	int
`parse_revision`	int
`parser_artifact_hash`	string
`source_url`	string
`sha256_content_hash`	string
`source_id`	string
`is_current`	boolean
`bronze_object_key`	string
`s3_version_id`	string
`vintage_tag`	string
`drug_source_version_id`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`occurrence_id,roster_year,county_name,plan_ordinal`
Join	`how_to_join(source_fqn="medicare_silver.ca_medi_cal_mcp_county_plan_roster")`
Raw door	Athena (read-only via query_substrate): medicare_silver.ca_medi_cal_mcp_county_plan_roster
Note	Production schema preserves roster year/status and dates; county and raw/normalized program model; source-native ordinal; raw display/legal names, notes and footnotes; plan class, prime/subcontracted status and qualifier; physical citation; separate operative/current/analytics flags; semantic hash and M-2 lineage. Query promotion and source certification are proven; hosted MCP data proof remains gated.

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