Call Request Status. Lists the states of the call request. May be added to at will. Allows the user to control whether the call request is active or inactive when it is changed to this status.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Unique (to the table) Numeric ID |
| persid | nvarchar(30) | with null | Persistent ID (SystemObjectName:id) |
| del | integer | not null | Deleted flag (0=active 1=inactive/marked as deleted) |
| sym | nvarchar(30) | not null | Request status name |
| 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 |
| description | nvarchar(500) | with null | Textual description of status |
| code | nvarchar(12) | not null | Primary key of this table |
| active | integer | with null | 0 = inactive, 1 = active |
| hold | integer | with null | 0 = start events, 1 = stop events |
| resolved | integer | with null | 0 = not yet resolved, 1 = resolved |
| cr_flag | integer | with null | When set to 1, this status is valid for requests |
| in_flag | integer | with null | When set to 1, this status is valid for incidents |
| pr_flag | integer | with null | When set to 1, this status is valid for problems |
Product Name: Unicenter Service Desk
Table Type: Table