| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N1MEIMPORT | i.s.h.med: Medication, Master Data Import Table | 4 | GROUPTYP | Medication: Type of Drug Category | nvarchar | 2 | 0 | | |
| 2 | TN1MEDGROUP | IS-H*MED: Medication Groups | 3 | GROUPTYP | Medication: Type of Drug Category | nvarchar | 2 | 0 | | |
| TOPCollectionsDisbursements |
| 3 | IBROSTMDFLT | ISCD: Broker Report - Default Values Per Item Category | 13 | GROUPTYP | Grouping Key for Broker Report | nvarchar | 10 | 0 | | |
| 4 | TIBRDEFAULTS | Broker Collections - Default Values for Broker Report | 12 | GROUPTYP | Grouping Key for Broker Report | nvarchar | 10 | 0 | | |
| 5 | TIBRPOSGRP | Grouping for Broker Report | 2 | GROUPTYP | Grouping Key for Broker Report | nvarchar | 10 | 0 | | |
| 6 | TIBRPOSGRPS | Grouping Criteria for Broker Report Item | 2 | GROUPTYP | Grouping Key for Broker Report | nvarchar | 10 | 0 | | |
| 7 | TIBRPOSGRPT | Grouping Broker Report Item - Texts | 3 | GROUPTYP | Grouping Key for Broker Report | nvarchar | 10 | 0 | | |
| 8 | TIBRWDBRPROCCD | Broker Report Web Application: Processing Codes | 3 | GROUPTYP | Grouping Key for Broker Report | nvarchar | 10 | 0 | | |
