Curated datasets

CPT/HCPCS → modal UB-04 Revenue Code mapping

medicare_silver.cpt_revcode_modal·live·dim·Billing Code Intelligence

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Empirical CPT/HCPCS → UB-04 revenue-code mapping: for each billing code, the MODAL revenue code observed, the modal count, total rows, and modal share.
2Lets facility lines be related to a revenue code (and vice versa) — part of the fix for revenue-only facility lines being unpriceable.

Grain

Key	Grain
N/A	1One row per billing_code — its modal (most-common) UB-04 revenue code + support.

Columns (5)

Column	Type	Meaning
`billing_code`	string
`modal_rc`	string
`modal_n`	bigint
`total_rc_rows`	bigint
`modal_share`	double

Query it

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

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

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