Previous Topic: Call_Solution TableNext Topic: Change_Category Table

Data Element Dictionary › Change_Act_Log Table

Change_Act_Log Table

Change manager tables Change_Act_Log is a history of activities associated with a change request. The types of activities are listed in the Act_Type table.

Field

Data Type

Reference

Remarks

action_desc

nvarchar(4000)

 

Shows 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 is the Analyst who created this activity log.

change_id

INTEGER

chg id

Foreign key to the id field of the chg table to which the activity log belongs. This is a Change Order.

description

nvarchar(4000)

 

Textual description of this activity log

id

INTEGER

 

Unique numeric ID that is the Primary key of this table.

internal

INTEGER

 

Marks this as 'Internal' log.

knowledge_
session

nvarchar(80)

 

The knowledge session value for this Change_Act_Log.

knowledge_tool

nvarchar(12)

 

The knowledge tool value for this Change_Act_Log.

last_mod_dt

INTEGER

 

Specifies the date of when this record was last modified.

persid

nvarchar(30)

 

Persistent ID (SystemObjectName:id).

system_time

INTEGER

 

Specifies the date and time of record creation.

time_spent

INTEGER

 

Specifies the time spent by the user on the activity.

time_stamp

INTEGER

 

Specifies the date and time time of activity by the user.

type

nvarchar(12)

Act_Type::
code

Identifies the Activity log type.
Note: This is the Foreign key to the code field of the act_type table.