AssetStatus Table

AssetStatus is a static table storing a list of possible asset states, such as purchased, in storage, installed, retired, disposed and other.

Table 1. Database columns for AssetStatus table

Database Column



Type: integer. Key. Generated ID

A unique identifier for each AssetStatus. Possible values and the corresponding default strings are:

  • 1 = Purchased
  • 2 = In Storage
  • 3 = Installed
  • 4 = Retired
  • 5 = Disposed
  • 6 = Other.

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing an asset status. Foreign key to the ComplianceResourceString table.


Type: text (max 100 characters)

The text to display if the status resource string has no translation.