When the audit log options are enabled, changes to selected fields are logged to this table to provide an audit log.
| 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) |
| change_date | integer | with null | The change date value for this Audit_Log. |
| analyst | byte(16) | with null | User whose update generated this audit record |
| aud_opr | integer | with null | the type of operation that generated this entry: update, insert, delete |
| audobj_persid | nvarchar(30) | with null | Used for tracking the object that has changed |
| audobj_uniqueid | nvarchar(30) | with null | Used for tracking the object that has changed |
| audobj_name | nvarchar(10) | with null | Used for tracking the object that has changed |
| audobj_trkid | nvarchar(40) | with null | Used for tracking the object that has changed |
| attr_name | nvarchar(80) | with null | The objects attribute that has changed |
| attr_before_val | nvarchar(160) | with null | The previous value of the objects attribute that has changed |
| attr_after_val | nvarchar(160) | with null | The new value of the objects attribute that has changed |
| str1_rsrved | nvarchar(25) | with null | Reserved for future use by CA |
| int1_rsrved | integer | with null | Reserved |
| int2_rsrved | integer | with null | Reserved |
Product Name: Unicenter Service Desk
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| id | view_audit_group view_audit_group view_audit_group view_audit_group view_audit_group view_audit_assignee view_audit_assignee view_audit_assignee view_audit_assignee view_audit_assignee view_audit_status view_audit_status view_audit_status view_audit_status view_audit_status view_audit_priority view_audit_priority view_audit_priority view_audit_priority view_audit_priority |