| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N1CYDEF | ISHMED: Cycle Definition | 21 | ZNR | Cycle Key | nvarchar | 10 | 0 | | |
| 2 | N1FOINSTA | i.s.h.med: OU-Related Objects - Drugs (O B S O L E T E) | 6 | ZNR | Medication: Cycle Key for Institution | nvarchar | 10 | 0 | | |
| 3 | N1FORCUSAGEA | i.s.h.med: Usage Key - Drug (O B S O L E T E) | 7 | ZNR | Medication: Cycle Key for Use | nvarchar | 10 | 0 | | |
| 4 | N1LSMAZ | IS-H*MED: Service/employee assign. (delete after 3.03!) | 17 | ZNR | Row Number for Service-Employee-Task Assignment | nvarchar | 2 | 0 | | |
| 5 | N1LSTEAM | IS-H*MED: Tasks/Employees for a Service | 11 | ZNR | Row Number for Service-Employee-Task Assignment | nvarchar | 2 | 0 | | |
| 6 | N1MEORDSLDOSEA | i.s.h.med: Sliding Dose - Order Assignment | 7 | ZNR | Cycle Key | nvarchar | 10 | 0 | | |
| 7 | N1OSETDRUG | IS-H*MED: Order Template - Drug Assignment | 12 | ZNR | Cycle Key | nvarchar | 10 | 0 | | |
| 8 | N1TPMEORDER | IS-H*MED: Medication, Medication Order Template | 36 | ZNR | Cycle Key | nvarchar | 10 | 0 | | |
| 9 | N1TPOSLDOSEA | i.s.h.med: Sliding Dose - Order Template Assignment | 7 | ZNR | Cycle Key | nvarchar | 10 | 0 | | |
