Custom bin stored queries. System administrators may add to this table at will. Determines which queries may be used by help desk analysts to customize their scoreboard with.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Unique (to the table) numeric identifier. |
| persid | nvarchar(30) | with null | Persistent ID (SystemObjectName:id) |
| del | integer | not null | Deleted flag (0=active 1=inactive/marked as deleted) |
| last_mod_dt | integer | with null | Timestamp of when this record was last modified |
| last_mod_by | byte(16) | with null | Specifies the uuid of the contact who last modified this record |
| code | nvarchar(12) | not null | Noneditable handle for query |
| description | nvarchar(240) | with null | Textual description of this stored query |
| criteria | nvarchar(4000) | with null | Where clause for query |
| count_url | nvarchar(240) | with null | URL for counts if obj_type=url |
| label | nvarchar(80) | with null | Display label for the scoreboard; This should be large enough to accomodate expansions. |
| obj_type | nvarchar(30) | with null | The object type to query on. |
Product Name: Unicenter Service Desk
Table Type: Table