EQEDD_v2 Format

Format Name: EQEDD_v2

File Name: EQEDD_v2.zip

Source: EDP Standalone, EQuIS Professional, and EQuIS Enterprise

Export(s):

•EQEDD_v2 Location EDD

•EQEDD_v2 Field Data EDD

•EQEDD_v2 Field Results EDD

•EQEDD_v2 Field Sample EDD

•EQEDD_v2 Sample Parameter EDD

•EQEDD_v2 Lab EDD

•EQEDD_v2 Lab EDD (by EDD)

•EQEDD_v2 LabQC EDD

•EQEDD_v2 GW Submittal EDD

•EQEDD_v2 GWQC Submittal EDD

Note: Exports will not work as expected if the data were imported using a different format, as each format has different mappings, checks, etc.

Description: The EQEDD_v2 format is an updated version of the original EQEDD format. These two formats share many similarities but include several differences. Like its predecessor, EQEDD_v2 contains sections for location, lab, and field data.

Installation Instructions: The EQEDD_v2 format is included in the installation of EDP Standalone and EQuIS Professional in the \Formats\EarthSoft folder. This format is also installed with EQuIS Enterprise and is configured (by default) to be available in the Enterprise EDP EDD Upload widget. The default configuration settings should be reviewed and modified to meet user needs (see the Add or Modify Enterprise EDP Formats article). The default commit type is Insert and Update.

Overview: The EQEDD_v2 format is divided into three separate sections: Field, Lab and Files_v2. The Files_v2 section can be used to load a file to an EQuIS database in EDP. See Uploading Files in EDP for additional information. To load new data into the database, a blank EDD (Electronic Data Deliverable) of the format can be generated. Click on the Home tab and select Blank EDD in the Tools group.

Columns in the EQEDD_v2 format use different tables for their reference value lookups. The EQuIS EDD Description file includes which tables are used for the reference value source. Download the EQuIS EDD Description file in EDP or the Enterprise EDP EDD Upload Widget.

Limitations/Assumptions: The checks and mappings in any EDD format involve assumptions. The following are assumptions and limitations for the EQEDD_v2 format.

•Test Alternate Key (TAK) for the format: The format uses SAMPLE_ID, ANALYTIC_METHOD, ANALYSIS_DATE , FRACTION, and TEST_TYPE fields in its TAK.

•FieldSample_v2 section typically is populated with field generated data. LabSample_v2 tab is typically populated with lab generated data. For any single sample in a single EDD, populate either FieldSample_v2 or LabSample_v2, but not both, since both sections map to the same database table.

•FieldSample_v2.sample_matrix_code and LabSample_v2.sample_matrix_code are lookups to RT_MATRIX.MATRIX_CODE for records with MATRIX_CLASS is null or “FIELD”.

•For any single sample, populate either TestResults_v2 or TestResultsQC_v2, but not both, since both sections map to the same database table.
TestResultsQC_v2 should be used if QC data are included (i.e., in qc_spike, qc_spike_recovery, qc_spike_lcl, qc_spike_ucl, etc.).

•The EQEDD_v2 format can be used to load new locations (SYS_LOC_CODE) and to submit new information for location (SYS_LOC_CODE) records already in the database.

•All sections containing the SYS_LOC_CODE column will function as explained below.

•If the SYS_LOC_CODE field is populated, the format will check against the Location tab to see if this data exists.

•If the Location section of the format file is empty, the SYS_LOC_CODE fields will check the database to see if the locations exist (Professional EDP Only).

•If the location does not exist in the database or the Location section, an error will occur on the commit stage.

EQEDD_v2 Differences: Differences between the EQEDD format and the EQEDD_v2 format when it was released with the 7.22.2 Build are denoted in the following table. See Release Notes for updates to the EQEDD_v2 format.

Format Section/Table	Changes from EQEDD Format
Basic Results	The Basic Results table is only present in the EQEDD format.
COC	The COC table is the same in both formats.
Coordinate	The Coordinate table is only present in the EQEDD_v2 format.
Data Provider	The Data Provider table is the same in both formats.
Downhole_Point	The following fields were added to the EQEDD_v2 format: END_DEPTH, CUSTOM_FIELD_1, CUSTOM_FIELD_2, CUSTOM_FIELD_3, CUSTOM_FIELD_4, CUSTOM_FIELD_5
Drill Activity	The following fields were added to the EQEDD_v2 format: CUSTOM_FIELD_3, CUSTOM_FIELD_4, CUSTOM_FIELD_5
Equipment	The following fields were added to the EQEDD_v2 format: SERIAL_NUMBER, CUSTOM_FIELD_1, CUSTOM_FIELD_2, CUSTOM_FIELD_3, CUSTOM_FIELD_4, CUSTOM_FIELD_5
Equipment_Parameter	The Equipment_Parameter_v2 table is only present in the EQEDD_v2 format.
ExtractionInjectionWells	The ExtraInjectionWells table is the same in both formats.
FieldQC_Batch	The FieldQC_Batch_v2 table is only present in the EQEDD_v2 format.
FieldResults	The following check was added to the EQEDD_v2 format: If DETECT_FLAG = "N", then QUANTITATION_LIMIT is required. The following Method Mapping was added to the EQEDD_v2 format: GetResultNumeric
FieldSample	The following fields were added to the EQEDD_v2 format: SAMPLE_END_DATE, SAMPLE_DESC, TASK_CODE_2, CUSTOM_FIELD_4, and CUSTOM_FIELD_5 The following check was added to the EQEDD_v2 format: If the DURATION or DURATION_UNIT is populated, then the other is required.
Files	The Files table is the same in both formats.
Flow	The Flow_v2 table is only present in the EQEDD_v2 format.
GeoSample	The following fields were added to the EQEDD_v2 format: CUSTOM_FIELD_1, CUSTOM_FIELD_2, CUSTOM_FIELD_3, CUSTOM_FIELD_4, CUSTOM_FIELD_5
LabSample	The following fields were added to the EQEDD_v2 format: CUSTOM_FIELD_4, CUSTOM_FIELD_5
Lithology	The following fields were added to the EQEDD_v2 format: CUSTOM_FIELD_2, CUSTOM_FIELD_3, CUSTOM_FIELD_4, CUSTOM_FIELD_5 The following Default Mappings were added to the EQEDD_v2 format: LITH_COLOR, LITH_ODOR
Location	The following fields were not included in the EQEDD_v2 format: X_COORD, Y_COORD, SURF_ELEV, ELEV_UNIT, COORD_TYPE_CODE, OBSERVATION_DATE, COORD_IDENTIFIER, HORZ_COLLECT_METHOD_CODE, HORZ_ACCURACY_VALUE, HORZ_ACCURACY_UNIT, HORZ_DATUM_CODE, ELEV_COLLECT_METHOD_CODE, ELEV_ACCURACY_VALUE, ELEV_ACCURACY_UNIT, ELEV_DATUM_CODE, SOURCE_SCALE, SUBCONTRACTOR_NAME_CODE, VERIFICATION_CODE, REFERENCE_POINT, GEOMETRIC_TYPE_CODE, RANK The following Method Mapping was added to the EQEDD_v2 format: COMPANYTYPE_SUBCONTRACTOR
Location_Parameter	The Location_Parameter table is the same in both formats.
Measure_Datum	The Measure_Datum_v2 table is only present in the EQEDD_v2 format.
Precipitation	The Precipitation_v2 table is only present in the EQEDD_v2 format.
Purge	The Purge table is the same in both formats.
SampleParameter	The SampleParameter table is the same in both formats.
Subfacilities	The following fields were added to the EQEDD_v2 format: CUSTOM_FIELD_1, CUSTOM_FIELD_2, CUSTOM_FIELD_3, CUSTOM_FIELD_4, CUSTOM_FIELD_5
Task	The following fields were added to the EQEDD_v2 format: CUSTOM_FIELD_1, CUSTOM_FIELD_2, CUSTOM_FIELD_3, CUSTOM_FIELD_4, CUSTOM_FIELD_5
TestBatch	The TestBatch table is the same in both formats.
TestResults	The following fields were added to the EQEDD_v2 format: CUSTOM_FIELD_5, LAB_REPORT_DATE, and APPROVAL_CODE The following checks were added to the EQEDD_v2 format: RESULT_VALUE must be numeric unless entering values for asbestos, color, and coliform. This list can include other CAS_RNs by adding to the TEXT_CAS_RN setting in the EQEDD_v2-enum.xml file. See Updating an Enumeration File for additional information. If METHOD_DETECTION_LIMIT, REPORTING_DETECTION_LIMIT or QUANTITATION_LIMIT is populated, then DETECTION_LIMIT_UNIT is required. The following check was not included in the EQEDD_v2 format: REPORTABLE_RESULT cannot be "Yes" where LAB_QUALIFIERS = "E", "G", "P", or "R".
TestResultsQC	The following fields were added to the EQEDD_v2 format: CUSTOM_FIELD_2, CUSTOM_FIELD_3, CUSTOM_FIELD_4, CUSTOM_FIELD_5, LAB_REPORT_DATE, and APPROVAL_CODE The following checks were added to the EQEDD_v2 format: If the RESULT_VALUE or RESULT_UNIT is populated, then the other is required. If METHOD_DETECTION_LIMIT, REPORTING_DETECTION_LIMIT or QUANTITATION_LIMIT is populated, then DETECTION_LIMIT_UNIT is required. The following check was not included in the EQEDD_v2 format: REPORTABLE_RESULT cannot be "Yes" where LAB_QUALIFIERS = "E", "G", "P", or "R".
WaterLevel	The WaterLevel table is the same in both formats.
WaterTable	The following fields were added to the EQEDD_v2 format: CUSTOM_FIELD_1, CUSTOM_FIELD_2, CUSTOM_FIELD_3, CUSTOM_FIELD_4, CUSTOM_FIELD_5
Well Construction	The Well Construction table is the same in both formats.
Well	The following fields were added to the EQEDD_v2 format: CUSTOM_FIELD_1, CUSTOM_FIELD_2, CUSTOM_FIELD_3, CUSTOM_FIELD_4, CUSTOM_FIELD_5

For changes made to the custom checks, please see the EDD Description Files.