Action Level Exceedance II

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_SAMPLE, DT_SUBFACILITY, DT_TEST, RT_GROUP, ST_REPORT, ST_USER_REPORT, , DT_SAMPLE, DT_TEST, ST_EDD_BATCH, ST_REPORT, ST_USER_REPORT, FACILITY_ID, FACILITY_CODE, SYS_LOC_CODE, LOC_NAME, SAMPLE_ID, SYS_SAMPLE_CODE, SAMPLE_NAME, SAMPLE_DATE, SAMPLE_TYPE_CODE, START_DEPTH, END_DEPTH, DEPTH_UNIT, MATRIX_CODE, TASK_CODE, PARENT_SAMPLE_CODE, ANALYSIS_LOCATION, LAB_SAMPLE_ID, LAB_MATRIX_CODE, LAB_NAME_CODE, ANALYTIC_METHOD, ANALYSIS_DATE, COLUMN_NUMBER, FRACTION, TEST_TYPE, PREP_METHOD, LEACHATE_METHOD, LEACHATE_DATE, LAB_SDG, PERCENT_MOISTURE, DILUTION_FACTOR, TEST_ID, CAS_RN, CHEMICAL_NAME, ORGANIC_YN, REPORT_RESULT_TEXT, REPORT_RESULT_VALUE, REPORT_RESULT_UNIT, REPORT_RESULT_LIMIT, REPORTABLE_RESULT, DETECT_FLAG, INTERPRETED_QUALIFIERS, VALIDATOR_QUALIFIERS, LAB_QUALIFIERS, QUANTITATION_LIMIT, METHOD_DETECTION_LIMIT, REPORTING_DETECTION_LIMIT, DETECTION_LIMIT_UNIT, APPROVAL_CODE, RESULT_TEXT, RESULT_NUMERIC, RESULT_UNIT, RESULT_TYPE_CODE, X_COORD, Y_COORD, Z_COORD_AVG, ZFROM, ZTO, LONGTITUDE, LATITUDE, LOC_GROUP_CODE, LOC_REPORT_ORDER

Report Parameters

Analytical Results

User Report

Select a saved Analytical Results user report.

Action Level

Early Warning

Percentage

Enter the percentage you want to use to adjust the Action Level for Early Warning report.

Action Level(s)

Select one or more Action Levels. Leaving this field blank will compare all applicable 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 which 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.

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 is False.

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