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

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

Attributes

AttributeDescription (where applicable)
Asset GroupRepresents the Asset Group (Equipment/Linea Asset/Etc.)
ColorRepresents the Color Code for Health Level
Dim_Asset_TypeDimension ID for Asset Type
Health Level Count
IDKey for Health Level setup value - Combination of Asset Group + Asset Type + Color Code
IntervalMaxRepresents the Max interval value for the health level for the Asset Type
LevelRepresents the description of the Color Code
Mvt_Created_Dt
Obj TypeRepresents the Asset Type

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 TableDW Source view (SQL Server)BI Access ViewReferenced Information SourceRecommended Access Type
ASSET HEALTH LEVELFACT_ASSET_HEALTH_LEVEL_TMFACT_ASSET_HEALTH_LEVEL_BIFACT_ASSET_HEALTH_LEVELOn Line