Water Levels

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Water Level Reports >

Water Levels

Report Name: Water Levels

 

Report Type: Standard

 

Description: The Water Levels Report conveys information about water levels, LNAPLs, and DNAPLs stored in the DT_WATER_LEVEL table. This report uses specific logic for computing the corrected water level elevation based on input parameters selected by the user. For more information, see Water Level Report Basics and the Water Level Elevation Correction Diagram.

 

The ST_REPORT_PARAMETER table can be used to control how the input selection screen appears to the user. For example, the options for computing corrected water level elevation could be pre-selected (using ST_REPORT.PARAMETER.DEFAULT_VALUE and hidden from the user (using ST_REPORT_PARAMETER.VISIBILITY).

 

Combine water level trend plot and analytical trend plot.

 

Report Dependencies: There are no dependencies for this report.

 

File Name: v5.4water_levels

 

Language: English

 

Input Parameters: A selection you make to customize the output of a report.

 

Input Parameters

Input Parameter Screenshot

Output Columns

Location





Individual(s)




Group(s)



Water Level





Date Range





Start Date




End Date



Task(s)




Reported Value





water_level_elev



Calculation





Elevation





historical_reference_elev



Depth





water_level_depth

30203-input.params.scrnsht

FACILITY_ID, FACILITY_CODE, SYS_LOC_CODE, LOC_NAME, LOC_GROUP, LOC_REPORT_ORDER, MEASUREMENT_DATE, REFERENCE_ELEV, WATER_LEVEL, EXACT_ELEV, MEASUREMENT_DEPTH_OF_WELL, DEPTH_UNIT, BATCH_NUMBER, TECHNICIAN, DRY_INDICATOR_YN, MEASUREMENT_METHOD, DIP_OR_ELEVATION, REMARK, EQUIPMENT_CODE, LNAPL_CAS_RN, LNAPL_DEPTH, LNAPL_THICKNESS, LNAPL_DENSITY, WATER_DEPTH, DNAPL_CAS_RN, DNAPL_DEPTH, DNAPL_THICKNESS, TASK_CODE, APPROVAL_CODE, X_COORD, Y_COORD, LONGITUDE, LATITUDE

Note: * refers to hidden parameters

 

The following SQL excerpts define the NAPL calculations for this report:

 

case when w.lnapl_depth is not null then coalesce(@product_density,(select specific_gravity from rt_analyte_detail where cas_rn = w.lnapl_cas_rn),@specific_gravity)

        else null end as LNAPL_DENSITY,

.

.

.

.

set exact_elev = (wl.water_level_depth - coalesce(w.lnapl_density * (wl.water_level_depth - coalesce(wl.lnapl_depth,wl.water_level_depth)),0.0))

 

 

Tables: DT_WATER_LEVEL, DT_WELL, RT_ANALYTE_DETAIL, DT_LOCATION, RT_GROUP, RT_GROUP_MEMBER, VW_LOCATION

 

Database Type: SQL

 

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

 

Database Version: v5.6+

 

Data Requirements: DT_WATER_LEVEL.DIP_OR_ELEVATION must be populated in order to perform a calculated water level.

 

Report Requirements: Excel

 

Output Type: Excel/HTML

 

Example Output: View the example below or download the attachment.

 

30203.ex.output1_zoom63

 

Additional Related Documentation: Water Level Report Basics