Medicare Advantage, Part D, Medicaid

CMS Medicare Coverage Database document relationships

medicare_silver.mcd_document_relationship·live·silver

Rows

2,965

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Public relationship records linking national coverage documents to version history, tracking sheets, transmittals, related documents, meetings, assessments, and other publicly exposed coverage artifacts.

Grain

Key	Grain
N/A	1One row per (Coverage API snapshot, parent document, public relationship endpoint, publisher row ordinal).

Columns (43)

Column	Type	Meaning
`snapshot_date`	date
`source_endpoint`	string
`record_type`	string
`record_ordinal`	bigint
`parent_document_type`	string
`parent_document_id`	string
`parent_document_version`	string
`document_type`	string
`document_id`	string
`document_version`	string
`document_display_id`	string
`title`	string
`status`	string
`note`	string
`contractor_name_type`	string
`publication_number`	string
`benefit_category`	string
`effective_date_raw`	string
`effective_end_date_raw`	string
`implementation_date_raw`	string
`retirement_date_raw`	string
`last_updated_raw`	string
`url`	string
`payload_json`	string
`source_member`	string
`source_member_sha256`	string
`quality_flags`	string
`is_analytics_eligible`	boolean
`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.mcd_document_relationship")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.mcd_document_relationship WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`parent_document_id`
Join	`how_to_join(source_fqn="medicare_silver.mcd_document_relationship")`
Raw door	Athena (read-only via query_substrate): medicare_silver.mcd_document_relationship

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