View_Change.*

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

chgalg_id

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

chgalg_persid

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

change_id

chgalg.change_id: This is a pointer to change the order id to which this activity belongs.
chgalg.change_id = chgalg.id

chgalg_last_mod_dt

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

time_spent

chgalg.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

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

system_time

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

analyst

chgalg.analyst: The uuid pointer to contact uuid to get the analyst who performed the activity.
chgalg.analyst = ca_contact.contact_uuid

chgalg_description

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

action_desc

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

type

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

internal

chgalg.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

chgalg.knowledge_session: This is an identifier for a particular session of a particular user.

knowledge_tool

chgalg.knowledge_tool: This is an indicator of the knowledge tool used for the search, such as NLS_FAQ or EXPERT, and so on.

chgalg_analyst_id

chgalg.analyst: This is the uuid pointer to contact uuid to get the analyst who performed the activity.
chgalg.analyst = ca_contact.contact_uuid