Issue tables Issue_Act_Log is a history of activities associated with an issue. 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) |
| issue_id | nvarchar(30) | with null | Issue. Foreign key to the persistent_id field of the iss table |
| 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 | Text description of of the activity log. |
| action_desc | nvarchar(4000) | with null | Text description of the activity log entry |
| type | nvarchar(12) | with null | acknowledgement (not used) noneditable string enum for |
| internal | integer | with null | Marks this as Internal log. |
| knowledge_session | nvarchar(80) | with null | Reference to a knowledge tool session |
| knowledge_tool | nvarchar(12) | with null | Knowledge tool used for this activity |
Product Name: Unicenter Service Desk
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| id | view_issue_act_log |