| 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 | 18 | PHFORMID | Medication: ID Dosage Form | nvarchar | 3 | 0 | | |
| 2 | N1FORMULARY | Medication: Drug Formulary | 44 | PHFORMID | Medication: ID Dosage Form | nvarchar | 3 | 0 | | |
| 3 | TN1PHFORM | Medication: Dosage Form | 2 | PHFORMID | Medication: ID Dosage Form | nvarchar | 3 | 0 | | |
| 4 | TN1PHFORMEXT | Medication: Dosage Form External Key | 2 | PHFORMID | Medication: ID Dosage Form | nvarchar | 3 | 0 | | |
| 5 | TN1PHFORMT | Medication: Pharmaceutical Form - Texts | 2 | PHFORMID | Medication: ID Dosage Form | nvarchar | 3 | 0 | | |
