Remap Sets - Creating a Set

Using the EQuIS remap tool, you can manage synonyms on both import and export of data. It is possible to define as many different remap sets as desired by giving them each a unique REMAP_CODE. For example, there may be different remap sets for different types of EDDs, different data submitters, different projects, etc.

The first step is to create one or more remap sets that will be used for replacing values. A remap set consists of the tables that define the value-to-value mappings. In order to create a remap set, do the following:

1.Open EQuIS Professional.

2.Click the Tables button.

3.Open RT_REMAP.

4.Add a new row (it is also possible to optionally populate other fields):

a.REMAP_CODE = "<name of remap set>"

b.REMAP_DESC = "<description of remap set>"

c.STATUS_FLAG = "A"

5.Save new row in RT_REMAP.

6.Open RT_REMAP_DETAIL.

7.Add a new row for each value-to-value mapping as indicated below.

a.REMAP_CODE = "<name of remap set>"

b.EXTERNAL_FIELD = "<table or format section name>.<fieldname>" (e.g. rt_matrix.matrix_code or EFW2FSample.sample_matrix_code) or

use the asterisk as a wildcard to apply the remap to all tables/sections that include the target field (e.g. *.test_type).

EXTERNAL_VALUE = "<external value>" (such as "GW")

To specify multiple external values, use the pipe delimiter ( | ) to separate the values (e.g. "GW|Groundwater|GrndWtr").

INTERNAL_VALUE = "<internal value>" (such as "WG")

8.Save the new row(s) in the RT_REMAP_DETAIL table.

Notes:

•The wildcard "*" format is required for remapping report output.

•In the RT_REMAP_DETAIL table, the combination of external_field, internal_value, and remap_code values must be unique.

Once the remap set(s) is complete, the remapping may be applied by selecting the Find option in EDP or Professional.