Curated datasets

Code Vintage Validity (which years a billing code is valid)

medicare_silver.dim_code_validity·live·dim·Billing Code Intelligence

Rows

20,523

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1For each billing code (HCPCS/CPT/DRG/etc.) the years it is valid: first_year, last_year, and the count of years observed.
2The reference that lets repricing resolve a claim's code against the RIGHT vintage and flag retired/not-yet-introduced codes instead of guessing — the code-vintage gap, now grounded in data (20,523 codes).

Grain

Key	Grain
N/A	1One row per (code, code_system) — first_year, last_year, year_count of validity.

Columns (5)

Column	Type	Meaning
`code`	string
`code_system`	varchar(6)
`first_year`	bigint
`last_year`	bigint
`year_count`	bigint

Query it

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

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

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