saprobtyp

Problem type definitions used with automated creation policies within Unicenter Service Desk applications.

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(40) not null Symobolic name of problem type
code nvarchar(20) not null Unique code name
description nvarchar(300) with null Textual description
owning_policy integer with null The owner of this problem type
ticket_tmpl_fac nvarchar(20) with null factory of the ticket template
ticket_tmpl_id integer with null Id of the ticket template
ticket_tmpl_name nvarchar(40) with null Name of the ticket template
is_default integer with null One and only one for all policies.
ret_usr_1 nvarchar(500) with null Text passed back to human for ticket creation.
ret_app_1 nvarchar(500) with null Text passed back to program for ticket creation.
dup_action integer with null enum for action to handle ticket duplication
dup_interval integer with null Time range for searching duplicate tickets
is_internal integer with null OTB problem types cannot be deleted.
last_mod_by byte(16) with null Specifies the uuid of the contact who last modified this record
last_mod_dt integer with null Timestamp of when this record was last modified

Product Name: Unicenter Service Desk

Table Type: Table


Copyright © 2006 CA. All rights reserved.