crsol

Call Request solutions. Solution used to resolve the call request. Ma

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)
sym nvarchar(60) not null Symbol for solution
last_mod_dt integer with null Timestamp of when this record was last modified
sname nvarchar(40) with null Solution name
description nvarchar(500) with null Problem description
nx_desc nvarchar(40) with null Name for prob_mgr cbox table
solution nvarchar(1000) with null Solution description
sapproved integer with null Solution approved
cr_count integer with null 0=yes,1=no call request usage count
tcode integer with null No longer used.
cr_flag integer with null Manager Used by ITIL code
in_flag integer with null Used by ITIL code
pr_flag integer with null Used by ITIL code

Product Name: Unicenter Service Desk

Table Type: Table


Copyright © 2006 CA. All rights reserved.