Previous Topic: Priority TableNext Topic: Product Table


Prob_Category Table

Call Request call areas. Category of the issue that the customer is calling about. Can be hierarchical.

Field

Data Type

Reference

Remarks

id

INTEGER

UNIQUE NOT_NULL KEY

Unique (to the table) numeric ID.

persid

STRING (30)

 

Persistent ID (SystemObjectName:id)

del

INTEGER

NOT_NULL

Delete flag that indicates the following:

0—Active

1—Inactive/marked as deleted

sym

STRING (1000)

NOT_NULL S_KEY

Specifies the symbolic name of the request area.

last_mod_dt

LOCAL_TIME

 

Identifies the timestamp of when this record was last modified.

last_mod_by

UUID

ca_contact

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

description

STRING (500)

 

Identifies the textual description of the call area.

organization

UUID

ca_organization

Foreign key to the id field of the ca_organization table, this is the Organization.

assignee

UUID

ca_contact

Foreign key to the contact_uuid field of the ca_contact table, this is the Assignee.

group_id

UUID

ca_contact

Foreign key to the contact_uuid field of the ca_contact table, this is the Group.

tcode

INTEGER

 

Deprecated

service_type

STRING (30)

Service_Desc

Foreign key to the code field of the srv_desc table, this is the Classic Service Type.

survey

INTEGER

Survey_Template

Foreign key of the id field of the survey_tpl table, this is the Survey.

schedule

INTEGER

Bop_Workshift

Deprecated

auto_assign

INTEGER

 

Represents the flag that enables auto assignment.

owning_contract

INTEGER

Service_Contract

Foreign key to the id field of the svc_contract table.This is the Service Contract.

cr_flag

INTEGER

 

Represents the cr_flag status. When set to 1, this status is valid for requests.

in_flag

INTEGER

 

Specifies the Incident flag. When set to 1, the status is valid for Incidents.

pr_flag

INTEGER

 

Specifies the Problem flag. When set to 1, the status is valid for Problems.

suggest_knowledge

INTEGER

 

Specifies whether or not to suggest knowledge to users.

1—Suggest knowledge.

2—Do not suggest knowledge.

assignable_ci_attr

STRING (60)

 

Identifies the name of the attribute on a CI object that contains the grp contact that should be used to perform Category/CI auto group assignment.

cawf_defid

STRING (40)

 

Identifies the CA Workflow process id.

flow_flag

INTEGER

 

Specifies the type of workflow:
0—Classic Workflow or none (default)

1—CA Workflow

2—CA IT PAM

caextwf_start_id

INTEGER

caextwf_start_forms

Identifies the CA IT PAM process definition information to use when the user selects this category on a change order, issue, request.

tenant

UUID

ca_contact

 

ss_include

INTEGER

 

Required.

On new default: 0

ss_sym

STRING (128)

 

 

category_urgency

INTEGER

Urgency

 

sap_prop

INTEGER