Model: Maintenance - Specifications for Dimension Table: ASSET HEALTH

On this page you will find the specifications regarding the Model: Maintenance and Dimension Table: ASSET HEALTH.

Attributes

Attribute Description (where applicable)
Asset Age Represents the Age as a percentage value, calculated using Installation Date and Technical Lifetime
Asset Count
Asset Group Represents the Asset Group (Equipment/Linea Asset/Etc.)
Asset Health Latest Health Value of the asset as a Percentage
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 Level Code Represents the Health Level Category Code of the latest Asset Health Value
Asset Id Asset ID (Object ID for equipment objects, etc)
Category Id
Company Id Represents the Company ID which the asset belongs to
Condition Score Represents the Condition Score of the Asset as a Percentage Value
Dim_Asset_Health_Level Represents the Health Level ID from the ASSET HEALTH LEVEL Dimension
Dim_Asset_Id Dimension ID for Asset ID
Dim_Asset_Type Dimension ID for Asset Type
Dim_Company_Id Dimension ID for Company ID
Dim_Site_Id Dimension ID for Site ID
ID Key ID for the Asset - Combination of Object Seq + Asset Group
ObjSearch Combination of Asset ID + Asset Name - Used or Search bars
Object Level Represents the Object Level of the Asset
Object Name Name of the Asset (Description)
Object Seq Key of the Asset in its relavant Asset Group
Object Type Represents the Type of Asset in the Asset Group
Object Type Desc Description of the Object Type
Operational Status Represents the Operational Status of the Asset
Operational Status Db Represents the Operational Status Code
Production Date Represents the Production Date of the Asset
Remaining Life Remaining Life percentage calculated from Installation Date and Technical Lifetime
SITE_TX A combination of Site ID + Site Description - Used for Search and Slicers
Site Id Represents the Site ID of the Asset
Technical Lifetime Expected Lifetime of the Asset in Years

USED BY MODEL(S)

Model Name
Maintenance

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
ASSET HEALTH FACT_ASSET_HEALTH_TM FACT_ASSET_HEALTH_BI FACT_ASSET_HEALTH On Line