# HCPCS code dimension

`vlada_curated.dim_hcpcs` · Curated datasets · status live · 24,855 rows

The resolving dimension for HCPCS, built because 19 catalogued assets carried the identifier and the only candidate authority was dim_provider_service, a provider-by-service fact holding roughly 1,988 rows per code. Population is the union of codes across the PFS RVU, OPPS Addendum B, ASC Addendum, CLFS and ASP fee schedules plus the provider-service fact. Descriptions are taken in source precedence, a CMS fee-schedule descriptor before a claims-aggregate label, and description_source records which supplied it.

**Grain.** One row per HCPCS code — the authority for cms:hcpcs.

| column | type | meaning |
|---|---|---|
| hcpcs_code | string |  |
| hcpcs_level | varchar(16) |  |
| hcpcs_prefix | string |  |
| description | string |  |
| description_source | varchar(36) |  |

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