<< Click to Display Table of Contents >> Navigation:  EDP > Customizability > Remap

Users can manage synonyms on both import and export of data using the EQuIS remap tool. Define as many different remap sets as desired by giving them each a unique REMAP_CODE. For example, different remap sets can be defined for different types of  EDDs (Electronic Data Deliverable), different data submitters, different projects, etc.  

 

The remap values used in the RT_REMAP and RT_REMAP_DETAIL tables can be uploaded to the database using the EarthSoft Reference Values Format (refvals.zip), typically installed in the EQuIS Professional formats folder (e.g., C:\Program Files\EarthSoft\EQuIS\Formats\EarthSoft). Any external values entered in the RT_REMAP_DETAIL.EXTERNAL_VALUE will remap to the internal value entered in the RT_REMAP_DETAIL.INTERNAL_VALUE field.

 

 

Formats with Automatic Remaps

 

Automatic remapping can be added in an EQuIS custom format by following the steps provided in Format Customization - Auto-Remapping.

 

To comply with various government agency submission guidelines, the EQuIS Remap tool is automatically implemented in some EarthSoft formats. For example, the valid values used in the AQS format or GeotrackerEDF format may not be the values stored in the EQuIS database. To account for this remapping is used to convert the government agency valid value to an EQuIS reference value and vice versa.

 

When a format automatically remaps within EDP, this is indicated in the format EDD Description file in the Database Mapping column. Create the EDD Description file in EDP or Enterprise EDP.

 

The required RT_REMAP table values based on the EarthSoft format are listed below:

 

 

 

RT_REMAP_DETAIL fields should be populated as follows:

•EXTERNAL_FIELD (256 char): Populate with format Section Name.Field Name or *.Field Name.

•EXTERNAL_VALUE (2000 char): Populate with value that will be submitted to the agency. Reference the format description file for the data type and field length of each column, (e.g., numeric, 20 characters). EXTERNAL_VALUE must be unique so a pipe [|] should be used to separate the values and will be treated as an "or".

•INTERNAL_VALUE (128 char): Must be unique. Populate with value that exists in the EQuIS database. The EXTERNAL_VALUES will be remapped to this INTERNAL_VALUE for the field indicated in EXTERNAL_FIELD.  

•STATUS_FLAG (1 char): Populate with ‘A’.

•REMAP_CODE (20 char): Populate with RT_REMAP.REMAP_CODE.

 

 

On export, the entire external value will be exported (not just the first value) when it contains a pipe. However, format exports do not use the same code, so they can be customized to export the whole list, a single value, or to use the original value, if stored in a custom field. If this customization is desired, please contact EarthSoft Support.