Act_Log is a history of activities associated with a managed survey. 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) |
| mgs_id | integer | with null | Unique (to the table) Numeric 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 | Ananlyst. Foreign key to the contact_uuid field of the ca_contact table |
| description | nvarchar(1000) | with null | Text description of |
| action_desc | nvarchar(700) | with null | Text description of the activity log entry |
| type | nvarchar(12) | with null | Type. Foreign key to the code field of the act_type table. |
| internal | integer | with null | Marks this as Internal log. |
Product Name: Unicenter Service Desk
Table Type: Table