Action Level Exceedance II by EDD

<< Click to Display Table of Contents >>

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

Action Level Exceedance II by EDD

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

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

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install, EQuIS Enterprise install

Language: English

Output Type: Report Grid1

 

Description: This version of the Action Level Exceedance II report is used for checking exceedances within an EDD (instead of within a saved report), and is commonly used as an EQuIS Information Agent (EIA), or trigger within EQuIS Enterprise. The report generates results by filtering DT_RESULT.EBATCH with the Ebatch parameter.

 

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

 

Overview:

In this Report, the AL_REMARK column is no longer being used in the comparison for duplicates. The AutoCrosstab_ActionLevel method now ignores that field when doing the AutoCrosstab for the ALE Report.

 

When using this report in crosstab, data that exceeds the WARNING_LEVEL can be highlighted in one format and/or color while data that also exceeds the ACTION_LEVEL can be highlighted in another format and/or color. Assuming the relationship where WARNING_LEVEL is less than the ACTION_LEVEL, the WARNING_LEVEL field must be placed before the ACTION_LEVEL field in the column or row header section of the crosstab interface to get these formatting results. Otherwise, the "Exceeds Action Level" color will be set first and then be over-written by the "Exceeds Warning Level" color since any value that exceeds the higher Action Level will also exceed the Warning Level.

 

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, DT_FACILITY, DT_FIELD_SAMPLE, DT_LITHOLOGY, DT_LOCATION, DT_PURGE, DT_RESULT, DT_RESULT_QC, DT_SAMPLE, DT_SDG, DT_STATIC_PROPS, DT_SUBFACILITY, DT_TASK, DT_TEST, DT_WATER_LEVEL, DT_WELL, RT_ANALYTE, RT_ANALYTE_VAR, RT_ANALYTIC_METHOD, RT_FRACTION, RT_GROUP, RT_GROUP_MEMBER, RT_MATRIX, RT_MTH_ANL_GROUP, RT_MTH_ANL_GROUP_MEMBER, RT_RESULT_TYPE, RT_SAMPLE_TYPE, RT_TEST_TYPE, RT_UNIT, VW_LOCATION

 

Report Parameters

EDD

Ebatch

Select one or more EDDs by Ebatch.

Latest

Check the box to select the most recent edd.

Action Level

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.

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

Match Facility

Match Matrix

Match Fractions

Match Method

Match Depth

Depth Type

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

 

 

Report Output

ACTION_LEVEL_CODE

CAS_RN

CHEMICAL_NAME

FLAG

ACTION_LEVEL

ACTION_LEVEL_MIN

AL_RESULT_TEXT

AL_RESULT_VALUE

ACTION_LEVEL_UNIT

WARNING_FLAG

WARNING_LEVEL

WARNING_LEVEL_MIN

FACILITY_ID

FACILITY_CODE

SYS_LOC_CODE

SAMPLE_NAME

SYS_SAMPLE_CODE

AL_SUBFACILITY_CODE

ACTION_LEVEL_TYPE

AL_MATRIX

AL_FRACTION

AL_ANALYTICAL_METHOD

AL_REMARK

OBJECT_NAME

ACTION_LEVEL_NOTE

ACTION_LEVEL_MIN_NOTE

LOC_NAME

LOC_GROUP

LOC_REPORT_ORDER

SAMPLE_DATE

SAMPLE_TYPE_CODE

START_DEPTH

END_DEPTH

DEPTH_UNIT

MATRIX_CODE

GEOLOGIC_UNIT_CODE

TASK_CODE

TASK_DESC

FIELD_SDG

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_DATE

LAB_SDG

PERCENT_MOISTURE

DILUTION_FACTOR

METHOD_ANALYTE_GROUP

REPORT ORDER

TEST_ID, 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

LONGITUDE LATITUDE

ACTION_LEVEL_VALUE

ACTION_LEVEL_MIN_VALUE

WARNING_LEVEL_VALUE

WARNING_LEVEL_MIN_VALUE

 

Extra fields: Any fields chosen

in this parameter

 

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

 

 



Copyright © 2023 EarthSoft, Inc • Modified: 23 Jul 2022