Catalog Items

Overview Graphs Folder

The Catalog folder \\Public\Meridium\Modules\Risk Based Inspection\Overview Graphs contains the following items.


Graph Name	Behavior and Usage
Current Risk Overview	Displays the Current Risk Categories for all assets under a Functional Location.
Past Risk Overview	Displays the most recently archived Past Risk Categories for all assets under a Functional Location. This allows the user to see the variations in risk after the completion of inspections.
RBI Risk Matrix	Displays the total number of RBI Components based on their consequence of failure and probability of failure values. This graph appears only if the Risk Based Inspection license is active.

Queries Folder

The Catalog folder \\Public\Meridium\Modules\Mechanical Integrity\Queries\Dashboard Queries contains the following items.


Item Name	Behavior and Usage
Percentage Change in External DM for Piping	Returns the number of RBI Components of the Piping Equipment Type where the CUI Inspection Priority Changed field is set to True.
Percentage Change in External DM for Tanks	Returns the number of RBI Components of the Tanks Equipment Type where the CUI Inspection Priority Changed field is set to True.
Percentage Change in External DM for Vessels	Returns the number of RBI Components of the Vessels Equipment Type where the CUI Inspection Priority Changed field is set to True.
Percentage Change in Internal DM for Piping	Returns the number of RBI Components of the Piping Equipment Type where the Int. Corr. Inspection Priority Changed field is set to True.
Percentage Change in Internal DM for Tanks	Returns the number of RBI Components of the Tanks Equipment Type where the Int. Corr. Inspection Priority Changed field is set to True.
Percentage Change in Internal DM for Vessels	Returns the number of RBI Components of the Vessels Equipment Type where the Int. Corr. Inspection Priority Changed field is set to True.

The Catalog folder \\Public\Meridium\Modules\Mechanical Integrity\Queries contains the following items.


Item Name	Behavior and Usage
AssetInfo_OpenRecommendations	Displays the count of open inspection recommendations associated with the given asset. This query is used for the Asset info summary in the Asset Summary workspace.
AssetInfo_RBIRisk	Displays the most critical risk of the analyses contained on an asset. This query is used for the Asset info summary in the Asset Summary workspace.
AssetInfo_RemainingLife	Displays the most conservative remaining life value from the related Asset Corrosion Analyses of a given asset. This query is used for the Asset info summary in the Asset Summary workspace.
AssetInfo_WorkHistory	Displays the count of work history records associated with the given asset. This query is used for the Asset info summary in the Asset Summary workspace.

The Catalog folder \\Public\Meridium\Modules\Risk Based Inspection\Queries contains the following items.


Item Name	Behavior and Usage
Active Analyses for Evergreening - 580	Returns a list of the RBI Criticality Analysis records for RBI Components linked to RBI assets that satisfy the following conditions: Are related to the given Functional Location or Process Unit key. Are in the active state. Have an evergreening Batch ID. This query is used on the RBI Bulk Evergreening page, in the Active section when the RBI Analysis Type Preference is set to RBI 580.
Analyses Created For Evergreening - 580	Returns a list of the RBI Criticality Analysis records for RBI Components linked to RBI assets that satisfy the following conditions: Are related to the given Functional Location or Process Unit key. Are in the Created state. Have an evergreening Batch ID. This query is used on the RBI Bulk Evergreening page, in the Created section when the RBI Analysis Type Preference is set to RBI 580. Important: Do not modify the following columns: Analysis ID, Component, Component Entity Key, Asset ID, ENTY_KEY, Analysis Entity Key, and Risk Category. Modifying these columns may affect the Calculate functionality during the evergreening process.
Analyses Ready for Evergreening - 580	Returns a list of the RBI Criticality Analysis records for RBI Components linked to RBI assets that satisfy the following conditions: Are related to the given Functional Location or Process Unit key. Are in the active state. Have not been evergreened. Have not been calculated in the last five years. This query is used on the Risk Based Inspection Overview page, in the Pending Reassessment section when the RBI Analysis Type Preference is set to RBI 580. Important: Do not modify the ENTY_KEY column. Modifying this column may affect the duplicate functionality during the evergreening process.
Analyses Ready for Evergreening for Unit - 580	Returns a list of the RBI Criticality Analysis records for RBI Components linked to RBI assets that satisfy the following conditions: Are related to the given Functional Location or Process Unit key. Are in the active state. Have not been evergreened. This query is used on the RBI Bulk Evergreening page, in the Pending Evergreening section when the RBI Analysis Type Preference is set to RBI 580. Important: Do not modify the ENTY_KEY column. Modifying this column may affect the duplicate functionality during the evergreening process.
Asset Components RBI 580	Returns all Active Components that have risk completed 580 analyses related to the given asset. This query is used on the RBI Asset Overview page and RBI Corrosion Loop page in the Components section. Important: Do not modify the Component, Component Entity Key and ENTY_KEY columns. Modifying these columns may affect the functionality.
Asset Corrosion Analysis More Current Than Analyses	Returns a list of all the assets linked to a Functional Location that have a TM Asset Corrosion Analysis more current than the active RBI analysis in the component. This query is used on the Risk Based Inspection Overview page in the Inspection/TM Updates pane if you do not have an active RBI 581 license.
Assets with No Recommendations	Returns a list of all the assets linked to a Functional Location that have no RBI Recommendations and have at least one component with a Risk Completed analysis. This query is used on the Risk Based Inspection Overview page in the No Recommendations pane when both Risk Based Inspection and RBI 581 are licensed. Important: Do not modify the Asset Entity Key field. Modifying this field may affect the generate recommendation functionality.
Assets with No Recommendations (580 Only)	Returns a list of all assets linked to a Functional Location that have no RBI Recommendations and have at least one component with a Risk Completed analysis. This query is used on the Risk Based Inspection Overview page in the No Recommendations pane if you do not have an active RBI 581 license. Important: Do not modify the Asset Entity Key field. Modifying this field may affect the generate recommendation functionality.
Criticality Consequence Evaluation	Returns the Criticality Consequence Evaluation records that are associated to an RBI Criticality Analysis. This query is used in the Consequence Evaluations section when you view an RBI Criticality Analysis. Important: Do not modify the ENTY_KEY or FMLY_KEY columns. Modifying these columns may affect the functionality.
Current Risk	Returns a list of the current rolled-up risk for each asset linked to a Functional Location. This query is used under the Current Risk query widget on the Risk Based Inspection Overview page.
Current Risk Overview	Returns a list of the highest Risk Category for each asset linked to a Functional Location and gives a count. This query is used under the Current Risk Overview graph widget on the Risk Based Inspection Overview page.
Data Export Analyses - 580	Returns a list of the RBI Criticality Analyses available for export and that meets the following conditions: Are related to the given Functional Location or Process Unit key. Are in the active state. Are in the Created state. This query is used on the RBI Analysis Export page, when the RBI Analysis Type Preference is set to RBI 580.
Export RBI Components by Asset	Returns a list of the Equipment records that are linked to active RBI Components and Equipment records that are not linked to at least one RBI Component.
Inspections More Current Than All Analysis	Returns a list of all the assets linked to a Functional Location that have Inspections more current than the active RBI analysis in the component. This query is used on the Risk Based Inspection Overview page, in the Inspection/TM Updates pane when both Risk Based Inspection and RBI 581 licenses are active. Important: Do not modify the Asset Key column. Modifying this column may affect the functionality.
Inspections More Current Than Analysis	Returns a list of all the assets linked to a Functional Location that have Inspections more current than the active RBI analysis in the component. This query is used on the Risk Based Inspection Overview under the Inspection/TM Updates pane when both Risk Based Inspection and RBI 581 licenses are active. Important: Do not modify the Asset Key column. Modifying this column may affect the functionality.
Invalid Inspections for Non-Intrusive Requirement Met	None.
Manage Inspection Groups	None.
Manage RBI Components	None.
Manage RBI System	None.
Maximum Internal Corrosion Rate	Returns a list of the calculated maximum internal corrosion rate for an Internal Corrosion DME.
Past Risk	Returns a list of the past rolled-up risk for each asset under a Functional Location. This query is used under the Past Risk query widget on the Risk Based Inspection Overview page.
Past Risk Overview	Returns a list of the highest Risk Category for each asset Under a Functional Location and gives a count. This query is used under the Past Risk Overview graph widget on the Risk Based Inspection Overview.
PRD Consequence Evaluation	None.
Process Unit Asset View	Returns all RBI Assets related to the given Process Unit and rolled up values from the RBI Assets related Inspection Plan. Important: Do not modify the Asset and the Asset Entity Key columns. Modifying these columns may affect the functionality.
Process Unit Corrosion Loop View	Returns all the Corrosion Loops related to the given Process Unit. Important: Do not modify the Corrosion Loop and the Corrosion Loop Key columns. Modifying these columns may affect the functionality.
Process Unit Query	Returns a list of the underlying Process Units for the selected level of the asset hierarchy. This query is used on the Risk Based Inspection Overview in the Process Units pane. Important: Do not modify the ENTY_KEY column. Modifying this column may affect the functionality.
RBI Asset Risk Query	None.
RBI Asset Risk Sub Query	None.
RBI Assets for a Functional Location	Returns a list of all the assets linked to a Functional Location. This query is used on the Risk Based Inspection Overview page in the Assets pane. Important: Do not modify the Asset Entity Key column. Modifying this column may affect the functionality.
RBI Components for an Asset	Returns a list of all the RBI Components for a given asset. This query is used under the Asset Hierarchy Navigation menu to display the count of components on the Risk Based Inspection hyperlink.
RBI Corrosion Loops for a Functional Location	Returns a list of all the Corrosion Loops linked to a given Functional Location.
RBI DM Query	Returns a list of Degradation Mechanism records that are linked to an RBI Criticality Analysis. This query is used on the Degradation Mechanisms tab when viewing an RBI Criticality Analysis. Important: Do not modify the following columns: UnmitigatedRiskKey MitigatedRiskkey DMEntityKey Modifying these columns may affect the functionality.
RBI Flexible Configurations	Returns a list of all the flexible calculation records.
RBI Flexible Validation Records	Returns all flexible validation records.
RBI Overview Filter Parameters	None.
RBI Pipeline Consequence Evaluation	None.
Review Analyses by Asset 580	Returns a list of all the RBI Criticality Analysis records not in an Archived state for the Equipment or Functional Location record for which you accessed the RBI asset. This is used for the Finalize Risk button in the Assets section of the Risk Based Inspection Overview page.
Review Analysis by Corrosion Loop 580	Returns a list of all the RBI Criticality Analysis records that are calculated in the Created state for the Corrosion Loop record for which you accessed the RBI asset. This is used for the Finalize Risk button in the Unit Summary page. This query is used when Finalizing Risk from the Process Unit Overview page. Important: The SMST_ID (Alias Name: StateID) is a required field in this query. When using the query: do not remove this field from the query. do not change the alias of this field. do not modify the order of this field.
Select Protected Assets	Returns a list of the Asset records in the Select Protected Assets window.
Select Protected RBI Components	Returns a list of the RBI Components in the Select Protected Assets window.
Select RBI Components	Returns a list of the RBI Components that are: Linked to Asset records. Not linked to a Corrosion Loop record. This query is used to display available components which can be linked to corrosion loops.
Unlinked Corrosion Loops	Returns a list of all the Corrosion Loops that are not linked to a Unit. This query is used to display available corrosion loops which can be linked to a process unit.
Valid Inspections for Non-Intrusive Requirement Met	None.
View all Recommendations	Returns a list of all the recommendations for a selected Unit.
View Protected RBI Components	Returns a list of all the Protected RBI Components for a selected Unit.
Policy Queries folder	Contains queries that are used by RBI Strategy Mapping Groups when you generate RBI Recommendations records.

Inspection Plan Queries

The Catalog folder \\Public\Meridium\Modules\Inspection\Compliance\Queries contains the following queries used in the Inspection Plan workflow.

Query

Behavior and Usage

Compliance Recommendations by Plan

Displays Recommendations based on the Inspection Plan.

The following columns in the query must be used, and the aliases must contain the following values.


Column	Alias
[MI_COMP_RECOMM].ENTY_ID AND [MI_RBIRECOM].ENTY_ID	REC_ENTY_ID
[MI_COMP_RECOMM].ENTY_KEY AND [MI_RBIRECOM].ENTY_KEY	REC_ENTY_KEY
[MI_TASKINSP].[MI_TASK_ID]	Task ID
a."SUCC_ENTY_KEY"	Linked Actions
[MI_TASKINSP].ENTY_KEY	TASK KEY
{MIR_RBICRAN}.PRED_ENTY_KEY Note: For Compliance Recommendations, the column must be set to NULL. For RBI Consolidated Recommendations, the column must be set to 0.	Comp Key
PRED_ENTY_KEY Note: For Compliance Recommendations, the column must be set to NULL. For RBI Consolidated Recommendations, the column must be set to 0.	Analysis Key
MI_SM_STATES.SMST_ID	STATE_ID
[MI_COMP_RECOMM].FMLY_KEY AND [MI_RBIRECOM].FMLY_KEY	FMLY_KEY
[MI_RBIRECOM].[MI_RBIRECOM_NONRE_FLG]	NonRecurring?

Important: \\Public\Meridium\Modules\Inspection\Compliance\Queries\Compliance Superseded Recommendation Counts is a subquery and must not be removed from the parent query. In this subquery, the SUCC_ENTY_KEY column is required, and the alias must not be modified.

Compliance Recommendations to Supersede

Displays Recommendations for a given entity keys. This query is used to select the master Recommended Action while superseding Compliance Recommendations in the Recommendation section of the Inspection Plan page.

Important: The [MI_RBIRECOM].ENTY_KEY column must not be removed, and the alias REC_ENTY_KEY must not be modified.

Compliance Superseded Recommendations

Displays a list of Consolidated and Superseded Recommendations. This query is used to access the linked actions in the Inspection Plan page.

Note: The [MI_RBIRECOM].ENTY_KEY column must not be removed, and the alias REC_ENTY_KEY must not be modified.

Inspection Tasks for Asset

Displays the Inspection Tasks for an asset. This query is used to access the Existing Tasks in the Inspection Plan page.

Important: In the WHERE criteria, the ID of the parameter must be ASSET_ENTY_KEY.

Compliance Superseded Recommendation Counts

Returns the count of Consolidated and Superseded Recommendations. This query is used in the Recommendation section of the Inspection Plan page.

Inspection Tasks Available to Implement

Displays the Inspection Tasks available to implement for a Compliance Recommendation. This query is used to access the Inspection tasks after selecting the Implement button in the Inspection Plan page.

Recommended Actions by Selected Plans

Displays unimplemented actions from a given Inspection Plan. This query is used in the Inspection Plan page. The following columns in the query must be used, and the aliases must not be changed.


Column	Alias
[MI_COMP_RECOMM].ENTY_ID AND [MI_RBIRECOM].ENTY_ID	REC_ENTY_ID
{MIR_ASST_HAS_INSP_PLAN}.PRED_ENTY_KEY	ASSET_KEY

Important: In the WHERE clause, the ID of the parameter must be ENTY_KEYS.

Link Existing Task to Recommended Action

Returns an Inspection Task to link to a given Recommendation based on Asset and Task Type. This query is used in the Inspection Plan page. The following columns in the query must be used, and the aliases must not be changed.


Column	Alias
[MI_TASKINSP].ENTY_KEY	ENTY_KEY

Important: In the WHERE clause, the following parameter IDs must be provided and not modified:

TASK_TYPE
ASSET_KEY

All Inspection Plans for Unit

Returns all Inspection Plans for the selected location in the hierarchy. This query is used to access all the Inspection plans in the Inspection Plan Management page.

Active Recommendations of Plans for Unit

Returns all active recommendations for Inspection Plans for the selected location in the hierarchy. This query is used to view active recommendations in the Inspection Plan Management page.

Inspection Plan Revisions

Displays the Inspection Plan Revisions for a given Inspection Plan. This query is used to retrieve the revisions for an Inspection Plan.

Important:

The column [MI_INSP_PLAN_REV].[MI_INSP_PLAN_REV_REVI_DATE_D] must not be removed and its alias must not be changed.
In the WHERE clause, the ID of the parameter must be PLAN_ENTY_KEY.

Compliance Recommendation Revisions for Inspection Plan

Displays the Recommendation Revision records for a given Inspection Plan Revision. This query is used in the Inspection Plan page to view the revisions for a Recommendation.

Important:

The column [MI_COMP_REC_REV].[MI_REC_ID] must not be removed and its alias must not be changed.
In the WHERE clause, the ID of the parameter must be PLAN_REV_ENTY_KEY.

Risk Based Inspection Queries Folder

The Catalog folder \\Public\Meridium\Modules\Risk Based Inspection\Queries contains the following queries which are relevant to the RBI 581 workflow.


Query	Behavior and Usage
Asset Corrosion Analysis More Current than All Analyses	Returns a list of all the assets linked to a Functional Location that have a TM Asset Corrosion Analysis more current than the active RBI analysis in the component. This query is used on the Risk Based Inspection Overview page under the Inspection/TM Updates pane when both Risk Based Inspection and RBI 581 are licensed. Important: Do not modify the Asset Key column. Modifying this column may affect the functionality.
Assets with No Recommendations	Returns a list of all the assets linked to a Functional Location that have no RBI Recommendations and have at least one component with a Risk Completed analysis. This query is used on the Risk Based Inspection Overview page under the No Recommendations pane when both Risk Based Inspection and RBI 581 are licensed. Important: Do not modify the Asset Entity Key field. Modifying this field may affect the generate recommendation functionality.
Current Risk	Returns a list of the current rolled-up risk for each asset linked to a Functional Location. This query is used under the Current Risk query widget on the Risk Based Inspection Overview page.
Current Risk Overview	Returns a list of the highest Risk Category for each asset linked to a Functional Location and gives a count. This query is used under the Current Risk Overview graph widget on the Risk Based Inspection Overview page.
Inspections More Current Than All Analysis	Returns a list of all the assets linked to a Functional Location that have Inspections more current than the active RBI analysis in the component. This query is used on the Risk Based Inspection Overview under the Inspection/TM Updates tile when both Risk Based Inspection and RBI 581 licenses are active. Important: Do not modify the Asset Key column. Modifying this column may affect the functionality.
Past Risk	Returns a list of the past rolled-up risk for each asset under a Functional Location. This query is used under the Past Risk query widget on the Risk Based Inspection Overview page.
Past Risk Overview	Returns a list of the highest Risk Category for each asset Under a Functional Location and gives a count. This query is used under the Past Risk Overview graph widget on the Risk Based Inspection Overview page.
Process Unit Asset View	Returns all RBI Assets related to the given Process Unit and rolled up values from the RBI Assets related Inspection Plan. Important: Do not modify the Asset and the Asset Entity Key columns. Modifying these columns may affect the functionality.
Process Unit Corrosion Loop View	Returns all the Corrosion Loops related to the given Process Unit. Important: Do not modify the Corrosion Loop and the Corrosion Loop Key columns. Modifying these columns may affect the functionality.
Process Unit Query	Returns a list of the underlying Process Units for the selected level of the asset hierarchy. This query is used on the Risk Based Inspection Overview page under the Process Units tile. Important: Do not modify the ENTY_KEY column. Modifying this column may affect the functionality.
RBI Assets for a Functional Location	Returns a list of all the assets linked to a Functional Location. This query is used on the Risk Based Inspection Overview under the Assets tile. Important: Do not modify the Asset Entity Key column. Modifying this column may affect the functionality.
RBI Components for an Asset	Returns a list of all the RBI Components for a given asset. This query is used under the Asset Hierarchy Navigation menu to display the count of components on the Risk Based Inspection hyperlink.
Review Analyses by Asset 581	Returns a list of all the RBI 581 Risk Analysis records that are calculated in the Created state for the Equipment or Functional Location record for which you accessed the RBI asset. This query is used when Finalizing Risk from the Risk Based Inspection Overview page under the Assets pane.
Review Analysis by Corrosion Loop 581	Returns a list of all the RBI 581 Risk Analysis records that are calculated in Created state for the Corrosion Loop record for which you accessed the RBI asset. This query is used when Finalizing Risk from the Process Unit Overview page.
Select RBI Components	Returns a list of the RBI Components that are: Linked to Asset records Not linked to Corrosion Loop record This query is used to display available components which can be linked to corrosion loops.

Reports Folder

The Catalog folder \\Public\Meridium\Modules\Risk Based Inspection\Reports contains the following items.


Report Name	Behavior and Usage
RBI Asset Risk Report	Displays an at-a-glance summary of an asset in RBI, Thickness Monitoring, and Inspection Management.
RBI Asset Risk Sub Report	Displays all of the data used for the calculation of each component, the risk for each component, and the recommendations assigned to each risk.