| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N1MEALERT | i.s.h.med: Drug Alerts | 5 | CHTYPEID | Medication: ID Check Type | nvarchar | 22 | 0 | | |
| 2 | N1MEMOCHA | i.s.h.med: Medication Check Status of Order | 4 | CHTYPEID | Medication: ID Check Type | nvarchar | 22 | 0 | | |
| 3 | N1MESFOA | i.s.h.med: Medication, Drug Messages | 23 | CHTYPEID | Medication: ID Check Type | nvarchar | 22 | 0 | | |
| 4 | TN1MEALHAND | i.s.h.med: Medication - Alert Processing | 5 | CHTYPEID | Medication: ID Check Type | nvarchar | 22 | 0 | | |
| 5 | TN1MECHTYPE | i.s.h.med: Medication Check Type | 2 | CHTYPEID | Medication: ID Check Type | nvarchar | 22 | 0 | | |
| 6 | TN1MECHTYPET | i.s.h.med: Medication Check Type - Text | 2 | CHTYPEID | Medication: ID Check Type | nvarchar | 22 | 0 | | |
