State programs

State duals knowledge base v5: payer chain

medicare_silver.state_duals_kb_payer_chain_v5·live·silver

Rows

2,171

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Cited, curated state-by-state knowledge of what Medicaid gives each dual category and who pays (current version v5: v1 seeds + CA/FL/TX/PA/NJ depth + wave-3 and wave-4 demand-driven depth, under neutral source and rule ids).
2Every row carries source_id, a verbatim quote + locator on exact rows, confidence (exact / rule / judged), effective dates and spine_ref.
3Seeds pipelines/medicare/data/state_duals_kb/v1..v4 through v5/neutralise_v5.yaml; row contract pipelines/medicare/dsnp_wrap/kb.py.

Grain

Key	Grain
N/A	1Key state_code, integration_type, state_arrangement, dual_category, benefit, payer_order, effective_from. 2Spine: 9 coverage x 3 population x D-SNP integration (CMS 42 CFR 422.2).

Columns (19)

Column	Type	Meaning
`chain_id`	string
`state_code`	string
`integration_type`	string
`state_arrangement`	string
`dual_category`	string
`benefit`	string
`payer_order`	int
`payer`	string
`coverage_note`	string
`rule_ids`	string
`effective_from`	string
`effective_to`	string
`confidence`	string
`spine_ref`	string
`external_rule_ids`	string
`external_confidence`	string
`parse_revision`	int
`seed_file`	string
`seed_sha256`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`state_code,integration_type,state_arrangement,dual_category,benefit,payer_order,effective_from`
Join	`how_to_join(source_fqn="medicare_silver.state_duals_kb_payer_chain_v5")`
Raw door	Athena (read-only via query_substrate): medicare_silver.state_duals_kb_payer_chain_v5
Note	Registered 2026-10-12 under register source state_duals_kb (W8) as the successor of the v4 object (same facts under neutral ids). Serving takes effect with the next MCP bridge release.

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