| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N1FORMULARY | Medication: Drug Formulary | 21 | MEDGRPID | Medication: Drug Category Key | nvarchar | 3 | 0 | | |
| 2 | N1MEORDER | IS-H*MED: Medication, Medication Order | 23 | MEDGRPID | Medication: Drug Category Key | nvarchar | 3 | 0 | | |
| 3 | N1TPMEORDER | IS-H*MED: Medication, Medication Order Template | 13 | MEDGRPID | Medication: Drug Category Key | nvarchar | 3 | 0 | | |
| 4 | TN1MEDCLGRPA | IS-H*MED: Medication Groups - OBSOLETE | 3 | MEDGRPID | Medication: Drug Category Key | nvarchar | 3 | 0 | | |
| 5 | TN1MEDGROUP | IS-H*MED: Medication Groups | 2 | MEDGRPID | Medication: Drug Category Key | nvarchar | 3 | 0 | | |
| 6 | TN1MEDGROUPT | IS-H*MED: Medication Groups - Texts | 2 | MEDGRPID | Medication: Drug Category Key | nvarchar | 3 | 0 | | |
