View_Change.*

This shows all fields listed in the View_Change view defined earlier in this document.

cr_id

call_req.id: This is the unique identifier for this record in the call_req table.

ref_num

call_req.ref_num: This is the Request reference number, which is used by analysts and customers to refer to a particular Request.

cr_summary

call_req.summary: This is a brief description of the request for quick reference.

cr_persid

call_req.persid: This is a unique identifier for this record in the call_req table, preceded by the object identifier (cr for table call_req) and a colon.

cr_description

call_req.description: This is the long description of a request, as dictated by an analyst or customer.

cr_status

call_req.status: This is a unique identifier referencing a record in the cr_stat table. It indicates the status of this request:
call_req.status = cr_stat.code

cr_active_flag

call_req.active_flag: This is the Integer flag used to determine whether this request record is active (1 or 0).

time_spent_sum

call_req.time_spent_sum: This is the derived total of all act_log records' time_spent fields, stored in seconds (i.e. 80 = 1 minute 20 seconds).

cr_open_date

call_req.open_date: This is the Request creation timestamp (pdmtime).

cr_last_mod_dt

call_req.last_mod_dt: This is the last modified timestamp (pdmtime).

cr_close_date

call_req.close_date: This is the Timstamp for when the request was set to inactive (pdmtime).

cr_log_agent

call_req.log_agent: This is a binary unique identifier referencing the ca_contact table. It references the person who was the request's original creator.
call_req.log_agent = ca_contact.contact_uuid

cr_group_id

call_req.group_id: This is a binary unique identifier referencing a record in the ca_contact table. It represents the group currently assigned to the request.
call_req.group_id = ca_contact.contact_uuid

cr_assignee

call_req.assignee: This is a binary unique identifier referencing a record in the ca_contact table. It represents the person currently assigned to the request.
call_req.assignee = ca_contact.contact_uuid

customer

call_req.customer: This is a binary unique identifier referencing a record in the ca_contact table. It represents the affected end user for this request.
call_req.customer = ca_contact.contact_uuid

charge_back_id

charge_back_id: This is a text field available for use as an indicator of accounting jargon for expensing this request to the appropriate cost center.

affected_rc

call_req.affected_rc: This is a binary unique identifier referencing a row in the ca_owned_resource table. It represents the asset to which this request applies.
call_req.affected_rc = ca_owned_resource.own_resource_uuid.

cr_support_lev

call_req.support_lev: This is a pointer to a service desc record, which automates some constraints under which this request must be completed.
call_req.support_lev = srv_desc.code

cr_category

call_req.category: This is a unique identifier referencing a record in the prob_ctg table,. It represents the category to which this request belongs.
call_req.category = prob_ctg.persid

solution

call_req.solution: This is a pointer to call solution to get solution.
call_req.solution = crsol.persid

cr_impact

call_req.impact: This is an integer unique identifier referencing a row in the impact table. It indicates the scope this request is affecting.
call_req.impact = impact.enum

cr_priority

call_req.priority: This is an integer unique identifier referencing a record in the pri table. It indicates how analysts will prioritize the work associated with this request.
call_req.priority = pri.enum

urgency

call_req.urgency: This is an integer unique identifier referencing a row in the urgncy table. It documents the user's feeling of urgency for having this request resolved.
call_req.urgency = urgncy.enum

severity

call_req.severity: This is an integer unique identifier referencing a row in the severity table. It indicates the severity of the consequences of this unresolved request.
call_req.severity = sevrty.enum

extern_ref

This specifies an associated ticket.

last_act_id

This is the id of the last activity.

cr_tticket

This is a pointer to a trouble ticket to get the associated ticket.

cr_parent

call_req.parent: This is a persid pointer to another request persid, which facilitates creation of a hierarchy of change orders.
call_req.parent = call_req.persid

cr_template_name

call_req.template_name: This is a text value, which indicates this request is designated for and can be chosen from a list as a template for other similar requests.
cr_template.template = call_req.persid

cr_sla_violation

call_req.sla_violation: This is an integer, which counts number of times slas attached to this request have been violated.

cr_predicted_sla_viol

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

cr_created_via

call_req.created_via: This is an integer pointer to a record in the interface table. It indicates from which interface the change order originated.
call_req.created_via = interface.id

cr_call_back_date

call_req.call_back_date: This is a timestamp field (pdmtime), which indicates a future date/time the affected_end_user is to be contacted.

cr_call_back_flag

call_req.call_back_flag: This is a Boolean indicator displayed as a checkbox to the user, indicating whether to notify the analyst at the call_req.call_back_date.

event_token

call_req.event_token: This is used by CA NSM for message matching.

type

call_req.type: This is a text field referencing a record in the crt table. It indicates the ITIL type of this request.
call_req.type = crt.code

cr_string1

This is a user-definable string.

cr_string2

This is a user-definable string.

cr_string3

This is a user-definable string.

cr_string4

This is a user-definable string.

cr_string5

This is a user-definable string.

cr_string6

This is a user-definable string.

change

call_req.change: This is an integer unique identifier, referencing a row in the chg table. It indicates the change order that was created as a result of this request.
call_req.change = chg.id.