id

chg.id: The unique identifier for this record in the chg table.

persid

chg.persid: The unique identifier for this record in the chg table, preceded by the object identifier (chg for table chg) and a colon.

chg_ref_num

chg.chg_ref_num: The change order reference number, which is used by analysts and customers to refer to a particular change order.

description

chg.description: The long description of a change order, as dictated by an analyst or customer.

status

chg.status: The unique identifier of a change order status, which is a pointer to the chgstat table.
chg.status = chgstat.code.

active_flag

chg.active_flag: The integer flag to determine whether this change record is active or not (1 or 0).

start_date

chg.start_date: The date the first task goes to a pending status (pdmtime).

open_date

chg.open_date: The change order creation date (pdmtime).

last_mod_dt

chg.last_mod_dt: The last modified date (pdmtime).

last_mod_by

chg.last_mod_by: The pointer to the contact uuid who was the last contact to modify this change order.
chg.last_mod_by = ca_contact.contact_uuid.

close_date

chg.close_date: The date the change order was set to inactive (pdmtime).

resolve_date

chg.resolve_date: The date the change order was set to a status configured to indicate the change was resolved (pdmtime).

rootcause

chg.rootcause: A pointer to a record in the rootcause table, which represents the original situation which required this change order to be executed.
chg.rootcause = rootcause.id.

est_total_time

chg.est_total_time: The estimated total time (pdmtime) it will take to complete this change.

actual_total_time

chg.actual_total_time: The actual total time (pdmtime) it took to complete this change.

log_agent

chg.log_agent: A binary unique identifier referencing the ca_contact table, referencing the person who was the change's original creator.
chg.log_agent = ca_contact.contact_uuid.

assignee

chg.assignee: The pointer to the contact uuid who is currently assigned to the change order.
chg.assignee = ca_contact.contact_uuid.

organization

chg.organization: The pointer to internal organization uuid, which represents the organization to whom this change order belongs.
chg.organization = ca_organization.organization_uuid.

group_id

chg.group_id: The pointer to contact uuid, which represents the group currently assigned to the change order.
chg.group_id = ca_contact.contact_uuid

affected_contact

chg.affected_contact: The pointer to the contact uuid, which represents the affected contact for this change order.
chg.affected_contact = ca_contact.contact_uuid

requestor

chg.requrestor: The pointer to the contact uuid, which represents the person who ordered the change.
chg.requestor = ca_contact.contact_uuid

category

chg.category: The pointer to the change category code to get the category into which this change falls.
chg.category = chgcat.code

priority

chg.priority: The pointer to priority enum, which represents the priority into which this change falls.
chg.priority = pri.enum

need_by

chg.need_by: The date which indicates when the affected_end_user needs to have the change completed (pdmtime).

est_comp_date

chg.est_comp_date: The estimated completion date (pdmtime) for this Change Order.

actual_comp_date

chg.actual_comp_date:The actual completion date (pdmtime) of this change order.

est_cost

chg.est_cost: The estimated cost of this change order.

actual_cost

chg.actual_cost: The actual cost to implement this change order.

justification

chg.justification: A text field which allows a requestor to document the reason(s) this change is required.

backout_plan

chg.backout_plan: A text field that allows an analyst to document a backout plan for this change.

impact

chg.impact: A pointer to an impact table record, which indicates the scope of resources that this change affects.
chg.impact = impact.enum

parent

chg.parent: A pointer to another change request id, which allows creation of a hierarchy of change orders.
chg.parent = chg.id

effort

chg.effort: A text field which explains the plan for implementing this change order.

support_lev

chg.support_lev: A pointer to a service desc record, which automates some constraints for which this change must be completed.
chg.support_lev = srv_desc.code

template_name

chg.template_name: The name of and pointer to a change order template.
chg.template_name = chg_template.template_name

sla_violation

chg.sla_violation: The integer to count the number of times slas attached to this "change has been violated".

predicted_sla_viol

chg.predicted_sla_viol: (r5.5) Neugent related technology field.

macro_predict_viol

chg.macro_predict_viol: (r5.5) Neugent related technology field.

created_via

chg.created_via: A pointer to a record in the interface table, which indicates from which interface the change order originated. chg.created_via = interface.id

call_back_date

chg.call_back_date:A date/time field (pdmtime), which indicates a future date/time the requestor is to be contacted.

call_back_flag

chg.call_back_flag: A boolean indicator displayed as a checkbox to the user, indicating whether or not to notify the analyst at the chg.call_back_date.

string1

This is a user-definable text field.

string2

This is a user-definable text field.

string3

This is a user-definable text field.

string4

This is a user-definable text field.

string5

This is a user-definable text field.

string6

This is a user-definable text field.

service_date

chg.service_date: The Date/ Time (pdmtime) that an outside vendor is expected to spend to service this change order.

service_num

chg.service_num: The text field to document an outside vendor's service or purchase order number.

product

chg.product: A pointer to a record in the product table, which indicates the product that is affected by this change.
chg.product = product.id

actions

chg.actions: A big text field for documenting actions.

type_of_contact

chg.type_of_contact: A pointer to a record in the toc table, which indicates a general categorization of the affected_end_user's perspective of the change order.
chg.type_of_contact = toc.id

reporting_method

chg.reporting_method: A pointer to a record in the repmeth table, which classifies the origination of the change order, and is selected by the person creating the change order.
chg.reporting_method = repmeth.id

person_contacting

chg.person_contacting: A pointer to a record in the perscon table, which indicates the role of the affected_end_user or requestor.
chg.person_contacting = perscon.id

status_name

chgstat.sym: The description of the status as seen by a user.
chg.status = chgstat.code

priority_num

pri.sym: The description of the priority as seen by a user.
chg.priority = pri.enum

category_name

chgcat.sym: The name of the Change Category as viewed by a user.
chg.category = chgcat.code

organization_name

ca_organization.org_name: The name of an organization as viewed by a user.
chg.organization = ca_organization.organization_uuid

affected_end_user_lastname

ca_contact.last_name: The affected end user's last name.
chg.affected_end_user = ca_contact.contact_uuid

affected_end_user_firstname

ca_contact.first_name: The affected end user's first name.
chg.affected_end_user = ca_contact.contact_uuid

affected_end_user_middlename

ca_contact.middle_name: The affected end user's middle name.
chg.affected_end_user = ca_contact.contact_uuid

requester_lastname

ca_contact.last_name: The requestor's last name.
chg.requestor = ca_contact.contact_uuid

requester_firstname

ca_contact.first_name: The requestor's first name.
chg.requestor = ca_contact.contact_uuid

requester_middlename

ca_contact.middle_name: The requestor's middle name.
chg.requestor = ca_contact.contact_uuid

business

ca_organization.org_name: The name of the Requester's organization as seen by users.
chg.requestor = ca_organization.organization_uuid

assignee_lastname

ca_contact.last_name: The assignee's last name.
chg.assignee = ca_contact.contact_uuid

assignee_firstname

ca_contact.first_name: The assignee's first name.
chg.assignee = ca_contact.contact_uuid

assignee_middlename

ca_contact.middle_name: The assignee's middle name.
chg.assignee = ca_contact.contact_uuid

groupID

ca_contact.contact_uuid: A binary representation of the internal id used for the group assigned to this change order.
chg.group_id = ca_contact.contact_uuid

group_name

ca_contact.last_name: The name of the group assigned to this change order.
chg.group = ca_contact.contact_uuid

service_type

srv_desc.sym: The name of the service type applied to this change order.
chg.support_lev = srv_desc.code

impact_num

impact.sym: The description of the impact as seen by users.
chg.impact = impact.enum

product_sym

product.sym: The product description as seen by users.
chg.product = product.id

type_of_contact_sym

toc.sym: The Type Of Contact description as seen by users.
chg.type_of_contact = toc.id

rpting_method_sym

repmeth.sym: The Reporting method description as seen by users.
chg.reporting_method = repmeth.id

person_contacting_sym

perscon.sym: The Person Contacting description as seen by users.
chg.person_contacting = perscon.id