EQEDD Format

Format Name: EQEDD

File Name: EQEDD.zip

Source: EDP Standalone, EQuIS Professional, and EQuIS Enterprise

Export(s):

•EQEDD Location EDD

•EQEDD Field Data ED

•EQEDD Basic Results EDD

•EQEDD Field Results EDD

•EQEDD Field Sample EDD

•EQEDD Sample Parameter EDD

•EQEDD Lab ED

•EQEDD Lab EDD (by EDD)

•EQEDD LabQC EDD

•EQEDD GW Submittal EDD

•EQEDD 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 format is one of the most extensive/detailed standard EQuIS formats. It contains sections for location, lab, and field data. It is a good generic format to begin importing data.

Installation Instructions: The EQEDD 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 format is divided into three separate sections: Field, Lab and Files_v1. The Files_v1 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 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 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_v1 section typically is populated with field generated data. LabSample_v1 tab is typically populated with lab generated data. For any single sample in a single EDD, populate either FieldSample_v1 or LabSample_v1, but not both, since both sections map to the same database table.

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

•WaterLevel_v1.WATER_LEVEL_ELEV is calculated by subtracting WATER_LEVEL_DEPTH from HISTORICAL_REFERENCE_ELEV. If either of these two fields is blank, WATER_LEVEL_ELEV will be populated with a blank string. If both fields are populated, the result of the calculation will overwrite any existing values in the WATER_LEVEL_ELEV field.

•For any single sample, populate either TestResults_v1 or TestResultsQC_v1, but not both, since both sections map to the same database table.
TestResultsQC_v1 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 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.