View Field Descriptions › View_Issue_Act_Log

Previous Topic: View_Issue

Next Topic: View_Issue_to_Assets

View_Issue_Act_Log

The following is a basic view of all issue activity logs. This is a view of the issue activity log table (issalg) joined with the activity type table (act_type) and the contact table (ca_contact) to give more meaningful data, such as the actual activity type and full name of the analyst who performed the activity.

Field

Remarks

id

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

persid

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

issue_id

issalg.issue_id: The pointer to issue id to which this activity belongs.
issalg.issue_id = issalg.id

last_mod_dt

issalg.last_mod_dt: The last modify date/time (pdmtime).

time_spent

issalg.time_spent: The duration of time spent on this activity, stored as the total number of seconds. For example, 80 = 1 minute, 20 seconds.

time_stamp

issalg.time_stamp: The user modifiable date/time of activity (pdmtime).

system_time

issalg.system_time: The date/time of record creation (pdmtime).

analyst

issalg.analyst: A binary-unique identifier referring to the contact uuid to get the analyst who performed the activity.
issalg.analyst = ca_contact.contact_uuid

description

issalg.description: The text description of this activity, which can be modified by the user.

action_desc

issalg.action_desc: The text description of the automated action, which cannot be modified by the user.

type

issalg.type: The text pointer to a record in the activity type table.
issalg.type = act_type.code

internal

issalg.internal: The integer flag (1 or 0), which indicates if this log entry is intended for all to see or just for internal use.

knowledge_session

issalg.knowledge_session: An identifier for a particular session of a particular user.

knowledge_tool

issalg.knowledge_tool: An indicator of the knowledge tool used for the search, such as NLS_FAQ or EXPERT, and so on.

analyst_lastname

View_Contact_Full.last_name: The Analyst's last name, derived from issalg.analyst = ca_contact.contact_uuid.

analyst_firstname

View_Contact_Full.first_name: The analyst's first name.

analyst_middlename

View_Contact_Full.middle_name: The middle name of the analyst.

activity_type

act_type.sym: The activity type referenced by issalg.type = act_type.code.