| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | N0FDBS0000000003 | PMD: ISHMDIATAB EDM Diagnoses: Diagnosis Table | 23 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
2 | N1SMPL_000000001 | PMD: N1SMPL_DST | 11 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
3 | N3BGF24040000001 | PMD: N3BG_DIAT | 9 | ISHMDIAKAT | IS-H: Identifikationskürzel für Diagnosekatalog | nvarchar | 2 | 0 | | |
TOPClinical System |
4 | N2CA010D | PMD: N8CATB_DIA | 7 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
5 | N2CA0206 | PMD: N8CATB_DIA | 7 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
6 | N2CA0301 | PMD: N8CATB_DIA | 7 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
7 | N2CA0402 | PMD: N8CATB_DIA | 7 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
8 | N2CA0501 | PMD: N8CATB_DIA | 7 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
9 | N2CA0602 | PMD: N8CATB_DIA | 7 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
10 | N2CA0702 | PMD: N8CATB_DIA | 7 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
11 | N2CA0802 | PMD: N8CATB_DIA | 7 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
12 | N2CA0901 | PMD: N8CATB_DIA | 7 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
13 | N2CA1002 | PMD: N8CATB_DIA | 7 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
14 | N2CA1101 | PMD: N8CATB_DIA | 7 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
15 | N2CA1201 | PMD: N8CATB_DIA | 7 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
16 | N2CA1301 | PMD: N8CATB_DIA | 7 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
17 | N2CA1401 | PMD: N8CATB_DIA | 7 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
18 | N2CA1501 | PMD: N8CATB_DIA | 7 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
19 | N2CA1601 | PMD: N8CATB_DIA | 7 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
20 | N2D13BGT00 | PDOK: N3BGDIATAB | 8 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
21 | N2ISHMDE00 | PDOC: ISHMDEMODI | 8 | ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | | |
22 | N3BF1004V2 | PMD: N3BGF1004 BG: Ergänzungsbericht Knie | 178 | ISHMDIAKAT | IS-H: Identifikationskürzel für Diagnosekatalog | nvarchar | 2 | 0 | | |
23 | N3BF1004V200 | PMD: N3BG_DIAT BG: Tabelle Diagnosen | 9 | ISHMDIAKAT | IS-H: Identifikationskürzel für Diagnosekatalog | nvarchar | 2 | 0 | | |
24 | N3BF1100V200 | PMD: N3BG_DIAT BG: Tabelle Diagnosen | 9 | ISHMDIAKAT | IS-H: Identifikationskürzel für Diagnosekatalog | nvarchar | 2 | 0 | | |
25 | N3BF2400V200 | PMD: N3BG_DIAT BG: Tabelle Diagnosen | 9 | ISHMDIAKAT | IS-H: Identifikationskürzel für Diagnosekatalog | nvarchar | 2 | 0 | | |
26 | N3BGF100000 | PDOK: N3BG_DIAT BG: Tabelle Diagnosen | 9 | ISHMDIAKAT | IS-H: Identifikationskürzel für Diagnosekatalog | nvarchar | 2 | 0 | | |
27 | N3BGF100400 | PDOK: N3BG_DIAT BG: Tabelle Diagnosen | 9 | ISHMDIAKAT | IS-H: Identifikationskürzel für Diagnosekatalog | nvarchar | 2 | 0 | | |
28 | N3BGF103000 | PDOK: N3BG_DIAT BG: Tabelle Diagnosen | 9 | ISHMDIAKAT | IS-H: Identifikationskürzel für Diagnosekatalog | nvarchar | 2 | 0 | | |
29 | N3BGF104000 | PDOK: N3BG_DIAT BG: Tabelle Diagnosen | 9 | ISHMDIAKAT | IS-H: Identifikationskürzel für Diagnosekatalog | nvarchar | 2 | 0 | | |
30 | N3BGF110000 | PDOK: N3BG_DIAT BG: Tabelle Diagnosen | 9 | ISHMDIAKAT | IS-H: Identifikationskürzel für Diagnosekatalog | nvarchar | 2 | 0 | | |
31 | N3BGF210000 | PDOK: N3BG_DIAT BG: Tabelle Diagnosen | 9 | ISHMDIAKAT | IS-H: Identifikationskürzel für Diagnosekatalog | nvarchar | 2 | 0 | | |
32 | N3BGF240000 | PDOK: N3BG_DIAT BG: Tabelle Diagnosen | 9 | ISHMDIAKAT | IS-H: Identifikationskürzel für Diagnosekatalog | nvarchar | 2 | 0 | | |
33 | N3BGF240201 | PMD: N3BG_DIAT | 9 | ISHMDIAKAT | IS-H: Identifikationskürzel für Diagnosekatalog | nvarchar | 2 | 0 | | |
34 | N3BGF241000 | PDOK: N3BG_DIAT BG: Tabelle Diagnosen | 9 | ISHMDIAKAT | IS-H: Identifikationskürzel für Diagnosekatalog | nvarchar | 2 | 0 | | |