AssetStatus_CODE Table

AssetStatus_CODE is an enumerated code table for Asset status.

Table 1. Database columns for AssetStatus_CODE table

Database Column

Details

AssetStatusID

Type: integer. Key

A unique identifier for Asset status. Possible values and the corresponding default strings are:

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

Type: text (max 1000 characters)

Status of the Asset in English.

AssetStatus_de

Type: text (max 1000 characters)

Status of the Asset in German.

AssetStatus_fr

Type: text (max 1000 characters)

Status of the Asset in French.

AssetStatus_ja

Type: text (max 1000 characters)

Status of the Asset in Japanese.

AssetStatus_es

Type: text (max 1000 characters). Nullable

Status of the Asset in Spanish.