Analytical and Water Results

<< Click to Display Table of Contents >>

EQuIS Library > Reports > EarthSoft Standard Reports > Analytical Results >

Analytical and Water Results

Report Name: Analytical and Water Results
previously called (Beta) Analytical Results

 

Report Type: Standard Report    

 

Description: Analytical and Water Results runs the Analytical Results II and Water Levels II Reports, and combines the output rows so the water level data are reported as CAS_RN results. This enables direct comparison in crosstab reports.

 

The report takes the output elements (e.g. REFERENCE_ELEV) of Water Levels II as new analytes, and appends them to the standard Analytical Results II output. The data mappings from the Analytical Results II columns to those of Water Levels II are:

 

Analytical Results II

Water Levels II

SAMPLE_DATE

MEASUREMENT_DATE

ANALYTICAL_METHOD

MEASUREMENT_METHOD

ANALYSIS_DATE

MEASUREMENT_DATE

REPORT_RESULT_UNIT

DEPTH_UNIT

CAS_RN/CHEMICAL_NAME

DNAPL_CAS_RN

CAS_RN/CHEMICAL_NAME

DNAPL_DEPTH

CAS_RN/CHEMICAL_NAME

DNAPL_THICKNESS

CAS_RN/CHEMICAL_NAME

EXACT_ELEV

REPORT_RESULT_VALUE

LNAPL_CAS_RN

CAS_RN/CHEMICAL_NAME

LNAPL_DENSITY

CAS_RN/CHEMICAL_NAME

LNAPL_DEPTH

CAS_RN/CHEMICAL_NAME

LNAPL_THICKNESS

CAS_RN/CHEMICAL_NAME

MEASURED_DEPTH_OF_WELL

CAS_RN/CHEMICAL_NAME

REFERENCE_ELEV

CAS_RN/CHEMICAL_NAME

WATER_DEPTH

CAS_RN/CHEMICAL_NAME

WATER_LEVEL

 

The input location/individuals or groups of Analytical Results II are used for Water Levels II.

 

Note: DT_WELL_SEGMENT is added to the Additional Fields drop-down list of this report. The default value of SEGMENT_TYPE is SCREEN. The value can be modified in ST_CONFIG by populating a new SEGMENT_TYPE in STRING_VALUE of ST_CONFIG where CONFIG_SECTION=ar and CONFIG_KEY=SEGMENT_TYPE.

 

Report Dependencies: Analytical Results II 50943 and Water Levels II 64102

 

File Name: EarthSoft.Reports.Library.44408.dll

 

Contact support@earthsoft.com for a direct file link.

 

Language: English

 

Input Parameters: Input parameters of Analytical Results II and Water Levels Reports. Note the Additional Fields parameter may be customized as explained here.

 

Tables: All of the tables used by Analytical Results II and Water Levels II Reports

 

Database Type: SQL

 

Database Schema: Standard (no custom or add-on schemas required)

 

Database Version: EQuIS 6.0+

 

Data Requirements: N/A

 

Report Requirements: Contact support@earthsoft.com for more information.

 

Output Type: Contact support@earthsoft.com for more information.

 

Example Output: Download the Analytical And Water Results Example Output.xlsx