| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SPRAS | Language Key | char | 1 | 0 | | | | Allow NULL? |
| 3 | DKAT | IS-H: Catalog Identification | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | DKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | | | Allow NULL? |
| 5 | REF_DKAT | IS-H: Identification Key of Reference Catalog | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | REF_DKEY | IS-H: Reference Diagnosis Code for Statistics | nvarchar | 30 | 0 | | | | Allow NULL? |
| 7 | DTEXT1 | Diagnosis Text | nvarchar | 40 | 0 | | | | Allow NULL? |
| 8 | DTEXT2 | Diagnosis Text | nvarchar | 40 | 0 | | | | Allow NULL? |
| 9 | DTEXT3 | Diagnosis Text | nvarchar | 40 | 0 | | | | Allow NULL? |
| 10 | DGRPKZ | IS-H: "Diagnosis Group" Indicator | char | 1 | 0 | | | | Allow NULL? |
| 11 | HITLIKZ | IS-H: Hit List Indicator | char | 1 | 0 | | | | Allow NULL? |
| 12 | GSCHL | IS-H: Sex Indicator - Internal | char | 1 | 0 | | | | Allow NULL? |
| 13 | ALTBIS | Diagnosis Valid To (Years) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | ALTVON | Diagnosis Valid From (Years) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | STRUKTM | Diagnosis Flagged as Generic Header | char | 1 | 0 | | | | Allow NULL? |
| 16 | CLFIND | IS-H: User-Defined Indicator for Cst-Spec. Classification | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | STDTEXT | Standardized Short Text for Diagnoses | nvarchar | 150 | 0 | | | | Allow NULL? |
| 18 | DTYP | Type for ICD-10 Diagnoses | char | 1 | 0 | | | | Allow NULL? |
| 19 | ICD10GM_P301 | IS-H: DE - Inpatient Use of Diagnosis Code | char | 1 | 0 | | | | Allow NULL? |
| 20 | ICD10GM_P295 | IS-H: DE - Use of Diagnosis Code Paragraph 295 | char | 1 | 0 | | | | Allow NULL? |
| 21 | /ISHFR/DIATYP | IS-H FR: Diagnosis Type | char | 1 | 0 | | | | Allow NULL? |