Contains a history of modifications that occurred to owned or discovered data
| Column Name | Column Datatype | Column Null Option | Column Comment |
| sys_name | nvarchar(30) | not null | System name. First part of the primary key. |
| reconcile_modification_id | integer | not null | Modification ID. Second part of the primary key. |
| reconcile_action | smallint | with null | Flag to represent the reconcile action. 1=Added, 2=Changed, 3=Deleted |
| own_resource_uuid | byte(16) | with null | Primary key. UUID to uniquely identify the owned resource within tables supporting ownership information. |
| own_resource_serial_num | nvarchar(64) | with null | Owned resource serial number |
| own_resource_host_name | nvarchar(255) | with null | Owned resource host name |
| own_resource_alias | nvarchar(30) | with null | Owned resource alias |
| own_resource_alternate_id | nvarchar(64) | with null | Owned resource alternate identifier |
| dis_hw_uuid | byte(16) | with null | Primary key. UUID to uniquely identify the discovered asset within tables supporting discovery information. e.g. inventory information collected by UAM(Unicenter Asset Management). |
| discovery_asset_name | nvarchar(255) | with null | Discovery asset name |
| discovery_asset_serial_num | nvarchar(64) | with null | Discovery serial number |
| discovery_asset_sys_model | nvarchar(127) | with null | Discovery system model |
| discovery_asset_sys_vendor | nvarchar(127) | with null | Discovery system vendor |
| creation_user | nvarchar(64) | with null | User or process that created the record. |
| creation_date | integer | with null | Date the record was created. |
| last_update_user | nvarchar(64) | with null | User or process that last updated the record. |
| last_update_date | integer | with null | Date the record was last updated. |
| version_number | integer | with null | Version number for transaction integrity. |
| subschema_id | integer | with null | Subschema id |
Product Name: Unicenter Asset Portfolio Management
Table Type: Table