Column Name | Column Type | Description |
---|---|---|
ASSET_TYPE | VARCHAR2(32) | Damaged asset type. Either device class name (for modeled assets) or damaged part id (for non-modeled assets). For non-modeled assets the list of known part ids is configured in the DAMAGE_PARTS database table. |
REPAIR_TIME_A | NUMBER | Number of minutes needed to repair single instance of this damage asset when the location is truck-accessible. |
REPAIR_TIME_I | NUMBER | Number of minutes needed to repair single instance of this damage asset when the location is not truck-accessible. |
DEFAILT_TQ | VARCHAR2(50) | Default trouble queue for this damage asset type. |