# Provider → Facility affiliation (curated)

`vlada_curated.dim_provider_facility_affiliation` · Provider identity · status live

Curated clinician-NPI → facility-CCN affiliation edges (with facility_type and PAC ID). The curated provider↔facility bridge (the silver source is drug_silver.dim_facility_affiliation / cms_facility_affiliation).

**Grain.** One row per (clinician_npi, facility_ccn) affiliation edge.

| column | type | meaning |
|---|---|---|
| clinician_npi | string |  |
| facility_ccn | string |  |
| facility_type | string |  |
| ind_pac_id | string |  |
| source | varchar(35) |  |

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