Report Name: Action Level Exceedance II - Early Warning
File Name: EarthSoft.Reports.Library.51729.dll
Dependencies: Saved Analytical Results II Report
Software: EQuIS Professional and EQuIS Enterprise
Source: EQuIS Professional install, EQuIS Enterprise install
Language: English
Output Type: Excel1
Description: The Action Level Exceedance II - Early Warning Report is designed to flag analytical results that exceed the action level reduced by the percentage entered in the Percentage report parameter, and is primarily used as an EQuIS Information Agent (EIA), or trigger within EQuIS Enterprise.
Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.
Overview: An action_level is calculated by subtracting the entered percentage amount from each analyte's action_level value. An action_level_min is calculated by adding the entered percentage amount to each analyte's action_level_min value.
Source Tables: DT_ACTION_LEVEL, DT_ACTION_LEVEL_PARAMETER, DT_LOCATION, DT_RESULT, DT_SAMPLE, DT_SUBFACILITY, DT_TEST, RT_GROUP, ST_EDD_BATCH, ST_REPORT, ST_USER_REPORT
Report Parameters
|
Analytical Results
|
|
User Report
|
Select a saved Analytical Results user report.
|
Action Level
|
|
Early Warning
|
|
Percentage
|
Enter the percentage to adjust the Action Level for Early Warning report.
|
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
Match Facility
|
Match Matrix
|
Match Fractions
|
Match Method
|
Depths
|
|
|
Section for default matching conditions. Default values for this section are True. The default depth type is Sample Depth.
|
Matching Special
Match Subfacility
|
Match Start-End Dates
|
Match Seasonal Dates
|
Match Land Use
|
Match Geologic Unit
|
Geologic Unit Code or Type
|
Geologic Unit Columns
|
|
|
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
Custom Fields from DT_ACTION_LEVEL:
|
Custom Fields from DT_ACTION_LEVEL_PARAMETER:
|
Date Fields from DT_ACTION_LEVEL:
|
Depths Fields from DT_ACTION_LEVEL:
|
|
|
Section for additional parameters that can be included in the report output. The default values for these parameters are False.
|
|
1Excel report output requires a valid license of Microsoft Excel to view the output.