Curated datasets
HCPCS code dimension
vlada_curated.dim_hcpcs·live·dimRows
24,855
Columns
5
History
N/A
Card
nocolumns only
Typed tools
0
What it is
- 1The 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.
- 2Population is the union of codes across the PFS RVU, OPPS Addendum B, ASC Addendum, CLFS and ASP fee schedules plus the provider-service fact.
- 3Descriptions are taken in source precedence, a CMS fee-schedule descriptor before a claims-aggregate label, and description_source records which supplied it.
Grain
| Key | Grain |
|---|---|
| N/A |
|
Columns (5)
| Column | Type | Meaning |
|---|---|---|
hcpcs_code | string | |
hcpcs_level | varchar(16) | |
hcpcs_prefix | string | |
description | string | |
description_source | varchar(36) |
Query it
describe_data_source(source_fqn="vlada_curated.dim_hcpcs") # the card, live query_substrate(sql="SELECT * FROM vlada_curated.dim_hcpcs WHERE <filter> LIMIT 100")
| Item | Value |
|---|---|
| Typed tools that read it | none; raw SQL |
| Identity key | hcpcs_code |
| Join | how_to_join(source_fqn="vlada_curated.dim_hcpcs") |
| Raw door | Athena (read-only): vlada_curated.dim_hcpcs |
| Note | Measured 2026-08-15 at 100.0% coverage over five HCPCS-carrying assets, uniqueness 1.0. Built by ops/scripts/build_dim_hcpcs.py; every source read is pinned to is_current where the column exists. |
This page as markdown: /docs-md/data/vlada_curated_dim_hcpcs.md · every page in one file: /llms-full.txt