id

INTEGER

Unique (to the table) numeric ID.

persid

STRING(30)

Persistent ID (SystemObjectName:id)

del

INTEGER

Active_Boolean_ Table::enum

Delete flag that indicates the following:
0—Active
1—Inactive/marked as deleted

sym

STRING(1000)

Identifies the Issue Category symbolic description.

code

STRING (12)

Primary key of this table.

last_mod_dt

LOCAL_TIME

Identifies the timestamp of when this record was last modified.

last_mod_by

UUID

ca_contact::uuid

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

description

STRING
(500)

Identifies the textual description of this issue category.

organization

UUID

ca_organization:: organization_uuid

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

assignee

UUID

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

group_id

UUID

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

children_ok

INTEGER

Specifies the handling of the issue category:
0—Children not allowed
1—Children are allowed

service_type

STRING (30)

Service_Desc

survey

INTEGER

Survey_Template::id

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

schedule

INTEGER

Bop_Workshift

Deprecated.

auto_assign

INTEGER

Flag that enables auto assignment.

owning_
contract

INTEGER

Service_Contract::id

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

cawf_defid

STRING(40)

Identifies the CA Workflow definition 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_tenant

chgtype

INTEGER

usp_change_type

risk_survey

INTEGER

Risk_Survey_Template

cab

UUID

ca_contact

ss_include

INTEGER

bool

REQUIRED

On new default: 0

ss_sym

STRING (128)