issstat

Issue Status. Lists the states of the Issue. May be added to at will. Allows the user to control whether the issue 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 Issue status symbolic 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 Text 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

Product Name: Unicenter Service Desk

Table Type: Table


Copyright © 2006 CA. All rights reserved.