This table holds the basic information about the event or transaction that had taken place in the iCan System. External events from other system can also be posted to iCan system.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | varchar(128) | not null | Non-displayable id used in the backend as a reference between tables. |
| name | nvarchar(50) | not null | Name of the transaction. For database events, it’s the table name i.e. billing_account, icuser etc. For LOGICAL transactions, it’s a plain-text name. This entry has a logical mapping to the iceventtype.icnsppath property in the Registry. |
| tran_level | varchar(50) | not null | LOGICAL or DATABASE transaction. |
| timestamp | date | not null | Time stamp the transaction took place |
| type | nvarchar(50) | not null | Event causing this transaction entry. ADDED, MODIFIED, DELETED etc. |
| description | nvarchar(256) | with null | Information about the event |
| host | varchar(50) | with null | Hostname, which is responsible for this event |
| component_name | nvarchar(50) | not null | Component from which this event originated from. Registry/Billing/Metering/Logical etc. |
| nsp_path | varchar(128) | not null | Namespace in which the affected object resides |
| user_id | nvarchar(100) | with null | User who affected the change that caused this event |
| domain | varchar(50) | with null | Domain to which the user belongs |
| object_id | varchar(256) | with null | Object id of the affected object |
| httpsession_id | nvarchar(50) | with null | HTTP Session ID of the user |
| partial_event | integer | not null | 1 indicates that this event does not contain further details. 0 indicates that this event contains more details that need to be fetched from transaction_details and transaction_details_ext table. |
| notified | varchar(512) | with null | List to be notified Should research more on this field |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| id | usm_system_change_detail | id |