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, 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).

Formats with Automatic Remaps

Automatic remapping can be added in an EQuIS custom format b 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, GeotrackerEDF format, etc. may not be the values stored in the EQuIS database.

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

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

Format	REMAP_CODE	REMAP_DESC
AQS	AQS	AQS
ERPIMS	ERPIMS	Not required
GeotrackerEDF	GeoTrackerEDF	Not required
HZST	HZST	HZST

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).

•INTERNAL_VALUE (128 char): 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.