This view contains the asset data.
Here you will find the curated, consolidated details of all the assets in your portfolio.
Data structure
| Column | Meaning | Comment |
|---|---|---|
| asset_id | Primary database key | |
| asset_code | Code/label of the asset | |
| asset_unique_reference | Unique GUID of the asset | Globally unique |
| asset_external_reference | External identifier of the asset | |
| asset_name | Name of the asset | |
| asset_description | Description of the asset | |
| asset_model_name | Model name of the asset | |
| asset_quantity | Quantity of the asset | Unitless |
| asset_serial_number | Serial number of the asset | |
| asset_barcode | Barcode of the asset | |
| asset_qrcode | QR code of the asset | |
| asset_priority_number | Numerical priority of the asset | |
| asset_priority_name | Name/label of the priority of the asset | |
| asset_category_name | Name of the asset category | |
| asset_category_code | Code of the asset category | |
| asset_type_name | Type name of the asset | |
| asset_type_code | Type code of the asset | |
| asset_construction_date | Date when the asset was constructed | |
| asset_purchase_date | Date when the asset was purchased | |
| asset_commissioning_date | Date when the asset was commissioned (activated) | |
| asset_decommissioning_date | Date when the asset was decommissioned (deactivated) | |
| asset_expected_lifetime | Number of years that the asset should cover | Forecast |
| asset_expected_replacement_year | Year in which the asset should be replaced | Forecast |
| asset_replacement_cost | Cost of replacing the asset in the expected replacement year | Forecast |
| asset_currency | Currency in which asset costs are defined | |
| asset_warranty_start_date | Start Date of warranty period | Same as asset_purchase_date by default |
| asset_warranty_end_date | End Date of warranty period | |
| location_id | Foreign database key to locations | |
| region_code | Code of region where the asset is located | |
| region_name | Name of region where the asset is located | |
| site_code | Code of Site where the asset is located | |
| site_name | Name of Site where the asset is located | |
| building_code | Code of Building where the asset is located | |
| building_name | Name of Building where the asset is located | |
| floor_code | Code of Floor where the asset is located | |
| floor_name | Name of Floor where the asset is located | |
| room_code | Code of Room where the asset is located | |
| room_name | Name of Room where the asset is located | |
| asset_status_name | Name of the asset status | |
| asset_status_code | Code of the asset status | |
| maintenance_organization_name | Name of the Organizations that performs maintenance on the asset | |
| asset_manufacturer | Name of the manufacturer of the asset | |
| asset_supplier | Name of the supplier of the asset | |
| parent_asset_id | Database key of the parent asset | In case when assets are hierarchical |
| corrective_wo_count | Number of corrective work orders linked to the asset | |
| preventive_wo_count | Number of preventive work orders linked to the asset |