id

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

persid

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

call_req_id

act_log.call_req_id: Pointer to call request persid to which this activity belongs. act_log.call_req_id = call_req.persid.

last_mod_dt

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

time_spent

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

act_log.time_stamp: User modifiable date/time of activity (pdmtime).

system_time

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

analyst

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

description

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

action_desc

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

type

act_log.type: The text pointer to a record in the activity type table. For example, act_log.type = act_type.code.

knowledge_session

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

knowledge_tool

act_log.knowledge_tool: An indicator of the knowledge tool used for the search, such as NLS_FAQ or EXPERT, etc.

internal

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

activity_type

act_type.symActivity: The type derived from act_log.type = act_type.code.

analyst_lastname

View_Contact_Full.last_name: The analyst's last name, derived from act_log.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 analyst's middle name.