Water Levels

<< Click to Display Table of Contents >>

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 the online help article Water Level Report Basics and also 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: v54.water_level

 

Language: English

 

Input Parameters: A selection made 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