EIM Export

<< Click to Display Table of Contents >>

EIM Export

Report Name: EIM Export (100111)

 

Report Type: Custom

 

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.

 

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

 

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

 

Note that this is a custom report, and is only available to approved individuals. Contact support@earthsoft.com for more information.

 

Language: English

 

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

 

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

 

Input Parameters: A selection made to customize the output of a report.
 

Input Parameters

Input Parameter Screenshot

Location




Individual(s)



Group(s)



Coordinate Type Code



Identifier


Sample




Matrix(es)



Date Range




Start Date



End Date


Type(s)


Result




Analyte




Individual(s)



Group(s)


Type(s)



Reportable


30238-EIM_Export_Parameters

 

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

 

Database Type: SQL

 

Database Schema: Standard (no Custom or add-on schemas required)

 

Database Version: EQuIS 6

 

Data Requirements: Requires locations with coordinates where COORD_TYPE_CODE = LAT/LONG. Remapping is also required as described above.

 

Report Requirements: Excel, EIM Load template files named EIMResultV2013.01 and EIMLocationV2013.01 must be stored in DT_FILE. These files are available from EIM Help Docs.

 

Output Type: Excel. Results are output into a zip file containing the EIM Location and EIM Result loading templates, populated with data from the report.