EQEDD Format

Format Name: EQEDD_v2

File Name: EQEDD_v2.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: This format is included in the installation of EDP Standalone, EQuIS Professional, and EQuIS Enterprise installation.

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.

Columns in the EQEDD format use different tables for their reference value lookups. The EQuIS EDD (Electronic Data Deliverable) 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 Test Alternate Key (TAK).

•LabSample_v1.sample_matrix_code is a lookup to RT_MATRIX.MATRIX_CODE for records with MATRIX_CLASS is null or “FIELD”.

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

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