id

INTEGER UNIQUE NOT_NULL KEY

Primary key of this table, this is a unique numeric ID.

persid

STRING 30

Specifies the Persistent ID (SystemObjectName:id).

chg_ref_num

STRING 30 UNIQUE NOT_NULL S_KEY;

Shows a User visible reference number.

summary

STRING 240

Identifies the Change Order summary text.

description

STRING 4000

Provides a textual description of this Change Order.

status

STRING 12

Change_Status

Foreign key to the code field of the chgstat table, this identifies the Status.

active_flag

INTEGER NOT_NULL

Boolean_Table::benum

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 Change Order was created.

last_mod_dt

LOCAL_TIME

Identifies the timestamp of when this record was last modified.

last_mod_by

UUID REF

ca_contact

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

close_date

LOCAL_TIME

Shows the timestamp of when the Change Order 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

NOT_NULL

ca_contact

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

requestor

UUID

NOT_NULL

ca_contact

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

category

STRING 12

Change_Category

Foreign key to the code field of the chgctg 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.

est_comp_ date

LOCAL_TIME

Shows the timestamp for the estimated completion date.

actual_comp_ date

LOCAL_TIME

Specifies the actual completion date timestamp.

est_cost

INTEGER

Specifies the estimated cost of this Change Order.

actual_cost

INTEGER

Identifies the actual cost of this Change Order.

justification

STRING 4000

Identifies the justification value for this Change_Request.

backout_plan

STRING 4000

Identifies the backout plan value for this Change_Request.

risk

INTEGER

Risk_Level

business_case

STRING 4000

cab

UUID

ca_contact

closure_code

INTEGER

Closure_Code

impact

INTEGER

Impact

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

parent

INTEGER

Change_Request

Foreign key to the id field of the chg table to allow for hierarchical Change Order groupings (for example, "parent/child").

effort

STRING 2000

Identifies the effort value for this Change_Request.

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 chg_tpl table, this identifies the Template name.

sla_violation

INTEGER

Flag indicating the following:

1—change order has violated its sla.

predicted_sla_ violation

INTEGER

Flag that indicates the following:

1—change order 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

Foreign key to the id field of the interface table, this identifies which interface created the Change request.

call_back_date

LOCAL_TIME

Identifies the call back timestamp for this Change Order.

call_back_flag

INTEGER

Specifies the call back flag value for this Change Order.

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 Change_Request.

service_num

STRING 30

Specifies the service num value for this Change_Request.

product

INTEGER

Product

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

actions

STRING 750

type_of_contact

INTEGER

Type_Of_Contact

reporting_method

INTEGER

Reporting_Method

Foreign key to the id field of the repmeth table, this identifies how this Change Order 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 a user-defined integer flag.

flag2

INTEGER

This is a user-defined integer flag.

flag3

INTEGER

This is a user-defined integer flag.

flag4

INTEGER

This is a user-defined integer flag.

flag5

INTEGER

This is a user-defined integer flag.

flag6

INTEGER

This is a user-defined integer flag.

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.

project

UUID

ca_owned_ resource

tenant

UUID

ca_tenant

sched_start_ date

LOCAL_TIME

sched_end_ date

LOCAL_TIME

sched_duration

DURATION

actual_start_date

LOCAL_TIME

actual_end_ date

LOCAL_TIME

chgtype

INTEGER

usp_change_ type

cab_approval

INTEGER

Boolean_Table

requested_by

UUID REF

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_ ast

LOCAL_TIME

target_hold_ count

INTEGER

target_resolved_ last

LOCAL_TIME

target_resolved_ count

INTEGER

target_closed_ last

LOCAL_TIME

target_closed_ count

INTEGER

target_start_ last

LOCAL_TIME

Time when target timer started or restarted.

target_hold_ last

LOCAL_TIME

Time of most recent ticket hold

target_hold_ count

INTEGER

Number of times ticket went into a Hold status

target_resolved_ last

LOCAL_TIME

Time of most recent ticket resolution

target_resolved_count

INTEGER

Number of times ticket was resolved

target_closed_ last

LOCAL_TIME

Time ticket was last closed

target_closed_ count

INTEGER

Number of times that ticket was closed