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

Format Name: ESBasic 

File Name: ESBasic.zip 

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

Export(s): Yes (see section below)

Enumeration File: Not applicable

 

 

Description: The ESBasic is a simple, single section lab EDD format that can be used to import single sample tests.

 

Installation Instructions: The ESBasic 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 ESBasic format populates the minimum fields for sample collection and analysis. Sample information includes the type and matrix while the analysis of the sample includes details of tests and the lab performing the analysis. This lab EDD format is best used for importing single sample tests. 

 

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

•Test Alternate Keys (TAKs)

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

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

•As the format maps the sys_loc_code field to the DT_SAMPLE and DT_LOCATION tables, basic analytical data can be added for new and existing locations. As there is no location lookup verification in this format, particular care should be taken to review the sys_loc_codes when using this format to avoid adding erroneous locations.  

 

 

For custom checks and additional default mappings, please see the EDD Description file for the ESBasic 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.