# CMS NCCI Procedure-to-Procedure (PTP) edits — quarterly editions, practitioner and hospital, stamped

`medicare_silver.ref_ncci_ptp_edit` · Medicare Advantage, Part D, Medicaid · status live · 4,506,527 rows

CMS NCCI PTP edits re-collected through the provenance envelope on 2026-09-07: both settings, every pair as published with effective and deletion dates, modifier indicator and rationale. Filter deletion_date IS NULL for the active edit set (the legacy ncci_ptp was that active practitioner set for one quarter). CPT descriptors are not stored (AMA license accepted openly; the license page is kept in bronze).

**Grain.** One row per (edition, setting, pair as published) including pairs carrying a deletion_date; natural key (edition, row_seq); 4,506,527 rows for 2026Q4 (practitioner 2,637,645 / hospital 1,868,882).

| column | type | meaning |
|---|---|---|
| edition | string |  |
| row_seq | bigint |  |
| setting | string |  |
| version | string |  |
| part | int |  |
| column_1_code | string |  |
| column_2_code | string |  |
| prior_to_1996 | boolean |  |
| effective_date | string |  |
| deletion_date | string |  |
| modifier_indicator | string |  |
| ptp_edit_rationale | string |  |
| source_member | 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.ref_ncci_ptp_edit WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.ref_ncci_ptp_edit")` first.