Medicare Advantage, Part D, Medicaid

ResDAC / CMS claim-reference governed source-asset ledger

medicare_silver.resdac_claim_reference_source_asset·live·silver

Rows

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Content and rights ledger for four public CMS claim CodeSystems, all 25 recovered CMS Medicare Provider and Supplier Taxonomy Crosswalk revisions, 11 exact NUBC/AMA/ADA source limits, and three pointers to independently mastered Vlada sources.

Grain

Key	Grain
N/A	1One row per governed corpus snapshot and acquired, source-limited, or existing-overlap asset.

Columns (35)

Column	Type	Meaning
`corpus_snapshot_date`	date
`asset_id`	string
`family`	string
`release_date`	date
`schema_era`	string
`asset_status`	string
`license_class`	string
`maintained_by`	string
`asset_url`	string
`final_url`	string
`file_name`	string
`byte_count`	bigint
`asset_sha256`	string
`bundle_member`	string
`payload_acquired`	boolean
`existing_vlada_overlap_source_id`	string
`source_limit`	string
`is_current_release`	boolean
`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.resdac_claim_reference_source_asset")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.resdac_claim_reference_source_asset WHERE <filter> LIMIT 100")

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

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