id

INTEGER UNIQUE NOT_NULL KEY

Specifies the unique (to the table) numeric ID.

persid

STRING 30

Specifies the Persistent ID (SystemObjectName:id).

ref_num

STRING 30 UNIQUE NOT_NULL S_KEY

Identifies the reference number.

summary

STRING 240

Identifies the Issue summary text.

description

STRING 4000

Provides a textual description of this Issue.

status

STRING 12

Issue_Status

active_flag

INTEGER NOT_NULL

Flag representing whether this record is active or inactive:

0—Inactive

1—Active

start_date

LOCAL_TIME

Indicates the timestamp of when processing started.

open_date

LOCAL_TIME

Shows the timestamp of when this Issue was opened.

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.

close_date

LOCAL_TIME

Shows the timestamp of when the Issue was closed.

resolve_date

LOCAL_TIME

Indicates the timestamp of when the Change Order was resolved.

rootcause

INTEGER

Rootcause

Foreign key to the id field of the rootcause table, this identifies the Root Cause.

est_total_time

DURATION

Identifies the sum of estimated task time.

actual_total_time

DURATION

Specifies the sum of actual task time.

log_agent

UUID NOT_NULL

ca_contact

Foreign key to the contact_uuid field of the ca_contact table, this identifies who the change request was reported by.

assignee

UUID

ca_contact

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

organization

UUID

ca_organization

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

group_id

UUID

ca_contact

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

affected_contact

UUID

ca_contact

Foreign key to the contact_uuid field of the ca_contact table.

requestor

UUID NOT_NULL

ca_contact

Foreign key to the contact_uuid field of the ca_contact table, this specifies the Affected End User.

category

STRING 12

Issue_Category

Foreign key to the code field of the isscat table, this identifies the Category.

priority

INTEGER NOT_NULL

Priority

Foreign key to the enum field of the pri table, this identifies the Priority.

need_by

LOCAL_TIME

Shows the Need By Date timestamp for this Issue.

est_comp_date

LOCAL_TIME

Shows the estimated completion date for this Issue.

actual_comp_date

LOCAL_TIME

Specifies the actual completion date timestamp.

est_cost

INTEGER

Specifies the estimated cost value for this Issue.

actual_cost

INTEGER

Identifies the actual cost of this Issue.

justification

STRING 240

Identifies the justification value for this Issue.

backout_plan

STRING 240

Identifies the backout plan value for this Issue.

impact

INTEGER

Impact

Foreign key to the enum field of the impact table, this defines the impact.

parent

STRING 30

Issue

Foreign key to the persistent_id field of the iss table, this identifies the Parent.

effort

STRING 240

Identifies the effort value for this Issue.

support_lev

STRING 30

Service_Desc

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

template_name

STRING 30

Foreign key to the template_name field of the iss_tpl table, this identifies the Template name.

sla_violation

INTEGER

Flag indicating the following:

1—Issue has violated its sla.

predicted_sla_ violation

INTEGER

Flag that indicates the following:

1—Has been predicted by neugents.

macro_predicted_ violation

INTEGER

Identifies that it is likely to violate its sla (boolean) for action macros to predict sla violations.

created_via

INTEGER

Interface

Specifies the unique (to the table) numeric ID.

call_back_date

LOCAL_TIME

Identifies the call back timestamp for this Issue.

call_back_flag

INTEGER

Specifies the call back flag value for this Issue.

string1

STRING 40

This is a user-defined string field.

string2

STRING 40

This is a user-defined string field.

string3

STRING 40

This is a user-defined string field.

string4

STRING 40

This is a user-defined string field.

string5

STRING 40

This is a user-defined string field.

string6

STRING 40

This is a user-defined string field.

service_date

LOCAL_TIME

Specifies the service date value for this Issue.

service_num

STRING 30

Specifies the service num value for this Issue.

product

INTEGER

Product

Foreign key to the id field of the product table, this identifies the Product.

actions

STRING 750

Identifies the actions value for this Issue.

type_of_contact

INTEGER

Type_Of_Contact

Foreign key to the id field of the toc table, this identifies the Type of Contact.

reporting_method

INTEGER

Reporting_ Method

Foreign key to the id field of the repmeth table, this identifies how this Issue was reported.

person_contacting

INTEGER

Person_ Contacting

Foreign key to the id field of the person table, this identifies the person who made the contact.

flag1

INTEGER

This is the flag1 value for this Issue.

flag2

INTEGER

This is the flag2 value for this Issue.

flag3

INTEGER

This is the flag3 value for this Issue.

flag4

INTEGER

This is the flag4 value for this Issue.

flag5

INTEGER

This is the flag5 value for this Issue.

flag6

INTEGER

This is the flag6 value for this Issue.

user1

STRING 100

This is a user-defined string field.

user2

STRING 100

This is a user-defined string field.

user3

STRING 100

This is a user-defined string field.

cawf_procid

STRING 40

Identifies the CA Workflow process id.

caextwf_instance_id

INTEGER

caextwf_instances

Indicates the CA Process Automation process instance id and process definition name and reference path launched by this Service Desk object.

ticket_avoided

INTEGER

tenant

UUID

ca_tenant

requested_by

UUID

ca_contact

external_system_ ticket

STRING 4000

orig_user_dept

INTEGER

ca_resource_ department

orig_user_ organization

UUID

ca_organization

orig_user_admin_ org

UUID

ca_organization

orig_user_cost_ center

INTEGER

ca_resource_ cost_ center

target_start_last

LOCAL_TIME

target_hold_last

LOCAL_TIME

target_hold_count

INTEGER

target_resolved_ last

LOCAL_TIME

target_resolved_ count

INTEGER

target_closed_last

LOCAL_TIME

target_closed_ count

INTEGER