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.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Primary key of this table |
| persid | nvarchar(30) | with null | Persistent ID (SystemObjectName:id) |
| change_id | integer | with null | Change Order. Foreign key to the id field of the chg table of which the activity log belongs |
| last_mod_dt | integer | with null | Timestamp of when this record was last modified |
| time_spent | integer | with null | Time spent on activity (user) |
| time_stamp | integer | with null | Datetime of activity (user) |
| system_time | integer | with null | Datetime of record creation |
| analyst | byte(16) | with null | Analyst who created this activity log. Foreign key to the contact_uuid field of the ca_contact table |
| description | nvarchar(4000) | with null | Textual description of this activity log |
| action_desc | nvarchar(4000) | with null | Text description of the activity log entry |
| type | nvarchar(12) | with null | Activity log type. Foreign key to the code field of the act_type table. |
| internal | integer | with null | Marks this as Internal log. |
| knowledge_session | nvarchar(80) | with null | The knowledge session value for this Change_Act_Log. |
| knowledge_tool | nvarchar(12) | with null | The knowledge tool value for this Change_Act_Log. |
Product Name: Unicenter Service Desk
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| id | view_change_act_log |