This is the denormalized subset of the ca_owned_asset table used for quick lookups in Service Intelligence.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| ci_uuid | byte(16) | not null | Owned_asset uuid |
| parent_uuid | byte(16) | with null | Owned_asset parents' uuid |
| vendor_name | nvarchar(100) | with null | Denormalized name of Vendor |
| uam_dom_id | integer | with null | Unicenter Asset Managements domain id |
| manufacturer_name | nvarchar(100) | with null | |
| uam_uid | integer | with null | Unicenter Asset Management Unit ID |
| ci_name | nvarchar(100) | with null | Asset name form Service Desk or Argis based on Service Intelligence configuration |
| ci_class | nvarchar(100) | with null | Asset class form Service Desk or Argis based on Service Intelligence configuration |
| ci_family | nvarchar(100) | with null | A de-normalized subset of asset/configuration item information for use in linking to other Unicenter applications for additional asset data. |
| active | integer | with null | Boolean that determines if the record is currently active or not in Service Desk |
| data_source | varchar(256) | not null | The uuid of the data source that the CI value is obtained from |
| arg_cost | money | with null | Summed total cost of asset from UFAM |
| arg_payment | money | with null | Summed total payments for a specified asset |
| arg_expired_doc | integer | with null | Total count of expired documents per asset based on expired UFAM legal documents, with the asset attached to it. |
Product Name: Unicenter Service Intelligence
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| ci_uuid | si_ci_rec_rel | ci_uuid |