action_desc

nvarchar(4000)

Specifies the text description of the activity log entry.

analyst

byte(16)

ca_contact::uuid

Foreign key to the contact_uuid field of the ca_contact table, this represents the Analyst who created this activity log.

description

nvarchar(4000)

Specifies the text description of the activity log.

id

INTEGER

Primary key of this table, this is a unique numeric ID.

internal

INTEGER

Designates the log as an Internal log.

issue_id

nvarchar(30)

issue persistent_id

Foreign key to the persistent_id field of the iss table, this is the Issue for this activity.

knowledge_
session

nvarchar(80)

Specifies the reference to the Knowledge Tool session.

knowledge_tool

nvarchar(12)

Identifies the Knowledge Tool used for this activity.

last_mod_dt

INTEGER

Identifies the timestamp of when this record was last modified.

persid

nvarchar(30)

Specifies the Persistent ID (SystemObjectName:id).

system_time

INTEGER

Represents the date and time of the record creation.

time_spent

INTEGER

Identifies the time spent on the activity by the user.

time_stamp

INTEGER

Specifies the time spent on the activity by the user.

type

nvarchar(12)

Act_Type::code

(Not Used) This is an acknowledgement that is also a non-editable string enum.