| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClinical System |
1 | N1MEORDER | IS-H*MED: Medication, Medication Order | 87 | TPID | Medication: ID Order Template | nvarchar | 10 | 0 | | |
2 | N1TPDIAA | Medication: OBSOLETE - Replaced by N1TPGDIAGA | 4 | TPID | Medication: ID Order Template | nvarchar | 10 | 0 | | |
3 | N1TPEMPA | IS-H*MED: Template / Group - Employee Assignment - OBSOLETE | 3 | TPID | Medication: ID Order Template | nvarchar | 10 | 0 | | |
4 | N1TPGDIAGA | i.s.h.med: Medication: Template Group - Diagnosis Assignment | 5 | TPID | Medication: ID Order Template | nvarchar | 10 | 0 | | |
5 | N1TPMEORDER | IS-H*MED: Medication, Medication Order Template | 2 | TPID | Medication: ID Order Template | nvarchar | 10 | 0 | | |
6 | N1TPMEORDERT | IS-H*MED: Template Medication Order Description | 2 | TPID | Medication: ID Order Template | nvarchar | 10 | 0 | | |
7 | N1TPODOSEMODA | i.s.h.med: Quantity Modulat. Assignment to Order Template | 3 | TPID | Medication: ID Order Template | nvarchar | 10 | 0 | | |
8 | N1TPODRUG | IS-H*MED: Medication, Drugs of Templates | 3 | TPID | Medication: ID Order Template | nvarchar | 10 | 0 | | |
9 | N1TPORATE | IS-H*MED: Dosage Quantities of Template | 3 | TPID | Medication: ID Order Template | nvarchar | 10 | 0 | | |
10 | N1TPOSLDOSEA | i.s.h.med: Sliding Dose - Order Template Assignment | 3 | TPID | Medication: ID Order Template | nvarchar | 10 | 0 | | |
11 | N1TPOUA | Medication: OBSOLETE - Replaced by N1TPGOUA | 4 | TPID | Medication: ID Order Template | nvarchar | 10 | 0 | | |
12 | N1TPTPGRA | IS-H*MED: Template - Template Group Assignment | 3 | TPID | Medication: ID Order Template | nvarchar | 10 | 0 | | |
13 | N1TPUSERA | Medication: OBSOLETE - Replaced by N1TPGUSERA | 3 | TPID | Medication: ID Order Template | nvarchar | 10 | 0 | | |
TOPUser Administration |
14 | SMUM_MAP | SAP-C1 mapping table | 3 | TPID | Trading Partner ID | nvarchar | 10 | 0 | | |
15 | SMUM_TPADD | Address link TP - CAM | 2 | TPID | Trading Partner ID | nvarchar | 10 | 0 | | |