Contains information about asset models. Models act as product templates based on which the physical assets are created. Models are defined first in the repository for each product that the company tracks in UAPM. A record is added to this table when a model object is created.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| model_uuid | byte(16) | not null | Model ID. Primary key. |
| subclass_id | integer | with null | Foreign key to the id field of the ca_resource_class table for the subclass which this model belongs to. |
| inactive | integer | not null | Flag representing whether this record is active or inactive. 0=False (Active), 1=True (Inactive) |
| name | nvarchar(100) | not null | Model name. Unique. |
| description | nvarchar(255) | with null | Model description. |
| abbreviation | nvarchar(30) | with null | Model abbreviation. |
| manufacturer_uuid | byte(16) | with null | Foreign key to the company_uuid field of the ca_company table for the record that represents this model's manufacturer. |
| preferred_seller_uuid | byte(16) | with null | Foreign key to the company_uuid field of the ca_company table for the record that represents the preferred seller company of this model. |
| family_id | integer | with null | Foreign key to the id field of the ca_resource_family table for the family which this model belongs to. |
| class_id | integer | with null | Foreign key to the id field of the ca_resource_class table for the class which this model belongs to. |
| current_as_of_date | integer | with null | Date which represents the point at which the model information is considered current. |
| 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. |
| exclude_registration | integer | with null | Exclude Registration |
| delete_time | integer | with null | Delete Time |
| operating_system | integer | with null | Operating system. Foreign key to the id column of the ca_resource_operating_system table. |
| capacity | float | with null | Capacity. |
| capacity_unit | integer | with null | Capacity unit. Foreign key to the id column of the ca_capacity_unit table. |
| gl_code | integer | with null | GL code. Foreign key to the id column of the ca_resource_gl_code table. |
| version_number | integer | with null | Version number for transaction integrity. |
Product Name: Unicenter Desktop and Server Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| model_uuid | ca_owned_resource | model_uuid |