Previous Topic: Call_Req_Type TableNext Topic: Change_Act_Log Table


Call_Solution Table

This table exists in the schema for backward compatibility only. Although there is an interface to it, you should not use this table at all; however, it is important that you not delete it from the schema.

Field

Data Type

Reference

Remarks

description

STRING 500

 

Specifies the problem description.

cr_count

INTEGER

 

Specifies the call request usage count:
0—Yes
1—No call request usage count

cr_flag

INTEGER

 

Indicates the call request manager flag used by ITIL code.

del

INTEGER NOT_NULL

Active_
Boolean_
Table::enum

Specifies the status of the Deleted flag:
0—Active
1—Inactive/marked as deleted.

id

INTEGER UNIQUE NOT_NULL KEY

 

Indicates the numeric ID that is unique to the table.

in_flag

INTEGER

 

Specifies the in_flag used by ITIL code.

last_mod_dt

LOCAL_TIME

 

Indicates the timestamp for when this record was last modified.

nx_desc

STRING 40

 

Specifies the name for prob_mgr cbox table.

persid

STRING 30

 

Indicates the Persistent ID:
SystemObjectName:id

pr_flag

INTEGER

 

Specifies the pr_flag used by ITIL code.

sapproved

INTEGER

Boolean_
Table::enum

Indicates the status of solution approved.

sname

STRING 40

 

Specifies the solution name.

solution

STRING 1000

 

Specifies the solution description.

sym

STRING 60 NOT_NULL S_KEY

 

Specifies the symbol for the solution.

tcode

INTEGER

 

This field is no longer used.