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