id

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

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.

ref_num

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

summary

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

description

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

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

active_flag

call_req.active_flag: This is an integer flag to determine whether this request record is active (1 or 0).

open_date

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

time_spent_sum

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

last_mod_dt

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

close_date

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

resolve_date

This is the date for when the request was resolved (pdmtime).

rootcause

This is a pointer to the rootcause.id.

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

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

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

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.

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.

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

impact

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

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 urgency table. It indicates 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 is an external reference to an associated ticket.

last_act_id

This identifies the id of the last activity.

cr_tticket

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

parent

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

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

sla_violation

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

predicted_sla_viol

This specifies that a request has been predicted by neugents to likely violate SLA.

macro_predicted_violation

This indicates that the request has been predicted by neugents to likely violate SLA.

created_via

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

call_back_date

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

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.

sched_token

call_req.sched_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 for this request.
call_req.type = crt.code

string1

This is a user-definable string.

string2

This is a user-definable string.

string3

This is a user-definable string.

string4

This is a user-definable string.

string5

This is a user-definable string.

string6

This is a user-definable string.

problem

This is an ITIL problem.

incident_priority

This is an ITIL incident priority.

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.

service_type

srv_desc.sym: This indicates the actual Service Type.
call_req.support_lev = srv_desc.code

severity_num

sevrty.sym: This is the actual Severity number.
call_req.severity = sevrty.enum

urgency_num

urgncy.sym: This indicates the actual Urgency number.
call_req.urgency = urgncy.enum

category_name

prob_ctg.sym: This is the actual Request Area (problem category).
call_req.category = prob_ctg.id

asset

ca_owned_resource.resource_name: This is the actual Asset name.
call_req.affected_rc = ca_owned_resource.own_resource_uuid

impact_num

impact.sym: This is the actual Impact number.
call_req.impact = impact.enum

assignee_lastname

ca_contact.last_name: This is the actual Assignee last name.
call_req.assignee = ca_contact.contact_uuid

assignee_firstname

ca_contact.first_name: This is the actual Assignee first name.
call_req.assignee = ca_contact.contact_uuid

assignee_middlename

ca_contact.middle_name: This is the actual Assignee middle name.
call_req.assignee = ca_contact.contact_uuid

customer_lastname

ca_contact.last_name: This is the actual last name of the Affected End User.
call_req.customer = ca_contact.contact_uuid

customer_firstname

ca_contact.first_name: This is the actual first name of the Affected End User.
call_req.customer.ca_contact.contact_uuid

customer_middlename

ca_contact.middle_name: This is the actual middle name of the Affected End User.
call_req.customer = ca_contact.contact_uuid

group_name

View_Group.last_name: This is the actual Group name.

GroupID

View_Group.contact_uuid: This is the actual Group key ID.

status_name

cr_stat.sym: This is the actual status.

priority_num

pri.sym: This is the actual Priority number.