| objid | query | objid | Internal record number | 3 (UNIQUE) |
| title | query | title | Name of the query | |
| owner_objid | user | objid | Query owner's objid | |
| owner_login | user | login_name | Query owner's login | |
| obj_type | query | obj_type | Object type ID the query is for; e.g., case=0, solution=1, subcase=24, change request=192 | |
| view_type | query | view_type | Schema view being used for query; differs based on object type | |
| default_val | query | default_val | Indicates whether the query invokes properties, keyphrases, or both | |
| stored_prc_name | query | stored_prc_name | Reserved for the name of the stored procedure for this query | |
| sql_statement | query | sql_statement | SQL code created based on parameters entered by user for this query | |
| keyword_mode | query | keyword_mode | If using keywords, match All or Any | |
| order_val | query | order_val | Ascending or descending sort criteria | |
| shared_pers | query | shared_pers | Indicates whether the query is shareable with users other than the originator; i.e., 0=private, 1=shareable, default=0 | |
| shared_pers_st | query | shared_pers_st | Translates shared_pers | |
| prompt_ind | query | prompt_ind | 0=no prompt, 1=prompt | |
| prompt_ind_st | query | prompt_ind_st | Translates prompt_ind | |