Heat Map – Condition Rating per Class/Criticality - HxGN EAM - 12.00.00 - Feature Briefs - Hexagon

HxGN EAM Equipment Overview 360

Language
English
Product
HxGN EAM
Search by Category
Feature Briefs
HxGN EAM Version
12

This will return the average condition rating of all equipment grouped per class and criticality of that equipment. Equipment must have class and criticality and condition rating calculated for it to be included. And to keep it simpler the query is not language independent.

SELECT * FROM (

SELECT cls_desc||' ('||obj_class||')' Class,

obj_criticality criticality,

ROUND( AVG( obj_conditionrating )) avgconditionrating

FROM r5objects, r5classes

WHERE obj_class = cls_code

AND obj_class_org = cls_org

AND obj_criticality IS NOT NULL

AND obj_conditionrating IS NOT NULL

GROUP BY obj_class, obj_class_org, cls_desc, obj_criticality

HAVING ROUND( AVG( obj_conditionrating ) ) > -1 )

PIVOT ( AVG( avgconditionrating )

FOR criticality IN

( 'CRIT01' "Very Low", 'CRIT02' "Low", 'CRIT03' "Medium",

'CRIT04' "High", 'CRIT05' "Critical" ) )

ORDER BY 1