Main source of information for the asset and its ownership attributes. Assets represent physical products with unique identifiers such as serial numbers, configuration, or contact. A record is added to this table when an asset object is created.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| own_resource_uuid | byte(16) | not null | Primary key. UUID to uniquely identify the owned resource within tables supporting ownership information. |
| location_uuid | byte(16) | with null | Foreign key to the location_uuid field of the ca_location table pointing to the resource's location. |
| inactive | integer | not null | Flag representing whether this record is active or inactive. 0=False (Active), 1=True (Inactive) |
| asset_type_id | integer | not null | Foreign key to the ca_asset_type table to represent Hardware, Software, etc. |
| asset_source_uuid | byte(16) | with null | Foreign key to ca_asset_source table. Establishes the identification of an non-software owned resource to a record in the common asset table through the asset source table. |
| resource_family | integer | with null | Foreign key to the id field of the ca_resource_family table for the resource family. Used for high-level extendibility. e.g. computer, hardware, software, service |
| resource_class | integer | not null | Foreign key to the id field of the ca_resource_class table for the resource class. |
| resource_name | nvarchar(100) | not null | The name of the resource. |
| manufacturer_uuid | byte(16) | with null | Foreign key to the company_uuid field of the ca_company table pointing to the company who manufactured the resource. |
| responsible_vendor_uuid | byte(16) | with null | Foreign key to the company_uuid field of the ca_company table pointing to the company ultimately responsible for the resource. |
| maintenance_org_uuid | byte(16) | with null | Foreign key to the organization_uuid field of the ca_organization table pointing to the organization responsible for maintenance of the resource. |
| resource_description | nvarchar(255) | with null | Longer name or description of the resource. |
| responsible_org_uuid | byte(16) | with null | Foreign key to the organization_uuid field of the ca_organization table pointing to the organization ultimately responsible for the resource. |
| org_bought_for_uuid | byte(16) | with null | Foreign key to the organization_uuid field of the ca_organization table pointing to the organization for which the resource was bought. |
| resource_contact_uuid | byte(16) | with null | Foreign key to the contact_uuid field of the ca_contact table pointing to the contact for the resource. |
| resource_owner_uuid | byte(16) | with null | Foreign key to the contact_uuid field of the ca_contact table pointing to the owner for the resource. |
| resource_status | integer | with null | Foreign key to the id field of the ca_resource_status table for resource status. |
| resource_quantity | integer | with null | Resource quantity. |
| company_bought_for_uuid | byte(16) | with null | Foreign key to the company_uuid field of the ca_company table pointing to the company for which the resource was bought. |
| model_uuid | byte(16) | with null | Foreign key to the model_uuid field of the ca_model_def table to represent the asset model. |
| floor_location | nvarchar(30) | with null | Floor location. |
| room_location | nvarchar(30) | with null | Room location. |
| cabinet_location | nvarchar(30) | with null | Cabinet location. |
| shelf_location | nvarchar(30) | with null | Shelf location. |
| slot_location | nvarchar(30) | with null | Slot location. |
| host_name | nvarchar(255) | with null | Machine name. (hardware only) |
| mac_address | nvarchar(64) | with null | MAC address. (hardware only) |
| ip_address | nvarchar(64) | with null | IP address. (hardware only) |
| resource_capacity | float | with null | Resource capacity (e.g. "20" in 20 MB). (hardware only) |
| resource_tag | nvarchar(64) | with null | Alternate resource identifier. e.g. alternate id located on sticker placed on machine. |
| resource_alias | nvarchar(30) | with null | Resource alias. |
| operating_system | integer | with null | Operating system of the resource (hardware) or supported operated system (software). Foreign key to the id column of the ca_resource_operating_system table. |
| product_version | nvarchar(16) | with null | Product release. |
| serial_number | nvarchar(64) | with null | Serial number. |
| acquire_date | integer | with null | Date resource was acquired. |
| installation_date | integer | with null | Date resource was installed in organization or network. |
| cost_center | integer | with null | Cost center. Foreign key to the id column of the ca_resource_cost_center table. |
| ufam | smallint | with null | Flag indicating if the asset is managed by UAPM. 0=False , 1=True |
| gl_code | integer | with null | GL code. Foreign key to the id column of the ca_resource_gl_code table. |
| requisition_id | nvarchar(50) | with null | Requisition ID on which the resource was requested. |
| purchase_order_id | nvarchar(20) | with null | Purchase order ID on which the resource was purchased. |
| creation_user | nvarchar(64) | with null | User or process that created the record. |
| creation_date | integer | with null | Date the record was created. |
| supply_vendor_uuid | byte(16) | with null | Foreign key to the company_uuid field of the ca_company table pointing to the vendor responsible for supplying the resource. |
| maintenance_vendor_uuid | byte(16) | with null | Foreign key to the company_uuid field of the ca_company table pointing to the vendor providing maintenance for the resource. |
| last_update_user | nvarchar(64) | with null | User or process that last updated the record. |
| resource_capacity_unit | integer | with null | Foreign key to the id field of the ca_capacity_unit table (e.g. "MB" in 20 MB). (hardware only) |
| 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 |
| license_uuid | byte(16) | with null | Foreign key to ca_license table . Establishes the identification of a software owned resource to a record in the common asset table through the license table. |
| department | integer | with null | Department. Foreign key to the id column of the ca_resource_department table. |
| status_date | integer | with null | Status date. |
| license_information | nvarchar(32) | with null | License Information |
| resource_subclass | integer | with null | Foreign key to the id field of the ca_resource_class table for the resource subclass. |
| audit_date | integer | with null | Audit Date |
| version_number | integer | with null | Version number for transaction integrity. |
| exclude_reconciliation | smallint | with null | Flag indicating if the asset is excluded from reconciliation. 0=False , 1=True |
| dns_name | nvarchar(100) | with null | The name by which this device is know in the domain name server |
Product Name: Asset
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| own_resource_uuid | ca_link_configured_service | own_resource_uuid |