| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | NNLFYSIO_VORLAGE | OBSOLETE | 9 | KATID | IS-H: Katalogidentifikation | nvarchar | 2 | 0 | | |
2 | NNL_FYSIO | Tabelle Physiotherapie | 13 | KATID | IS-H: Katalogidentifikation | nvarchar | 2 | 0 | | |
TOPBasic Data |
3 | NLSU | IS-H: Totals File for Service Statistics | 3 | KATID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
4 | TNK00 | IS-H: Diagnosis Coding Catalog Categories | 2 | KATID | IS-H: Catalog Identification | nvarchar | 2 | 0 | | |
5 | TNK01 | IS-H: Service Catalog Types | 3 | KATID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
6 | TNS24 | IS-H: Log File for Totals Records File Services | 3 | KATID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
TOPClinical System |
7 | N1DFO | IS-H*MED: Dispensing Form | 4 | KATID | Identification of a Medication Catalog | nvarchar | 10 | 0 | | |
8 | N1DFOT | IS-H*MED: Dispensing Form/Language-Dependent Text | 5 | KATID | Identification of a Medication Catalog | nvarchar | 10 | 0 | | |
9 | N1DYLMZUO | IS-H*MED: Dynamic material proposal | 4 | KATID | IS-H MM: Identification of a Material Catalog | nvarchar | 8 | 0 | | |
10 | N1MED | OBSOLETE: Patient-Related Medication Data for a Prescription | 5 | KATID | Identification of a Medication Catalog | nvarchar | 10 | 0 | | |
11 | N1MEK | IS-H*MED: Master Data Medications - Catalogs | 3 | KATID | Identification of a Medication Catalog | nvarchar | 10 | 0 | | |
12 | N1MEKT | IS-H*MED: Master Data Medications - Catalog/Lang-Dep. Text | 4 | KATID | Identification of a Medication Catalog | nvarchar | 10 | 0 | | |
13 | N1MEOEZ | IS-H*MED: Medication - OU Assignment | 3 | KATID | Identification of a Medication Catalog | nvarchar | 10 | 0 | | |
14 | N1MEP | OBSOLETE: Master Data Medication - Catalog Positions | 3 | KATID | Identification of a Medication Catalog | nvarchar | 10 | 0 | | |
15 | N1MEPSTFZ | IS-H*MED: Medication - Substance Assignment | 5 | KATID | Identification of a Medication Catalog | nvarchar | 10 | 0 | | |
16 | N1MEPT | OBSOLETE: Master Data Medication - Cat.Pos./Lang.-Dep. T. | 4 | KATID | Identification of a Medication Catalog | nvarchar | 10 | 0 | | |
17 | N1MLZUO | IS-H*MED: Service-related material proposal | 7 | KATID | IS-H MM: Identification of a Material Catalog | nvarchar | 8 | 0 | | |
18 | N1POPAKTE | IS-H*Med: Patient Organizer - Redundant Structure | 61 | KATID | Health Problems Catalog | nvarchar | 40 | 0 | | |
19 | N1STF | IS-H*MED: Master Data of Medication Substances | 4 | KATID | Identification of a Medication Catalog | nvarchar | 10 | 0 | | |
20 | N1STFTYP | IS-H*MED: Substance Types | 4 | KATID | Identification of a Medication Catalog | nvarchar | 10 | 0 | | |
21 | TN2DKATID2EXTID | IS-H*MED: Diagnosis Catalog Types TNK00 by External Version | 2 | KATID | IS-H: Catalog Identification | nvarchar | 2 | 0 | | |
22 | TN2K0 | IS-H*MED: Nursing catalog categories | 2 | KATID | Identification of a Basic Catalog | nvarchar | 2 | 0 | | |
23 | TN2K1 | IS-H*MED: Nursing standard catalog categories | 2 | KATID | Identification of Standardized Nursing Plan Catalog | nvarchar | 2 | 0 | | |
24 | TN2K2 | IS-H*MED: Classification area catalog categories | 2 | KATID | Identification of the Classification Area Catalog | nvarchar | 2 | 0 | | |
25 | TN2K3 | IS-H*MED: Service catalog - classification catalog asgmt | 3 | KATID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
26 | TN2PKATID2EXTID | IS-H*MED: Service Catalog TNK01 by External Version | 3 | KATID | IS-H: Identification of Surgical Procedure Coding Catalog | nvarchar | 2 | 0 | | |
TOPMedical Patient Data Organization Patient Organizer |
27 | N1STRUCMEDREC | IS-H*MED: Health Problems (Struct. Med. Patient Record) | 6 | KATID | Health Problems Catalog | nvarchar | 40 | 0 | | |
28 | N1STRUCMEDRECCAT | IS-H*MED: Health Problems Catalog | 2 | KATID | Health Problems Catalog | nvarchar | 40 | 0 | | |
TOPPatient Accounting |
29 | NLAZ | IS-H: Assign IS-H Service to CO Activity Type | 3 | KATID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
30 | NMHIT | IS-H MM: Material-OU hit list | 2 | KATID | IS-H MM: Identification of a Material Catalog | nvarchar | 8 | 0 | | |
31 | NMKAO | IS-H MM: Assignment of Material Catalog to OU | 3 | KATID | IS-H MM: Identification of a Material Catalog | nvarchar | 8 | 0 | | |
32 | NMKAP | IS-H MM: Material catalog items | 2 | KATID | IS-H MM: Identification of a Material Catalog | nvarchar | 8 | 0 | | |
33 | NMKAT | IS-H MM: Material catalogs | 2 | KATID | IS-H MM: Identification of a Material Catalog | nvarchar | 8 | 0 | | |
34 | NMKATT | IS-H MM: Material catalogs | 3 | KATID | IS-H MM: Identification of a Material Catalog | nvarchar | 8 | 0 | | |
35 | TNDRG | IS-H: DRG Billing Parameters | 11 | KATID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
36 | NLVERZF_007 | Konversion Diagnose SAP nach Diagnose VEKTIS | 3 | KATID | IS-H: Catalogusidentificatie | nvarchar | 2 | 0 | | |
37 | NLVERZF_008 | Konversion Diagnose SAP nach Diagnose VEKTIS 2 | 3 | KATID | IS-H: Catalogusidentificatie | nvarchar | 2 | 0 | | |
38 | TNWCHDRG | IS-H CH: DRG-Abrechnungsparameter | 6 | KATID | IS-H: identificatore di un catalogo di prestazioni | nvarchar | 2 | 0 | | |