Mappings | On-Premises APM

About Values Mapped to RBI Recommendations

When you generate RBI Recommendations, the fields in RBI Recommendations are populated with values from:

The RBI Criticality Analysis or the RBI PRD Criticality Analysis to which the RBI Recommendation is linked.
The RBI Components that are linked to the associated RBI Criticality Analysis or the RBI PRD Criticality Analysis.
The Asset that is linked to the associated RBI Components.
The Degradation Mechanisms record that is linked to the associated RBI Criticality Analysis.
The Inspection Strategy that was used to generate the RBI Recommendation.

Additionally, some RBI Recommendations may be populated with values from the Criticality Int. Corr. Deg. Mech. Eval. linked to the associated RBI Criticality Analysis.

RBI Recommendation Fields Populated from Related Records

The following table lists the RBI Recommendation fields that are populated automatically from these sources.

Note: Some of the fields listed in the table are not available on any of the datasheets that are configured for the RBI Recommendation family.


This RBI Recommendation field:	...is populated with:	...from the following record:
Analysis ID	The value in the Analysis ID field.	The associated RBI Criticality Analysis.
Asset ID	The value in the Asset ID field.	The related Asset.
Author Name	The last and first name of the Security User who created the RBI Recommendation.	The Security User who initiated the generation of the RBI Recommendation.
Damage Mechanism	The value in the Degradation Mechanism field.	The RBI Degradation Mechanism that is linked to the associated RBI Criticality Analysis.
Functional Location ID	The value in the Equipment ID field.	The associated RBI Criticality Analysis.
Nonrecurring?	FALSE	None
Originating Reference	The Recommendation ID.	The associated RBI Criticality Analysis.
RBI Component	The value in the Component Description field.	The associated RBI Component.
RBI Recommendation Methodology	The value Criticality Calculator.	The associated RBI Criticality Analysis.
Recommendation Basis	The value in the Inspection Strategy Description field.	The Inspection Strategy that generated the RBI Recommendation.
Recommendation Headline	The value RBI- <RBI Components Record ID>-<Damage Mechanism> ...where: <RBI Components Record ID> is the Record ID of the associated RBI Component. <Damage Mechanism> is the value in the Damage Mechanism field in the RBI Recommendation. For example, given the following values: RBI Components Record ID = Storage Tank Damage Mechanism = Brittle Fracture The Recommendation Headline would be: RBI- Storage Tank- Brittle Fracture	The associated RBI Component.
Recommended Inspection Scope	The value in the Recommended Inspection Scope field.	The Inspection Strategy that generated the RBI Recommendation.
Recommended Interval Scope	One of the following values, depending on the following scenarios: When the Use Calculated Data field in the Inspection Strategy that generated the RBI Recommendation is set to: False, then the value in the Recommended Inspection Interval field in the Inspection Strategy is used. True, then the value in the Estimated Half Life field in the Criticality Int. Corr. Deg. Mech. Eval. that is linked to the associated RBI Criticality Analysis is used. For all RBI Recommendations associated with RBI PRD Criticality Analyses, the value in the Recommended Inspection Interval field in the associated RBI PRD Criticality Analysis.	One of the following: Inspection Strategy Criticality Int. Corr. Deg. Mech. Eval.. PRD Analysis
Status	The value Created.	None
Task Type	The value in the Inspection Task Type field.	The Inspection Strategy that generated the RBI Recommendation.

About Values Mapped to Risk

When you promote an asset to Asset Strategy Management (ASM), a Risk is created in ASM for each Degradation Mechanisms record (DM) in active RBI Criticality Analyses. This Risk contains the details of unmitigated and mitigated risks defined in the DM.

The following table provides a list of fields on the Risk datasheet that are populated from the DM or the associated RBI Criticality Analysis.


This Risk field:	...is populated with:	...from the following associated records:
Name	A value in the following format: <Equipment Description> ~ <Degradation Mechanism> If there is no value in the Equipment Description field, then the value in the Equipment Type field is used.	RBI Criticality Analysis and DM
Description	A value in the following format: <Equipment Description> ~ <Degradation Mechanism> If there is no value in the Equipment Description field, then the value in the Equipment Type field is used.	RBI Criticality Analysis and DM
Failure Mode	The value in the Degradation Mechanism field	DM
Maintainable Item	A value in the following format: <RBI Component Entity ID> ~ <Equipment Description or Equipment Type>	RBI Criticality Analysis and Criticality Calculator RBI Component
Failure Cause	The value in the Degradation Mechanism field	DM
Unmitigated Financial Risk	The value in the Unmitigated Financial Risk Rank field	DM
Risk Basis	The value Risk Based Inspection	None

RBI Values Mapped to ASM

When you promote an Asset record to ASM, several fields in the ASM records are populated automatically. The following tables list the source RBI records whose field values are mapped, the target ASM records to which the values are mapped, and the datasheet captions of the fields that are populated automatically.

Values Mapped to the Asset Strategy Record


Datasheet Caption of Asset Strategy Field	Source RBI Record	Datasheet Caption of Source RBI Field
Strategy ID	RBI Criticality Analysis	Component
Asset Name	Asset	This will vary. Rather than mapping the value in a specific field in the source Asset record, the Record ID is used as the default value in the Asset Name field in the Asset Strategy.

Values Mapped to the Active Strategy Record

Datasheet Caption of Active Strategy Field: Strategy ID
Source RBI Record: RBI Criticality Analysis
Datasheet Caption of Source RBI Field: Component

Values Mapped to the Proposed Strategy Record

Datasheet Caption of Active Strategy Field: Strategy ID
Source RBI Record: RBI Criticality Analysis
Datasheet Caption of Source RBI Field: Component

Values Mapped to Risk Records


Datasheet Caption of Risk Assessment Field	Source RBI Record	Datasheet Caption of Source RBI Field
Risk ID	RBI Criticality Analysis	Component
Risk Rank	RBI Degradation Mechanisms	On the datasheet, the source value appears at the intersection of the Unmitigated Risk row and the Strategy Risk Rank column.
Financial Risk	RBI Degradation Mechanisms	On the datasheet, the source value appears at the intersection of the Unmitigated Financial Risk row and the Strategy Risk Rank column.
Name	RBI Degradation Mechanisms -and- RBI Criticality Analysis	Degradation Mechanism -and- Criticality Item Description
Description	RBI Degradation Mechanisms -and- RBI Criticality Analysis	Degradation Mechanism -and- Criticality Item Description
Failure Mode	RBI Degradation Mechanisms	Degradation Mechanism
Failure Cause	RBI Degradation Mechanisms	Degradation Mechanism

Values Mapped to Risk Assessment Records


Datasheet Caption of Risk Assessment Field	Source RBI Record	Datasheet Caption of Source RBI Field
Risk Rank	RBI Degradation Mechanisms	On the datasheet, the source value appears at the intersection of the Mitigated Risk row and the Strategy Risk Rank column.
Financial Risk	RBI Degradation Mechanisms	On the datasheet, the source value appears at the intersection of the Mitigated Financial Risk row and the Strategy Risk Rank column.

Values Mapped to Risk Rank Records


Datasheet Caption of Risk Assessment Field	Source RBI Record	Datasheet Caption of Source RBI Field
Risk	RBI Degradation Mechanisms	The source values that are mapped to the Risk field in Risk Rank records come from the values that appear on the Risk Matrix that is accessible from the RBI Degradation Mechanisms record. This mapping is best understood through an example. Suppose you access the Risk Matrix from the Brittle Fracture RBI Degradation Mechanisms record, and the unmitigated risk on the Safety tab is 10. In this case, if you open the Risk Rank records that are linked to the Risk Assessment record to which the Brittle Fracture Risk record is linked, the Risk Rank record with the value Safety in the Category field will contain the value 10 in the Risk field.
Production Loss	RBI Degradation Mechanisms	The source values that are mapped to the Production Loss field in Risk Rank records come from the values that appear on the Risk Matrix that is accessible from the RBI Degradation Mechanisms record. This mapping is best understood through an example. Suppose you access the Risk Matrix from the Brittle Fracture RBI Degradation Mechanisms record, and the Production Loss on the Financial tab is 100. In this case, if you query the Risk Rank records that are linked to the Risk Assessment record to which the Brittle Fracture Risk record is linked, the Risk Rank record with the value Financial in the Category field will contain the value 100 in the Production Loss field.
Maintenance Cost	RBI Degradation Mechanisms	The source values that are mapped to the Maintenance Cost field in Risk Rank records come from the values that appear on the Risk Matrix that is accessible from the RBI Degradation Mechanisms record. This mapping is best understood through an example. Suppose you access the Risk Matrix from the Brittle Fracture RBI Degradation Mechanisms record, and the Maintenance Cost on the Financial tab is 100. In this case, if you query the Risk Rank records that are linked to the Risk Assessment record to which the Brittle Fracture Risk record is linked, the Risk Rank record with the value Financial in the Category field will contain the value 100 in the Maintenance Cost field.

Values Mapped to Action Records


Datasheet Caption of Risk Assessment Field	Source RBI Record	Datasheet Caption of Source RBI Field
Action ID	RBI Criticality Analysis	Component
Action Type	RBI Recommendation	Action Type
Cost	RBI Recommendation	Estimated Cost
Cost Basis	RBI Recommendation	Estimated Cost Basis
Description	RBI Recommendation -AND- Recommendation	Recommended Inspection Scope -AND- Recommendation Basis
Interval	RBI Recommendation	RBI Recommendation
Name	RBI Recommendation	Task Type
Nonrecurring	RBI Recommendation	NonRecurring?
Shutdown Required	Shutdown Required	Shutdown Required
Target Completion Date	RBI Recommendation	Target Completion Date

Hard-Coded Values

When you promote an Asset record to ASM, some values in the ASM records are hard-coded to be populated with a default value that is different from the standard default value for these values. The fields and their default values are listed in the following table.


ASM Record	Datasheet Caption	Default Value
Asset Strategy	Description	This strategy was automatically generated from RBI
Active Strategy	Description	This strategy was automatically generated from RBI
Proposed Strategy	Description	This strategy was automatically generated from RBI
Risk	Risk Basis	Risk Based Inspection
Risk	Source	RBI Analysis
Recommendation	Interval Units	Months
Recommendation	Action Basis	RBI Recommendation

In addition, if you promote an Asset record that is associated with an RBI Degradation Mechanisms record that is not linked to an RBI Recommendation record, for the Risk record that is created from that RBI Degradation Mechanisms record, the Strategy Mitigated Risk Rank in ASM will be set to the value in the Unmitigated Risk Rank field in the Risk record.

About Values Mapped to Action

When you promote an asset to Asset Strategy Management (ASM), an Action is created in ASM for each RBI Recommendation in active RBI Criticality Analyses. This Action contains the details of the Recommendation.

The following table provides a list of the fields on an Action datasheet that are populated from the RBI Recommendation.


This Action field:	...is populated with:
Action Basis	The value RBI Recommendation.
Action Source	The value RBI.
Action Task Type	The value in the Task Type field.
Action Basis	The value in the Action Type field.
Cost	The value in the Estimated Cost field.
Cost Basis	The value in the Estimated Cost Basis field.
Description	<Recommendation Inspection Scope> ~ <Recommendation Basis>
Interval	The least value among the following: The value in the Interval field in the RBI Recommendation The value in the RBI Half-Life field in the associated Degradation Mechanism Evaluation The value in the TM Half-Life field in the associated Asset Corrosion Analysis. Time Based Inspection Settings
Interval Basis	The value of the Interval Basis that corresponds to the Interval field (only if the value in the Override Interval field in the Task is set to False).
Interval Units	The value Months.
Name	<Damage Mechanism> ~ <Task Type>
Nonrecurring	The value in the NonRecurring? field.
Shutdown Required	The value in the Asset Shutdown Required? field.

About Values Mapped to Inspection Task

When you promote an asset to Asset Strategy Management (ASM), and create an Inspection Task based on an Action, the fields in the Inspection Task are populated with the values in the various records. The following table provides a list of fields on an Inspection Task datasheet that are populated automatically from these sources.


This Inspection Task field:	...is populated with:	...from the following record:
Asset ID	The entity key of the Asset that is associated with the Asset Strategy.	Asset Strategy
Asset Key	The entity key of the Asset that is associated with the Asset Strategy.	Asset Strategy
Desired Interval	The highest value among the values in the RBI Half-Life, TM Half Life, Recommendation Interval, and Time-Based Settings fields.	RBI Recommendation Degradation Mechanism Evaluation Asset Corrosion Analysis
Desired Interval Basis	The value of the Interval Basis that corresponds to the Desired Interval field (only if the value in the Override Interval field in the Task is set to False).	Action
Next Date	Not applicable.	RBI Recommendation
Next Date Basis	Not applicable.	RBI Recommendation
Override Interval	FALSE	None
Reason	The value in the Action basis field	Action
Rejectable	The value False if the value in the Mandatory field is set to True. The value True if the value in the Mandatory field is set to False.	Action
Reoccurring	TRUE	None
Task Details	The value in the Description field.	Action
Task ID	The value in the Name field.	Action
Task Type	The value in the Action Task Type field.	Action

Risk Analysis Mapping

The Risk Analysis Mapping family defines the Policy records that are used to populate the RBI Risk Matrix automatically from RBI Analyses. The following table provides the baseline state and behavior of fields that exist in the Risk Analysis Mapping family.

Note: The Risk Analysis Mapping family supports RBI Criticality, RBI Pipeline, and RBI PRD Criticality Analyses. These mappings support both the default and the Standard Practice risk matrices.


Field	Caption	Data Type	Description	Behavior and Usage
MI_RRSKMAP_ANLY_FAM_C	Analysis Family	Character	The Family ID of the analysis.	This field is populated automatically.
MI_RRSKMAP_DEG_MECH_C	Degradation Mechanism	Character	The Degradation Mechanism that stores values that are used to populate the Risk Matrix.	This field is populated automatically.
MI_RRSKMAP_POLICY_NM_C	Policy Name	Character	The name of the Policy that is used to populate the Risk Matrix.	This field is populated automatically.
MI_RRSKMAP_RISK_CTG_C	Risk Category	Character	The Risk Category that is populated on the Risk Matrix (e.g., Environment, Financial Risk, Operations, Safety).	This field is populated automatically.

The Policy Input Nodes that are used by the Risk Analysis Mapping family to populate the RBI Risk Matrix depend on both the type of Risk Category that you choose and the Degradation Mechanism that you apply to the family. The information in the following tables indicates which policy nodes and input fields are used when populating your selected RBI Risk Matrix.

Note: When you calculate an RBI Criticality Analysis or RBI Pipeline Analysis, the Failure Frequency field is populated by Degradation Mechanism Evaluation that corresponds to each Degradation Mechanism in the selected RBI Analysis.

The following table provides the range of the financial loss based on the consequence category.


Consequence Category	Description	Range in USD
A	Catastrophic	> $10,000,000
B	Very Serious	$1,000,000 - $10,000,000
C	Serious	$100,000 - $1,000,000
D	Significant	$10,000 - $100,000
E	Minor	< $10,000

The value in the Production Loss Category field in a Criticality Consequence Evaluation indicates the amount of financial loss expected from an event. By default, the value in the Production Loss Category field is converted to a numeric equivalent, and mapped to the Production Loss input node in the risk mapping policies. The lowest value in each range is the default production loss value. The following table provides the default value of production loss based on the value in the Production Loss Category field.


Production Loss Category	Default Production Loss Value in USD
A	$10,000,000
B	$1,000,000
C	$100,000
D	$10,000
E	$5,000

Risk Analysis Mapping for RBI Criticality Analyses

Risk Category - Environment: The following table provides the values in the Policy Input Node, Source Family, and Source Field fields in the Risk Analysis Mapping Details record for the RISK_MAPPING-ENVIRONMENT and DEFAULT-RISK_MAPPING-ENVIRONMENT policies.


Policy Input Node	Source Family	Source Field
Component Type	RBI Criticality Analysis	Criticality Item Type
Environment Category	Criticality Consequence Evaluation	Environmental Consequence Category
Failure Frequency	Criticality Ext. Corr. Deg. Mech. Eval. Criticality Int. Corr. Deg. Mech. Eval. Criticality Env. Crack. Deg. Mech. Eval. Criticality Other Damage Mech. Eval.	Failure Frequency
Risk Category	Risk Analysis Mapping	Risk Category

Risk Category - Financial Risk: The following table provides the values in the Policy Input Node, Source Family, and Source Field fields in the Risk Analysis Mapping Details record for the RISK_MAPPING-FINANCIAL and DEFAULT-RISK_MAPPING-FINANCIAL policies.


Policy Input Node	Source Family	Source Field
Failure Frequency	Criticality Degradation Mech Evaluation	Failure Frequency
Maintenance Cost	Criticality Consequence Evaluation	Cleanup Cost
Production Loss	Criticality Consequence Evaluation	Lost Production Category
Risk Category	Risk Analysis Mapping	Risk Category

Risk Category - Operations: The following table provides the values in the Policy Input Node, Source Family, and Source Field fields in the Risk Analysis Mapping Details record for the RISK_MAPPING-OPERATIONS and DEFAULT-RISK_MAPPING-OPERATIONS policies.


Policy Input Node	Source Family	Source Field
Consequence (only for Criticality Int. Deg. Mech. Eval. and Criticality Env. Crack. Deg. Mech. Eval.)	Criticality Consequence Evaluation	Product Leak Category
Failure Frequency	Criticality Ext. Corr. Deg. Mech. Eval. Criticality Int. Corr. Deg. Mech. Eval. Criticality Env. Crack. Deg. Mech. Eval. Criticality Other Damage Mech. Eval.	Failure Frequency
Lost Production Category	Criticality Consequence Evaluation	Lost Production Category
Risk Category	Risk Analysis Mapping	Risk Category

Risk Category - Safety: The following table provides the values in the Policy Input Node, Source Family, and Source Field fields in the Risk Analysis Mapping Details record for the RISK_MAPPING-SAFETY and DEFAULT-RISK_MAPPING-SAFETY policies.


Policy Input Node	Source Family	RBI Analysis Source Field
Failure Frequency	Criticality Ext. Corr. Deg. Mech. Eval. Criticality Int. Corr. Deg. Mech. Eval. Criticality Env. Crack. Deg. Mech. Eval. Criticality Other Damage Mech. Eval.	Failure Frequency
Risk Category	Risk Analysis Mapping	Risk Category
Toxic Category	Criticality Consequence Evaluation	Toxic Consequence Category
Flammable Category	Criticality Consequence Evaluation	Flammable Consequence Category

Risk Analysis Mapping for PRD Criticality Analyses

Risk Category - Operations: The following table provides the values in the Policy Input Node, Source Family, and Source Field fields in the Risk Analysis Mapping Details record for the PRD-DEF-RISK_MAPPING-OPERATIONS and PRD-RISK_MAPPING-OPERATIONS policies.


Policy Input Node	Source Family	Source Field
Consequence	PRD Consequence Evaluation	Leak Consequence Category
Probability	Criticality Over Pressure Deg. Mech. Eval.	Failure Frequency of Protected Asset
Probability	Criticality Leak Deg. Mech. Eval.	Probability of Leak
Risk Category	Risk Analysis Mapping	Risk Category

Risk Category - Safety: The following table provides the values in the Policy Input Node, Source Family, and Source Field fields in the Risk Analysis Mapping Details record for the PRD-DEF-RISK_MAPPING-SAFETY and PRD-RISK_MAPPING-SAFETY policies.


Policy Input Node	Source Family	Source Field
Consequence	Criticality Over Pressure Deg. Mech. Eval.	Consequence of Failure at Overpressure
Consequence	PRD Consequence Evaluation	Leak Consequence Category
Probability	Criticality Leak Deg. Mech. Eval.	Probability of Leak
Probability	Criticality Over Pressure Deg. Mech. Eval.	Failure Frequency of Protected Asset
Risk Category	Risk Analysis Mapping	Risk Category

Risk Analysis Mapping for Pipeline Analyses

Risk Category - Environment: The following table provides the values in the Policy Input Node, Source Family, and Source Field fields in the Risk Analysis Mapping Details record for the PL-RISK_MAPPING-ENVIRONMENT and PL-DEF-RISK_MAPPING-ENVIRONMENT policies.


Policy Input Node	Source Family	Source Field
Component Type	RBI Pipeline Analysis	Criticality Item Type
Environment Consequence Category - Hole	Criticality Consequence Evaluation	Environment Consequence Category - Hole
Environment Category - Rupture	Criticality Consequence Evaluation	Environment Consequence Category - Rupture
Failure Frequency	Criticality Third Party Deg. Mech. Eval. Criticality Ext. Corr. Deg. Mech. Eval. Criticality Int. Corr. Deg. Mech. Eval. Criticality Env. Crack. Deg. Mech. Eval.	Failure Frequency
Risk Category	Risk Analysis Mapping	Risk Category

Risk Category - Financial Risk: The following table provides the values in the Policy Input Node, Source Family, and Source Field fields in the Risk Analysis Mapping Details record for the PL-RISK_MAPPING-FINANCIAL and PL-RISK_MAPPING-FINANCIAL policies.


Policy Input Node	Source Family	Source Field
Failure Frequency	Criticality Degradation Mech Evaluation	Failure Frequency
Maintenance Cost- Hole	Criticality Consequence Evaluation	Impact Clean Up Cost - Hole
Maintenance Cost - Rupture	Criticality Consequence Evaluation	Impact Clean Up Cost - Rupture
Production Loss - Hole	Criticality Consequence Evaluation	Lost Production Category - Hole
Production Loss - Rupture	Criticality Consequence Evaluation	Lost Production Category - Rupture
Risk Category	Risk Analysis Mapping	Risk Category

Risk Category - Operations: The following table provides the values in the Policy Input Node, Source Family, and Source Field fields in the Risk Analysis Mapping Details record for the PL-RISK_MAPPING-OPERATIONS and PL-DEF-RISK_MAPPING-OPERATIONS policies.


Policy Input Node	Source Family	Source Field
Failure Frequency	Criticality Ext. Corr. Deg. Mech. Eval. Criticality Third Party Deg. Mech. Eval. Criticality Env. Crack. Deg. Mech. Eval.	Failure Frequency
Lost Production Category - Hole	Criticality Consequence Evaluation	Lost Production Category - Hole
Lost Production Category - Rupture	Criticality Consequence Evaluation	Lost Production Category - Rupture
Risk Category	Risk Analysis Mapping	Risk Category

Risk Category - Safety: The following table provides the values in the Policy Input Node, Source Family, and Source Field fields in the Risk Analysis Mapping Details record for the PL-RISK_MAPPING-SAFETY and PL-RISK_MAPPING-SAFETY policies.


Policy Input Node	Source Family	Source Field
Failure Frequency	Criticality Third Party Deg. Mech. Eval. Criticality Ext. Corr. Deg. Mech. Eval. Criticality Int. Corr. Deg. Mech. Eval. Criticality Env. Crack. Deg. Mech. Eval.	Failure Frequency
Flammable Category - Hole	Criticality Consequence Evaluation	Flammable Consequence - Hole
Flammable Category - Rupture	Criticality Consequence Evaluation	Flammable Consequence - Rupture
Risk Category	Risk Analysis Mapping	Risk Category
Toxic Category - Hole	Criticality Consequence Evaluation	Toxic Consequence - Hole
Toxic Category - Rupture	Criticality Consequence Evaluation	Toxic Consequence - Rupture

Create Data Mapping Group

About This Task

To map fields from Component to a custom DME family, you must create and configure a Data Mapping Group.

Procedure

On the top navigation bar, select , and then navigate to and select Data Mapping Group.
The Record Manager page appears, displaying a new Data Mapping Group datasheet.
On the Data Mapping Group datasheet, in the ID box, enter a value in the following format:
RBI_CNAFC_<Component Family ID>-<New DME Family ID> (for example, RBI-CNAFC MI_CCRBICTB-TEST_CUST_DME)
In the Source Family box, select the component family ID.
In the Target Family box, select the new DME family ID.
Update the baseline query for the component by adding the new fields required for the mapping. The baseline query is located in Public\Meridium\Modules\Risk Based Inspection\Queries\Mapping Queries\RBI-CNAFC Query MI_CCRBICOM.
Create a linked Data Mapping Query record to the newly created Data Mapping Group record.
Set the newly created Data Mapping Query record as the root record.
Create a linked Data Mapping Column-Field Pair record to the newly created Data Mapping Query record.
1. In the Source Query Field box, select the field from the modified query.
2. In the Target Field(s) box, select the corresponding target field.

Results

The Data Mapping Group is configured.