<< Click to Display Table of Contents >> Navigation:  EQuIS Library > Formats > EarthSoft Standard Formats > EFWEDD Format

Format Name: EFWEDD

File Name: EFWEDD.zip 

Source: EDP Standalone, EQuIS Professional, and EQuIS Enterprise

Export(s): Yes (see section below)

Enumeration File: Not applicable

 

 

Description: The EFWEDD format, also known as the 4-file format, is a standard format that is suitable for most labs. The format offers two different sections for sample information (choose either Field or Lab), a test section, a results section, and a batch section.

 

 

Installation Instructions: The EFWEDD 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 EFWEDD format contains two different sections for sample information (choose either Field or Lab), a test section, a results section, and a batch section. 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 EFWEDD format use different tables for their reference value lookups. The EQuIS EDD Description file includes which tables are used for the reference value source. Create 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 EFWEDD format.

•Test Alternate Key (TAK) fields available in the format: SAMPLE_ID, ANALYTIC_METHOD, ANALYSIS_DATE, FRACTION, TEST_TYPE, COLUMN_NUMBER, and IDENTIFIER.

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

•In the EFW2LabRES section, the result_value field is required when the detect_flag = 'Y' and result_type_code = 'TRG' or 'TIC'.

•Dilutions in the EFWEDD format may be handled by changing the test_type from 'INITIAL' to 'DILUTION' or any identifier that works for the data. Please note that a record for the identifier would first need to be added to the RT_TEST_TYPE table.

•If records exist in a child section, then there must be a corresponding record in the parent section. For example, a record in the EFW2LabTST section must have a corresponding record in either EFW2FSample or EFW2LabSamp section. If the record in the Sample section does not exist, then the record in the EFW2LabTST section will fail to load.

•The following four fields in the EFWLabRES section of the format can be used for radiological data management in EQuIS:

•uncertainty: The uncertainty of the counting error, valid values include "1 sigma" or "2 sigma". This field is required if the counting_error field is populated.

•minimum_detectable_conc: The lowest concentration of an analyte that can be detected. This value should be in the same units as DT_RESULT.RESULT_UNIT.

•critical_value: Critical value as reported by the laboratory.

•counting_error: For tests that depend on counting, this is the error as reported by the laboratory. This value should be in the same units as DT_RESULT.RESULT_UNIT.

•SYS_LOC_CODES, for locations present in the submitted EDD, are required to be present in the DT_LOCATION table or an error will be displayed stating "SYS_LOC_CODE must exist in database".

 

For custom checks, please see the EDD Description File.

 

 

EQuIS Table Mappings:

 

 

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. See the Exports from Professional EDP article for more information about running exports.