| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TN1MCI_COMP | Component Registration | 12 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
2 | TN1MCI_PROC | Communication Processes | 12 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
3 | TN1MCI_PROP | Properties of a Processing Step | 13 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
4 | TN1MCI_STEP | Processing Steps of a Communication Process | 13 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
TOPClinical System |
5 | N1BCEXPCFG | Basis Cat.: Export Configuration | 15 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
6 | N1BCEXPCFGCPL | Basis Cat.: Export Configuration Item Assignment | 8 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
7 | N1BCH | Basic Cat.: Catalog Header | 16 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
8 | N1BCH2OU | OBSOLETE | 14 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
9 | N1BCH2ROLE | OBSOLETE | 13 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
10 | N1BCH2USER | OBSOLETE | 13 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
11 | N1BCHLD | Basic Cat.: Catalog Assignment Definition | 16 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
12 | N1BCIMPCFG | Basic Cat.: Import Configuration | 22 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
13 | N1BCIMPCFGCPL | Basic Cat.: Import Configuration Item Assignment | 10 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
14 | N1BCP | Basic Cat.: Catalog Item | 21 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
15 | N1BCP2BCP | Basic Cat.: Catalog Item to Catalog Item Assignment | 18 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
16 | N1BCP2DIAG | Basic Cat.: Catalog Item to Diagnosis Assignment | 15 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
17 | N1BCP2HIER | Basic Cat.: Catalog Item to Hierarchy Assignment | 15 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
18 | N1BCP2MAT | Basic Cat.: Catalog Item to Material Assignment | 15 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
19 | N1BCP2NTPK | Basic Cat.: Catalog Item to Service Assignment | 17 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
20 | N1BCP2RC | Basic Cat.: Item - Display Configuration Assignment | 16 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
21 | N1BCP2TASK | Basic Cat.: Catalo Item to Task Assignment | 14 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
22 | N1BCP2URL | Basic Cat.: Catalog Item to URL Assignment | 16 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
23 | N1BCPLD | OBSOLETE | 16 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
24 | N1BCRC | Basic Cat.: Display Configuration | 12 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
25 | N1BCRC2BCSMC | Basic Cat.: Display Config. - Main Catalog Assignment | 17 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
26 | N1BCRG | Basic Cat.: Display Group | 14 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
27 | N1BCS | OBSOLETE: Basic Cat.: Basic Catalog Set | 17 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
28 | N1BCSE | OBSOLETE: Basic Cat.: Basic Catalog Set Entry | 17 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
29 | N1BCSEP | OBSOLETE: Basic Cat.: Basic Catalog Set Entry Property | 17 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
30 | N1BCSF | Basic Catalog Set: Folder | 13 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
31 | N1BCSG | OBSOLETE: Basic Cat.: Basic Catalog Set Group | 14 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
32 | N1BCSH | Basic Catalog Set: Header Data | 18 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
33 | N1BCSMC | Basic Catalog Set: Main Catalog | 18 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
34 | N1BCSPC | Basic Catalog Set: Property Catalog | 17 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
35 | N1BCSPEC | Basic Cat.: Range | 12 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
36 | N1BCSPEC2BCP | Basic Cat.: Range to Catalog Item Assignment | 15 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
37 | N1BCSPEC2EBCP | Basic Cat.: Range to Excluded Catalog Item Assignment | 14 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
38 | N1BCSPEC2OU | Basic Cat.: Range to OU Assignment | 15 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
39 | N1CORDUNIT | CORD: Units for Clinical Orders | 12 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
40 | N1DC | IS-H*MED: Table of Formularies | 17 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
41 | N1FOCATREFA | i.s.h.med: Medication, ID References for External Catalogs | 15 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
42 | N1FOFILLSAB | i.s.h.med: Medication, Fill Source - Drug Assignment | 19 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
43 | N1FOFORMTYPEA | i.s.h.med: Medication, Drug - Drug Type Assignment | 14 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
44 | N1FOFOTYPEA | IS-H*MED: (O B S O L E T E) Usage Type - Drug Assignment | 13 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
45 | N1FOTHCLASSA | IS-H*MED: Classification Code - Drug Assignment | 16 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
46 | N1FSOURCE | IS-H*MED: Fill Source | 17 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
47 | N1FSOURCEOUA | IS-H*MED: Fill Source for OUs Assignment | 16 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
48 | N1GPFOA | IS-H*MED: Medication, Gener. Drug - Parameter Assignment | 17 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
49 | N1MESFOA | i.s.h.med: Medication, Drug Messages | 20 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
50 | N1PRDOC | IS-H*MED: PATREG: Dokumente | 34 | LOTIM | Silme saati | nvarchar | 6 | 0 | | |
51 | N1PRFOA | i.s.h.med: Medication, Price - Drug Assignment | 19 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
52 | N1SPMLAYOUT_DIS | i.s.h.med: Table for Display Parameters | 24 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
53 | N1TMSTP | i.s.h.med: Table for Time Stamps | 13 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
54 | N1TMSTPDURDEF | i.s.h.med: Duration Definition of Time Stamps | 19 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
55 | NAGENT | IS-H*MED: Agents of Drugs | 19 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
56 | NDOCA | IS-H*MED: Document Management Data for Archived Documents | 42 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
57 | NDOCSTORNO | IS-H*MED: Canceled Documents | 43 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
58 | TN1AGTYPE | i.s.h.med: Medication, Agent Types of Drugs | 12 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
59 | TN1CCPROV | i.s.h.med: Medication, External Provider Medication Checks | 15 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
60 | TN1DEVICE | Medication: Administration Devices | 14 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
61 | TN1FORMLEVEL | i.s.h.med: Medication, Drug Levels | 22 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
62 | TN1FORMP | i.s.h.med: Medication, Generic Drug Parameters | 12 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
63 | TN1FORMTYPE | IS-H*MED: Drug Types | 14 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
64 | TN1LINTYP | IS-H*MED: Line Type | 13 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
65 | TN1MEALHAND | i.s.h.med: Medication - Alert Processing | 18 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
66 | TN1MECCGEPA | i.s.h.med: Medication Transfer Parameters | 19 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
67 | TN1MECCTS | i.s.h.med: Medication Time Spans | 19 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
68 | TN1MECHARTGRP | Medication: Customizable Grouping Types | 14 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
69 | TN1MECHTYPE | i.s.h.med: Medication Check Type | 26 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
70 | TN1MEDCLASS | IS-H*MED: Medication Classes - OBSOLETE | 12 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
71 | TN1MEDGROUP | IS-H*MED: Medication Groups | 14 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
72 | TN1MELOC | IS-H*MED: Localization for Medication | 13 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
73 | TN1MESEVLEV | i.s.h.med: Severity for Medication Alerts | 16 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
74 | TN1MSGGROUP | i.s.h.med: Medication, Groups of Drug Messages | 12 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
75 | TN1PHFORM | Medication: Dosage Form | 15 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
76 | TN1PRICETYP | i.s.h.med: Medication, Price Types for Drug | 12 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
77 | TN1RCIND | Medication: Reason Code (Institution-Independent) | 13 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
78 | TN1RCODE | IS-H*MED: Reason Code | 20 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
79 | TN1ROUTE | Medication: Administration Routes | 14 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
80 | TN1SIGNS | i.s.h.med: Patient Record, Indicators | 12 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
81 | TNTHCLASS | Medication: Classification Codes | 16 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
TOPContract Accounts Receivable and Payable |
82 | DFKKCRDEL | CR: Deleted Payment Medium / Basic Data | 10 | LOTIM | System Time | nvarchar | 6 | 0 | | |
83 | DFKKCRDEL2P | CR: Deleted Payment Medium / Payee Data | 11 | LOTIM | System Time | nvarchar | 6 | 0 | | |
84 | DFKKCRDELADD | CR: Deleted Payment Medium / Additional Data | 10 | LOTIM | System Time | nvarchar | 6 | 0 | | |
85 | DFKKCRDELD2 | Check Register: Deleted Payment Media/Partial Encashments | 11 | LOTIM | System Time | nvarchar | 6 | 0 | | |
86 | DFKKCRDELESCH | Check Register: Escheatment Data | 10 | LOTIM | System Time | nvarchar | 6 | 0 | | |
87 | DFKKCRDELESCHA | Check Register: Escheatment Data: Correspondence | 5 | LOTIM | System Time | nvarchar | 6 | 0 | | |
TOPDocuments |
88 | N1IM_IMAGE | Single Image Within Image Study | 22 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
89 | N1IM_STUDY | Meta Data of Image Study | 24 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
TOPNursing |
90 | N1NRSPKMS | Nursing Plan: NCPS Classifications | 20 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
91 | N1SNP | OBSOLETE - Std.Nurs.Plan: Std.Nurs.Plan Header Data | 19 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
92 | N1SNP2BCP | OBS.: Std. Nrs.Plan: Std. Nrs. Plan to Basic Cat. Item Asgmt | 15 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
93 | N1SNP2SNP | OBSOLETE: Std. Nrs. Plan: Std. Nrs. Plan to Std. Nrs. Plan | 15 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
94 | N1SNPE | Standard Nursing Plan: Entry | 20 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
95 | N1SNPH | Std.Nurs.Plan: Header Data | 20 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
96 | N1SNPH2BCP | Stnd Nrs. Plan: Stnd Nrs. Plan to Basic Calog Item Asgmt | 16 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
97 | N1SNPH2OU | Stnd Nrs. Plan: Standard Nursing Plan to OU Assignment | 15 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
98 | N1SNPH2SNPH | Std.Nurs.Plan: Std.Nurs.Plan to Std.Nurs.Plan | 15 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
99 | N1SNPP | OBSOLETE - Std. Nrs. Plan: Std. Nrs. Plan Item | 16 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
TOPPatient Management |
100 | NDOC | IS-H: Assignment of IS-H Objects to Documents in DMS | 42 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
101 | N2BASEITEM | Base Items: Base Item | 22 | LOTIM | Deletion Time | nvarchar | 6 | 0 | | |