| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | TN1CCPROV | i.s.h.med: Medication, External Provider Medication Checks | 2 | CCPROVID | Medication: ID Provider for Medical Checks | nvarchar | 22 | 0 | | |
| 2 | TN1MECCGEPA | i.s.h.med: Medication Transfer Parameters | 3 | CCPROVID | Medication: ID Provider for Medical Checks | nvarchar | 22 | 0 | | |
| 3 | TN1MECCTS | i.s.h.med: Medication Time Spans | 8 | CCPROVID | Medication: ID Provider for Medical Checks | nvarchar | 22 | 0 | | |
| 4 | TN1MECHTYPE | i.s.h.med: Medication Check Type | 5 | CCPROVID | Medication: ID Provider for Medical Checks | nvarchar | 22 | 0 | | |
| 5 | TN1MESEVLEV | i.s.h.med: Severity for Medication Alerts | 3 | CCPROVID | Medication: ID Provider for Medical Checks | nvarchar | 22 | 0 | | |
