Contains results from tasks that have been processed by the reconciliation engine. A Reconciliation task is a collection of processing option definitions that describe the actions to be performed by the reconciliation engine while integrating with UAM data. Once the task is executed the results from the task are stored in the table.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| task_uuid | byte(16) | not null | Task uuid. Primary key. |
| reconcile_data_id | integer | not null | Data ID. Second part of the primary key. |
| reconcile_data_type | smallint | with null | Flag to represent the type of data the record represents. 0=Changed, 1=Deleted Argis, 2=Deleted Discovery, 3=Unmatched Argis, 4=Unmatched Discovery, 5=Proposed Match |
| own_resource_uuid | byte(16) | with null | Foreign key to the ca_owned_resource table for the owned resource that matches the discovery record. |
| discovery_asset_name | nvarchar(255) | with null | Discovery asset name |
| discovery_operating_sys | nvarchar(127) | with null | Discovery operating system |
| discovery_capacity | float | with null | Discovery capacity |
| discovery_capacity_unit | integer | with null | Discovery capacity unit. Foreign key to the id field of the ca_capacity_unit table. |
| 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. |
| dis_hw_uuid | byte(16) | with null | Foreign key to the ca_discovered_hardware table for the discovered resource that matches the owned record. |
Product Name: Unicenter Asset Portfolio Management
Table Type: Table