id

INTEGER

Specifies the unique (to the table) numeric ID.

persid

nvarchar(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)

S_KEY

REQUIRED Change Category symbolic description.

code

STRING (12)

S_KEY

Primary key of this table.

last_mod_dt

INTEGER

Identifies the timestamp of when this record was last modified.

last_mod_by

byte(16)

ca_contact::uuid

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

description

nvarchar
(500)

Identifies the textual description of this change category.

organization

byte(16)

ca_organization ::organization_ uuid

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

assignee

byte(16)

ca_contact

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

group_id

byte(16)

ca_contact

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

children_ok

INTEGER

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

service_type

STRING (30)

Service_Desc

survey

INTEGER

Survey_Template

schedule

INTEGER

Bop_Workshift

Deprecated.

auto_assign

INTEGER

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.

cawf_defid

nvarchar(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 Process Automation

caextwf_start_id

INTEGER

caextwf_start_forms

Identifies the CA Process Automation 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

Reference to Contact information.

ss_include

INTEGER

REQUIRED

On new default: 0

ss_sym

STRING (128)