Model: Maintenance - Specifications for Dimension Table: ASSET HEALTH INDICATOR

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

Attributes

Attribute	Description (where applicable)
Asset Group	Represents the Asset Group (Equipment/Linea Asset/Etc.)
Asset Health Indicator Count
Description	Represents the Description of the Indicator Type
Dim_Asset_Type	Dimension ID for Asset Type
ID	Key for Indicator setup value by Asset Group - Combination of Asset Group + Asset Type + Indicator Type + Parameter
Indicator Type	Represents the type of the Indicator (Parameter, Age, Condition Score, etc.)
Indicator Type Desc	Description of the Indicator Type
Mvt_Created_Dt
OBJECT_TYPE	Represents the Asset Type
Parameter	Represents the Parameter ID of the indicator ( "-" if not a parameter)
Parameter Description	Description of the parameter (Blank if not a parameter)
Parameter Type	Represents the Type of the Parameter - Only for Parameters. Blank if not a parameter (Limit, Accumalated or Condition)
ParameterID	Represents a name for the parameter (If parameter - Parameter ID, else - Indicator Type)
Type	Represents the Type of the Indicator (Limit, Accumalated, Condition, Age, Condition Score, etc.)
Weight	Represents the allocated Weight for the Indicator to be used for calculations

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 INDICATOR	FACT_ASSET_HEALTH_INDICATOR_TM	FACT_ASSET_HEALTH_INDICATOR_BI	FACT_ASSET_HEALTH_INDICATOR	On Line