ICD-10-PCS Inpatient Procedure Code Dimension

What it is

1. 1The official CMS FY2026 ICD-10-PCS procedure-code reference dimension: every valid ICD-10-PCS inpatient procedure code with its long description, ingested from the CMS "2026-icd-10-pcs-codes-file.zip".
2. 2It is a lookup/decode table used to attach human-readable procedure names to PCS codes and to validate codes that appear in inpatient cost/claims data (e.g.
3. 3MS-DRG mapping, hospital procedure references).

Grain

How to read it

1. 1Use it to decode or validate ICD-10-PCS inpatient procedure codes.
2. 2Example: SELECT code, description FROM drug_silver.dim_icd10pcs WHERE is_current = true AND code = '0016070' returns 'Bypass Cerebral Ventricle to Nasopharynx with Autologous Tissue Substitute, Open Approach'.
3. 3ALWAYS include WHERE is_current = true (otherwise every code returns 2 rows).
4. 4To filter to a PCS section, use substr(code,1,1) (e.g. ='0' for Medical & Surgical, ='B' for Imaging, ='X' for New Technology).

Traps

1. 1DOUBLE-COUNT TRAP: the table is 158,230 rows but only 79,115 distinct codes. Every code appears exactly twice — the SAME FY2026 file (identical sha256_content_hash) was ingested on 2026-05-16 (is_current=false) and 2026-05-18 (is_current=true). ALWAYS filter WHERE is_current = true; then 'code' alone is a unique key.
2. 2FAKE TIME DIMENSION: the profiler reports earliest 2026-05-16 -> latest 2026-05-18, 2 periods, 'daily' periodicity. That is NOT code history — it is just the two re-ingestion dates of one file. effective_period_start/observed_period/asserted_at all carry the ingestion date, not the CMS fiscal-year effective date (~2025-10-01). Treat this table as STATIC FY2026, single vintage (cms_vintage_sequence=1, source_url has one FY2026 file).
3. 3MEANINGFUL NULL: s3_version_id is NULL for the entire older (is_current=false) copy and populated for the current copy. A null s3_version_id reliably flags the superseded run; it is not random missing data.
4. 4WRONG CODE SYSTEM TRAP: this is ICD-10-PCS = inpatient PROCEDURE codes (7-char alphanumeric, used for hospital inpatient procedures and MS-DRG assignment). The sibling dim_icd10cm (98,186 codes) is ICD-10-CM = DIAGNOSIS codes. Do not join PCS codes to diagnosis fields or vice-versa. Also note dim_msdrg is the related DRG grouping table.
5. 5PURE DECODE TABLE, NO COST: this dimension contains NO prices, rates, or payment amounts — only code + description. Its role in a cost catalog is to translate/validate ICD-10-PCS codes that appear in inpatient claims/MS-DRG cost data; pricing lives in fact_* tables (e.g. drug spending, reimbursement) and in the Medicare/commercial rate marts elsewhere.
6. 6PROVENANCE COLUMNS DON'T VARY BY CODE: parser_artifact_hash (2 values) and vintage_tag (2 values) differ only by ingestion run, and every other provenance column (source_url, sha256_content_hash, bronze_object_key, source_id, drug_source_version_id, cms_vintage_sequence) is single-valued. Don't mistake parser_artifact_hash/vintage_tag for per-code attributes.

Columns (17)

Query it

describe_data_source(source_fqn="drug_silver.dim_icd10pcs")     # the card, live
query_substrate(sql="SELECT * FROM drug_silver.dim_icd10pcs WHERE code = '<value>' LIMIT 100")