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

Format Name: EZEDD 

File Name: EZEDD.zip 

Source: EDP Standalone, EQuIS Professional, and EQuIS Enterprise (only in format installation folder)

Export(s): Yes (see section below)

Enumeration File: Not applicable

License Level: Standard

 

Description: The EZEDD format is a single section lab EDD format. Use the EZEDD_Location format to include a SYS_LOC_CODE field.

 

Installation Instructions: The EZEDD format is included in the installation of EDP Standalone and EQuIS Professional in the \Formats\EarthSoft folder. This format is also provided with the installation of EQuIS Enterprise but requires configuration to be available in the Enterprise EDP EDD Upload widget. If the format should be configured for EQuIS Enterprise, an administrator will need to define the commit type and other EDP Enterprise elements as defined in the Workflow Widget and Add or Modify Enterprise EDP Formats articles.

 

Overview: The EZEDD format is a single section lab EDD format designed to import sample, test, and result data.    

 

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

•Test Alternate Keys (TAKs)

•TAK fields available in the format: SAMPLE_ID, ANALYTIC_METHOD, ANALYSIS_DATE, FRACTION, and IDENTIFIER.

•The format may be used in databases that contain TEST_TYPE in their TAK because it contains a default mapping of 'INITIAL' to DT_TEST.TEST_TYPE. However, this value cannot be changed, and as such, it cannot be used to differentiate records.

•This format is not suggested for loading dual-column data as column number has a default mapping of 'NA' to DT_TEST.COLUMN_NUMBER to satisfy any possible TAK requirements.  

•The Result_Value field is not required even if the Detect_Flag = 'Y'.

•The Reporting_Detection_Limit field is not required, regardless of the Detect_Flag field status.

•The EDD fields project_code and Lab_Batch_Number do not map to related tables in the EQuIS Schema.

 

For custom checks and additional default mappings, please see the EDD Description file for the EZEDD format.

 

 

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.