assets_v1

This view contains the asset data.

Here you will find the curated, consolidated details of all the assets in your portfolio.
 

 

Data structure

ColumnMeaningComment
asset_idPrimary database key 
asset_codeCode/label of the asset 
asset_unique_referenceUnique GUID of the assetGlobally unique
asset_external_referenceExternal identifier of the asset 
asset_nameName of the asset 
asset_descriptionDescription of the asset 
asset_model_nameModel name of the asset 
asset_quantityQuantity of the assetUnitless
asset_serial_numberSerial number of the asset 
asset_barcodeBarcode of the asset 
asset_qrcodeQR code of the asset 
asset_priority_numberNumerical priority of the asset 
asset_priority_nameName/label of the priority of the asset 
asset_category_nameName of the asset category 
asset_category_codeCode of the asset category 
asset_type_nameType name of the asset 
asset_type_codeType code of the asset 
asset_construction_dateDate when the asset was constructed 
asset_purchase_dateDate when the asset was purchased 
asset_commissioning_dateDate when the asset was commissioned (activated) 
asset_decommissioning_dateDate when the asset was decommissioned (deactivated) 
asset_expected_lifetimeNumber of years that the asset should coverForecast
asset_expected_replacement_yearYear in which the asset should be replacedForecast
asset_replacement_costCost of replacing the asset in the expected replacement yearForecast
asset_currencyCurrency in which asset costs are defined 
asset_warranty_start_dateStart Date of warranty periodSame as asset_purchase_date by default
asset_warranty_end_dateEnd Date of warranty period 
location_idForeign database key to locations 
region_codeCode of region where the asset is located 
region_nameName of region where the asset is located 
site_codeCode of Site where the asset is located 
site_nameName of Site where the asset is located 
building_codeCode of Building where the asset is located 
building_nameName of Building where the asset is located 
floor_codeCode of Floor where the asset is located 
floor_nameName of Floor where the asset is located 
room_codeCode of Room where the asset is located 
room_nameName of Room where the asset is located 
asset_status_nameName of the asset status 
asset_status_codeCode of the asset status 
maintenance_organization_nameName of the Organizations that performs maintenance on the asset  
asset_manufacturerName of the manufacturer of the asset 
asset_supplierName of the supplier of the asset 
parent_asset_idDatabase key of the parent assetIn case when assets are hierarchical
corrective_wo_countNumber of corrective work orders linked to the asset 
preventive_wo_countNumber of preventive work orders linked to the asset