Act_Log is a history of activities associated with a call 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 | Unique (to the table) Numeric ID |
| persid | nvarchar(30) | with null | Persistent ID (SystemObjectName:id) |
| call_req_id | nvarchar(30) | with null | Persistent ID (SystemObjectName:id) |
| 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 | Foreign key to the Contact that created this activity log entry |
| 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(30) | with null | Acknowledgement (not used) noneditable string enum for |
| knowledge_session | nvarchar(80) | with null | Reference to a knowledge tool session |
| knowledge_tool | nvarchar(12) | with null | Knowledge tool used for this activity |
| internal | integer | with null | Marks this as Internal log. |
Product Name: Unicenter Service Desk
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| id | view_act_log |