| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N1FORMULARY | Medication: Drug Formulary | 20 | MEDCLID | Medication: Drug Category ID - OBSOLETE | nvarchar | 3 | 0 | | |
| 2 | TN1MEDCLASS | IS-H*MED: Medication Classes - OBSOLETE | 2 | MEDCLID | Medication: Drug Category ID - OBSOLETE | nvarchar | 3 | 0 | | |
| 3 | TN1MEDCLASST | IS-H*MED: Medication Groups - Texts - OBSOLETE | 2 | MEDCLID | Medication: Drug Category ID - OBSOLETE | nvarchar | 3 | 0 | | |
| 4 | TN1MEDCLGRPA | IS-H*MED: Medication Groups - OBSOLETE | 2 | MEDCLID | Medication: Drug Category ID - OBSOLETE | nvarchar | 3 | 0 | | |
