id

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

persid

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

issue_ref_num

issue.iss_ref_num: The Issue reference number, which is used by analysts and customers to refer to a particular issue.

description

issue.description: The long description of an issue as dictated by an analyst or customer.

status

issue.status: The unique identifier of an issue status, which is a pointer to the issstat table.
issue.status = issstat.code

active_flag

issue.active_flag: The integer flag used to determine whether this issue is active (1 or 0).

start_date

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

open_date

issue.open_date: The issue creation date (pdmtime).

last_mod_dt

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

last_mod_by

issue.last_mod_by: The pointer to the contact uuid, which indicates the last contact to modify this issue.
issue.last_mod_by = ca_contact.contact_uuid

close_date

issue.close_date: The date the issue was set to inactive (pdmtime).

resolve_date

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

rootcause

issue.rootcause: A pointer to a record in the rootcause table, which represents the original situation that required this issue to be logged.
issue.rootcause = rootcause.id

est_total_time

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

actual_total_time

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

log_agent

issue.log_agent: A binary-unique identifier, this references the ca_contact table, which in turn references the person who was the issue's original creator.
issue.log_agent = ca_contact.contact_uuid

assignee

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

organization

issue.organization: A pointer to the internal organization uuid, which represents the organization to whom this issue belongs.
issue.organization = ca_organization.organization_uuid

group_id

issue.group_id: A pointer to the contact uuid, which represents the group currently assigned to the issue.
issue.group_id = ca_contact.contact_uuid

affected_contact

issue.affected_contact: A pointer to the contact uuid, which represents the affected contact for this issue.
issue.affected_contact = ca_contact.contact_uuid

requestor

issue.requrestor: A pointer to the contact uuid, which represents the person who asked this issue to be logged.
issue.requestor = ca_contact.contact_uuid

category

issue.category: A pointer to the issue category code to reference the category into which this issue falls.
issue.category = isscat.code

priority

issue.priority: A pointer to priority enum, which represents the priority into which this issue falls.
issue.priority = pri.enum

need_by

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

est_comp_date

issue.est_comp_date: The estimated completion date (pdmtime) for this Issue.

actual_comp_date

issue.actual_comp_date: The actual completion date (pdmtime) of this issue.

est_cost

issue.est_cost: The estimated cost of this issue.

actual_cost

issue.actual_cost: The actual cost to implement this issue.

justification

issue.justification: A text field, which allows a requester to document the reason(s) this issue is required.

backout_plan

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

impact

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

parent

issue.parent: A pointer to another issue id, which allows creation of a hierarchy of issues.
issue.parent = issue.id

effort

issue.effort: A text field which explains the plan for implementing this issue.

support_lev

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

template_name

issue.template_name: The name of and pointer to an issue template.
issue.template_name = iss_template.template_name

sla_violation

issue.sla_violation: The integer to count the number of times slas attached to this issue have been violated.

predicted_sla_viol

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

macro_predict_viol

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

created_via

issue.created_via: A pointer to a record in the interface table. This indicates from which interface the issue originated.
issue.created_via = interface.id

call_back_date

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

call_back_flag

issue.call_back_flag: A boolean indicator displayed as a checkbox to the user, to indicate whether to notify the analyst at the issue.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

issue.service_date: The Date/ Time (pdmtime) that an outside vendor is expected to service this issue.

service_num

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

product

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

actions

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

type_of_contact

issue.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 issue.
issue.type_of_contact = toc.id

reporting_method

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

person_contacting

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

status_name

issstat.sym: The description of the status as seen by a user.
issue.status = issstat.code

priority_num

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

category_name

isscat.sym: The name of the issue category as viewed by a user.
issue.category = isscat.code

organization_name

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

affected_end_user_lastname

ca_contact.last_name: The affected End User's last name.
issue.affected_end_user = ca_contact.contact_uuid

affected_end_user_firstname

ca_contact.first_name: The affected End User's first name.
issue.affected_end_user = ca_contact.contact_uuid

affected_end_user_middlename

ca_contact.middle_name: The affected End User's middle name.
issue.affected_end_user = ca_contact.contact_uuid

assignee_lastname

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

assignee_firstname

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

assignee_middlename

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

groupID

View_Group.contact_uuid: A binary representation of the internal id used for the group assigned to this issue.
issue.group_id = ca_contact.contact_uuid

group_name

View_Group.last_name: The name of the group assigned to this issue.
issue.group = ca_contact.contact_uuid

service_type

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

impact_num

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

product_sym

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

type_of_contact_sym

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

rpting_method_sym

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

person_contacting_sym

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

created_via_sym

interface.sym: issue.created_via = interface.id.

rootcause_sym

rootcause.sym: issue.rootcause = rootcause.id.