State programs

California Medi-Cal managed-care contract source occurrences

medicare_silver.ca_medi_cal_managed_care_contract_source_occurrence·live·silver

Rows

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Production-reconciled and exact-replay-idempotent occurrence ledger for California physical-health Medi-Cal managed-care boilerplates, publisher-labeled amendment/full-restatement packages, Exhibit L variants, and explicitly nonoperative drafts.
2It preserves artifact class, source-native dates, exact payload identity, acquisition/source-limit state, content aliases, operativity and fact-eligibility flags, semantic hashes, and M-2 lineage without manufacturing executed contract, amendment, CMS-review, or rate facts.

Grain

Key	Grain
N/A	1One frozen corpus snapshot and official DHCS contract-publication occurrence, including acquired payloads and exact retrieval limits.

Columns (59)

Column	Type	Meaning
`corpus_snapshot_date`	date
`occurrence_id`	string
`artifact_class`	string
`managed_care_models_json`	string
`publisher_document_label`	string
`publisher_version_label`	string
`exhibit_l_variant`	string
`variant_semantics`	string
`publication_date`	date
`publisher_effective_period_raw`	string
`publisher_applicability_raw`	string
`pdf_created_at_raw`	string
`pdf_modified_at_raw`	string
`archive_capture_at`	string
`contract_effective_start`	date
`official_url`	string
`candidate_static_url`	string
`acquisition_url`	string
`byte_count`	bigint
`document_sha256`	string
`expected_page_count`	int
`parse_disposition`	string
`failed_probe_ids_json`	string
`source_limit_evidence_json`	string
`distinct_from_acquired_303_page_payload`	boolean
`content_occurrence_count`	int
`content_occurrence_ordinal`	int
`is_content_alias`	boolean
`is_payload_acquired`	boolean
`is_source_limited`	boolean
`is_explicitly_nonoperative`	boolean
`operative_status`	string
`is_exhibit_l_variant`	boolean
`is_temporal_version`	boolean
`blank_rate_semantics`	string
`is_corpus_search_eligible`	boolean
`is_contract_fact_eligible`	boolean
`is_executed_contract_evidence`	boolean
`is_plan_specific_amendment_evidence`	boolean
`is_rate_fact_eligible`	boolean
`quality_flags`	string
`manifest_sha256`	string
`raw_occurrence_json`	string
`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_managed_care_contract_source_occurrence")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.ca_medi_cal_managed_care_contract_source_occurrence WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`corpus_snapshot_date,occurrence_id`
Join	`how_to_join(source_fqn="medicare_silver.ca_medi_cal_managed_care_contract_source_occurrence")`
Raw door	Athena (read-only via query_substrate): medicare_silver.ca_medi_cal_managed_care_contract_source_occurrence
Note	Production schema preserves artifact class, managed-care models, raw publisher labels and dates, acquisition/source-limit evidence, content aliases, explicit operativity, Exhibit L non-temporal semantics, fact-eligibility sentinels, raw JSON, semantic hash, and M-2 lineage. Query promotion and certification are proven; hosted MCP data proof, customer-live status, terminal completion, and family completion remain gated.

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