# Medicare provider CCN dimension (all provider types)

`vlada_curated.dim_provider_ccn` · Provider identity · status live · 101,528 rows

The resolving dimension for Medicare CCNs of every provider type, built because cms:ccn is a family rather than one identifier. A CCN identifies a Medicare-certified provider and the type is encoded in the number, so the hospital identity dimension resolved hospitals at 99.9% and SNF, home-health, hospice, FQHC, RHC, ASC and dialysis rosters at roughly 0%. Built as the union of the ten rosters we already hold, each authoritative for its own type, rather than from CMS positional range conventions.

**Grain.** One row per Medicare CCN across ALL provider types — the authority for cms:ccn.

| column | type | meaning |
|---|---|---|
| ccn | string |  |
| provider_type | varchar(26) |  |
| all_provider_types | string |  |
| provider_type_count | bigint |  |
| ccn_type_digits | string |  |

Tools that read it: resolve_provider

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