| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | USMD2044 | Search Apps: Assignment of Search Help - Model - Entity | 1 | USMD_SEARCH_MODE | Search Mode | nvarchar | 2 | 0 | | |
| TOPApplication Framework |
| 2 | USMD203C | Stored Search Criteria (by User and Entity Type) | 5 | USMD_SEARCH_MODE | Search Mode | nvarchar | 2 | 0 | | |
| 3 | USMD2041 | Search Apps: Assignment of Search Type - Search Help | 1 | USMD_SEARCH_MODE | Search Mode | nvarchar | 2 | 0 | | |
| 4 | USMD2041T | Search Apps: Assignment of Search Type - Search Help TextTbl | 1 | USMD_SEARCH_MODE | Search Mode | nvarchar | 2 | 0 | | |
| 5 | USMD2042 | Search Apps: Assignment of Search Type - Model - Entity | 1 | USMD_SEARCH_MODE | Search Mode | nvarchar | 2 | 0 | | |
| 6 | USMD204C | Search Applications: Definition | 1 | USMD_SEARCH_MODE | Search Mode | nvarchar | 2 | 0 | | |
| 7 | USMD204T | Search Applications: Text Table | 2 | USMD_SEARCH_MODE | Search Mode | nvarchar | 2 | 0 | | |
| TOPData Quality |
| 8 | MDG_DQ_CONF_DC | Configuration table for duplicate check - Data Quality | 1 | USMD_SEARCH_MODE | Search Mode | nvarchar | 2 | 0 | | |
| 9 | MDG_DQ_MATCH_DC | Match profile for duplicate check configuration | 1 | USMD_SEARCH_MODE | Search Mode | nvarchar | 2 | 0 | | |
| 10 | MDG_DQ_MATCH_TXT | Text table for Match profile id | 1 | USMD_SEARCH_MODE | Search Mode | nvarchar | 2 | 0 | | |
| 11 | USMD_DUPCHK_MOD | Duplicate Check Mode For Particular Data Model | 4 | USMD_SEARCH_MODE | Search Mode | nvarchar | 2 | 0 | | |
