Contains information about the statuses which can be chosen for an asset. The status of an asset can either be active or inactive.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Primary key. Resource status 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 | Status name. Unique. |
| description | nvarchar(255) | with null | Status description. |
| 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. |
| exclude_registration | integer | with null | Exclude Registration |
| delete_time | integer | with null | Delete Time |
Product Name: Asset
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| id | ca_owned_resource | resource_status |