| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N1BDCC | IS-H*MED: External Drug Basic Catalog Entries | 16 | APDEVID | Medication: Administration Device ID | nvarchar | 3 | 0 | | |
| 2 | N1FORMULARY | Medication: Drug Formulary | 42 | APDEVID | Medication: Administration Device ID | nvarchar | 3 | 0 | | |
| 3 | N1MEEVENT | IS-H*MED: Medication, Medication Event | 19 | APDEVID | Medication: Administration Device ID | nvarchar | 3 | 0 | | |
| 4 | TN1DEVICE | Medication: Administration Devices | 2 | APDEVID | Medication: Administration Device ID | nvarchar | 3 | 0 | | |
| 5 | TN1DEVICEEXT | Medication: Administration Device External Key | 2 | APDEVID | Medication: Administration Device ID | nvarchar | 3 | 0 | | |
| 6 | TN1DEVICET | Medication: Administration Devices - Texts | 2 | APDEVID | Medication: Administration Device ID | nvarchar | 3 | 0 | | |
