Contains information about the classes which can be assigned to an asset. Classes and subclasses are used to classify assets. The class you assign categorizes the product such as a printer, and the subclass provides additional refinement such as inkjet or laser printer. The values for class and subclass can be specified in the drop-down list property of Class and subclass fields of customization window.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Primary key. Class id. |
| inactive | integer | not null | Flag representing whether this record is active or inactive. 0=False (Active), 1=True (Inactive) |
| name | nvarchar(100) | not null | Class name. Unique within family. |
| family_id | integer | with null | Primary key. Resource family id. |
| parent_id | integer | with null | Foreign key back to the id field of the ca_resource_class table to allow for hierarchical class groupings (e.g. "subclass"). |
| usp_nsm_class | integer | with null | NSM Class. Foreign key to the id field of the buscls 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. |
| description | nvarchar(255) | with null | Class description. |
| exclude_registration | integer | with null | Exclude Registration |
| delete_time | integer | with null | Delete Time |
Product Name: Asset
Table Type: Table