EIM Export

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Custom Reports >

EIM Export

Report Name: EIM Export

File Name: EarthSoft.Reports.Library.100111.dll

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: contact support@earthsoft.com

Language: English

Output Type: Excel1

 

Description: Many clients in Washington State are required to submit data to the Department of Ecology (Ecology) database, EIM. This process can be time consuming and complicated. The EIM Export Report for EQuIS Professional is designed to assist with this process by exporting data from EQuIS directly into the EIM Location and EIM Result loader spreadsheets provided by Ecology.

 

Installation Instructions: Download the EIM Export report, unblock the *.zip file and extract the EarthSoft.Reports.Library.100111.dll to the EQuIS Professional installation folder. For default installations this directory is C:\Program Files\EarthSoft\EQuIS. The report will be available for selection once Professional has been relaunched.

 

Overview:

The EIM Export files generated from EQuIS meet the general EIM format requirements as of 2014. The valid values in the template are subject to change and not regularly updated in the EQuIS report. It is incumbent on users to review and finalize the files prior to official submittal to ensure current requirements are met (see EIM Help Docs).

 

This report requires the following prequisites:

oLocations with coordinates where COORD_TYPE_CODE = LAT/LONG.

oCoordinate Type Code and Identifier are required parameters for this report.
       Due to the way the EIM loader template handles coordinates, this report will only output one set of coordinate data at a time.

oEIM Load template files named EIMResultV2013.01 and EIMLocationV2013.01 must be stored in DT_FILE. These files are available from EIM Help Docs.

oIn addition to these data requirements, remapping is also required as described below.

 

This report requires populating the EQuIS remap tables (RT_REMAP, RT_REMAP_DETAIL) to enable the Locations and Results output by mapping the EQuIS values to the EIM valid values. (If any remap is missing, the report will use the EQuIS item itself, e.g. if the remap of DT_TEST.PREP_METHOD does not exist, it will use DT_TEST.PREP_METHOD).

 

Remap details are shown below and in the EIM Export Mapping.  

 

remap_code = EIM_EXPORT

external_field = EQuIS Field Name (e.g. PREP_METHOD)

external_value = value specified for EIM

internal_value = equivalent value stored in EQuIS

 

The following data field values are remapped using RT_REMAP_DETAIL. See the remap help article for setup details.

 

Location Data

EIM Field Name

RT_REMAP_DETAIL.EXTERNAL FIELD

EQuIS Field (table.field)

Coordinate_System

COORD_TYPE_CODE

DT_COORDINATE.COORD_TYPE_CODE

Elevation_Accuracy

ELEV_ACCURACY_VALUE

DT_COORDINATE.ELEV_ACCURACY_VALUE

Elevation_Collection_Method

ELEV_COLLECT_METHOD_CODE

DT_COORDINATE.ELEV_COLLECT_METHOD_CODE

Well_Completion_Type

HEAD_CONFIGURATION

DT_WELL.HEAD_CONFIGURATION

Horizontal_Coordinate_Accuracy

HORZ_ACCURACY_VALUE

DT_COORDINATE.HORZ_ACCURACY_VALUE

Horizontal_Coordinate_Collection_Method

HORZ_COLLECT_METHOD_CODE

DT_COORDINATE.HORZ_COLLECT_METHOD_CODE

Horizontal_Datum

HORZ_DATUM_CODE

DT_COORDINATE.HORZ_DATUM_CODE

Groundwater_Location_Type

LOC_TYPE_2

DT_LOCATION.LOC_TYPE_2

Horizontal_Coordinates_Represent

REFERENCE_POINT

DT_COORDINATE.REFERENCE_POINT

Paper_Map_Scale

SOURCE_SCALE

DT_COORDINATE.SOURCE_SCALE

Elevation_Datum

ELEV_DATUM_CODE

DT_COORDINATE.ELEV_DATUM_CODE

Well_Casing_Material

MATERIAL_TYPE_CODE

DT_WELL_SEGMENT.MATERIAL_TYPE_CODE

 

Result Data

EIM Field Name

RT_REMAP_DETAIL.EXTERNAL FIELD

EQuIS Field (table.field)

Result_Method

ANALYTIC_METHOD

DT_TEST.ANALYTIC_METHOD

Fraction_Analyzed

FRACTION

DT_TEST.FRACTION

Result_Data_Qualifier

INTERPRETED_QUALIFIERS

DT_RESULT.INTERPRETED_QUALIFIERS

Result_Lab_Name

LAB_NAME_CODE

DT_TEST.LAB_NAME_CODE

Sample_Matrix

MEDIUM_CODE

DT_SAMPLE.MEDIUM_CODE

Sample_Method_Other

PRESERVATIVE

DT_TEST.PRESERVATIVE

Sample_Preparation_Method

PREP_METHOD

DT_TEST.PREP_METHOD

Sample_Collection_Method

SAMPLE METHOD

DT_SAMLE.SAMPLE_METHOD

Sample_Source

MATRIX_DESC

DT_SAMPLE.MATRIX_DESC

 

Tables: DT_LOCATION, DT_COORDINATE, DT_SAMPLE, DT_FIELD_SAMPLE, DT_TEST, DT_RESULT, RT_ANALYTE, RT_ANALYTE_VAR, RT_REMAP, RT_REMAP_DETAIL

 

Report Parameters

Location


Individual(s)

Parameter for selecting individual locations.

Group(s)

Parameter for selecting location groups.

Coordinate Type Code

Parameter for selecting the coordinate type code.

Identifier

Parameter for selecting the coordinate identifier.

Sample


Matrix(es)

Parameter for selecting sample matrix(es).

Date Range


Start Date

Parameter for selecting the start date.

End Date

Parameter for selecting the end date.

Type(s)

Parameter for selecting sample type(s).

Result


Analyte


Individual(s)

Individual analyte parameter selection.

Group(s)

Analyte group parameter selection.

Type(s)

Result type parameter selection.

Reportable

Parameter to specify reportable results.

 

1Excel report output requires a valid license of Microsoft Excel to view the output.