EQEDD_v2 Format

Format Name: EQEDD_v2

File Name: EQEDD_v2.zip

Source: EDP Standalone, EQuIS Professional, and EQuIS Enterprise

Export(s): Yes (see section below)

Enumeration File: Not applicable

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) fields available in the format: SAMPLE_ID, ANALYTIC_METHOD, ANALYSIS_DATE, FRACTION, TEST_TYPE and IDENTIFIER.

•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'.

•In the FieldResults_v2 section, the result_value field is not required even if the detect_flag = 'Y'.

•For any single sample, populate either TestResults_v2 or TestResultsQC_v2, but not both, since both sections map to the same database table.

•The TestResultsQC_v2 section should be used if QC data are included (e.g., in qc_spike, qc_spike_recovery, qc_spike_lcl, qc_spike_ucl, etc.).

•For both the TestResults_v1 and TestResultsQC_v1 sections, the result_value is required when the detect_flag = 'Y' and result_type_code = 'TRG' or 'TIC'. The error appears the on detect_flag field.

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

•The WaterLevel_v2.water_level_elev field is automatically calculated by subtracting the water_level_depth from the historical_reference_elev. If water_level_elev is manually populated, the calculated value will not overwrite the manually populated value.

•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	In EQEDD_v2, if water_level_elev is manually populated, the calculated value will not overwrite the manually populated value. In EQEDD, the calculated value will overwrite any manually populated value.
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.

Exports: The data returned will be automatically filtered by the facility to which the user is connected, as well as by the parameters selected prior to running the report.

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

Export	Format Section	Source Table(s)
EQEDD_v2 Location EDD	DataProvider_v2	RT_COMPANY
	Task_v2	DT_SUBFACILITY DT_TASK
	Subfacilities_v2	DT_SUBFACILITY
	Location_v2	DT_COORDINATE DT_FACILITY DT_LOCATION DT_MEASURE_DATUM DT_WELL DT_WELL_SEGMENT
	Coordinate_v2	DT_COORDINATE DT_FACILITY DT_LOCATION
	Well_v2	DT_MEASURE_DATUM DT_WELL
	WellConstruction_v2	DT_WELL_SEGMENT
EQEDD_v2 Field Data EDD	LocationParameter_v2	DT_LOCATION_PARAMETER
	DrillActivity_v2	DT_DRILL_ACTIVITY
	Lithology_v2	DT_LITHOLOGY
	GeoSample_v2	DT_ATTERBERG DT_SAMPLE DT_STATIC_PROPS
	WaterTable_v2	DT_WATER_TABLE
	DownHoldPoint_v2	DT_DOWNHILL_POINT_DATA
	ExtractionInjectionWells_2	DT_PUMP_RATE
	Measure_Datum_v2	DT_MEASURE_DATUM
	Equipment_v2	DT_EQUIPMENT
	Equipment_Parameter_v2	DT_EQUIPMENT DT_EQUIPMENT_PARAMETER
	Purge _v2	DT_PURGE
	Precipitation_v2	DT_PRECIPITATION
	Flow_v2	DT_FLOW
EQEDD_v2 Field Results EDD	FieldResults_v2	DT_FIELD_SAMPLE DT_RESULT DT_SAMPLE DT_TEST RT_ANALYTE
EQEDD_v2 Field Sample EDD	FieldSample_v2	DT_FIELD_SAMPLE DT_SAMPLE DT_STATIC_PROPS
EQEDD_v2 Sample Parameter EDD	SampleParameter_v2	DT_FIELD_SAMPLE DT_SAMPLE DT_SAMPLE_PARAMETER
EQEDD_v2 Lab EDD	LabSample_v2	DT_FIELD_SAMPLE DT_RESULT DT_SAMPLE DT_TEST RT_ANALYTE
	TestResults_v2	DT_FIELD_SAMPLE DT_RESULT DT_SAMPLE DT_TEST RT_ANALYTE
	TestBatch_v2	AT_TEST_BATCH_ASSIGN DT_FIELD_SAMPLE DT_RESULT DT_RESULT_QC DT_SAMPLE DT_TEST DT_TEST_BATCH RT_ANALYTE
EQEDD_v2 Lab EDD (by EDD)	LabSample_v2	DT_FIELD_SAMPLE DT_RESULT DT_SAMPLE DT_TEST RT_ANALYTE
	TestResults_v2	DT_FIELD_SAMPLE DT_RESULT DT_SAMPLE DT_TEST RT_ANALYTE
	TestBatch_v2	AT_TEST_BATCH_ASSIGN DT_FIELD_SAMPLE DT_RESULT DT_RESULT_QC DT_SAMPLE DT_TEST DT_TEST_BATCH RT_ANALYTE
EQEDD_v2 Lab QC EDD	LabSample_v2	DT_FIELD_SAMPLE DT_RESULT DT_SAMPLE DT_TEST RT_ANALYTE
	TestResultsQC_v2	DT_FIELD_SAMPLE DT_RESULT DT_RESULT_QC DT_SAMPLE DT_TEST RT_ANALYTE
	TestBatch_v2	AT_TEST_BATCH_ASSIGN DT_FIELD_SAMPLE DT_RESULT DT_RESULT_QC DT_SAMPLE DT_TEST DT_TEST_BATCH RT_ANALYTE
EQEDD_v2 GW Submittal EDD	WaterTable_v2	DT_WATER_TABLE
	LabSample_v2	DT_FIELD_SAMPLE DT_RESULT DT_SAMPLE DT_TEST RT_ANALYTE
	TestResults_v2	DT_FIELD_SAMPLE DT_RESULT DT_SAMPLE DT_TEST RT_ANALYTE
	TestBatch_v2	AT_TEST_BATCH_ASSIGN DT_FIELD_SAMPLE DT_RESULT DT_RESULT_QC DT_SAMPLE DT_TEST DT_TEST_BATCH RT_ANALYTE
EQEDD_v2 GWQC Submittal EDD	WaterTable_v2	DT_WATER_TABLE
	LabSample_v2	DT_FIELD_SAMPLE DT_RESULT DT_SAMPLE DT_TEST RT_ANALYTE
	TestResultsQC_v2	DT_FIELD_SAMPLE DT_RESULT DT_RESULT_QC DT_SAMPLE DT_TEST RT_ANALYTE
	TestBatch_v2	AT_TEST_BATCH_ASSIGN DT_FIELD_SAMPLE DT_RESULT DT_RESULT_QC DT_SAMPLE DT_TEST DT_TEST_BATCH RT_ANALYTE