Data Characterization: Procedures Table
The procedures table provides counts of patients stratified by procedure code, code type, and data partner. The procedures table contains one record per unique combination of DP, Px_Codetype, and PX.
PDX Table Specification | |||
---|---|---|---|
Field Name | Data Type | Predefined Value Sets | Description |
DP | nvarchar(6) |
| Data partner identifier. |
Px_Codetype | nvarchar(2) | 09 10 11 C2 C3 C4 HC HC3 LC LO ND RE OT | Code type identifier. Intended code definitions are below: 09 = ICD-9-CM 10 = ICD-10-CM 11 = ICD-11-CM C2 = CPT Category II C3 = CPT Category III C4 = CPT-4 (i.e., HCPCS Level I) HC = HCPCS (i.e., HCPCS Level II) HC3 = HCPCS Level III LC = LOINC LO = Local homegrown ND = NDC RE = Revenue OT = Other |
PX | nvarchar(11) |
| Procedure code. Leading zeroes and decimal points permissible. |
N | float |
| Number of patients. |