Analytical and Water Results

<< Click to Display Table of Contents >>

EQuIS 7  >>  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 Level (Extra Fields) 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 Level (Extra Fields) 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 Level (Extra Fields) are:

 

Analytical Results II

Water Level (Extra Fields)

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

CAS_RN/CHEMICAL_NAME

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 Level (Extra Fields).

 

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 Level (Extra Fields) 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 Level (Extra Fields) Reports. Note the Additional Fields parameter may be customized as explained here.

 

Tables: All of the tables used by Analytical Results II and Water Level (Extra Fields) 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