State programs

California legacy SMHS 1915(b) authority-period history

medicare_silver.ca_smhs_1915b_legacy_history_period·live·silver

Rows

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Production-reconciled and exact-replay-idempotent lossless chronology layer for the CA-17 initial authority through CA17.R09 temporary extensions.
2It preserves source-stated period text, independently parsed start/end dates, evidence basis, original-package recovery status, warnings, exact raw manifest JSON, semantic hashes, and M-2 lineage without manufacturing continuity or turning reconstructed dates into original authority documents.

Grain

Key	Grain
N/A	1One frozen corpus snapshot and source-stated legacy SMHS authority period.

Columns (29)

Column	Type	Meaning
`corpus_snapshot_date`	date
`authority_id`	string
`period_text`	string
`period_start`	date
`period_end`	date
`date_basis`	string
`original_package_status`	string
`partial_original_evidence`	string
`warning`	string
`is_reconstructed_date_basis`	boolean
`is_original_date_basis`	boolean
`manifest_sha256`	string
`raw_history_period_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_smhs_1915b_legacy_history_period")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.ca_smhs_1915b_legacy_history_period WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`corpus_snapshot_date,authority_id`
Join	`how_to_join(source_fqn="medicare_silver.ca_smhs_1915b_legacy_history_period")`
Raw door	Athena (read-only via query_substrate): medicare_silver.ca_smhs_1915b_legacy_history_period
Note	Production schema columns are corpus_snapshot_date, authority_id, period_text, period_start/end, date_basis, original_package_status, partial_original_evidence, warning, reconstruction/original-basis flags, manifest_sha256, raw_history_period_json, semantic_row_sha256, plus the M-2 lineage envelope. Production reconciliation, unchanged-snapshot replay, query promotion, and source certification are proven; hosted MCP data proof remains gated.

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