Queries Folder

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

Query Name	Behavior and Usage
Active Analyses for Evergreening - 580	Returns the RBI Criticality Analysis records for RBI Components linked to RBI Assets that: Are related to the given Functional Location or Process Unit key. Are in the active state. Have an evergreening Batch ID.
Active Analyses for Evergreening - 581	Returns the RBI 581 Risk Analysis records for RBI Components linked to RBI Assets that: Are related to the given Functional Location or Process Unit key. Are in the active state. Have an evergreening Batch ID.
Analyses Created For Evergreening - 580	Returns the RBI Criticality Analysis records for RBI Components linked to RBI Assets that: Are related to the given Functional Location or Process Unit key. Are in the Created state. Have an evergreening Batch ID. IMPORTANT: Do not modify the following columns: Analysis ID, Component, Asset ID, Analysis Entity Key, and Risk Category. Modifying these columns may affect the Calculate functionality during the evergreening process.
Analyses Created For Evergreening - 581	Returns the RBI 581 Risk Analysis records for RBI Components linked to RBI Assets that: Are related to the given Functional Location or Process Unit key. Are in the Created state. Have an evergreening Batch ID. IMPORTANT: Do not modify the following columns: Analysis ID, Component, Asset ID, Analysis Entity Key, and Risk Category. Modifying these columns may affect the Calculate functionality during the evergreening process.
Analyses Ready for Evergreening - 580	Returns the RBI Criticality Analysis records for RBI Components linked to RBI Assets that: 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. IMPORTANT: Do not modify the ENTY_KEY column. Modifying this column may affect the duplicate functionality during the evergreening process.
Analyses Ready for Evergreening -581	Returns the RBI 581 Risk Analysis records for RBI Components linked to RBI Assets that: 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. 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 the RBI Criticality Analysis records for RBI Components linked to RBI Assets that: Are related to the given Functional Location or Process Unit key. Are in the active state. Have not been evergreened. 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 - 581	Returns the RBI 581 Risk Analysis records for RBI Components linked to RBI Assets that: Are related to the given Functional Location or Process Unit key. Are in the active state. Have not been evergreened. IMPORTANT: Do not modify the ENTY_KEY column. Modifying this column may affect the duplicate functionality during the evergreening process.
Asset Corrosion Analysis More Current Than Analyses	Returns all Assets linked to a Functional Location that have a TM Asset Corrosion Analysis more current than the active RBI analysis on the component. Note: This query will not return RBI 581 analyses.
Asset Counts for Units	Returns a count of assets that contain RBI data that is linked to Functional Locations hierarchically.
Assets with No Recommendations	Returns all assets linked to a Functional Location that do not have any Recommendations and at least one component with a risk complete analysis without RBI Recommendations. IMPORTANT: Do not modify the Asset Entity Key field. Modifying this field may affect the generate recommendation functionality.
Criticality Consequence Evaluation	None
Current Risk	Returns the current rolled-up risk for each Asset under a Functional Location.
Current Risk Overview	Returns the highest Risk Category for each Asset under a Functional Location and gives a count.
Export RBI Components by Asset	Returns 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 Analysis	Returns all Assets linked to a Functional Location that have Inspections more current than the active RBI analysis on the component. Note: This query will not return RBI 581 analyses.
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 the calculated maximum internal corrosion rate for an Internal Corrosion DME.
Past Risk	Returns the past rolled up risk for each Asset under a Functional Location.
Past Risk Overview	Returns the highest Risk Category for each Asset Under a Functional Location and gives a count.
PRD Consequence Evaluation	None
Process Unit Query	Returns a list of the Process Units that fall under the selected level of the Asset Hierarchy. Also returns a count of assets that are related to each given Process Unit hierarchically.
RBI Asset Risk Query	None
RBI Asset Risk Sub Query	None
RBI Assets for a Functional Location	Returns all Assets linked to a Functional Location.
RBI Components for an Asset	Returns all RBI Components for a given Asset.
RBI Corrosion Loops for a Functional Location	Returns all Corrosion Loops linked to a given Functional Location.
RBI DM Query	None
RBI Flexible Configuration Records	Returns all custom Degradation Mechanism Evaluation Configuration records.
RBI Flexible Validation Records	Returns all custom Degradation mechanism Evaluation Validation records.
RBI Overview Filter Parameters	None
RBI Pipeline Consequence Evaluation	None
Recommendations by Asset	Returns RBI Recommendation records related to the selected asset.
Review Analyses by Asset 580	Return all RBI Criticality Analysis records that are calculated in Created state for the Equipment or Functional Location record for which you accessed the RBI Asset.
Review Analysis by Corrosion Loop 580	Return all RBI Criticality Analysis records that are calculated in the Created state for the Corrosion Loop record for which you accessed the RBI Asset.
Review Analyses by Asset 581	Return all 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.
Review Analysis by Corrosion Loop 581	Return all RBI 581 Risk Analysis records that are calculated in Created state for the Corrosion Loop record for which you accessed the RBI Asset.
Select Protected Assets	Return Equipment records on the Select Protected Equipment window.
Select Protected RBI Components	Returns RBI Components on the Select Protected Equipment window.
Select RBI Components	Returns RBI Components that are: Linked to Equipment records. Not linked to a Corrosion Loop record.
Select Unit for Grouping	Returns all Functional Location records that: Represent a unit. Are linked to an Corrosion Loop record that is associated with RBI Components.
Unlinked Corrosion Loops	Returns all Corrosion Loops that are not linked to a Unit.
Valid Inspections for Non-Intrusive Requirement Met	None
View all Recommendations	Returns all recommendations for a selected Unit.
View Protected RBI Components	Returns all 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 automatically.