| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClinical System |
1 | N1BDCCTHCLA | Medication: Th. Classes - Base Catalog Assignment | 4 | THCLASSID | Medication: Internal Key of Classification Code | nvarchar | 15 | 0 | | |
2 | N1FOTHCLA | i.s.h.med: Therap. Class - Drug (O B S O L E T E) | 3 | THCLASSID | Medication: Internal Key of Classification Code | nvarchar | 15 | 0 | | |
3 | N1FOTHCLASSA | IS-H*MED: Classification Code - Drug Assignment | 4 | THCLASSID | Medication: Internal Key of Classification Code | nvarchar | 15 | 0 | | |
4 | N1MEORDERTHCLA | i.s.h.med: Medication, Order -> Indication | 4 | THCLASSID | Medication: Internal Key of Classification Code | nvarchar | 15 | 0 | | |
5 | N1TPGCLA | i.s.h. med: Medication: Template Group - Classif. Code Asgmt | 4 | THCLASSID | Medication: Internal Key of Classification Code | nvarchar | 15 | 0 | | |
6 | TNTHCLASS | Medication: Classification Codes | 3 | THCLASSID | Medication: Internal Key of Classification Code | nvarchar | 15 | 0 | | |
7 | TNTHCLASST | Medication: Classification Codes - Texts | 3 | THCLASSID | Medication: Internal Key of Classification Code | nvarchar | 15 | 0 | | |