action_desc

nvarchar
(4000)

Provides the textual description of the activity log entry.

analyst

byte(16)

ca_contact::uuid

Foreign key to the Contact that created this activity log entry.

call_req_id

nvarchar(30)

Call_Req::persid

This is the Persistent ID (SystemObjectName:id).

description

nvarchar (4000)

Indicates the textual description of this Activity Log.

id

INTEGER

Identifies the unique (to the table) numeric ID.

internal

INTEGER

Marks this as Internal log.

knowledge_ session

nvarchar(80)

Indicates the reference to a knowledge tool session.

knowledge_ tool

nvarchar(12)

Specifies the Knowledge tool used for this activity.

last_mod_dt

INTEGER

Indicates the timestamp of when this record was last modified.

persid

STRING 30

Persistent ID (SystemObjectName:id).

system_time

INTEGER

Indicates the Date and Time of record creation.

time_spent

INTEGER

Specifies the time spent on this activity by the user.

time_stamp

INTEGER

Specifies the Date and Time of the user activity.

type

nvarchar(12)

Act_Type::code

(Not Used) Specifies the acknowledgement, which is a noneditable string enum.
Note: This is a foreign key.