| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | N1ME_THREC_LB | Medication: Link Module Data for Therapy Recommendation | 5 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
TOPClinical System |
2 | N1AGENTFOA | i.s.h.med: Assignment of Agent to Drugs | 3 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
3 | N1DRUGDOC | IS-H*MED: Drug Documentation | 6 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
4 | N1EDRUG | IS-H*MED: Drug Event - Drug Assignment | 6 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
5 | N1FOAGENTA | i.s.h.med: Agents - Drug (O B S O L E T E) | 2 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
6 | N1FOCATREFA | i.s.h.med: Medication, ID References for External Catalogs | 3 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
7 | N1FOFILLSA | i.s.h.med: Medication, Fill Source - Drug Assignment | 3 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
8 | N1FOFORMTYPEA | i.s.h.med: Medication, Drug - Drug Type Assignment | 3 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
9 | N1FOFOTYPEA | IS-H*MED: (O B S O L E T E) Usage Type - Drug Assignment | 2 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
10 | N1FOFSA | i.s.h.med: Fill Source - Drug (O B S O L E T E) | 2 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
11 | N1FOINHERIT | i.s.h.med: Medication; Drug and Assignment Inheritance | 3 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
12 | N1FOINSTA | i.s.h.med: OU-Related Objects - Drugs (O B S O L E T E) | 2 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
13 | N1FORCUSAGEA | i.s.h.med: Usage Key - Drug (O B S O L E T E) | 3 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
14 | N1FORMULARY | Medication: Drug Formulary | 2 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
15 | N1FORMULARYT | Medication: Drug Formulary - Texts | 2 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
16 | N1FOTHCLA | i.s.h.med: Therap. Class - Drug (O B S O L E T E) | 4 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
17 | N1FOTHCLASSA | IS-H*MED: Classification Code - Drug Assignment | 5 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
18 | N1GPFOA | IS-H*MED: Medication, Gener. Drug - Parameter Assignment | 3 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
19 | N1MESFOA | i.s.h.med: Medication, Drug Messages | 3 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
20 | N1ODRUG | IS-H*MED: Medication, Drugs of Order | 5 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
21 | N1OSETDRUG | IS-H*MED: Order Template - Drug Assignment | 3 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
22 | N1PRFOA | i.s.h.med: Medication, Price - Drug Assignment | 3 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
23 | N1TPODRUG | IS-H*MED: Medication, Drugs of Templates | 5 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
24 | N2AD_ALLERGY | Allergy Documentation - Allergies | 10 | DRUGID | Medication: Mnemonic | nvarchar | 32 | 0 | | |
25 | TN1DEFDRUGS | i.s.h.med: Medidation, Mixed Drugs | 5 | DRUGID | i.s.h.med: Medication: Drug ID | nvarchar | 32 | 0 | | |