Data Characterization: Diagnoses Table
The diagnoses table provides counts of patients stratified by code, code type and data partner. The diagnosis table contains one record per unique combination of DP, Dx_Codetype, and DX.
DIAGNOSES Table Specification | |||
---|---|---|---|
Field Name | Data Type | Predefined Value Sets | Description |
DP | nvarchar(6) |
| Data partner identifier. |
Dx_Codetype | nvarchar(2) | 09 10 11 SM OT | Code type identifier; intended definitions are below: 09 = ICD-9-CM 10 = ICD-10-CM 11 = ICD-11-CM SM = SNOMED CT OT = Other |
DX | nvarchar(18) |
| Diagnosis code. Leading zeroes and decimal points permissible. |
n | float |
| Number of patients. |