# CPT/HCPCS → modal UB-04 Revenue Code mapping

`medicare_silver.cpt_revcode_modal` · Curated datasets · status live

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

**Grain.** One row per billing_code — its modal (most-common) UB-04 revenue code + support.

| column | type | meaning |
|---|---|---|
| billing_code | string |  |
| modal_rc | string |  |
| modal_n | bigint |  |
| total_rc_rows | bigint |  |
| modal_share | double |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.cpt_revcode_modal WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.cpt_revcode_modal")` first.