tskstat

Workflow task states. possible states: wait, pending, approve, reject, etc.

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 Task 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 Text description of status
code nvarchar(12) not null Primary key of this table
allow_task_update integer not null 0=not updateable,1=updateable
no_update_msg nvarchar(500) with null Cannot update message
task_complete integer not null 0=no,1=yes
do_next_task integer not null 0=no,1=yes
allow_accumulate integer not null 0=dont accumulate,1=yes
hold integer not null 0 = start events, 1 = stop events
is_internal integer not null 0=no 1=yes, dont display in most status selections.

Product Name: Unicenter Service Desk

Table Type: Table


Copyright © 2006 CA. All rights reserved.