Previous Topic: sa_portal_component TableNext Topic: sa_property Table


SA_Prob_Type Table

Problem type definitions used with automated creation policies within CA SDM applications.

Field

Data Type

Reference

Remarks

description

STRING 300

 

Specifies the textual description.

code

STRING 20 UNIQUE NOT_NULL S_KEY

 

Specifies the unique code name.

del

INTEGER NOT_NULL

Active_Boolean_ Table::enum

Deleted flag

0—Active

1—Inactive/marked as deleted

dup_action

INTEGER

 

Specifies the enum for action to handle ticket duplication.

dup_interval

DURATION

 

Indicates the time range for searching duplicate tickets.

id

INTEGER UNIQUE NOT_NULL KEY

 

Unique (to the table) Numeric ID

is_default

INTEGER

 

Specifies the one and only one for all policies.

is_internal

INTEGER

Active_Boolean_ Table::enum

Specifies that the default problem types cannot be deleted.

last_mod_by

UUID

ca_contact::uuid

Specifies the UUID of the contact who last modified this record.

last_mod_dt

LOCAL_TIME

 

Indicates the timestamp of when this record was last modified.

owning_policy

INTEGER

SA_Policy::id

Specifies the owner of this problem type.

persid

STRING 30

 

Persistent ID (SystemObjectName:id)

ret_app_1

STRING 500

 

Specifies the text passed back to program for ticket creation.

ret_usr_1

STRING 500

 

Specifies the text passed back to human for ticket creation.

sym

STRING 40 NOT_NULL

 

Specifies the symobolic name of problem type.

ticket_tmpl_fac

STRING 20

 

Specifies the factory of the ticket template.

ticket_tmpl_id

INTEGER

 

Specifies the id of the ticket template.

ticket_tmpl_ name

STRING 40

 

Specifies the name of the ticket template