Action Level Exceedance II by User Report

Report Name: Action Level Exceedance II by User Report (example)

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

Dependencies: Saved Analytical Results or Analytical Results II Report

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install, EQuIS Enterprise install

Language: English

Output Type: Report Grid1

Description: The Action Level Exceedance II by User Report compares values from a saved Analytical Results or Analytical Results II Report against one or more action levels (e.g., collection of regulatory limits).

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.

Overview: Action levels may apply to the entire database or they may be specific to a certain facility or subfacility, a limited time period, a particular matrix, land use, analytic method, fraction, depth or geologic unit (by entering data into the related fields in the DT_ACTION_LEVEL or DT_ACTION_LEVEL_PARAMETER table). Action levels are only compared to analytical results that have matching criteria.

Tables: DT_ACTION_LEVEL, DT_ACTION_LEVEL_PARAMETER, DT_LOCATION, DT_RESULT, DT_SAMPLE, DT_SUBFACILITY, DT_TEST

Report Parameters and Information:

See Action Level Exceedance II with Parameters for descriptions of Comparison, Flagging, and Matching input options and other common information about both versions of the ALE II Report.

Report Parameters

Analytical Results

User Report

Select a saved Analytical Results user report.

Action Level

Action Level(s)

Select one or more Action Levels.

Comparison

Operator

Select an operator: <, <=, >, >=.

Unit

Select a comparison unit: action_level_unit or report_result_unit.

Significant Figures

Select the desired number of significant figures.

Compare to Action Level Before Applying to Significant Figures

Select 'Yes' to compare results before significant figures are applied. Select 'No' to compare results after significant figures are applied.

Display in scientific notation

Select whether to display results in scientific notation. Default value is No.

Flagging

Show Results

Select 'Show All' to show all results (with exceedances flagged) OR 'Show Only Exceedances' OR 'Show With Any Exceedance' to show results that exceed any of the selected action levels.

Flag Non-Detects

Please select 'Yes' to flag non-detect results whose detection limit exceeds the action level OR 'No' to not flag them.

Exceedance Flag

Character for flagging exeedances. Leaving blank will return only exceedances in the report output.

Warning Flag

Character for flagging warnings.

Action Level Unit Conversion Errors

Select either 'Stop Report' (default) or 'Flag Errors'.

Matching Default

Section for default matching conditions. Default values for this section are True. The default depth type is Sample Depth.

Matching Special

Section for special matching conditions. Default values for this section are False. The Geologic Unit section also includes parameters for Geologic Unit Code or Type and Geologic Unit Columns and do not have defaults.

Include

Section for additional parameters that can be included in the report output. The default values for these parameters are False.

The Action Level Exceedance II with Parameters version of this report displays all of the parameters from the Analytical Results II Report, thus allowing users to create the Analytical Results Report and the Action Level Exceedance Report together (displayed once in the Action Level Exceedance Format).

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