Replacing sub-record field values

You can replace a value in a data field with another value. You can replace a value when the external system and the asset management system have different identifiers for the same entity. For example, a plant identifier of an external system can be translated to an asset management system site identifier.

Before you begin

You must create a processing rule that contains a replace action before you can replace sub-record field values. You must also create a cross-reference control that contains the original and new values for the data field.

Procedure

  1. In the Enterprise Services or Publish Channels application, display the service or channel record to which the sub-record field replace action applies.
  2. On the Enterprise Services or Publish Channels tab, select the processing rule to which the sub-record field replace action applies.
  3. Perform one of the following actions:
    • For an enterprise service, click Sub-Record Fields on the Object Structure Processing Rules tab or the Object Processing Rules tab.
    • For a publish channel, click Sub-Record Fields on the Processing Rules for Sub-Record table window.
  4. Click New Row.
  5. In the Field field, enter the name of the target data field.
    This value defines the field that you want to replace. The target field must be in the sub-record object.
  6. In the Integration Control field, enter the name of the cross-reference type control that contains the original and new values for the target field.
  7. Click OK.