Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CodeDescription | Unknown | 0 | null |
|
|
Code description - Description of the mapped diagnostic code |
||
| ICD10Code | Unknown | 0 | null |
|
|
ICD-10 code - Standard ICD-10 diagnostic code |
||
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this mapping is currently valid |
||
| KIndex | float | 8 | √ | null |
|
|
Data field - KIndex information for KinneyICD10Map business operations |
|
| ICDCode | nvarchar | 510 | √ | null |
|
|
Code identifier - Standardized code or identifier for KinneyICD10Map classification |
|
| KinneyCode | Unknown | 0 | null |
|
|
Kinney code - Kinney program-specific diagnostic code |
||
| MappingId | Unknown | 0 | null |
|
|
Primary key - KinneyICD10Map unique identifier for each mapping |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| IX_ICD10Code | Performance | Asc | ICDCode |
| IX_IndexICD | Must be unique | Asc/Asc | KIndex + ICDCode |