action_desc

nvarchar(700)

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(1000)

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.

last_mod_dt

INTEGER

Indicates the timestamp of when this record was last modified.

mgs_id

INTEGER

Managed
_Survey
::id

Specifies the unique (to the table) numeric ID.

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 date time spent on the activity by the user.

type

nvarchar(12)

Act_Type
::code

Foreign key to the code field of the act_type table, this is the Type.