| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | N0FDBS0000000003 | PMD: ISHMDIATAB EDM Diagnoses: Diagnosis Table | 24 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
2 | N1SMPL_000000001 | PMD: N1SMPL_DST | 9 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
3 | N3BGF24040000001 | PMD: N3BG_DIAT | 8 | ISHMDIAKEY | IS-H: Schlüsselung einer Diagnose | nvarchar | 30 | 0 | | |
TOPClinical System |
4 | N2CA010D | PMD: N8CATB_DIA | 8 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
5 | N2CA0206 | PMD: N8CATB_DIA | 8 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
6 | N2CA0301 | PMD: N8CATB_DIA | 8 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
7 | N2CA0402 | PMD: N8CATB_DIA | 8 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
8 | N2CA0501 | PMD: N8CATB_DIA | 8 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
9 | N2CA0602 | PMD: N8CATB_DIA | 8 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
10 | N2CA0702 | PMD: N8CATB_DIA | 8 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
11 | N2CA0802 | PMD: N8CATB_DIA | 8 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
12 | N2CA0901 | PMD: N8CATB_DIA | 8 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
13 | N2CA1002 | PMD: N8CATB_DIA | 8 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
14 | N2CA1101 | PMD: N8CATB_DIA | 8 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
15 | N2CA1201 | PMD: N8CATB_DIA | 8 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
16 | N2CA1301 | PMD: N8CATB_DIA | 8 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
17 | N2CA1401 | PMD: N8CATB_DIA | 8 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
18 | N2CA1501 | PMD: N8CATB_DIA | 8 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
19 | N2CA1601 | PMD: N8CATB_DIA | 8 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
20 | N2D13BGT00 | PDOK: N3BGDIATAB | 7 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
21 | N2ISHMDE00 | PDOC: ISHMDEMODI | 9 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
22 | N2N3AF0100 | PDOK: N3A_DIAT | 7 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
23 | N2N3AF0101 | PDOK: N3A_DIAT | 7 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
24 | N2N3AF0201 | PDOK: N3A_DIAT | 7 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
25 | N2N3AF0300 | PDOK: N3A_DIAT | 7 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
26 | N2N3AF0400 | PDOK: N3A_DIAT | 7 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
27 | N2N3AF0700 | PDOK: N3A_DIAT | 7 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
28 | N2N3AF0800 | PDOK: N3A_DIAT | 7 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
29 | N2N3AF1000 | PDOK: N3A_DIAT | 7 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
30 | N2N3AF1100 | PDOK: N3A_DIAT | 7 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
31 | N2N3AF1200 | PDOK: N3A_DIAT | 7 | ISHMDIAKEY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | | |
32 | N3BF1004V2 | PMD: N3BGF1004 BG: Ergänzungsbericht Knie | 177 | ISHMDIAKEY | IS-H: Schlüsselung einer Diagnose | nvarchar | 30 | 0 | | |
33 | N3BF1004V200 | PMD: N3BG_DIAT BG: Tabelle Diagnosen | 8 | ISHMDIAKEY | IS-H: Schlüsselung einer Diagnose | nvarchar | 30 | 0 | | |
34 | N3BF1100V200 | PMD: N3BG_DIAT BG: Tabelle Diagnosen | 8 | ISHMDIAKEY | IS-H: Schlüsselung einer Diagnose | nvarchar | 30 | 0 | | |
35 | N3BF2400V200 | PMD: N3BG_DIAT BG: Tabelle Diagnosen | 8 | ISHMDIAKEY | IS-H: Schlüsselung einer Diagnose | nvarchar | 30 | 0 | | |
36 | N3BGF100000 | PDOK: N3BG_DIAT BG: Tabelle Diagnosen | 8 | ISHMDIAKEY | IS-H: Schlüsselung einer Diagnose | nvarchar | 30 | 0 | | |
37 | N3BGF100400 | PDOK: N3BG_DIAT BG: Tabelle Diagnosen | 8 | ISHMDIAKEY | IS-H: Schlüsselung einer Diagnose | nvarchar | 30 | 0 | | |
38 | N3BGF103000 | PDOK: N3BG_DIAT BG: Tabelle Diagnosen | 8 | ISHMDIAKEY | IS-H: Schlüsselung einer Diagnose | nvarchar | 30 | 0 | | |
39 | N3BGF104000 | PDOK: N3BG_DIAT BG: Tabelle Diagnosen | 8 | ISHMDIAKEY | IS-H: Schlüsselung einer Diagnose | nvarchar | 30 | 0 | | |
40 | N3BGF110000 | PDOK: N3BG_DIAT BG: Tabelle Diagnosen | 8 | ISHMDIAKEY | IS-H: Schlüsselung einer Diagnose | nvarchar | 30 | 0 | | |
41 | N3BGF210000 | PDOK: N3BG_DIAT BG: Tabelle Diagnosen | 8 | ISHMDIAKEY | IS-H: Schlüsselung einer Diagnose | nvarchar | 30 | 0 | | |
42 | N3BGF240000 | PDOK: N3BG_DIAT BG: Tabelle Diagnosen | 8 | ISHMDIAKEY | IS-H: Schlüsselung einer Diagnose | nvarchar | 30 | 0 | | |
43 | N3BGF240201 | PMD: N3BG_DIAT | 8 | ISHMDIAKEY | IS-H: Schlüsselung einer Diagnose | nvarchar | 30 | 0 | | |
44 | N3BGF241000 | PDOK: N3BG_DIAT BG: Tabelle Diagnosen | 8 | ISHMDIAKEY | IS-H: Schlüsselung einer Diagnose | nvarchar | 30 | 0 | | |