Water Levels

Report Name: Water Levels (example)

File Name: v54.water_level

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Standard Schema

Language: English

Output Type: Excel1

Note: The v54 reports have been superseded by more comprehensive class reports (version ‘II’). The Water Levels report was replaced by Water Levels II. EarthSoft recommends using the Analytical Results II report rather than Water Levels to take advantage of additional features, fixes, and performance optimization.

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.

Installation Instructions: The Water Levels report is part of the EQuIS Schema and is created when the EQuIS database is created.

Overview:

The ST_REPORT_PARAMETER table can be used to control how the input selection screen appears to the user. DT_WATER_LEVEL.DIP_OR_ELEVATION must be populated in order to perform a calculated water level. 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).

Additional Related Documentation: Water Level Report Basics

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

Report Parameters

Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Water Level
Date Range	Section to select the water levels start date, and end date.
Task(s)	Select one or more tasks
Reported Value	Parameter for selecting which water levels are reported: calculate, corrected_elevation, water_level_elev
Calculation	This section is available when selecting calculate in reported value.
Elevation	Elevation parameter used for calculated water levels: historical_reference_elev, measure_datum, surf_elev, or top_casing_elev
Depth	Depth parameter used for calculated water levels: calculate, corrected_depth, or water_level_depth

Output Columns
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

Output Columns

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

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))

1Excel report output requires a valid license of Microsoft Excel to view the output.