| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | N1MESORTORDPOS | Medication: Position of MO in Man. Sort Order | 4 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
2 | N1ME_THREC_LB | Medication: Link Module Data for Therapy Recommendation | 4 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
TOPClinical System |
3 | N1EADDOC | IS-H*MED: Medication, Event Administration Document | 3 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
4 | N1EDRUG | IS-H*MED: Drug Event - Drug Assignment | 4 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
5 | N1EPREPDOC | IS-H*MED: Preparation Documentation of Event | 3 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
6 | N1GENCY_03 | IS-H*MED: Cycle - Drug Order Assignment | 3 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
7 | N1MEALMOA | i.s.h.med: Medication: Assign Drug Alert to Medication Order | 3 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
8 | N1MEEVENT | IS-H*MED: Medication, Medication Event | 4 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
9 | N1MEGENLOG | IS-H*MED: Medication, Log Tables for Event Generation | 2 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
10 | N1MEMOCHA | i.s.h.med: Medication Check Status of Order | 3 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
11 | N1MEOACT | i.s.h.med: Medication, Order Activities | 4 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
12 | N1MEODOCA | IS-H*MED: Document Assignment for Medication Order | 6 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
13 | N1MEODOSEMODA | i.s.h.med: Assignment of Quantity Modulation to Order | 3 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
14 | N1MEORDER | IS-H*MED: Medication, Medication Order | 2 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
15 | N1MEORDERTHCLA | i.s.h.med: Medication, Order -> Indication | 5 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
16 | N1MEORDSLDOSEA | i.s.h.med: Sliding Dose - Order Assignment | 3 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
17 | N1MEOSRVA | IS-H*MED: Order - Service - Assignment | 2 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
18 | N1ODRUG | IS-H*MED: Medication, Drugs of Order | 3 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
19 | N1ORATE | IS-H*MED: Medication, Dosage Quantities Infusions | 3 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
20 | N1OSTATUSA | IS-H*MED: Order - Status - Assignment | 2 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |
21 | N1POPAKTE | IS-H*Med: Patient Organizer - Redundant Structure | 55 | MEORDID | Medication: Order - Order Number | nvarchar | 10 | 0 | | |