Linear Condition tab - HxGN EAM - Version 11.07.01 - Feature Briefs - Hexagon

HxGN EAM Equipment Rankings

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

This tab is like the Linear References tab but is dedicated to the condition, risk and criticality of the segments represented here. The records on this tab are the same as linear reference records but the system uses a flag on the record (invisible to the user) to decide on which of these tabs to show the record. A few notable aspects on this tab in comparison to the Linear References tab are:

  • The Type field is omitted. The linear condition records are automatically associated to the "Point of Interest" type.

  • The Class field is omitted, but on the Linear Overview tab the system automatically uses "Condition Index", "Risk Priority Index" and "Criticality Index" as additional classes when records on this tab exist with condition, risk or criticality data.

  • There is no Color or Icon field. Color and icon for these rows on the Linear Overview tab are configured on the Ranks tab of the Equipment Ranking screen. To be able to find these ranks the system will look on the Rankings tab and search for the Equipment Ranking of the same type. If found it will use the ranks from that Equipment Ranking. If none found, then the default color will be displayed as configured in the Linear Overview Preferences popup.

  • And to help with queries, the hidden flag (database column lrf_linear_reftype) = 'I' for these records. For linear reference records this same column holds ‘O’. Do not confuse this field with lrf_reftype which holds the Type field that is visible on the Linear References tab.

The Linear Condition tab has the following important attributes:

  1. Condition Score - You can manually assign a score or use Equipment Ranking to determine the score automatically. If you use Equipment Ranking these must be noted:

    1. The Ranking Survey does not have questions on the level of the linear condition segments. Questions, and therefore answers obviously, are all associated to the equipment instead. Any questions manually answered by the user will apply to all segments.

    2. Calculated questions that are automatically answered have the same limitation, but the queries do support the linear parameters :FROMPOINT and :TOPOINT which means that queries can be executed within the context of the From Point and To Point of the segment.
      For example, these query selects the risk priority number and the condition score from the current linear condition segment that is being processed and then multiplies these two values to calculate the criticality of the segment.
      SELECT NVL(lrf_riskprioritynumber,0) * NVL(lrf_conditionscore,0)
      FROM r5objects, r5objlinearref
      WHERE obj_code = lrf_objcode
      AND obj_org = lrf_objorg
      AND lrf_linear_reftype = 'I'
      AND TRUNC(SYSDATE) BETWEEN lrf_dateeffective AND lrf_dateexpired
      AND obj_code = :OBJECT
      AND obj_org = :OBJECTORG
      AND lrf_frompoint = :FROMPOINT
      AND lrf_topoint = :TOPOINT

    3. Checklist result questions that are automatically answered will also be executed within the context of the From Point and To Point of the segment. These conditions apply:

      • Checklist item From Point must be greater than or equal to the linear condition record From Point and

      • Checklist item To Point must be less than or equal to the linear condition record To Point and

        If the Checklist item From Point and To Point are both blank the system will also include the checklist result, but the answer will apply to all segments unless a more recent item is found for a specific segment based on from and to point.

        On the setup of the checklist, you can make use of the Equipment Level "Linear Condition". When the checklist is created for a work order with a linear equipment, the system will automatically include a copy of the checklist item for each linear condition segment that falls within the scope (from/to) of the work order.

  2. Condition Index - System Codes entity "OBRI". You can manually assign an index or use Equipment Ranking to determine the index automatically.

  3. Risk Priority Score - See above under Condition Score.

  4. Risk Priority Index - System Codes entity "OBRI". See further above under Condition Index.

  5. Criticality Score - See above under Condition Score.

  6. Criticality - System Codes entity "OBCR". See further above under Condition Index.

    The condition score calculations for linear segments do not differ from those for point equipment, but the calculations are performed on linear condition segment level. For that purpose, several fields are also available on linear condition segment level:

  7. Commission Date - The commission date is used by several condition protocols. If you enter this field for a segment this will be used in the condition score calculation instead of the date recorded on the equipment record. For example, in case this segment of 5 miles was just recently replaced.

  8. Service Life (years) - Like the Commission Date, enter a value here if the expected service life of the segment is different than that of the equipment.

  9. Service Life Usage - Like the Commission Date, enter a value here if the expected service life usage of the segment is different than that of the equipment.

  10. End of Useful Life - Populated automatically if the system can determine when the condition score threshold will be reached by the linear condition segment.

  11. Remaining Useful Life (years): Calculated automatically using End of Useful Life.

  12. Correction Condition Score - Like the Correction Condition Score on the equipment, but now applicable for a linear condition segment. If you enter this field for a segment this will be used in the condition score calculation instead of the value recorded on the equipment record.

  13. Correction Reason - See above under Correction Condition Score.

  14. Correction Date - See above under Correction Condition Score.

  15. Correction Usage - See above under Correction Condition Score.

  16. Correction Ranking Status - This field has the same purpose as on the Rankings tab. See above.

If the equipment is linear and the equipment ranking being calculated is a "Reliability Index" or a "Facility Condition Index", then the system will do the calculation on equipment level. But if the equipment ranking is a "Condition Index", a "Risk Priority Index" or a "Criticality Index", then the system will do the calculation for each linear condition segment that is currently active. Active means the Date Effective is today or in the past and the Date Expired is today or in the future. If no such record exists one will automatically be created for the whole equipment length, effective today until 2099.

After all scores are calculated for all currently active linear condition segments, the system will update the corresponding Equipment Ranking record, and the header equipment record itself, but will use the weighted average of the segment scores. The weight is determined by the length of each linear condition segment relative to the total combined length of all these segments, i.e. (score * segment length + score * segment length + etc.) / total length all segments. The system will base the index on this weighted score as well. Note that if the total length of all segments is zero, the system will skip the update of the equipment ranking record and the header equipment. No error will be raised.

If Track History is selected on the Equipment Ranking the system will create a history record with the weighted score and index for the header equipment. This record will only contain the score and index. Other values like End of Useful Life are not determined on this level or linear equipment and will remain blank. Additionally, the system will create history linear condition segments for all currently active linear condition records with a Date Effective in the past as follows:

  • Expire the current active segment by setting Date Expired to yesterday.

  • Copy each of these records but set Date Effective equal to today.

During the calculation process answers are determined for each linear condition segment, but since these answers are only recorded on equipment header level, the answers from the previous linear condition record will be overwritten by the current linear condition record being processed. Practically this means that after the calculation process is complete for all linear condition segments, only the answers of the last linear condition segment will be visible on the Ranking Survey tab. Calculated scores can obviously be viewed individually on each linear condition segment on this tab and a weighted score and index on the Rankings tab or on the equipment screen itself.