[MI/URSA-CORE] ICD-10-PCS Procedure Code Reference

Prev Next

Object Description

One record per ICD-10-PCS procedure code.

The sources for this object are CMS ICD-10-PCS Codes, and AHRQ Clinical Classifications Software (CCS) for ICD-10-PCS, and the Ursa Standard Value Sets for determining if ICD10-PCS code is a surgical procedure

Ursa Studio Update Cadence: Annually

Metadata

  • Table Name: ursa.mi_ursa_core_105
  • Layer: METADATA_AND_INTEGRATION
  • Object Type: Ursa Reference
  • Temporal Class: Entity
  • Case ID: ICD-10-PCS Code
  • Primary Key: ICD-10-PCS Code

Published Fields

  • [No Field Group]
    • ICD-10-PCS Code
    • ICD-10-PCS Short Description
    • ICD-10-PCS Long Description
    • Is Leaf Code
    • AHRQ CCS Single-Level Procedure Category Code
    • AHRQ CCS Single-Level Procedure Category Description
    • AHRQ CCS Multi-Level Procedure Category Tier 1 Code -- Broadest level CCS procedure category, which groups by body systems (16 total)
    • AHRQ CCS Multi-Level Procedure Category Tier 1 Description -- Natural language description of AHRQ CCS Multi-Level Procedure Category Tier 1 Code
    • AHRQ CCS Multi-Level Procedure Category Tier 2 Code -- Provides 187 distinct procedure categories
    • AHRQ CCS Multi-Level Procedure Category Tier 2 Description -- Natural language description of AHRQ CCS Multi-Level Procedure Category Tier 2 Code
    • Is Ursa Surgical Procedure -- If ICD-10 procedure code is in the ICD-10PCS operating room procedure value set then value = 1, else 0