| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | MDGM_SEARCH | FPM Table for saved searches | 7 | SEARCH_MODE | Search Mode | nvarchar | 2 | 0 | | |
| 2 | MDGM_SEARCH_APPL | FPM Table for saved searches | 9 | SEARCH_MODE | Search Mode | nvarchar | 2 | 0 | | |
| 3 | MDG_SRCH_SRV_CNF | Search Applications for Search Services | 4 | SEARCH_MODE | Search Mode | nvarchar | 2 | 0 | | |
| TOPData Quality |
| 4 | USMD_DUPCHK_MOD | Duplicate Check Mode For Particular Data Model | 10 | SEARCH_MODE | Default Search Mode for Search Applications | nvarchar | 2 | 0 | | |
| TOPFront Office |
| 5 | ECICBPSD | Profile for IS-U Business Partner Component of CIC | 3 | SEARCH_MODE | Search Mode of CIC Business Partner Search | nvarchar | 1 | 0 | | |
| TOPInformation Consistency |
| 6 | SIC_SRC_PROF | Search: Profiles | 8 | SEARCH_MODE | Search Mode | tinyint | 3 | 0 | | |
| TOPNetWeaver Enterprise Search |
| 7 | ESH_QL_QLOG | Query Log | 15 | SEARCH_MODE | Term Action (Search Mode, e.g. Denoting Fuzzy Search) | nvarchar | 1 | 0 | | |
