Action Level Exceedance II with Water Levels (Grid)

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports > Action Level Reports >

Action Level Exceedance II with Water Levels (Grid)

Report Name: Action Level Exceedance II with Water Levels (Grid)

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

Dependencies: Analytical and Water Results, Analytical Results II, Water Levels II, and Action Level Exceedance II with Parameters

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1


Description: The Action Level Exceedance II with Water Levels (Grid) Report compares results of the Analytical and Water Results Report against one or more action levels (e.g. regulatory limits).


For the analytical results, all the standard and advanced action levels are supported.  


The report applies standard action levels for water levels by processing the water level data as analytical data. To achieve this, the report remaps the water level columns of Water Level II into the cas_rn and chemical columns etc., e.g. map the column name of exact_elev to cas_rn and chem_name of an analytical result row and its value of a water level row to REPORT_RESULT_VALUE of an analytical result row etc.


For seasonal and locational water level action levels, this report supports the following configurations:


1.seasonal configurations using season_start_month, season_start_day, season_end_month, and season_end_day of DT_ACTION_LEVEL_PARAMETER, and

2.locational configurations using Locations in DT_ACTION_LEVEL_LOOKUP.


Note that these supported configurations differ from those used in the Water Level - Action Level Exceedance (WALE) Report.


Installation Instructions: The Action Level Exceedance II with Water Levels (Grid) report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.


For EQuIS Enterprise use, make sure the four (4) assemblies of EarthSoft.Reports.Library.44408.dll (Analytical and Water Results), EarthSoft.Reports.Library.64102.dll (Water Levels II), EarthSoft.Reports.Library.50943.dll (Analytical Results II) and EarthSoft.Reports.Library.51729.dll (Action Level Exceedance II with Parameters) are placed in the Enterprise bin folder. If not, copy/paste them from the EQuIS Professional installation directory.


Report Parameters


Analytical Results and Water Levels section*

Action Level section**



* This section includes the report input parameters of the “Analytical and Water Results Report”.


** This section includes the Action Level parameters of the "Action Level Exceedance II with Parameters Report".



Report Output:

Refer to the Report Output of the Action Level Exceedance II with Parameters Report.


For water level “results”, when present, the report populates cas_rn and chemical_name columns with 'reference_elev', 'water_level', 'exact_elev', 'water_depth', 'measured_depth_of_well', 'lnapl_cas_rn', 'lnapl_depth', 'lnapl_thickness', 'dnapl_cas_rn', 'dnapl_depth', and/or 'dnapl_thickness', which come from the column names of the result of Water Level II Report, and their respective values to REPORT_RESULT_VALUE.


Action Level Parameter Configuration:

Refer to the Action Level Parameter Configuration of the Action Level Exceedance II with Parameters Report.


Note that if the Action Levels tool of Professional is used to add water level related action levels, the names of the water level items need to be added to rt_analyte. For example, rt_analyte.cas_rn = “exact_elev” and rt_analyte.chemical_name=”exact_elev”.  


1The report grid result provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.