EIM Export

Report Name: EIM Export

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

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

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 or (for per-user installation) %localappdata%\Programs\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 prerequisites:

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 must be named EIMResultV2013.01.xls and EIMLocationV2013.01.xls and stored in DT_FILE. EIM template files are available from EIM Help Docs but, as noted above, may be more current than those used in developing the report. Contact EarthSoft Support for the original template files if needed.

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.