usm_system_change_detail

An event might occur when an object gets added, deleted or modified in the iCan system or external system. This table allows you to store the state of the object before modification and the state of the object after modification.

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 property of the object or the field
data_type nvarchar(50) with null Data type of the field or property
old_value nvarchar(256) with null Property value before modification or change
new_value nvarchar(256) with null Property value after modification or change
multi_value integer with null 0/1. If 0, this field is not a multi-value field.

Product Name: Unicenter Service Management

Table Type: Table

Relationships:

Primary Key Related Table Related Column
id
name
usm_system_change_detail_ext id
name


Copyright © 2006 CA. All rights reserved.