Model: Maintenance - Specifications for Dimension Table: ASSET HEALTH LEVEL
Attributes
| Attribute |
Description (where applicable) |
| Asset Group |
Represents the Asset Group (Equipment/Linea Asset/Etc.) |
| Color |
Represents the Color Code for Health Level |
| Dim_Asset_Type |
Dimension ID for Asset Type |
| Health Level Count |
|
| ID |
Key for Health Level setup value - Combination of Asset Group + Asset Type + Color Code |
| IntervalMax |
Represents the Max interval value for the health level for the Asset Type |
| Level |
Represents the description of the Color Code |
| Mvt_Created_Dt |
|
| Obj Type |
Represents the Asset Type |
USED BY MODEL(S)
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 LEVEL |
FACT_ASSET_HEALTH_LEVEL_TM |
FACT_ASSET_HEALTH_LEVEL_BI |
FACT_ASSET_HEALTH_LEVEL |
On Line |