Update the Non-Intrusive Requirement Met Query

If you are planning to use a single configured Degradation Mechanism (DM), multiple DMs, or an Internal Corrosion DME, you must update both the Valid Inspections for Non-Intrusive Requirement Met query and the Invalid Inspections for Non-Intrusive Requirement Met query in order for the Non-Intrusive Requirement Met check box to be enabled on the Internal Corrosion DME.

Steps

Access the Query page.
In the upper-right corner of the page, select Browse.

The Select a query from the catalog window appears.
In the left pane, navigate to the following folder: Public/Meridium/Modules/Risk Based Inspection/Queries
Select the Invalid Inspections for Non-Intrusive Requirement Met query, and then select Open.

The Enter Parameter Values window appears.
Select Cancel.

The Results section appears.
Select the SQL tab.

The SQL Query for the Invalid Inspections for Non-Intrusive Requirement Met appears.
In the query text:
- Find and replace all instances of <> with the text: NOT IN.
- Find and replace all instances of = with the text: IN.
- Find all instances of ='Criticality Calculator Internal Corrosion' and add a list of your configured internal corrosion DMs to the clause (e.g., IN ('Criticality Calculator Internal Corrosion', 'Custom Internal', 'Custom External')).
Select , and close the page.

The Query page appears.
In the upper-right corner of the page, select Browse.

The Select a query from the catalog window appears.
In the left pane, navigate to the following: Public/Meridium/Modules/Risk Based Inspection/Queries, then select the Invalid Inspections for Non-Intrusive Requirement Met query, and then select Open.

The Enter Parameter Values window appears.
Repeat steps 4-7.

The Non-Intrusive Requirement Met Query is updated.