Change Request Status. Lists the states of the change request. May be added to at will. Allows the user to control whether the change request is active or inactive when it is changed to this status. possible status: open , approval in process, implementation in progress, verification in progress, cancelled, suspended, closed
| 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 | Change 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 this 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 |
Product Name: Unicenter Service Desk
Table Type: Table