| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N1FORMULARY | Medication: Drug Formulary | 102 | EXTCATID | Medication: ID of External Drug Catalog | nvarchar | 3 | 0 | | |
| 2 | N1FORMULARYXML | i.s.h.med: Medication; XML Sections for Drug | 5 | EXTCATID | Medication: ID of External Drug Catalog - OBSOLETE | nvarchar | 3 | 0 | | |
| 3 | NAGENT | IS-H*MED: Agents of Drugs | 9 | EXTCATID | Medication: ID of Agent Catalog - OBSOLETE | nvarchar | 3 | 0 | | |
| 4 | NAGENTEXT | i.s.h.med: Medication; External References for Agents | 4 | EXTCATID | Medication: ID of a Drug Catalog | nvarchar | 3 | 0 | | |
| 5 | NAGENTT | IS-H*MED: Agents of Drugs - Texts | 6 | EXTCATID | Medication: ID of Agent Catalog - OBSOLETE | nvarchar | 3 | 0 | | |
| 6 | TN1EXTREF | i.s.h.med: Medication; External Key for Medication Data | 5 | EXTCATID | Medication: ID of a Drug Catalog | nvarchar | 3 | 0 | | |
| 7 | TN1MELOCEXT | i.s.h.med: Medication; Localization External Key | 3 | EXTCATID | Medication: ID of External Drug Catalog | nvarchar | 3 | 0 | | |
| 8 | TNTHCLASS | Medication: Classification Codes | 6 | EXTCATID | Medication: ID of External Drug Catalog - OBSOLETE | nvarchar | 3 | 0 | | |
| 9 | TNTHSYS | Medication: Classification Systems | 4 | EXTCATID | Medication: ID of External Drug Catalog - OBSOLETE | nvarchar | 3 | 0 | | |
