# CMS PECOS Public Provider Enrollment — IDTF (imaging) Roster

`medicare_silver.dim_imaging_facility` · Provider identity · status live

A slice of the CMS Medicare Fee-For-Service Public Provider Enrollment (PPEF) file, FILTERED to Independent Diagnostic Testing Facilities (IDTF; provider_type_cd in the 12-47 enrollment-type band). This is the imaging / diagnostic-testing leg of the care-site spine — it locates fixed-base and mobile imaging facilities that bill Medicare Part B. One PPEF extract fully restates the IDTF roster (supersession by extract, not row-level delta).

**Grain.** One row per approved Independent Diagnostic Testing Facility enrollment (by enrollment_id) per PPEF extract.

| column | type | meaning |
|---|---|---|
| enrollment_id | string |  |
| npi | string |  |
| pecos_asct_cntl_id | string |  |
| fac_name | string |  |
| city | string |  |
| state_cd | string |  |
| zip_cd | string |  |
| county_fips | string |  |
| is_active | boolean |  |
| provider_type_cd | string |  |
| provider_type_desc | string |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_id | string |  |
| is_current | boolean |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |
| vintage_tag | string |  |
| drug_source_version_id | string |  |

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