Program control table used by Unicenter Knowledge Tools
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Unique (to the table) numeric identifier. |
| search_text | nvarchar(255) | with null | The search text value for this EBR_LOG. |
| search_quality | integer | with null | The search quality value for this EBR_LOG. |
| num_matches | integer | with null | The num matches value for this EBR_LOG. |
| top_match_id | integer | with null | The top match id value for this EBR_LOG. |
| user_id | nvarchar(100) | with null | The user id value for this EBR_LOG. |
| asked_date | integer | with null | The asked date value for this EBR_LOG. |
| search_type | integer | with null | The search type value for this EBR_LOG. |
| external_id | nvarchar(50) | with null | The external id value for this EBR_LOG. |
| method_type | integer | with null | The method type value for this EBR_LOG. |
| method_performance | integer | with null | The method performance value for this EBR_LOG. |
| fuzziness | integer | with null | The fuzziness value for this EBR_LOG. |
| match_type | integer | with null | The match type value for this EBR_LOG. |
| search_in | integer | with null | The search in value for this EBR_LOG. |
| primary_order | nvarchar(50) | with null | The primary order value for this EBR_LOG. |
| secondary_order | integer | with null | The secondary order value for this EBR_LOG. |
| order_direction | integer | with null | The order direction value for this EBR_LOG. |
| rows_to_fetch | integer | with null | The rows to fetch value for this EBR_LOG. |
| rows_found | integer | with null | The rows found value for this EBR_LOG. |
| filter_data | nvarchar(4000) | with null | The filter data value for this EBR_LOG. |
| keywords | long nvarchar | with null | The keywords value for this EBR_LOG. |
| sql_text | nvarchar(4000) | with null | The sql text value for this EBR_LOG. |
| session_id | integer | with null | The session id value for this EBR_LOG. |
| unique_word_count | integer | with null | The unique word count value for this EBR_LOG. |
| word_count | integer | with null | The word count value for this EBR_LOG. |
| best_ids | nvarchar(110) | with null | The best ids value for this EBR_LOG. |
Product Name: Unicenter Service Desk
Table Type: Table