Action Level Exceedance II by EDD

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Action Level Reports >

Action Level Exceedance II by EDD

Report Name: Action Level Exceedance II by EDD*

*previously called (Beta) Action Level Exceedance by EDD

 

Report Type: Standard Report

 

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 Environmental Information Agent (EIA), or trigger, within EQuIS Enterprise. The report generates results by filtering DT_RESULT.EBATCH with the Ebatch parameter (Note filtering DT_SAMPLE.EBATCH in v6.2 or earlier).

 

Warning: Using the Action Level Exceedance II Report in Crosstab will now allow data that exceeds the WARNING_LEVEL to be highlighted with one format and/or color while data that also exceeds the ACTION_LEVEL is highlighted with another format and/or color. Assuming the normal relationship where the 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 the desired 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.

 

Additional descriptions of both reports are available in Action Level Exceedance II by User Report.

 

Note: In the ALE II Report, the AL_REMARK column was being used in the comparison for duplicates. The AutoCrosstab_ActionLevel method now ignores that field when doing the AutoCrosstab for the ALE Report.

 

Go to Action Level Exceedance (by EDD) - Standard for an earlier version of this report.

 

Report Dependencies: Contact support@earthsoft.com for more information.

 

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

 

Language: English

 

Input Parameters: A selection made to customize the output of a report.

 

Input Parameters

Input Parameter Screenshot

Output Columns

EDDs



Action Level(s)




Action Levels



Comparison




Operator



Unit



Significant Figures



Compare to Action Level Before Applying to Significant Figures


Flagging




Show Results



Flag Non-Detects



Exceedance Flag



Warning Flag


Matching




Match Start - End Dates



Match Seasonal Dates



Match Depths



Match Fractions



Match Methods



Match Subfacility



Match Facility




 

Analyte Exceedance (Over Time)        

30004-bar.exceed.by.EDD

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

Note: * refers to hidden parameters.

 

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

 

Database Type: SQL

 

Database Schema: Standard (no custom or add-on schemas required)

 

Database Version: EQuIS v5.4.3+

 

Data Requirements: N/A

 

Report Requirements: Excel

 

Output Type: Excel

 

Example Output: View the example below.

 

30004-ex.output_zoom74