Configuring a Data-Element-to-Data-Element Mapping

The types of mapping between data elements are:

  • Copy value mapping

  • Value transformation mapping

  • Unit-of-measure mapping

  • Advanced mapping

When you create a mapping between data elements, the default mapping type created depends on the data elements being mapped:

  • If the source and target elements are of the same type (except if one or both has units of measure defined for it) or if the target element is of string type, the default mapping is copy value mapping.

  • If either the source or target data element has enumerations defined for it, the default mapping type is value transformation mapping.

  • If both the source and target have units defined from the same Units of Measure common model entity, the default mapping is unit-of-measure mapping.

  • If the source and target elements are of incompatible types (for example only one has units of measure defined or the source is dateTime and the target is Boolean), the default mapping type is an advanced mapping.

To configure a data-element-to-data-element copy value mapping:

  1. Open a mapping rule and click the Mapping tab.

  2. In the Entries table, select the mapping you would like to configure.

  3. In the Mapping subtab, click the target of the mapping you would like to configure.

  4. In the Mapping Rule Item area, select Copy Value.

  5. Configure the information in the Details, Condition, and Actions subtabs as necessary.

To configure a data-element-to-data-element value transformation mapping:

  1. Open a mapping rule and click the Mapping tab.

  2. In the Entries table, select the mapping you would like to configure.

  3. In the Mapping subtab, click the target of the mapping you would like to configure.

  4. In the Mapping Rule Item area, select Value Map.

  5. For each incoming value that you wish to transform, do the following:

    1. In the Configuration subtab, Transform Value Selection area, click Add.

    2. Enter values in the Input Value and Output Value fields and click OK.

  6. Configure the information in the Details, Condition, and Actions subtabs as necessary.

To configure a data-element-to-data-element unit-of-measure mapping:

In general, there is no need to configure unit-of-measure mappings. If you create a mapping between two data elements with compatible units of measure defined for them, when you create a mapping between them, it is created as a unit-of-measure mapping by default. If you create a mapping between any other types of data elements, the unit-of-measure mapping is not available. However, if you have a mapping between compatible data elements that you have changed to another type of mapping, and you want to reconfigure it as a unit-of-measure mapping, you can use the following procedure.

  1. Open a mapping rule and click the Mapping tab.

  2. In the Entries table, select the mapping you would like to configure.

  3. In the Mapping subtab, click the target of the mapping you would like to configure.

  4. In the Mapping Rule Item area, select Unit Of Measure.

    The units defined for the data elements are automatically populated in the Target Unit and Source Unit fields and cannot be changed.

To configure a data-element-to-data-element advanced mapping:

  1. Open a mapping rule and click the Mapping tab.

  2. In the Entries table, select the mapping you would like to configure.

  3. In the Mapping subtab, click the target of the mapping you would like to configure.

  4. In the Mapping Rule Item area, select Advanced.

  5. In the Mapping Rule Item area, enter information about the XQuery expression you would like to use. See "About Creating XQuery Expressions with Design Studio" for more information about entering information into XQuery controls. See "About Data-Element-to-Data-Element Advanced Mapping XQuery Expressions" for more information about this XQuery field.

  6. Configure the information in the Details, Condition, and Actions subtabs as necessary.

Related Topics

Configuring Mappings