| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | TNMCONSVA | Routes of drug administration | 3 | CONSVA | Route of Administration of Drugs | nvarchar | 5 | 0 | | |
| 2 | TNMCONSVAT | Routes of Administration for Drugs - Texts | 4 | CONSVA | Route of Administration of Drugs | nvarchar | 5 | 0 | | |
| 3 | TNWCHSDRG03 | Swiss-DRG - Leistungsregeln DRG-Zusatzentgelte Medikamente | 5 | CONSVA | Verabreichungsart von Medikamenten | nvarchar | 5 | 0 | | |
| 4 | TNWCH_ATC_REL | Statistikrelevante ATC-Codes | 7 | CONSVA | Verabreichungsart von Medikamenten | nvarchar | 5 | 0 | | |
| 5 | TNWCH_LST_CONSVA | Default-Verabreichungsart je Medikament | 5 | CONSVA | Verabreichungsart von Medikamenten | nvarchar | 5 | 0 | | |
| TOPPatient Accounting |
| 6 | NMATV | IS-H: Material Entered for Case | 40 | CONSVA | Route of Administration of Drugs | nvarchar | 5 | 0 | | |
| TOPPatient Management |
| 7 | NLEI | IS-H: Services Performed | 138 | CONSVA | Route of Administration of Drugs | nvarchar | 5 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 8 | NWCHLS_RNLSR | IS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR) | 198 | CONSVA | Metodo di somministrazione dei farmaci | nvarchar | 5 | 0 | | |
