On this page you will find the specifications regarding the Model: Maintenance and Dimension Table: ASSET HEALTH.
| Attribute | Description (where applicable) |
| ID | Key ID for the Asset - Combination of Object Seq + Asset Group |
| Object Seq | Key of the Asset in its relavant Asset Group |
| Asset Group | Represents the Asset Group (Equipment/Linea Asset/Etc.) |
| Remaining Life | Remaining Life percentage calculated from Installation Date and Technical Lifetime |
| Site Id | Represents the Site ID of the Asset |
| Asset Id | Asset ID (Object ID for equipment objects, etc) |
| Object Name | Name of the Asset (Description) |
| Company Id | Represents the Company ID which the asset belongs to |
| Object Type | Represents the Type of Asset in the Asset Group |
| Object Type Desc | Description of the Object Type |
| Category Id | |
| Object Level | Represents the Object Level of the Asset |
| Operational Status | Represents the Operational Status of the Asset |
| Operational Status Db | Represents the Operational Status Code |
| Asset Health Level Code | Represents the Health Level Category Code of the latest Asset Health Value |
| Dim_Asset_Type | Dimension ID for Asset Type |
| Dim_Asset_Id | Dimension ID for Asset ID |
| Dim_Company_Id | Dimension ID for Company ID |
| Dim_Site_Id | Dimension ID for Site ID |
| Dim_Asset_Health_Level | Represents the Health Level ID from the ASSET HEALTH LEVEL Dimension |
| Production Date | Represents the Production Date of the Asset |
| Asset Count | |
| Technical Lifetime | Expected Lifetime of the Asset in Years |
| Asset Age | Represents the Age as a percentage value, calculated using Installation Date and Technical Lifetime |
| Condition Score | Represents the Condition Score of the Asset as a Percentage Value |
| Asset Health Color | Represents the Color Hex Code for the latest Asset Health Value |
| Asset Health Level | Represents the Health Level Category of the latest Asset Health Value |
| Asset Health | Latest Health Value of the asset as a Percentage |
| ObjSearch | Combination of Asset ID + Asset Name - Used or Search bars |
| SITE_TX | A combination of Site ID + Site Description - Used for Search and Slicers |
| Model Name |
The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.
Additional information can be found in the online documentation of Information Sources.
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| ASSET HEALTH | FACT_ASSET_HEALTH_BI | FACT_ASSET_HEALTH | On Line |